Re: Huge undotbs during insert

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 26 May 2005 12:51:09 -0700
Message-ID: <1117136806.510187@yasure>

astalavista wrote:

>>Before we get to the question you asked ... the current 9i version
>>is 9.2.0.6 ... apply the appropriate patches.
>>
>>Second ... how big is the table and how big is your UNDO tablespace?

>
>
> Thanks for your help ...
> table1 is about 1.3 GB
> and UNDO tablespace went up to 6 GB
> is it a normal behavior ?

Based on the fact that this is probably not the only thing happening on your system I wouldn't sweat it. 6GB in today's world is nothing.

But you really should patch to 9.2.04 or 9.2.0.6 ASAP.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu May 26 2005 - 14:51:09 CDT