Wait groups

From DB Optimizer
Jump to: navigation, search
create table waitgroups (
 NAME         VARCHAR2(64),
 WAIT_CLASS   VARCHAR2(64)
);
create index waitgroups_i on waitgroups(name);
truncate table waitgroups;
insert into waitgroups values ('null event','Other');
insert into waitgroups values ('pmon timer','Idle');
insert into waitgroups values ('rdbms ipc message','Idle');
insert into waitgroups values ('kst: async disk IO','System I/O');
insert into waitgroups values ('ksfd: async disk IO','System I/O');
insert into waitgroups values ('Datapump dump file I/O','User I/O');
insert into waitgroups values ('dbms_file_transfer I/O','User I/O');
insert into waitgroups values ('DG Broker configuration file I/O','User I/O');
insert into waitgroups values ('Data file init write','User I/O');
insert into waitgroups values ('Log file init write','User I/O');
insert into waitgroups values ('Log archive I/O','System I/O');
--insert into waitgroups values ('RMAN backup & recovery I/O','System I/O');
insert into waitgroups values ('Standby redo I/O','System I/O');
insert into waitgroups values ('Backup: sbtinit','Administrative');
insert into waitgroups values ('Backup: sbtopen','Administrative');
insert into waitgroups values ('Backup: sbtread','Administrative');
insert into waitgroups values ('Backup: sbtwrite','Administrative');
insert into waitgroups values ('Backup: sbtclose','Administrative');
insert into waitgroups values ('Backup: sbtinfo','Administrative');
insert into waitgroups values ('Backup: sbtremove','Administrative');
insert into waitgroups values ('Backup: sbtbackup','Administrative');
insert into waitgroups values ('Backup: sbtclose2','Administrative');
insert into waitgroups values ('Backup: sbtcommand','Administrative');
insert into waitgroups values ('Backup: sbtend','Administrative');
insert into waitgroups values ('Backup: sbterror','Administrative');
insert into waitgroups values ('Backup: sbtinfo2','Administrative');
insert into waitgroups values ('Backup: sbtinit2','Administrative');
insert into waitgroups values ('Backup: sbtread2','Administrative');
insert into waitgroups values ('Backup: sbtremove2','Administrative');
insert into waitgroups values ('Backup: sbtrestore','Administrative'); 
insert into waitgroups values ('Backup: sbtwrite2','Administrative');
insert into waitgroups values ('Backup: sbtpcbackup','Administrative');
insert into waitgroups values ('Backup: sbtpccancel','Administrative');
insert into waitgroups values ('Backup: sbtpccommit','Administrative');
insert into waitgroups values ('Backup: sbtpcend','Administrative');
insert into waitgroups values ('Backup: sbtpcquerybackup','Administrative');
insert into waitgroups values ('Backup: sbtpcqueryrestore','Administrative');
insert into waitgroups values ('Backup: sbtpcrestore','Administrative');
insert into waitgroups values ('Backup: sbtpcstart','Administrative');
insert into waitgroups values ('Backup: sbtpcstatus','Administrative');
insert into waitgroups values ('Backup: sbtpcvalidate','Administrative');
insert into waitgroups values ('io done','System I/O');
insert into waitgroups values ('i/o slave wait','Idle');
insert into waitgroups values ('wait for unread message on broadcast channel','Idle');
insert into waitgroups values ('wait for unread message on multiple broadcast channels','Idle');
insert into waitgroups values ('class slave wait','Idle');
insert into waitgroups values ('KSV master wait','Idle');
insert into waitgroups values ('os thread startup','Concurrency');
insert into waitgroups values ('watchdog main loop','Idle');
insert into waitgroups values ('DIAG idle wait','Idle');
insert into waitgroups values ('ges remote message','Idle');
insert into waitgroups values ('gcs remote message','Idle');
insert into waitgroups values ('SGA: MMAN sleep for component shrink','Idle');
insert into waitgroups values ('retry contact SCN lock master','Cluster');
insert into waitgroups values ('control file sequential read','System I/O');
insert into waitgroups values ('control file single write','System I/O');
insert into waitgroups values ('control file parallel write','System I/O');
insert into waitgroups values ('enq: PW - flush prewarm buffers','Application');
insert into waitgroups values ('latch: cache buffers chains','Concurrency');
insert into waitgroups values ('free buffer waits','Configuration'); 
insert into waitgroups values ('local write wait','User I/O');
insert into waitgroups values ('checkpoint completed','Configuration');
insert into waitgroups values ('write complete waits','Configuration');
insert into waitgroups values ('buffer read retry','User I/O');
insert into waitgroups values ('buffer busy waits','Concurrency');
insert into waitgroups values ('gc buffer busy','Cluster');
insert into waitgroups values ('read by other session','User I/O');
insert into waitgroups values ('multiple dbwriter suspend/resume for file offline','Administrative') ;
insert into waitgroups values ('buffer pool resize','Administrative');
insert into waitgroups values ('recovery read','System I/O');
insert into waitgroups values ('pi renounce write complete','Cluster');
insert into waitgroups values ('enq: RO - contention','Application');
insert into waitgroups values ('enq: RO - fast object reuse','Application');
insert into waitgroups values ('enq: KO - fast object checkpoint','Application');
insert into waitgroups values ('ARCH wait for pending I/Os','System I/O');
insert into waitgroups values ('ARCH wait for netserver start','Network');
insert into waitgroups values ('ARCH wait for netserver init 1','Network');
insert into waitgroups values ('ARCH wait for netserver init 2','Network');
insert into waitgroups values ('ARCH wait for flow-control','Network');
insert into waitgroups values ('ARCH wait for netserver detach','Network');
insert into waitgroups values ('ARCH wait for net re-connect','Network');
insert into waitgroups values ('LNS ASYNC control file txn','System I/O');
insert into waitgroups values ('LNS ASYNC archive log','Idle');
insert into waitgroups values ('LNS ASYNC dest activation','Idle');
insert into waitgroups values ('LNS ASYNC end of log','Idle');
insert into waitgroups values ('LNS wait on ATTACH','Network');
insert into waitgroups values ('LNS wait on SENDREQ','Network');
insert into waitgroups values ('LNS wait on DETACH','Network');
insert into waitgroups values ('LNS wait on LGWR','Network');
insert into waitgroups values ('LGWR wait on ATTACH','Network');
insert into waitgroups values ('LGWR wait on SENDREQ','Network');
insert into waitgroups values ('LGWR wait on DETACH','Network'); 
insert into waitgroups values ('LGWR sequential i/o','System I/O');
insert into waitgroups values ('LGWR random i/o','System I/O');
insert into waitgroups values ('LGWR wait on LNS','Network');
insert into waitgroups values ('RFS sequential i/o','System I/O');
insert into waitgroups values ('RFS random i/o','System I/O');
insert into waitgroups values ('RFS write','System I/O');
insert into waitgroups values ('ARCH wait on ATTACH','Network');
insert into waitgroups values ('ARCH wait on SENDREQ','Network');
insert into waitgroups values ('ARCH wait on DETACH','Network');
insert into waitgroups values ('ARCH sequential i/o','System I/O'); 
insert into waitgroups values ('ARCH random i/o','System I/O');
insert into waitgroups values ('log file sequential read','System I/O');
insert into waitgroups values ('log file single write','System I/O');
insert into waitgroups values ('log file parallel write','System I/O');
insert into waitgroups values ('latch: redo writing','Configuration');
insert into waitgroups values ('latch: redo copy','Configuration');
insert into waitgroups values ('log buffer space','Configuration');
insert into waitgroups values ('log file switch (checkpoint incomplete)','Configuration');
insert into waitgroups values ('log file switch (private strand flush incomplete)','Configuration');
insert into waitgroups values ('log file switch (archiving needed)','Configuration'); 
insert into waitgroups values ('switch logfile command','Administrative');
insert into waitgroups values ('log file switch completion','Configuration');
insert into waitgroups values ('log file sync','Commit');
insert into waitgroups values ('db file sequential read','User I/O');
insert into waitgroups values ('db file scattered read','User I/O');
insert into waitgroups values ('db file single write','User I/O');
insert into waitgroups values ('db file parallel write','System I/O');
insert into waitgroups values ('db file parallel read','User I/O');
insert into waitgroups values ('gc current request','Cluster');
insert into waitgroups values ('gc cr request','Cluster');
insert into waitgroups values ('gc cr disk request','Cluster');
insert into waitgroups values ('gc cr multi block request','Cluster');
insert into waitgroups values ('gc current multi block request','Cluster');
insert into waitgroups values ('gc block recovery request','Cluster');
insert into waitgroups values ('gc cr block 2-way','Cluster');
insert into waitgroups values ('gc cr block 3-way','Cluster');
insert into waitgroups values ('gc cr block busy','Cluster');
insert into waitgroups values ('gc cr block congested','Cluster'); 
insert into waitgroups values ('gc cr failure','Cluster');
insert into waitgroups values ('gc cr block lost','Cluster');
insert into waitgroups values ('gc cr block unknown','Cluster');
insert into waitgroups values ('gc current block 2-way','Cluster');
insert into waitgroups values ('gc current block 3-way','Cluster');
insert into waitgroups values ('gc current block busy','Cluster');
insert into waitgroups values ('gc current block congested','Cluster');
insert into waitgroups values ('gc current retry','Cluster'); 
insert into waitgroups values ('gc current block lost','Cluster');
insert into waitgroups values ('gc current split','Cluster');
insert into waitgroups values ('gc current block unknown','Cluster');
insert into waitgroups values ('gc cr grant 2-way','Cluster');
insert into waitgroups values ('gc cr grant busy','Cluster');
insert into waitgroups values ('gc cr grant congested','Cluster');
insert into waitgroups values ('gc cr grant unknown','Cluster');
insert into waitgroups values ('gc cr disk read','Cluster');
insert into waitgroups values ('gc current grant 2-way','Cluster');
insert into waitgroups values ('gc current grant busy','Cluster');
insert into waitgroups values ('gc current grant congested','Cluster'); 
insert into waitgroups values ('gc current grant unknown','Cluster');
insert into waitgroups values ('gc freelist','Cluster');
insert into waitgroups values ('gc prepare','Cluster');
insert into waitgroups values ('gc remaster','Cluster');
insert into waitgroups values ('gc current cancel','Cluster');
insert into waitgroups values ('gc cr cancel','Cluster');
insert into waitgroups values ('gc assume','Cluster');
insert into waitgroups values ('gc domain validation','Cluster');
insert into waitgroups values ('gc recovery free','Cluster');
insert into waitgroups values ('gc recovery quiesce','Cluster');
insert into waitgroups values ('gc claim','Cluster');
insert into waitgroups values ('gc quiesce wait','Cluster');
insert into waitgroups values ('direct path read','User I/O');
insert into waitgroups values ('direct path read temp','User I/O');
insert into waitgroups values ('direct path write','User I/O');
insert into waitgroups values ('direct path write temp','User I/O');
insert into waitgroups values ('PX Deq: Par Recov Reply','Idle');
insert into waitgroups values ('PX Deq: Par Recov Execute','Idle');
insert into waitgroups values ('PX Deq: Par Recov Change Vector','Idle');
insert into waitgroups values ('LogMiner: slave waiting for activate message','Idle');
insert into waitgroups values ('LogMiner: wakeup event for builder','Idle');
insert into waitgroups values ('LogMiner: wakeup event for preparer','Idle');
insert into waitgroups values ('LogMiner: wakeup event for reader','Idle');
insert into waitgroups values ('LogMiner: client waiting for transaction','Idle');
insert into waitgroups values ('wait for possible quiesce finish','Administrative');
insert into waitgroups values ('parallel recovery coordinator waits for cleanup of slaves','Idle');
insert into waitgroups values ('enq: TM - contention','Application');
insert into waitgroups values ('enq: ST - contention','Configuration');
insert into waitgroups values ('enq: HW - contention','Configuration');
insert into waitgroups values ('enq: SS - contention','Configuration');
insert into waitgroups values ('undo segment extension','Configuration');
insert into waitgroups values ('undo segment tx slot','Configuration');
insert into waitgroups values ('switch undo - offline','Administrative');
insert into waitgroups values ('alter rbs offline','Administrative');
insert into waitgroups values ('enq: TX - row lock contention','Application');
insert into waitgroups values ('enq: TX - allocate ITL entry','Configuration');
insert into waitgroups values ('enq: TX - index contention','Concurrency');
insert into waitgroups values ('enq: TW - contention','Administrative');
insert into waitgroups values ('sort segment request','Configuration');
insert into waitgroups values ('smon timer','Idle');
insert into waitgroups values ('PX Deq: Txn Recovery Start','Idle');
insert into waitgroups values ('PX Deq: Txn Recovery Reply','Idle');
insert into waitgroups values ('latch: Undo Hint Latch','Concurrency');
insert into waitgroups values ('statement suspended, wait error to be cleared','Configuration');
insert into waitgroups values ('latch: In memory undo latch','Concurrency'); 
insert into waitgroups values ('latch: MQL Tracking Latch','Concurrency');
insert into waitgroups values ('enq: SQ - contention','Configuration');
insert into waitgroups values ('PX Deq: Index Merge Reply','Idle');
insert into waitgroups values ('PX Deq: Index Merge Execute','Idle');
insert into waitgroups values ('PX Deq: Index Merge Close','Idle');
insert into waitgroups values ('PX Deq: kdcph_mai','Idle');
insert into waitgroups values ('PX Deq: kdcphc_ack','Idle');
insert into waitgroups values ('index (re)build online start','Administrative');
insert into waitgroups values ('index (re)build online cleanup','Administrative');
insert into waitgroups values ('index (re)build online merge','Administrative');
insert into waitgroups values ('latch: row cache objects','Concurrency');
insert into waitgroups values ('row cache lock','Concurrency');
insert into waitgroups values ('row cache read','Concurrency');
insert into waitgroups values ('cursor: mutex X','Concurrency');
insert into waitgroups values ('cursor: mutex S','Concurrency');
insert into waitgroups values ('cursor: pin S wait on X','Concurrency');
insert into waitgroups values ('latch: shared pool','Concurrency'); 
insert into waitgroups values ('latch: library cache','Concurrency');
insert into waitgroups values ('latch: library cache lock','Concurrency');
insert into waitgroups values ('latch: library cache pin','Concurrency');
insert into waitgroups values ('library cache pin','Concurrency');
insert into waitgroups values ('library cache lock','Concurrency');
insert into waitgroups values ('library cache load lock','Concurrency');
insert into waitgroups values ('BFILE read','User I/O');
insert into waitgroups values ('resmgr:cpu quantum','Scheduler');
insert into waitgroups values ('resmgr:internal state change','Concurrency');
insert into waitgroups values ('resmgr:internal state cleanup','Concurrency');
insert into waitgroups values ('resmgr:sessions to exit','Concurrency');
insert into waitgroups values ('resmgr:become active','Scheduler'); 
insert into waitgroups values ('TCP Socket (KGAS)','Network');
insert into waitgroups values ('alter system set dispatcher','Administrative');
insert into waitgroups values ('virtual circuit status','Idle');
insert into waitgroups values ('dispatcher timer','Idle');
insert into waitgroups values ('dispatcher listen timer','Network');
insert into waitgroups values ('dedicated server timer','Network');
insert into waitgroups values ('jobq slave wait','Idle');
insert into waitgroups values ('Wait for Table Lock','Application');
insert into waitgroups values ('pipe get','Idle');
insert into waitgroups values ('pipe put','Concurrency');
insert into waitgroups values ('enq: DB - contention','Administrative');
insert into waitgroups values ('PX Deque wait','Idle');
insert into waitgroups values ('PX Idle Wait','Idle');
insert into waitgroups values ('PX Deq: Join ACK','Idle');
insert into waitgroups values ('PX Deq Credit: need buffer','Idle');
insert into waitgroups values ('PX Deq: Msg Fragment','Idle');
insert into waitgroups values ('PX Deq: Parse Reply','Idle');
insert into waitgroups values ('PX Deq: Execute Reply','Idle');
insert into waitgroups values ('PX Deq: Execution Msg','Idle');
insert into waitgroups values ('PX Deq: Table Q Normal','Idle');
insert into waitgroups values ('PX Deq: Table Q Sample','Idle');
insert into waitgroups values ('Streams fetch slave: waiting for txns','Idle');
insert into waitgroups values ('Streams capture: filter callback waiting for ruleset','Application') ;
insert into waitgroups values ('Streams: RAC waiting for inter instance ack','Cluster');
insert into waitgroups values ('Streams: apply reader waiting for DDL to apply','Application');
insert into waitgroups values ('Streams capture: waiting for subscribers to catch up','Configuration ');
insert into waitgroups values ('Streams capture: resolve low memory condition','Configuration');
insert into waitgroups values ('enq: ZG - contention','Administrative');
insert into waitgroups values ('single-task message','Idle');
insert into waitgroups values ('SQL*Net message to client','Network');
insert into waitgroups values ('SQL*Net message to dblink','Network');
insert into waitgroups values ('SQL*Net more data to client','Network');
insert into waitgroups values ('SQL*Net more data to dblink','Network'); 
insert into waitgroups values ('SQL*Net message from client','Idle');
insert into waitgroups values ('SQL*Net more data from client','Network');
insert into waitgroups values ('SQL*Net message from dblink','Idle');
insert into waitgroups values ('SQL*Net more data from dblink','Network');
insert into waitgroups values ('SQL*Net break/reset to client','Application');
insert into waitgroups values ('SQL*Net break/reset to dblink','Application');
insert into waitgroups values ('PL/SQL lock timer','Idle');
insert into waitgroups values ('enq: UL - contention','Application');
insert into waitgroups values ('wait for EMON to process ntfns','Configuration');
insert into waitgroups values ('EMON idle wait','Idle');
insert into waitgroups values ('Streams AQ: waiting for messages in the queue','Idle');
insert into waitgroups values ('Streams AQ: waiting for time management or cleanup tasks','Idle');
insert into waitgroups values ('Streams AQ: enqueue blocked on low memory','Configuration');
insert into waitgroups values ('Streams AQ: delete acknowledged messages','Idle');
insert into waitgroups values ('Streams AQ: deallocate messages from Streams Pool','Idle');
insert into waitgroups values ('Streams AQ: qmn coordinator idle wait','Idle');
insert into waitgroups values ('Streams AQ: qmn slave idle wait','Idle'); 
insert into waitgroups values ('Streams AQ: RAC qmn coordinator idle wait','Idle');
insert into waitgroups values ('HS message to agent','Idle');
insert into waitgroups values ('ASM COD rollback operation completion','Administrative');
insert into waitgroups values ('kfk: async disk IO','System I/O');
insert into waitgroups values ('ASM background timer','Idle');
insert into waitgroups values ('ASM mount : wait for heartbeat','Administrative');
insert into waitgroups values ('ASM PST query : wait for [PM][grp][0] grant','Cluster');
insert into waitgroups values ('lock remastering','Cluster');
insert into waitgroups values ('JS kgl get object wait','Administrative');
insert into waitgroups values ('JS external job','Idle'); 
insert into waitgroups values ('JS kill job wait','Administrative');
insert into waitgroups values ('JS coord start wait','Administrative');
insert into waitgroups values ('events in waitclass Other','Other');
insert into waitgroups values ('unspecified wait event','Other');
insert into waitgroups values ('latch activity','Other');
insert into waitgroups values ('wait list latch activity','Other');
insert into waitgroups values ('latch free','Other');
insert into waitgroups values ('wait list latch free','Other');
insert into waitgroups values ('ksqded','Other');
insert into waitgroups values ('global enqueue expand wait','Other');
insert into waitgroups values ('enq: KM - contention','Other');
insert into waitgroups values ('enq: KT - contention','Other');
insert into waitgroups values ('free process state object','Other');
insert into waitgroups values ('inactive session','Other');
insert into waitgroups values ('process terminate','Other');
insert into waitgroups values ('latch: session allocation','Other');
insert into waitgroups values ('check CPU wait times','Other');
insert into waitgroups values ('enq: CI - contention','Other');
insert into waitgroups values ('enq: PR - contention','Other');
insert into waitgroups values ('ksim generic wait event','Other');
insert into waitgroups values ('debugger command','Other');
insert into waitgroups values ('ksdxexeother','Other');
insert into waitgroups values ('ksdxexeotherwait','Other');
insert into waitgroups values ('enq: PE - contention','Other');
insert into waitgroups values ('enq: PG - contention','Other');
insert into waitgroups values ('ksbsrv','Other');
insert into waitgroups values ('ksbcic','Other');
insert into waitgroups values ('process startup','Other');
insert into waitgroups values ('process shutdown','Other');
insert into waitgroups values ('prior spawner clean up','Other');
insert into waitgroups values ('latch: messages','Other');
insert into waitgroups values ('rdbms ipc message block','Other');
insert into waitgroups values ('rdbms ipc reply','Other');
insert into waitgroups values ('latch: enqueue hash chains','Other');
insert into waitgroups values ('enq: FP - global fob contention','Other');
insert into waitgroups values ('imm op','Other');
insert into waitgroups values ('slave exit','Other');
insert into waitgroups values ('reliable message','Other');
insert into waitgroups values ('master exit','Other');
insert into waitgroups values ('ksv slave avail wait','Other');
insert into waitgroups values ('enq: PV - syncstart','Other');
insert into waitgroups values ('enq: PV - syncshut','Other');
insert into waitgroups values ('IPC send completion sync','Other');
insert into waitgroups values ('IPC wait for name service busy','Other'); 
insert into waitgroups values ('IPC busy async request','Other');
insert into waitgroups values ('IPC waiting for OSD resources','Other');
insert into waitgroups values ('ksxr poll remote instances','Other');
insert into waitgroups values ('ksxr wait for mount shared','Other');
insert into waitgroups values ('DBMS_LDAP: LDAP operation ','Other');
insert into waitgroups values ('wait for FMON to come up','Other');
insert into waitgroups values ('enq: FM - contention','Other');
insert into waitgroups values ('enq: XY - contention','Other');
insert into waitgroups values ('set director factor wait','Other');
insert into waitgroups values ('enq: AS - service activation','Other');
insert into waitgroups values ('enq: AS - modify service','Other');
insert into waitgroups values ('enq: PD - contention','Other');
insert into waitgroups values ('cleanup of aborted process','Other');
insert into waitgroups values ('enq: RU - contention','Other');
insert into waitgroups values ('enq: RU - waiting','Other');
insert into waitgroups values ('rolling migration: cluster quiesce','Other');
insert into waitgroups values ('LMON global data update','Other');
insert into waitgroups values ('latch: ges resource hash list','Other');
insert into waitgroups values ('DFS lock handle','Other');
insert into waitgroups values ('ges LMD to shutdown','Other');
insert into waitgroups values ('ges global resource directory to be frozen','Other');
insert into waitgroups values ('ges resource directory to be unfrozen','Other');
insert into waitgroups values ('gcs resource directory to be unfrozen','Other'); 
insert into waitgroups values ('ges LMD to inherit communication channels','Other');
insert into waitgroups values ('ges wait for lmon to be ready','Other');
insert into waitgroups values ('ges cgs registration','Other');
insert into waitgroups values ('wait for master scn','Other');
insert into waitgroups values ('ges reconfiguration to start','Other');
insert into waitgroups values ('ges2 proc latch in rm latch get 1','Other');
insert into waitgroups values ('ges2 proc latch in rm latch get 2','Other');
insert into waitgroups values ('ges lmd/lmses to freeze in rcfg - mrcvr','Other');
insert into waitgroups values ('ges lmd/lmses to unfreeze in rcfg - mrcvr','Other');
insert into waitgroups values ('ges LMON to join CGS group','Other');
insert into waitgroups values ('ges pmon to exit','Other');
insert into waitgroups values ('ges lmd and pmon to attach','Other');
insert into waitgroups values ('gcs drm freeze begin','Other');
insert into waitgroups values ('gcs remastering wait for write latch','Other');
insert into waitgroups values ('gcs remastering wait for read latch','Other');
insert into waitgroups values ('ges cached resource cleanup','Other');
insert into waitgroups values ('ges generic event','Other');
insert into waitgroups values ('ges retry query node','Other'); 
insert into waitgroups values ('ges process with outstanding i/o','Other');
insert into waitgroups values ('ges user error','Other');
insert into waitgroups values ('ges enter server mode','Other');
insert into waitgroups values ('gcs enter server mode','Other');
insert into waitgroups values ('gcs drm freeze in enter server mode','Other');
insert into waitgroups values ('gcs ddet enter server mode','Other');
insert into waitgroups values ('ges cancel','Other');
insert into waitgroups values ('ges resource cleanout during enqueue open','Other');
insert into waitgroups values ('ges resource cleanout during enqueue open-cvt','Other'); 
insert into waitgroups values ('ges master to get established for SCN op','Other');
insert into waitgroups values ('ges LMON to get to FTDONE ','Other');
insert into waitgroups values ('ges1 LMON to wake up LMD - mrcvr','Other'); 
insert into waitgroups values ('ges2 LMON to wake up LMD - mrcvr','Other');
insert into waitgroups values ('ges2 LMON to wake up lms - mrcvr 2','Other');
insert into waitgroups values ('ges2 LMON to wake up lms - mrcvr 3','Other');
insert into waitgroups values ('ges inquiry response','Other');
insert into waitgroups values ('ges reusing os pid','Other');
insert into waitgroups values ('ges LMON for send queues','Other');
insert into waitgroups values ('ges LMD suspend for testing event','Other');
insert into waitgroups values ('ges performance test completion','Other');
insert into waitgroups values ('kjbopen wait for recovery domain attach','Other');
insert into waitgroups values ('kjudomatt wait for recovery domain attach','Other');
insert into waitgroups values ('kjudomdet wait for recovery domain detach','Other');
insert into waitgroups values ('kjbdomalc allocate recovery domain - retry','Other');
insert into waitgroups values ('kjbdrmcvtq lmon drm quiesce: ping completion','Other');
insert into waitgroups values ('KJC: Wait for msg sends to complete','Other');
insert into waitgroups values ('kjctssqmg: quick message send wait','Other');
insert into waitgroups values ('kjctcisnd: Queue/Send client message','Other');
insert into waitgroups values ('gcs domain validation','Other');
insert into waitgroups values ('latch: gcs resource hash','Other');
insert into waitgroups values ('affinity expansion in replay','Other');
insert into waitgroups values ('wait for sync ack','Other');
insert into waitgroups values ('wait for verification ack','Other');
insert into waitgroups values ('wait for assert messages to be sent','Other');
insert into waitgroups values ('wait for scn ack','Other');
insert into waitgroups values ('lms flush message acks','Other');
insert into waitgroups values ('name-service call wait','Other');
insert into waitgroups values ('CGS wait for IPC msg','Other');
insert into waitgroups values ('kjxgrtest','Other');
insert into waitgroups values ('wait for tmc2 to complete','Other');
insert into waitgroups values ('wait for votes','Other');
insert into waitgroups values ('wait for rr lock release','Other');
insert into waitgroups values ('wait for message ack','Other');
insert into waitgroups values ('wait for record update','Other');
insert into waitgroups values ('wait for membership synchronization','Other');
insert into waitgroups values ('wait for split-brain resolution','Other');
insert into waitgroups values ('CGS skgxn join retry','Other');
insert into waitgroups values ('gcs to be enabled','Other');
insert into waitgroups values ('gcs log flush sync','Other');
insert into waitgroups values ('SGA: allocation forcing component growth','Other');
insert into waitgroups values ('SGA: sga_target resize','Other');
insert into waitgroups values ('control file heartbeat','Other');
insert into waitgroups values ('control file diagnostic dump','Other');
insert into waitgroups values ('enq: CF - contention','Other');
insert into waitgroups values ('enq: SW - contention','Other');
insert into waitgroups values ('enq: DS - contention','Other');
insert into waitgroups values ('enq: TC - contention','Other');
insert into waitgroups values ('enq: TC - contention2','Other');
insert into waitgroups values ('buffer exterminate','Other');
insert into waitgroups values ('buffer resize','Other');
insert into waitgroups values ('latch: cache buffers lru chain','Other');
insert into waitgroups values ('enq: PW - perwarm status in dbw0','Other');
insert into waitgroups values ('latch: checkpoint queue latch','Other');
insert into waitgroups values ('latch: cache buffer handles','Other');
insert into waitgroups values ('kcbzps','Other');
insert into waitgroups values ('buffer deadlock','Other');
insert into waitgroups values ('buffer latch','Other');
insert into waitgroups values ('cr request retry','Other');
insert into waitgroups values ('writes stopped by instance recovery or database suspension','Other') ;
insert into waitgroups values ('lock escalate retry','Other');
insert into waitgroups values ('lock deadlock retry','Other');
insert into waitgroups values ('prewarm transfer retry','Other');
insert into waitgroups values ('wait for MTTR advisory state object','Other');
insert into waitgroups values ('latch: object queue header operation','Other');
insert into waitgroups values ('latch: object queue header heap','Other');
insert into waitgroups values ('enq: WR - contention','Other');
insert into waitgroups values ('log switch/archive','Other');
insert into waitgroups values ('ARCH wait on c/f tx acquire 1','Other');
insert into waitgroups values ('ARCH wait on c/f tx acquire 2','Other');
insert into waitgroups values ('ARCH wait for process start 1','Other');
insert into waitgroups values ('ARCH wait for process death 1','Other');
insert into waitgroups values ('ARCH wait for process start 2','Other');
insert into waitgroups values ('ARCH wait for process death 2','Other');
insert into waitgroups values ('ARCH wait for process start 3','Other');
insert into waitgroups values ('ARCH wait for process death 3','Other');
insert into waitgroups values ('ARCH wait for process start 4','Other');
insert into waitgroups values ('ARCH wait for process death 4','Other');
insert into waitgroups values ('ARCH wait for process death 5','Other'); 
insert into waitgroups values ('ARCH wait for archivelog lock','Other');
insert into waitgroups values ('Wait on stby instance close','Other');
insert into waitgroups values ('RFS dispatch','Other');
insert into waitgroups values ('RFS attach','Other');
insert into waitgroups values ('RFS create','Other');
insert into waitgroups values ('RFS close','Other');
insert into waitgroups values ('RFS announce','Other');
insert into waitgroups values ('RFS register','Other');
insert into waitgroups values ('RFS detach','Other');
insert into waitgroups values ('RFS ping','Other');
insert into waitgroups values ('LGWR simulation latency wait','Other');
insert into waitgroups values ('LGWR-LNS wait on channel','Other');
insert into waitgroups values ('LGWR wait on full LNS buffer','Other');
insert into waitgroups values ('LNS simulation latency wait','Other');
insert into waitgroups values ('kcrrrcp','Other'); 
insert into waitgroups values ('LNS wait for LGWR redo','Other');
insert into waitgroups values ('Data Guard: process exit','Other');
insert into waitgroups values ('Data Guard: process clean up','Other');
insert into waitgroups values ('MRP wait on process start','Other');
insert into waitgroups values ('MRP wait on process restart','Other');
insert into waitgroups values ('MRP wait on startup clear','Other');
insert into waitgroups values ('MRP wait on process death','Other');
insert into waitgroups values ('MRP wait on state change','Other');
insert into waitgroups values ('MRP wait on state n_a','Other');
insert into waitgroups values ('MRP wait on state reset','Other');
insert into waitgroups values ('MRP wait on archivelog delay','Other');
insert into waitgroups values ('MRP wait on archivelog arrival','Other');
insert into waitgroups values ('MRP wait on archivelog archival','Other');
insert into waitgroups values ('FAL archive wait 1 sec for REOPEN minimum','Other');
insert into waitgroups values ('LGWR wait for redo copy','Other');
insert into waitgroups values ('latch: redo allocation','Other');
insert into waitgroups values ('log file switch (clearing log file)','Other');
insert into waitgroups values ('simulated log write delay','Other');
insert into waitgroups values ('enq: WL - contention','Other');
insert into waitgroups values ('enq: RN - contention','Other');
insert into waitgroups values ('DFS db file lock','Other');
insert into waitgroups values ('enq: DF - contention','Other');
insert into waitgroups values ('enq: IS - contention','Other');
insert into waitgroups values ('enq: FS - contention','Other'); 
insert into waitgroups values ('enq: DM - contention','Other');
insert into waitgroups values ('enq: RP - contention','Other');
insert into waitgroups values ('latch: KCL gc element parent latch','Other');
insert into waitgroups values ('enq: RT - contention','Other');
insert into waitgroups values ('enq: KK - context','Other');
insert into waitgroups values ('enq: IR - contention','Other');
insert into waitgroups values ('enq: IR - contention2','Other'); 
insert into waitgroups values ('enq: MR - contention','Other');
insert into waitgroups values ('enq: BR - file shrink','Other');
insert into waitgroups values ('enq: BR - proxy-copy','Other');
insert into waitgroups values ('enq: ID - contention','Other');
insert into waitgroups values ('enq: MN - contention','Other');
insert into waitgroups values ('enq: PL - contention','Other');
insert into waitgroups values ('Logical Standby Apply shutdown','Other');
insert into waitgroups values ('Logical Standby pin transaction','Other');
insert into waitgroups values ('Logical Standby dictionary build','Other'); 
insert into waitgroups values ('Logical Standby Terminal Apply','Other');
insert into waitgroups values ('enq: SB - contention','Other');
insert into waitgroups values ('enq: XR - quiesce database','Other');
insert into waitgroups values ('enq: XR - database force logging','Other');
insert into waitgroups values ('change tracking file synchronous read','Other');
insert into waitgroups values ('change tracking file synchronous write','Other');
insert into waitgroups values ('change tracking file parallel write','Other'); 
insert into waitgroups values ('block change tracking buffer space','Other');
insert into waitgroups values ('enq: CT - global space management','Other');
insert into waitgroups values ('enq: CT - local space management','Other');
insert into waitgroups values ('enq: CT - change stream ownership','Other');
insert into waitgroups values ('enq: CT - state','Other');
insert into waitgroups values ('enq: CT - state change gate 1','Other');
insert into waitgroups values ('enq: CT - state change gate 2','Other');
insert into waitgroups values ('enq: CT - CTWR process start/stop','Other');
insert into waitgroups values ('enq: CT - reading','Other');
insert into waitgroups values ('recovery area: computing dropped files','Other');
insert into waitgroups values ('recovery area: computing obsolete files','Other');
insert into waitgroups values ('recovery area: computing identical files','Other');
insert into waitgroups values ('recovery area: computing backed up files','Other');
insert into waitgroups values ('recovery area: computing applied logs','Other');
insert into waitgroups values ('enq: RS - file delete','Other');
insert into waitgroups values ('enq: RS - record reuse','Other');
insert into waitgroups values ('enq: RS - prevent file delete','Other');
insert into waitgroups values ('enq: RS - prevent aging list update','Other');
insert into waitgroups values ('enq: RS - persist alert level','Other'); 
insert into waitgroups values ('enq: RS - read alert level','Other');
insert into waitgroups values ('enq: RS - write alert level','Other');
insert into waitgroups values ('enq: FL - Flashback database log','Other');
insert into waitgroups values ('enq: FL - Flashback db command','Other');
insert into waitgroups values ('enq: FD - Marker generation','Other');
insert into waitgroups values ('enq: FD - Tablespace flashback on/off','Other');
insert into waitgroups values ('enq: FD - Flashback coordinator','Other');
insert into waitgroups values ('enq: FD - Flashback on/off','Other');
insert into waitgroups values ('enq: FD - Restore point create/drop','Other');
insert into waitgroups values ('flashback free VI log','Other');
insert into waitgroups values ('flashback buf free by RVWR','Other');
insert into waitgroups values ('flashback log switch','Other');
insert into waitgroups values ('RVWR wait for flashback copy','Other');
insert into waitgroups values ('transaction','Other'); 
insert into waitgroups values ('inactive transaction branch','Other');
insert into waitgroups values ('txn to complete','Other');
insert into waitgroups values ('PMON to cleanup pseudo-branches at svc stop time','Other');
insert into waitgroups values ('test long ops','Other');
insert into waitgroups values ('enq: TF - contention','Other');
insert into waitgroups values ('Wait for shrink lock2','Other');
insert into waitgroups values ('Wait for shrink lock','Other');
insert into waitgroups values ('L1 validation','Other');
insert into waitgroups values ('Wait for TT enqueue','Other');
insert into waitgroups values ('kttm2d','Other'); 
insert into waitgroups values ('ktsambl','Other');
insert into waitgroups values ('ktfbtgex','Other');
insert into waitgroups values ('enq: DT - contention','Other');
insert into waitgroups values ('enq: TS - contention','Other');
insert into waitgroups values ('enq: FB - contention','Other');
insert into waitgroups values ('enq: SK - contention','Other');
insert into waitgroups values ('latch: undo global data','Other');
insert into waitgroups values ('undo segment recovery','Other');
insert into waitgroups values ('unbound tx','Other');
insert into waitgroups values ('wait for change','Other');
insert into waitgroups values ('wait for another txn - undo rcv abort','Other');
insert into waitgroups values ('wait for another txn - txn abort','Other');
insert into waitgroups values ('wait for another txn - rollback to savepoint','Other');
insert into waitgroups values ('undo_retention publish retry','Other');
insert into waitgroups values ('enq: TA - contention','Other');
insert into waitgroups values ('enq: TX - contention','Other');
insert into waitgroups values ('enq: US - contention','Other');
insert into waitgroups values ('enq: SU - contention','Other'); 
insert into waitgroups values ('enq: TT - contention','Other');
insert into waitgroups values ('ktm: instance recovery','Other');
insert into waitgroups values ('instance state change','Other');
insert into waitgroups values ('wait for stopper event to be increased','Other');
insert into waitgroups values ('wait for a undo record','Other');
insert into waitgroups values ('wait for a paralle reco to abort','Other');
insert into waitgroups values ('enq: IM - contention for blr','Other');
insert into waitgroups values ('enq: TD - KTF dump entries','Other'); 
insert into waitgroups values ('enq: TE - KTF broadcast','Other');
insert into waitgroups values ('enq: CN - race with txn','Other');
insert into waitgroups values ('enq: CN - race with reg','Other');
insert into waitgroups values ('enq: CN - race with init','Other');
insert into waitgroups values ('latch: Change Notification Hash table latch','Other');
insert into waitgroups values ('index block split','Other');
insert into waitgroups values ('enq: HV - contention','Other');
insert into waitgroups values ('dupl. cluster key','Other');
insert into waitgroups values ('kdic_do_merge','Other');
insert into waitgroups values ('enq: DL - contention','Other');
insert into waitgroups values ('enq: HQ - contention','Other');
insert into waitgroups values ('enq: HP - contention','Other');
insert into waitgroups values ('enq: DV - contention','Other');
insert into waitgroups values ('enq: RW - MV metadata contention','Other');
insert into waitgroups values ('enq: OC - contention','Other');
insert into waitgroups values ('enq: OL - contention','Other');
insert into waitgroups values ('kkdlgon','Other');
insert into waitgroups values ('kkdlsipon','Other');
insert into waitgroups values ('kkdlhpon','Other');
insert into waitgroups values ('kgltwait','Other');
insert into waitgroups values ('kksfbc research','Other');
insert into waitgroups values ('kksscl hash split','Other');
insert into waitgroups values ('kksfbc child completion','Other');
insert into waitgroups values ('enq: CU - contention','Other');
insert into waitgroups values ('cursor: pin X','Other');
insert into waitgroups values ('cursor: pin S','Other');
insert into waitgroups values ('enq: PF - contention','Other');
insert into waitgroups values ('enq: IL - contention','Other');
insert into waitgroups values ('enq: CL - drop label','Other');
insert into waitgroups values ('enq: CL - compare labels','Other');
insert into waitgroups values ('enq: MK - contention','Other');
insert into waitgroups values ('enq: OW - initialization','Other');
insert into waitgroups values ('enq: OW - termination','Other');
insert into waitgroups values ('enq: AU - audit index file','Other');
insert into waitgroups values ('enq: DX - contention','Other');
insert into waitgroups values ('enq: DR - contention','Other');
insert into waitgroups values ('pending global transaction(s)','Other');
insert into waitgroups values ('free global transaction table entry','Other');
insert into waitgroups values ('library cache revalidation','Other');
insert into waitgroups values ('library cache shutdown','Other');
insert into waitgroups values ('BFILE closure','Other');
insert into waitgroups values ('BFILE check if exists','Other');
insert into waitgroups values ('BFILE check if open','Other');
insert into waitgroups values ('BFILE get length','Other');
insert into waitgroups values ('BFILE get name object','Other');
insert into waitgroups values ('BFILE get path object','Other');
insert into waitgroups values ('BFILE open','Other');
insert into waitgroups values ('BFILE internal seek','Other');
insert into waitgroups values ('waiting to get CAS latch','Other');
insert into waitgroups values ('waiting to get RM CAS latch','Other');
insert into waitgroups values ('dispatcher shutdown','Other');
insert into waitgroups values ('latch: virtual circuit queues','Other');
insert into waitgroups values ('listen endpoint status','Other');
insert into waitgroups values ('select wait','Other');
insert into waitgroups values ('jobq slave shutdown wait','Other');
insert into waitgroups values ('jobq slave TJ process wait','Other'); 
insert into waitgroups values ('job scheduler coordinator slave wait','Other');
insert into waitgroups values ('enq: JD - contention','Other');
insert into waitgroups values ('enq: JQ - contention','Other');
insert into waitgroups values ('kkshgnc reloop','Other');
insert into waitgroups values ('optimizer stats update retry','Other');
insert into waitgroups values ('wait active processes','Other');
insert into waitgroups values ('enq: MD - contention','Other');
insert into waitgroups values ('enq: MS - contention','Other');
insert into waitgroups values ('PX slave connection','Other');
insert into waitgroups values ('PX slave release','Other');
insert into waitgroups values ('PX Send Wait','Other'); 
insert into waitgroups values ('PX qref latch','Other');
insert into waitgroups values ('PX server shutdown','Other');
insert into waitgroups values ('PX create server','Other');
insert into waitgroups values ('PX signal server','Other');
insert into waitgroups values ('PX Deq Credit: free buffer','Other');
insert into waitgroups values ('PX Deq Credit: send blkd','Other'); 
insert into waitgroups values ('PX Deq: Test for msg','Other');
insert into waitgroups values ('PX Deq: Signal ACK','Other');
insert into waitgroups values ('PX Deq: reap credit','Other');
insert into waitgroups values ('PX Nsq: PQ descriptor query','Other');
insert into waitgroups values ('PX Nsq: PQ load info query','Other');
insert into waitgroups values ('enq: PI - contention','Other');
insert into waitgroups values ('enq: PS - contention','Other');
insert into waitgroups values ('latch: parallel query alloc buffer','Other'); 
insert into waitgroups values ('kxfxse','Other');
insert into waitgroups values ('kxfxsp','Other');
insert into waitgroups values ('PX Deq: Table Q qref','Other');
insert into waitgroups values ('PX Deq: Table Q Get Keys','Other');
insert into waitgroups values ('PX Deq: Table Q Close','Other');
insert into waitgroups values ('GV$: slave acquisition retry wait time','Other');
insert into waitgroups values ('enq: TO - contention','Other');
insert into waitgroups values ('enq: IT - contention','Other'); 
insert into waitgroups values ('enq: BF - allocation contention','Other');
insert into waitgroups values ('timer in sksawat','Other');
insert into waitgroups values ('scginq AST call','Other');
insert into waitgroups values ('kupp process wait','Other');
insert into waitgroups values ('Kupp process shutdown','Other');
insert into waitgroups values ('enq: KP - contention','Other');
insert into waitgroups values ('Replication Dequeue ','Other');
insert into waitgroups values ('knpc_acwm_AwaitChangedWaterMark','Other');
insert into waitgroups values ('knpc_anq_AwaitNonemptyQueue','Other');
insert into waitgroups values ('knpsmai','Other');
insert into waitgroups values ('enq: SR - contention','Other');
insert into waitgroups values ('Streams capture: waiting for database startup','Other'); 
insert into waitgroups values ('Streams capture: waiting for archive log','Other');
insert into waitgroups values ('enq: SI - contention','Other');
insert into waitgroups values ('enq: IA - contention','Other');
insert into waitgroups values ('enq: JI - contention','Other');
insert into waitgroups values ('qerex_gdml','Other');
insert into waitgroups values ('enq: AT - contention','Other');
insert into waitgroups values ('opishd','Other');
insert into waitgroups values ('wait for EMON to spawn','Other');
insert into waitgroups values ('wait for EMON to die','Other');
insert into waitgroups values ('enq: SE - contention','Other');
insert into waitgroups values ('tsm with timeout','Other');
insert into waitgroups values ('Streams AQ: waiting for busy instance for instance_name','Other');
insert into waitgroups values ('enq: TQ - TM contention','Other');
insert into waitgroups values ('enq: TQ - DDL contention','Other');
insert into waitgroups values ('enq: TQ - INI contention','Other');
insert into waitgroups values ('enq: DP - contention','Other');
insert into waitgroups values ('enq: MH - contention','Other');
insert into waitgroups values ('enq: ML - contention','Other');
insert into waitgroups values ('enq: PH - contention','Other');
insert into waitgroups values ('enq: SF - contention','Other');
insert into waitgroups values ('enq: XH - contention','Other');
insert into waitgroups values ('enq: WA - contention','Other'); 
insert into waitgroups values ('Streams AQ: enqueue blocked due to flow control','Other');
insert into waitgroups values ('queue slave messages','Other');
insert into waitgroups values ('Streams AQ: qmn coordinator waiting for slave to start','Other');
insert into waitgroups values ('rfm_dmon_pdefer','Other');
insert into waitgroups values ('rfm_dmon_shut','Other');
insert into waitgroups values ('rfm_dmon_timeout_op','Other');
insert into waitgroups values ('rfm_pmon_dso_stall','Other');
insert into waitgroups values ('rfm_dmon_last_gasp','Other');
insert into waitgroups values ('Data Guard broker: single instance','Other');
insert into waitgroups values ('rfrm_dbop','Other');
insert into waitgroups values ('rfrm_dbcl','Other'); 
insert into waitgroups values ('rfrm_stall','Other');
insert into waitgroups values ('rfrm_rsm_shut','Other');
insert into waitgroups values ('rfrm_zero_sub_count','Other');
insert into waitgroups values ('rfrm_rsm_start','Other');
insert into waitgroups values ('rfrm_nonzero_sub_count','Other');
insert into waitgroups values ('rfrm_rsm_so_attach','Other');
insert into waitgroups values ('rfi_drcx_site_del','Other');
insert into waitgroups values ('rfi_insv_shut','Other');
insert into waitgroups values ('rfi_insv_start','Other');
insert into waitgroups values ('rfi_nsv_deldef','Other');
insert into waitgroups values ('rfi_nsv_md_close','Other');
insert into waitgroups values ('rfi_nsv_md_write','Other'); 
insert into waitgroups values ('rfi_nsv_postdef','Other');
insert into waitgroups values ('rfi_nsv_shut','Other');
insert into waitgroups values ('rfi_nsv_start','Other');
insert into waitgroups values ('rfi_recon1','Other');
insert into waitgroups values ('rfi_recon2','Other');
insert into waitgroups values ('enq: RF - synch: DG Broker metadata','Other'); 
insert into waitgroups values ('enq: RF - atomicity','Other');
insert into waitgroups values ('enq: RF - synchronization: chief','Other');
insert into waitgroups values ('enq: RF - synchronization: HC master','Other');
insert into waitgroups values ('enq: RF - synchronization: aifo master','Other');
insert into waitgroups values ('enq: RF - new AI','Other');
insert into waitgroups values ('enq: RF - synchronization: critical ai','Other');
insert into waitgroups values ('enq: RF - RF - FSFO state','Other');
insert into waitgroups values ('enq: RF - RF - FSFO wait','Other');
insert into waitgroups values ('enq: RF - RF - FSFO connectivity','Other');
insert into waitgroups values ('enq: RF - RF - FSFO synchronization','Other');
insert into waitgroups values ('enq: RF - RF - FSFO Observed','Other');
insert into waitgroups values ('rfrxptarcurlog','Other');
insert into waitgroups values ('rfrxpt_pdl','Other');
insert into waitgroups values ('rfrdb_recon1','Other');
insert into waitgroups values ('rfrdb_recon2','Other');
insert into waitgroups values ('rfrdb_dbop','Other');
insert into waitgroups values ('rfrdb_try235','Other');
insert into waitgroups values ('Data Guard broker: wait upon ORA-12850 error','Other');
insert into waitgroups values ('rfrla_lapp1','Other');
insert into waitgroups values ('rfrla_lapp2','Other');
insert into waitgroups values ('rfrla_lapp3','Other');
insert into waitgroups values ('rfrla_lapp4','Other');
insert into waitgroups values ('rfrla_lapp5','Other');
insert into waitgroups values ('rfrpa_mrpup','Other');
insert into waitgroups values ('rfrpa_mrpdn','Other');
insert into waitgroups values ('RF - FSFO Wait for Ack','Other');
insert into waitgroups values ('rfrld_rhmrpwait','Other');
insert into waitgroups values ('PX Deq: OLAP Update Reply','Other');
insert into waitgroups values ('PX Deq: OLAP Update Execute','Other');
insert into waitgroups values ('PX Deq: OLAP Update Close','Other');
insert into waitgroups values ('OLAP Parallel Type Deq','Other');
insert into waitgroups values ('OLAP Parallel Temp Grow Request','Other');
insert into waitgroups values ('OLAP Parallel Temp Grow Wait','Other');
insert into waitgroups values ('OLAP Parallel Temp Grew','Other');
insert into waitgroups values ('OLAP Null PQ Reason','Other');
insert into waitgroups values ('OLAP Aggregate Master Enq','Other');
insert into waitgroups values ('OLAP Aggregate Client Enq','Other');
insert into waitgroups values ('OLAP Aggregate Master Deq','Other');
insert into waitgroups values ('OLAP Aggregate Client Deq','Other');
insert into waitgroups values ('enq: AW - AW$ table lock','Other');
insert into waitgroups values ('enq: AW - AW state lock','Other');
insert into waitgroups values ('enq: AW - user access for AW','Other');
insert into waitgroups values ('enq: AW - AW generation lock','Other');
insert into waitgroups values ('enq: AG - contention','Other');
insert into waitgroups values ('enq: AO - contention','Other');
insert into waitgroups values ('enq: OQ - xsoqhiAlloc','Other');
insert into waitgroups values ('enq: OQ - xsoqhiFlush','Other');
insert into waitgroups values ('enq: OQ - xsoq*histrecb','Other');
insert into waitgroups values ('enq: OQ - xsoqhiClose','Other');
insert into waitgroups values ('enq: OQ - xsoqhistrecb','Other');
insert into waitgroups values ('enq: AM - client registration','Other');
insert into waitgroups values ('enq: AM - shutdown','Other');
insert into waitgroups values ('enq: AM - rollback COD reservation','Other');
insert into waitgroups values ('ASM internal hang test','Other');
insert into waitgroups values ('buffer busy','Other');
insert into waitgroups values ('buffer freelistbusy','Other');
insert into waitgroups values ('buffer rememberlist busy','Other');
insert into waitgroups values ('buffer writeList full','Other');
insert into waitgroups values ('no free buffers','Other');
insert into waitgroups values ('buffer write wait','Other');
insert into waitgroups values ('buffer invalidation wait','Other');
insert into waitgroups values ('buffer dirty disabled','Other');
insert into waitgroups values ('enq: CM - gate','Other');
insert into waitgroups values ('enq: CM - instance','Other');
insert into waitgroups values ('enq: XQ - recovery','Other');
insert into waitgroups values ('enq: XQ - relocation','Other');
insert into waitgroups values ('enq: AD - allocate AU','Other');
insert into waitgroups values ('enq: AD - deallocate AU','Other');
insert into waitgroups values ('extent map load/unlock','Other');
insert into waitgroups values ('Sync ASM rebalance','Other');
insert into waitgroups values ('enq: DG - contention','Other');
insert into waitgroups values ('enq: DD - contention','Other');
insert into waitgroups values ('enq: HD - contention','Other');
insert into waitgroups values ('enq: DN - contention','Other');
insert into waitgroups values ('Cluster stablization wait','Other');
insert into waitgroups values ('Cluster Suspension wait','Other');
insert into waitgroups values ('ASM background starting','Other');
insert into waitgroups values ('ASM background running','Other');
insert into waitgroups values ('ASM db client exists','Other');
insert into waitgroups values ('DBFG waiting for reply','Other');
insert into waitgroups values ('enq: FA - access file','Other');
insert into waitgroups values ('log write(odd)','Other');
insert into waitgroups values ('log write(even)','Other');
insert into waitgroups values ('checkpoint advanced','Other');
insert into waitgroups values ('enq: FR - contention','Other');
insert into waitgroups values ('enq: FG - serialize ACD relocate','Other');
insert into waitgroups values ('enq: FG - FG redo generation enq race','Other');
insert into waitgroups values ('enq: FG - LGWR redo generation enq race','Other');
insert into waitgroups values ('enq: FT - allow LGWR writes','Other');
insert into waitgroups values ('enq: FT - disable LGWR writes','Other');
insert into waitgroups values ('enq: FC - open an ACD thread','Other');
insert into waitgroups values ('enq: FC - recover an ACD thread','Other');
insert into waitgroups values ('rollback operations block full','Other');
insert into waitgroups values ('rollback operations active','Other');
insert into waitgroups values ('enq: RB - contention','Other');
insert into waitgroups values ('enq: PT - contention','Other');
insert into waitgroups values ('global cache busy','Other');
insert into waitgroups values ('lock release pending','Other');
insert into waitgroups values ('dma prepare busy','Other');
insert into waitgroups values ('GCS lock cancel','Other');
insert into waitgroups values ('GCS lock open S','Other');
insert into waitgroups values ('GCS lock open X','Other');
insert into waitgroups values ('GCS lock open','Other');
insert into waitgroups values ('GCS lock cvt S','Other');
insert into waitgroups values ('GCS lock cvt X','Other');
insert into waitgroups values ('GCS lock esc X','Other');
insert into waitgroups values ('GCS lock esc','Other');
insert into waitgroups values ('GCS recovery lock open','Other');
insert into waitgroups values ('GCS recovery lock convert','Other');
insert into waitgroups values ('kfcl: instance recovery','Other');
insert into waitgroups values ('no free locks','Other');
insert into waitgroups values ('lock close','Other');
insert into waitgroups values ('enq: WF - contention','Other');
insert into waitgroups values ('enq: WP - contention','Other');
insert into waitgroups values ('enq: FU - contention','Other');
insert into waitgroups values ('enq: MW - contention','Other');
insert into waitgroups values ('AWR Flush','Other');
insert into waitgroups values ('AWR Metric Capture','Other');
insert into waitgroups values ('enq: TB - SQL Tuning Base Cache Update','Other');
insert into waitgroups values ('enq: TB - SQL Tuning Base Cache Load','Other');
insert into waitgroups values ('enq: SH - contention','Other');
insert into waitgroups values ('enq: AF - task serialization','Other');
insert into waitgroups values ('MMON slave messages','Other');
insert into waitgroups values ('MMON (Lite) shutdown','Other');
insert into waitgroups values ('enq: TL - contention','Other');
insert into waitgroups values ('enq: JS - contention','Other');
insert into waitgroups values ('enq: JS - job run lock - synchronize','Other');
insert into waitgroups values ('enq: JS - job recov lock','Other');
insert into waitgroups values ('enq: JS - queue lock','Other');
insert into waitgroups values ('enq: JS - sch locl enqs','Other');
insert into waitgroups values ('enq: JS - q mem clnup lck','Other');
insert into waitgroups values ('enq: JS - evtsub add','Other');
insert into waitgroups values ('enq: JS - evtsub drop','Other');
insert into waitgroups values ('enq: JS - wdw op','Other');
insert into waitgroups values ('enq: JS - evt notify','Other');
insert into waitgroups values ('secondary event','Other');
-- 9 waits
insert into waitgroups values ('unspecified event','Other');
insert into waitgroups values ('name service busy','Other');
insert into waitgroups values ('ksimret is busy in recovery','Other');
insert into waitgroups values ('background parameter adjustment','Other');
insert into waitgroups values ('enqueue','Application');
insert into waitgroups values ('trace writer flush','Other');
insert into waitgroups values ('trace writer I/O','Other');
insert into waitgroups values ('trace unfreeze','Other');
insert into waitgroups values ('trace continue','Other');
insert into waitgroups values ('async disk IO','Other');
insert into waitgroups values ('fib/fob latch','Other');
insert into waitgroups values ('sbtinit','Other');
insert into waitgroups values ('sbtopen','Other');
insert into waitgroups values ('sbtread','Other');
insert into waitgroups values ('sbtwrite','Other');
insert into waitgroups values ('sbtclose','Other');
insert into waitgroups values ('sbtinfo','Other');
insert into waitgroups values ('sbtremove','Other');
insert into waitgroups values ('sbtbackup','Other');
insert into waitgroups values ('sbtclose2','Other');
insert into waitgroups values ('sbtcommand','Other');
insert into waitgroups values ('sbtend','Other');
insert into waitgroups values ('sbterror','Other');
insert into waitgroups values ('sbtinfo2','Other');
insert into waitgroups values ('sbtinit2','Other');
insert into waitgroups values ('sbtread2','Other');
insert into waitgroups values ('sbtremove2','Other');
insert into waitgroups values ('sbtrestore','Other');
insert into waitgroups values ('sbtwrite2','Other');
insert into waitgroups values ('sbtpcbackup','Other');
insert into waitgroups values ('sbtpccancel','Other');
insert into waitgroups values ('sbtpccommit','Other');
insert into waitgroups values ('sbtpcend','Other');
insert into waitgroups values ('sbtpcquerybackup','Other');
insert into waitgroups values ('sbtpcqueryrestore','Other');
insert into waitgroups values ('sbtpcrestore','Other'); 
insert into waitgroups values ('sbtpcstart','Other');
insert into waitgroups values ('sbtpcstatus','Other');
insert into waitgroups values ('sbtpcvalidate','Other');
insert into waitgroups values ('DIAG dummy wait','Other');
insert into waitgroups values ('ges global resource directory to be unfrozen','Other');
insert into waitgroups values ('wait for scn from all nodes','Other');
insert into waitgroups values ('ges cgs de-registration','Other');
insert into waitgroups values ('ges server qs to be empty - kjbrrit','Other');
insert into waitgroups values ('ges proc table latch - kjdrptref','Other');
insert into waitgroups values ('ges lmd/lmses to freeze in rcfg - srcvr','Other');
insert into waitgroups values ('ges lmd/lmses to unfreeze in rcfg - srcvr','Other');
insert into waitgroups values ('ges process allocation','Other');
insert into waitgroups values ('ges drm deferred close','Other');
insert into waitgroups values ('ges drm freeze begin','Other');
insert into waitgroups values ('ges1 LMON to wake up LMD','Other');
insert into waitgroups values ('ges2 LMON to wake up LMD - srcvr','Other');
insert into waitgroups values ('ges LMON for send buffers to be empty','Other');
insert into waitgroups values ('ges LMS suspend for testing event','Other');
insert into waitgroups values ('wait for membership change','Other');
insert into waitgroups values ('gcs for action','Other');
insert into waitgroups values ('contacting SCN server or SCN lock master','Other');
insert into waitgroups values ('refresh controlfile command','Other');
insert into waitgroups values ('buffer busy global cache','Other');
insert into waitgroups values ('buffer busy global CR','Other');
insert into waitgroups values ('cache simulator heap','Other');
insert into waitgroups values ('conversion file read','Other');
insert into waitgroups values ('global cache open s','Other');
insert into waitgroups values ('global cache open x','Other');
insert into waitgroups values ('global cache null to s','Other');
insert into waitgroups values ('global cache null to x','Other');
insert into waitgroups values ('global cache s to x','Other');
insert into waitgroups values ('global cache cr request','Other');
insert into waitgroups values ('global cache cr disk request','Other');
insert into waitgroups values ('global cache freelist wait','Other');
insert into waitgroups values ('global cache bg acks','Other');
insert into waitgroups values ('global cache pending ast','Other');
insert into waitgroups values ('global cache retry prepare','Other');
insert into waitgroups values ('global cache cancel wait','Other');
insert into waitgroups values ('global cache cr cancel wait','Other');
insert into waitgroups values ('global cache pred cancel wait','Other');
insert into waitgroups values ('global cache domain validation','Other');
insert into waitgroups values ('global cache assume wait','Other');
insert into waitgroups values ('global cache recovery free wait','Other');
insert into waitgroups values ('global cache recovery quiesce wait','Other');
insert into waitgroups values ('global cache claim wait','Other');
insert into waitgroups values ('global cache remastering wait','Other');
insert into waitgroups values ('global cache quiesce wait','Other');
insert into waitgroups values ('direct path read (lob) ','Other');
insert into waitgroups values ('direct path write (lob)','Other');
insert into waitgroups values ('wait for activate message','Other');
insert into waitgroups values ('wakeup event for builder','Other');
insert into waitgroups values ('wakeup event for preparer','Other');
insert into waitgroups values ('wakeup event for reader','Other');
insert into waitgroups values ('wait for transaction','Other');
insert into waitgroups values ('wait for Logical Standby Apply shutdown','Other');
insert into waitgroups values ('Wait for Dictionary Build to lock all tables','Other');
insert into waitgroups values ('instance recovery','Other');
insert into waitgroups values ('file identify','Other');
insert into waitgroups values ('file open','Other');
insert into waitgroups values ('resmgr:wait in actses run','Other');
insert into waitgroups values ('resmgr:waiting in end wait','Other');
insert into waitgroups values ('resmgr:waiting in check','Other');
insert into waitgroups values ('resmgr:waiting in system stop','Other');
insert into waitgroups values ('resmgr:waiting in enter','Other');
insert into waitgroups values ('resmgr:waiting in shutdown','Other');
insert into waitgroups values ('resmgr:waiting in check2','Other');
insert into waitgroups values ('resmgr:waiting in enter2','Other');
insert into waitgroups values ('resmgr:waiting in run (queued)','Other');
insert into waitgroups values ('resmgr:waiting in end wait2','Other');
insert into waitgroups values ('resmgr:waiting for cschlat1','Other');
insert into waitgroups values ('resmgr:waiting for cschlat2','Other');
insert into waitgroups values ('resmgr:waiting for cschlat3','Other');
insert into waitgroups values ('resmgr:waiting for cschlat4','Other');
insert into waitgroups values ('slave shutdown wait','Other');
insert into waitgroups values ('slave TJ process wait','Other');
insert into waitgroups values ('qxdid_gdml','Other');
insert into waitgroups values ('queue messages','Other');
insert into waitgroups values ('wakeup time manager','Other');
insert into waitgroups values ('STREAMS apply coord waiting for slave message','Other');
insert into waitgroups values ('STREAMS apply coord waiting for some work to finish','Other');
insert into waitgroups values ('STREAMS fetch slave waiting for txns','Other');
insert into waitgroups values ('STREAMS apply slave waiting for coord message','Other');
insert into waitgroups values ('knlWaitForStartup','Other');
insert into waitgroups values ('STREAMS capture process waiting for archive log','Other');
insert into waitgroups values ('STREAMS capture process filter callback wait for ruleset','Other');
insert into waitgroups values ('Streams: Wating for DDL to apply','Other');
insert into waitgroups values ('knlqdeq','Other');