This ratio is available from Oracle 10g.
CPU Time Ratio - Percentage of total time used in performing user requests.
Wait Time Ratio- Percentage of total time used in waiting for resources.
When Wait time ratio is higher than the CPU time ratio, perform the Wait event analysis.
Run hitratio script to get the ratio.
Thanks
Sunday, July 5, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
This post describes database wait time to CPU time ration. You will understand it very easily. This is very simple. This ratio is available from Oracle 10g. The concept is very simple to learn. I applied the ratio for my machine. Thanks for the post.
Post a Comment