UNDOTBS01.DBF file size

From: Jim <mail_at_lost.com>
Date: Fri, 26 Aug 2005 06:02:10 -0400
Message-ID: <23qtg1h1omivphpq5onj8p1lblqh5ecicv@4ax.com>

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. Received on Fri Aug 26 2005 - 05:02:10 CDT