The ratio of sum of WAITS to the sum of GETS in v$rollstat should be less than 5%.
The V$WAITSTAT view is used to find the contention in rollback segment header block.
A value over zero in the column UNDO_HEADER means there is contention.
Run hitratio script to get the ratio.
Thanks
Sunday, July 5, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
I really thankful to you Rollback segment wait to get ratio. I also wanted to request for sharing some more information on the concept of DBA views .
Post a Comment