Tip
2010.04.23 21:31

IDLE EVENT

조회 수 21499 추천 수 0 댓글 0

9i idle event

smon timer
pmon timer
rdbms ipc message
Null event
parallel query dequeue
pipe get
client message
SQL*Net message to client
SQL*Net message from client
SQL*Net more data from client
dispatcher timer
virtual circuit status
lock manager wait for remote message
PX Idle Wait
PX Deq: Execution Msg
PX Deq: Table Q Normal
wakeup time manager
slave wait
i/o slave wait
jobq slave wait
null event
gcs remote message
gcs for action
ges remote message
queue messages

 

10g idle event

AQ Proxy Cleanup Wait
ASM background timer
DIAG idle wait
EMON idle wait
KSV master wait
LNS ASYNC archive log
LNS ASYNC dest activation
LNS ASYNC end of log
LogMiner: client waiting for transaction
LogMiner: slave waiting for activate message
LogMiner: wakeup event for builder
LogMiner: wakeup event for preparer
LogMiner: wakeup event for reader
Null event
PX Deq Credit: need buffer
PX Deq Credit: send blkd
PX Deq: Execute Reply
PX Deq: Execution Msg
PX Deq: Par Recov Execute
PX Deq: Signal ACK
PX Deq: Table Q Normal
PX Deq: Table Q Sample
PX Deque wait
PX Idle Wait
Queue Monitor Shutdown Wait
Queue Monitor Slave Wait
Queue Monitor Wait
SQL*Net message from client
SQL*Net message to client
SQL*Net more data from client
STREAMS apply coord waiting for slave message
STREAMS apply slave idle wait
STREAMS apply slave waiting for coord message
STREAMS capture process filter callback wait for ruleset
STREAMS fetch slave waiting for txns
STREAMS waiting for subscribers to catch up
Streams AQ: RAC qmn coordinator idle wait
Streams AQ: deallocate messages from Streams Pool
Streams AQ: delete acknowledged messages
Streams AQ: qmn coordinator idle wait
Streams AQ: qmn slave idle wait
Streams AQ: waiting for messages in the queue
Streams AQ: waiting for time management or cleanup tasks
Streams fetch slave: waiting for txns
class slave wait
client message
dispatcher timer
gcs for action
gcs remote message
ges remote message
i/o slave wait
jobq slave wait
knlqdeq
lock manager wait for remote message
master wait
null event
parallel query dequeue
pipe get
pmon timer
queue messages
rdbms ipc message
rdbms ipc reply
reliable message
slave wait
smon timer
virtual circuit status
wait for activate message
wait for unread message on broadcast channel
wakeup event for builder
wakeup event for preparer
wakeup event for reader
wakeup time manager

 

 

무조건 idle event라고 해서 무시하는건 아닌거 아시죠? ㅎ

 


List of Articles
번호 분류 제목 글쓴이 날짜 조회 수
공지 Q&A Oracle관련 게시물만 Sean 2014.04.09 84902
76 Tip 오라클 null값 정리 유주환 2010.04.18 29867
75 Tip sysaux resize 유주환 2010.04.18 25290
74 Tip Analyze 통계정보 dbkill 2010.04.11 13296
73 Tip Expdp/Impdp시 ORA-31633 에러 해결 방법 2 김준호 2010.04.20 22479
72 Tip DATAFILE SIZE 줄이는 계산 1 고구마 2010.04.19 13475
71 Tip 세마포어에 대하여 고구마 2010.04.19 13230
70 Tip DML_DDL_로그기록_체크 유주환 2010.04.19 13417
69 Tip 통계 백업 및 생성 유주환 2010.04.18 16183
68 Tip shared pool / library cache 고구마 2010.04.28 25066
67 Tip DML 문의 처리과정 고구마 2010.04.28 17306
66 Tip Buffer Cahe 관련 대기 이벤트들 고구마 2010.04.28 25635
65 Tip Buffer busy waits 고구마 2010.04.28 19597
64 Tip 버퍼캐시와 OWI 1 고구마 2010.04.28 19873
» Tip IDLE EVENT 유주환 2010.04.23 21499
62 Tip 권한주기 고구마 2010.04.23 15733
61 Tip 핫백업 디비올리기 유주환 2010.04.09 34980
60 Tip partiton table truncate 및 rebuild 작업 유주환 2010.04.09 10545
59 Tip How to Use DBMS_STATS to Move Statistics to a Different Database 고구마 2010.04.09 17064
58 Tip 10G FGA AUDIT 1 고구마 2010.04.09 23607
57 Tip EM 재구성 고구마 2010.04.09 26261
Board Pagination Prev 1 2 3 4 Next
/ 4