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
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
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