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.

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.