Tuesday, June 7, 2011

PSAPUNDO retention Period

Today our server hitting PSAPUNDO full 100%


Here's how we check the retention period

SQL> show parameter retention

here how to change it.

ALTER SYSTEM SET UNDO_RETENTION = 7200;

or

alter system set undo_retention=7200 scope=both/spfile;


No comments:

Post a Comment