cpu instensive query
I want to know which sql query in the database is consuming more cpu cycles resource ?
can any one help me out ?
thanks in advance
What Oracle version?
It's pretty easy to drill down with OEM, i'm assuming you do not have OEM?
I remember when this place was cool.
high CPU usage SQLs are those which has high
v$sql shows that (you might want to divide buffer_gets per executions since buffer_gets is cumulative)
hi, if in oracle 9i,
there is cpu_time in v$sql, and cpu% in statspack report.
Also you can monitor it from unix, like prstat/top/ps find the spid and check the sql.
Thanks all for the inputs
OS sun 2.7 E3500
Ram 2 GB
Bit still I am not convienced yet
Click Here to Expand Forum to Full Width