|
-
Create a few more rb segments,since you have enough space i guess you have more transactions than the rbs might consider handling..
alternatively query V$waitstat to query if there are any waits particularly in undo header, undo block etc..
or restarting the instance will also reset the dba_rollback_segs parameters.......
Check also you optimal clause, depending upon the shrinks,and aveshrinks parameters, you need to adjust them.
if shrinks are low and aveshrink high then the setting is good.
If aveshrink is low and closer to the current setting then it's fine if not the optimal is too high.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)

--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|