ksqstwat: The number of wait for the enqueue statistics class.
ksqstwtim: Cumulated waiting time. This column is selected when v$enqueue_stat.cum_wait_time is selected.
select
case when nvl(
lag( ksq.ksqsttyp ) over (order by ksq.ksqsttyp, ksq.ksqstrsn ),
'n/a'
) <> ksqsttyp then ksq.ksqsttyp end ksqsttyp,
ksq.ksqstrsn,
ksq.ksqstreq,
ksq.ksqstwat,
ksq.ksqstsgt,
ksq.ksqstwtm,
ksq.ksqstexpl,
ksq.ksqstevidx
from
x$ksqst ksq
order by
ksq.ksqsttyp,
ksq.ksqstrsn;
Type of classes
BL Buffer Cache Management
CF Controlfile Transaction
CI Cross-instance call invocation
CU Bind Enqueue
DF Datafile
DL Direct Loader index creation
DM Database mount
DP ???
DR Distributed Recovery
DX Distributed TX
FB acquired when formatting a range of bitmap blocks far ASSM segments. id1=ts#, id2=relative dba
FS File Set
IN Instance number
IR Instance Recovery
IS Instance State
IV Library cache invalidation
JD Something to do with dbms_job
JQ Job queue
KK Redo log kick
LA..LP Library cache lock
MD enqueue for Change data capture materialized view log (gotten internally for DDL on a snapshot log) id1=object# of the snapshot log.