Options

after transaction completed in undo tablespace what would happen?

poguypoguy Member Posts: 91 ■■□□□□□□□□
after transaction completed in undo tablespace what would happen?
will they take out of undo tablespace or segment?
please elaborate, thank you

Comments

  • Options
    cablegodcablegod Member Posts: 294
    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.
    “Government is a disease masquerading as its own cure.” -Robert LeFevre
Sign In or Register to comment.