Does anybody know good documentations that can help me understand the report generated by Statspack? Particularly what's meaningful and what's not.
Thanks,
Printable View
Does anybody know good documentations that can help me understand the report generated by Statspack? Particularly what's meaningful and what's not.
Thanks,
Which is the problem with the Oracle Documentation ? :D
Cheers
There is an excellent chapter in http://www.amazon.com/exec/obidos/tg...books&n=507846
Report:
Latch Name -- Where -- Misses -- Sleeps -- Sleeps
------------------------ -------------------------- ------- ---------- -------
checkpoint queue latch -- kcbk0rrd: update recovery -- 0 -- 13 -- 0
library cache -- kglhdgn: child: -- 0 -- 9 -- 5
library cache -- kglic -- 0 -- 5 -- 1
redo writing -- kcrfsr -- 0 -- 1 -- 0
redo writing -- kcrfss -- 0 -- 1 -- 2
Which documentation explain the where section? Thanks.
Most of the reports in statspack give wait statistics that too they are not correct.
Only the top 10 SQL statements are useful. Rest of the reports are useless. I would suggest do not use it.
Start learning how to use some of the internal tables like X$.....
Tamil