[오라클]대기 이벤트 확인하기
C:\>sqlplus "/as sysdba"
SQL> desc v$event_name;
이름 널? 유형
----------------------------------------- -------- ----------------------------
EVENT# NUMBER
EVENT_ID NUMBER
NAME VARCHAR2(64)
PARAMETER1 VARCHAR2(64)
PARAMETER2 VARCHAR2(64)
PARAMETER3 VARCHAR2(64)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> -- 오라클의 대기이벤트 확인
SQL> select count(*) from v$event_name;
COUNT(*)
----------
876
SQL> -- 현재시스템의 이벤트
SQL> desc v$system_event;
이름 널? 유형
----------------------------------------- -------- ----------------------------
EVENT VARCHAR2(64)
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER
TIME_WAITED_MICRO NUMBER
EVENT_ID NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> select event from v$system_event;
EVENT
----------------------------------------------------------------
pmon timer
rdbms ipc message
Data file init write
Log archive I/O
wait for unread message on broadcast channel
class slave wait
os thread startup
control file sequential read
control file parallel write
latch: cache buffers chains
local write wait
checkpoint completed
buffer busy waits
read by other session
recovery read
enq: RO - fast object reuse
log file sequential read
log file single write
log file parallel write
log buffer space
log file switch completion
log file sync
db file sequential read
db file scattered read
db file single write
db file parallel write
direct path read
direct path read temp
direct path write
direct path write temp
PX Deq: Par Recov Reply
PX Deq: Par Recov Execute
PX Deq: Par Recov Change Vector
undo segment extension
smon timer
latch: In memory undo latch
latch: row cache objects
cursor: pin S wait on X
latch: shared pool
latch: library cache
library cache load lock
virtual circuit status
dispatcher timer
jobq slave wait
PX Idle Wait
PX Deq: Join ACK
SQL*Net message to client
SQL*Net more data to client
SQL*Net message from client
SQL*Net more data from client
SQL*Net break/reset to client
Streams AQ: waiting for messages in the queue
Streams AQ: waiting for time management or cleanup tasks
Streams AQ: qmn coordinator idle wait
Streams AQ: qmn slave idle wait
latch free
enq: PE - contention
rdbms ipc reply
reliable message
control file heartbeat
LGWR wait for redo copy
latch: redo allocation
instance state change
PX qref latch
PX Deq: Test for msg
PX Deq: Signal ACK
Streams AQ: qmn coordinator waiting for slave to start
enq: TL - contention
68 개의 행이 선택되었습니다.
SQL>
