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:
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”.
Follow if you like:
An intriguing discussion is definitely worth comment. I do believe that you should write more on this topic, it may not be a taboo matter but usually people do not speak about such issues. To the next! All the best!