CPU vs Waits Timing – Simple View

I’ve spent the last week performance tuning for a customer here in Georgia. The biggest thing I found was that they were having a lot of wait issues.  To illustrate these wait issues in a simplified method, I used the V$SYSMETRIC view.  The query below gives you a comparison between waits and cpu times with ratios. 

select metric_name, round(value,2) from v$sysmetric
where metric_name in ('Database CPU Time Ratio', 'Database Wait Time Ratio')
and intsize_csec = (select max(INTSIZE_CSEC) FROM V$SYSMETRIC);

Enjoy!

twitter: @curtisbl294

blog: http://dbasolved.com

 

Please follow and like:
Comments
  • Hey there! Do you know if they make any plugins
    to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords
    but I’m not seeing very good results. If you know of any please share.

    Thank you! You can read similar art here: Warm blankets

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.