Parse CPU to Parse Elapsd

[big]

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

[ErmanArslansOracleBlog]

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

Yes.. Tracing the whole database is not a good idea.

Check v$sqlarea, there is a parse_calls column there.. You can find some correlations from that.