| data block count 5871 on report.txt [message #58040] |
Mon, 28 July 2003 06:43 |
Chinnu
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
Hi every body,
Below is a pary of my report.txt. The utl stats ran for 24 hours to generate the report.txt. Based on the below stats.. i don't need to change any thing on the rollback segments. But what about the data blocks ?
Thanks,
Chinnu.
=========================================
SVRMGR> Rem Buffer busy wait statistics. If the value for 'buffer busy wait' in
SVRMGR> Rem the wait event statistics is high, then this table will identify
SVRMGR> Rem which class of blocks is having high contention. If there are high
SVRMGR> Rem 'undo header' waits then add more rollback segments. If there are
SVRMGR> Rem high 'segment header' waits then adding freelists might help. Check
SVRMGR> Rem v$session_wait to get the addresses of the actual blocks having
SVRMGR> Rem contention.
SVRMGR> select * from stats$waitstat
2> where count != 0
3> order by count desc;
CLASS COUNT TIME
------------------ ---------------- ----------------
data block 5871 9019
segment header 40 40
undo block 10 19
undo header 3 1
4 rows selected.
--
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
