Re: Undo Tablespace growing even with retention = 0

> Undo is LMT manual segment space management.
> No. of Transaction : I fixed the loop for 300 seconds.
>
> This tablespace's size increased to 251 mb with undo_retention=0 and
> with
> unto_retention=9000 it reach to 476 mb.
>
> Regards,
> Jagjeet Singh
>

Even though your UNDO_RETENTION is set to 0 seconds, you will still generate undo. And that undo will require space until that transaction is committed or rolled back. At that point, Oracle *may* overwrite that undo with the next transaction, provided UNDO_RETENTION seconds have passed.

In your PL/SQL block, you have an UPDATE statement. Obviously, this update statement is generating undo.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown