Re: UNDOTBS01.DBF file size

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 26 Aug 2005 14:17:48 +0200
Message-ID: <430f086d$0$6747$ba620e4c@news.skynet.be>

"Jim" <mail_at_lost.com> wrote in message
news:23qtg1h1omivphpq5onj8p1lblqh5ecicv_at_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.

See the thread some messages below regarding Undo Management.

Matthias Received on Fri Aug 26 2005 - 07:17:48 CDT