Ads

All session events in ORACLE DATABASE



SQL> select distinct(event)  from v$session_event;

EVENT
----------------------------------------------------------------
os thread startup
db file parallel write
control file parallel write
SQL*Net message from client
library cache pin
cursor: pin S wait on X
log file sync
direct path write temp
resmgr:cpu quantum
wait for unread message on broadcast channel
Streams AQ: waiting for messages in the queue

EVENT
----------------------------------------------------------------
control file sequential read
read by other session
SQL*Net break/reset to client
pmon timer
rdbms ipc message
db file sequential read
log file sequential read
jobq slave wait
smon timer
JS coord start wait
latch: row cache objects

EVENT
----------------------------------------------------------------
SQL*Net more data to client
buffer busy waits
direct path read temp
Log archive I/O
events in waitclass Other
SQL*Net more data from client
direct path write
db file parallel read
class slave wait
db file scattered read
Streams AQ: qmn slave idle wait

EVENT
----------------------------------------------------------------
Parameter File I/O
Disk file operations I/O
SQL*Net message to client
log file parallel write
Space Manager: slave idle wait
direct path read
Streams AQ: qmn coordinator idle wait
log file single write
Streams AQ: waiting for time management or cleanup tasks
DIAG idle wait
SGA: MMAN sleep for component shrink

44 rows selected.