In message <42961f24$0$32432$636a15ce_at_news.free.fr>, astalavista
<spam_at_nowhere.com> writes
>> 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 ?
>
>
In some circumstances, yes.
Check your undo_retention parameter. If it is too high your undo
tablespace will grow unreasonably.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Fri May 27 2005 - 00:37:08 CDT
