Parse CPU to Parse Elapsd

Posted by big on Dec 19, 2022; 10:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Parse-CPU-to-Parse-Elapsd-tp11379.html

Hi,
On 19c on AIX

In AWR we have Parse CPU to Parse Elapsd %: 21.24

Then much time to parse out of CPU. Waits to parse without using CPU.


How can we find the sql query for which it is the case?

It is suggested : trace the session using 10046 tracing with level 8.
Where and when? How to do that? Where would be the output? How to avoid a huge output?

Thanks