Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center