SAP : Knowledge Sharing Site
This is a blog that share's SAP tutorials for beginner and intermediate level for all SAP people.
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
‹
›
Home
View web version
No comments:
Post a Comment