| rollback segment problem HELP [message #57824] |
Wed, 09 July 2003 10:29 |
Teresa
Messages: 36
Registered: May 2002
|
Member |
|
|
Can someone please tell me how to I view which rollback segment is currently been used on the database? Also I'm getting the "ORA-1555 snapshot too old". Oracle support gave me this query "Select a.name, b.extents, b.rssize, b.optsize, b.shrinks, b.aveshrink, b.aveactive, b.wraps, b.extends, b.status from v$rollname a, v$rollstat b
where a.usn = b.usn;"
to view
If Shrinks "High" and Avesize "High" then, Optsize = too low, increase optimal
If Shrinks "High" and Avesize "Low" then, Optsize = too low, increase optimal
If Shrinks "Low" and Avesize "Low" then, Optsize = Too high, reduce optimal (unless nearly equal to AVEACTIVE)
If Shrinks "Low" and Avesize "High" then, Optsize is OK
But How can I get the AVESIZE? the query above does not list the AVESIZE
help please
Thank you
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
