> 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@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