SQL Performance (MOSC)

MOSC Banner

Unlabeled wait event in DBA_HIST_ACTIVE_SESS_HISTORY

edited Dec 10, 2018 4:23AM in SQL Performance (MOSC) 7 commentsAnswered

Attached image of DBA_HIST_ACTIVE_SESS_HISTORY shows the usual events, but for this SQL_ID I see many "blank" events -- they are sometimes taking up excessive resources (elapsed time), but the EVENT, EVENT_ID, and WAIT_CLASS are NULL. Notice that P3 implies there is some kind of I/O -- single block reads, but "ON CPU" (?) -- but why? It is generally difficult to set up a deeper trace, partly because it's a production environment but mostly because this happens to random SQL_IDs and we can't turn on tracing for everything all the time. How can I figure out what these "ghost" events are???? Thanks.

Tagged:

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