I install sportlight (quest software ) , oracle management server performance dignostic.
I am trying to monitor my production database and found
Sportlight shows 0% to 50%
(Oem)Performance manager- 81%
(Oem)memory cache hits , buffer cache hit% negative.
My database has some serious problems, Now can I get correct buffer hit%.
If you do not specify optimal size in rollback segment what will happen ? What is the meaning of rollback wrap, undo header ? Does it effact degrad performance. My rollback shrink is 0.
I can't fathom how buffer hit % can be negative.
You calculate Buffer cache hit ratio as follows:
Now Calculate hit ratio in % by:
Select name, value from V$SYSSTAT where name in ('db block gets', 'consistent gets', 'physical reads');
(db block gets+ consistent gets - physical reads/db block gets + consistent gets)*100
Did you run the database for several hours before taking the hit ratio?
If you do not specify optimal size while creating roll back segments, they will not shrink. There is a chance of them getting elongated out of proportion if there is a long running transaction. If optimal is specified (recommended), the roll back segment will shrink back to its optimal size.
If you do not specify optimal size in rollback segment what will happen ? What is the meaning of rollback wrap, undo header ? Does it effact degrad performance. My rollback shrink is 0
Wraps occur when the transaction has to carry forward to the next rollback extent. Wraps occur normally and do not affect performance if the next extent is inactive and available.
Click Here to Expand Forum to Full Width