« Redo Log File in Oracle
Sorts Tuning in Oracle »

Auto Undo Management in Oracle

Oracle 9 introduced a new way to manage rollback / undo data – an Undo Tablespace. To utilize Automatic Undo Management, create a tablespace in the database of type UNDO:

create undo tablespace UNDOTBS1 datafile ‘/U01/oradata/prod/undotbs_01.dbf’

extent management local uniform size 256k;

Next, modify your init file:

  • UNDO_MANAGEMENT=AUTO
  • UNDO_TABLESPACE=UNDOTBS1
  • UNDO_RETENTION=<# of minutes>

Tags:

This entry was posted on Monday, February 25th, 2008 at 2:49 pm and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.