Parse CPU to parse elapsed

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Parse CPU to parse elapsed

Zaheer
Hi Erman,

I have observed in my AWR report that Parse CPU to parse elapsed ration is too low. It fluntuate between 30 to 90 % in a day during working hrs.
Please let me know how to fix it.

Thanks & Regards
Reply | Threaded
Open this post in threaded view
|

Re: Parse CPU to parse elapsed

ErmanArslansOracleBlog
Administrator
Parse CPU to Parse Elapsed : 100*Parse CPU Time / Parse Elapsed, how much of the total parse time was spent on CPU.

So you have some waits during parsing.
There may be a contention in somehwere.. For instance in shared pool..
We need to check the other sections of AWR to make more comments on this.