Home > Archive > Oracle Databases > August 2005 > UNDOTBS01.DBF file size









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author UNDOTBS01.DBF file size
Jim

2005-08-25, 8:26 pm

First of all I am not a Oracle techie so please excuse the lack of
technical knowledge. I have the following problem.

A disk was running low on space to I did a check of file sizes. The
UNDOTBS01.DBF turned out to be 7gb. That is huge given that the files
in which the data is stored is only 1.5gb. My questions are as
follows:

- why is the UNDOTBS01.DBF file so big?
- how can I reduce the size of this file?
- what can I do to ensure that it doesn't get this big in the future?

Thanks.
Jim

2005-08-25, 8:26 pm

Win2k, Personal Oracle Database 10g Release 10.1.0.2.0

First of all I am not a Oracle techie so please excuse the lack of
technical knowledge. I have the following problem.

A disk was running low on space to I did a check of file sizes. The
UNDOTBS01.DBF turned out to be 7gb. That is huge given that the files
in which the data is stored is only 1.5gb. My questions are as
follows:

- why is the UNDOTBS01.DBF file so big?
- how can I reduce the size of this file?
- what can I do to ensure that it doesn't get this big in the future?

Thanks.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com