after transaction completed in undo tablespace what would happen?

poguy

after transaction completed in undo tablespace what would happen?
will they take out of undo tablespace or segment?
please elaborate, thank you

cablegod

poguy wrote: »

after transaction completed in undo tablespace what would happen?
will they take out of undo tablespace or segment?
please elaborate, thank you

The first thing is to look at your undo_retention parameter. That specifies in seconds how long Oracle will guarantee the ability to rollback a transaction. The size of your undo tablespace also matters. Once the undo retention guarantee period has expired, that data is removed when the space is needed by another transaction.

It's best to use automatic undo management. Automatic undo management is enabled by setting undo_management to true and by specifying an undo tablespace with undo_tablespaces.If the undo tablespace is auto extensible, the size of the undo tablespace depends on the parameter undo_retention.