on 06-12-2013 2:09 AM
PSAPUNDO tablespace is get filled frequently whenever any activity is going on in SAP level and we get alerts for them why?
Hi Nitu,
You can use this as a guide line to sizing undo tablespace
http://www.akadia.com/services/ora_optimize_undo.html
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This depends on the Oracle version you are using. If you are using Oracle 10 then not to worry, PSAPUNDO will be auto managed.
And normally the usage of the tablespace is high since Oracle will try to keep the undo segments there as long as possible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nitu,
Could you share the database version and patch level.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.