Parse CPU to Parse Elapsd
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. Then waits for other things than 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