oracle 所有等待事件

set linesize 200 pages 120
select wait_class#,wait_class_id,wait_class,count(*) as "count"
  from v$event_name
  group by wait_class#,wait_class_id,wait_class
  order by wait_class#;

WAIT_CLASS# WAIT_CLASS_ID WAIT_CLASS                                                            count
----------- ------------- ---------------------------------------------------------------- ----------
          0    1893977003 Other                                                                   745
          1    4217450380 Application                                                              17
          2    3290255840 Configuration                                                            24
          3    4166625743 Administrative                                                           55
          4    3875070507 Concurrency                                                              33
          5    3386400367 Commit                                                                    2
          6    2723168908 Idle                                                                     95
          7    2000153315 Network                                                                  35
          8    1740759767 User I/O                                                                 48
          9    4108307767 System I/O                                                               31
         10    2396326234 Scheduler                                                                 8
         11    3871361733 Cluster                                                                  50
         12     644977587 Queueing                                                                  9

13 rows selected.

  select * from v$event_name where wait_class='Idle' order by name;

NAME                                                            
----------------------------------------------------------------
ASM background timer                                            
DIAG idle wait                                                  
EMON slave idle wait                                            
GCR sleep                                                       
HS message to agent                                             
IORM Scheduler Slave Idle Wait                                  
JOX Jit Process Sleep                                           
JS external job                                                 
KSV master wait                                                 
LGWR real time apply sync                                       
LNS ASYNC archive log                                           
LNS ASYNC dest activation                                       
LNS ASYNC end of log                                            
LogMiner builder: branch                                        
LogMiner builder: idle                                          
LogMiner client: transaction                                    
LogMiner preparer: idle                                         
LogMiner reader: log (idle)                                     
LogMiner reader: redo (idle)                                    
LogMiner: activate                                              
LogMiner: find session                                          
LogMiner: internal                                              
LogMiner: other                                                 
LogMiner: reset                                                 
Logical Standby Apply Delay                                     
MRP redo arrival                                                
PING                                                            
PL/SQL lock timer                                               
PX Deq Credit: need buffer                                      
PX Deq Credit: send blkd                                        
PX Deq: Execute Reply                                           
PX Deq: Execution Msg                                           
PX Deq: Index Merge Close                                       
PX Deq: Index Merge Execute                                     
PX Deq: Index Merge Reply                                       
PX Deq: Join ACK                                                
PX Deq: Metadata Update                                         
PX Deq: Msg Fragment                                            
PX Deq: Parse Reply                                             
PX Deq: Table Q Normal                                          
PX Deq: Table Q Sample                                          
PX Deq: Txn Recovery Reply                                      
PX Deq: Txn Recovery Start                                      
PX Deq: kdcph_mai                                               
PX Deq: kdcphc_ack                                              
PX Deque wait                                                   
PX Idle Wait                                                    
SGA: MMAN sleep for component shrink                            
SQL*Net message from client                                     
SQL*Net vector message from client                              
SQL*Net vector message from dblink                              
Space Manager: slave idle wait                                  
Streams AQ: RAC qmn coordinator idle wait                       
Streams AQ: deallocate messages from Streams Pool               
Streams AQ: delete acknowledged messages                        
Streams AQ: emn coordinator idle wait                           
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 capture: waiting for archive log                        
Streams fetch slave: waiting for txns                           
Streams: waiting for messages                                   
VKRM Idle                                                       
VKTM Init Wait for GSGA                                         
VKTM Logical Idle Wait                                          
WCR: replay client notify                                       
WCR: replay clock                                               
WCR: replay paused                                              
auto-sqltune: wait graph update                                 
cell worker idle                                                
class slave wait                                                
cmon timer                                                      
dispatcher timer                                                
fbar timer                                                      
gcs remote message                                              
ges remote message                                              
heartbeat monitor sleep                                         
i/o slave wait                                                  
jobq slave wait                                                 
parallel recovery control message reply                         
parallel recovery coordinator waits for slave cleanup           
parallel recovery slave idle wait                               
parallel recovery slave next change                             
pipe get                                                        
pmon timer                                                      
pool server timer                                               
rdbms ipc message                                               
shared server idle wait                                         
simulated log write delay                                       
single-task message                                             
smon timer                                                      
wait for unread message on broadcast channel                    
wait for unread message on multiple broadcast channels          
watchdog main loop                                              

95 rows selected.