Parallel Query Wait Events
From :
SCOPE & APPLICATION
-------------------
This is intended as a reference for anyone involved in database tuning.
At the moment we consider the following PX wait events as idle:
- "PX Idle Wait"
- "PX Deq: Execution Msg"
- "PX Deq: Table Q Normal"
- "PX Deq Credit: send blkd"
- "PX Deq: Execute Reply"
- "PX Deq Credit: need buffer"
- "PX Deq: Signal ACK"
- "PX Deque wait"
In 9i statspack does not filter out all idle PX wait event in
the Top 5 wait event section. So it can happen that you see
a PX idle wait event in this section.
The full list of Parallel Execution wait events are documented here
for completeness.
Parallel Execution Wait Events
------------------------------
Parallel Recovery
=================
"PX Deq: Par Recov Reply"
"PX Deq: Par Recov Execute"
"PX Deq: Par Recov Change Vector"
Replication
===========
"Replication Dequeue "
"waiting for slave message"
Parallel Query
==============
"PX Deq: Table Q Normal" Note 270921.1
"PX Deq: Table Q Sample"
"PX Deq: Table Q qref"
"PX Deq: Table Q Get Keys"
"PX Deq: Table Q Close"
Index Operations
================
"PX Deq: Merge Reply"
"PX Deq: Index Merge Execute"
"PX Deq: Index Merge Close"
General Parallel Execution
==========================
"PX qref latch" Note 240145.1
"PX server shutdown" Note 250357.1
"PX create server" obsolete since Oracle 8.0
"PX signal server"
"PX Deque wait"
"PX Idle Wait" Note 257595.1
"PX Deq: Join ACK" Note 250960.1
"PX Deq Credit: need buffer" Note 253912.1
"PX Deq Credit: free buffer"
"PX Deq Credit: send blkd"
"PX Deq: Test for msg"
"PX Deq: Signal ACK" Note 257594.1
"PX Deq: reap credit" Note 250947.1
"PX Nsq: PQ descriptor query"
"PX Nsq: PQ load info query"
"PX Deq: Msg Fragment" Note 254760.1
"PX Deq: Parse Reply" Note 257596.1
"PX Deq: Execute Reply" Note 270916.1
"PX Deq: Execution Msg" Note 69067.1
Parallel Transaction Recovery
=============================
"PX Deq: Txn Recovery Start"
"PX Deq: Txn Recovery Reply" [@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-1010971/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- Master Note Parallel Execution Wait Events [ID 1097154.1]ASTParallelAI
- wait eventsAI
- Parallel query & viewsParallelView
- 關於Parallel queryParallel
- Oracle RAC Wait EventsOracleAI
- Data Guard Wait EventsAI
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- 【DATAGUARD】Data Guard Wait EventsAI
- 幾個ORACLE wait eventsOracleAI
- High "Resmgr:Cpu Quantum" Wait EventsAI
- 轉:latch wait events 說明分析AI
- zt_關於wait events asynch descriptor resize_wait eventAI
- Buffer Cache I/O-Related Wait EventsAI
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- wait event_Additional Statistics_that do not have corresponding wait eventsAI
- oracle中 Wait Events 和可能原因(oracle doc)OracleAI
- Oracle並行操作——並行查詢(Parallel Query)Oracle並行Parallel
- Wait Events的分類及分類依據AI
- 0317Library Cache Pin/Lock Wait EventsAI
- Parallel Query Tuning(並行化查詢優化)Parallel並行優化
- Oracle Enqueues Wait Events 三 enq: TX - row lock contentionOracleENQAI
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Redo Logging I/O-Related Wait EventsAI
- alter session force parallel query與執行計劃變化SessionParallel
- oracle11g_Descriptions of Wait Events_等待事件全列表OracleAI事件
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]Parallel
- 等待事件wait for a undo record 與 fast_start_parallel_rollback引數事件AIASTParallel
- Deal With "SGA: allocation forcing component growth" Wait Events_1270867.1AI
- Statspack報告分析—第6部分: Wait Events - Complete listAI
- ORA-12801: error signaled in parallel query server PZ99分析ErrorParallelServer
- oracle hint_no_parallel_no_parallel_indexOracleParallelIndex
- oracle hint_parallel_parallel_indexOracleParallelIndex
- Statspack報告分析—第四部分:Top 5 Wait Events 5大等待事件AI事件
- oracle eventsOracle
- Tasks in parallelParallel