SAP : Knowledge Sharing Site
This is a blog that share's SAP tutorials for beginner and intermediate level for all SAP people.
Popular Posts
SQL script to list largest tables in Oracle
Troubleshooting : Housekeeping on /sapmnt/SID/global full
ABAP Dumps we normally face in SAP system
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment