-- ********************************************************************
-- * Copyright Notice   : (c)20012007 OraPub, Inc.
-- * Filename           : event_type_nc.sql -- For pre-10g databases
-- * Author             : Craig A. Shallahamer
-- * Original           : 11-may-01
-- * Last Update        : 17-Mar-09
-- * Description        : event_type_nc.sql - Loads "event type" table
-- *                      which is used by other scripts.
-- * Usage              : start event_type.sql
-- *                      This is called by osmprep.sql
-- ********************************************************************

prompt
prompt file: event_type.sql
prompt
prompt The WAIT EVENT category table, o$event_type, is about
prompt to be dropped, created, and re-loaded.
prompt
prompt This table is required by all of OraPub's response time 
prompt reports (interactive and historical) and OraPub's 
prompt session wait related reports.
prompt
prompt Press ENTER to re-create the o$event_type table.
accept x

-- Event TYPES are defined as follows:

-- ior   - IO read related wait
-- iow   - IO write related wait
-- other - "real" but not explicitly categorized wait
-- idle  - idle event that is sometimes useful (e.g., SQL*Net...)

drop table o$event_type
/
create table o$event_type (
event		varchar2(64),
type		varchar2(64)
)
/

-- To re-fresh the inserts below, go to an Oracle 10g+ enviornment, run event_type.sql to load
-- the o$event_type table, run the below SQL, connect to sqlplus as the OSM user,
-- copy the resulting inserts into sqlplus, and commmit.
--
-- The following inserts came from a 11g environment.

-- THE LAST FEW INSERTS (at the bottom of this file) MUST ALWAYS BE RUN, 
-- SO DON'T REMOVE THOSE!!!

--set pagesize 0
--set heading off
--select 
--'insert into o$event_type values ('''||event||''','''||type||''');'
--from o$event_type
--order by 1;
--set heading on

insert into o$event_type values ('AQ propagation connection','other');
insert into o$event_type values ('ARCH wait for archivelog lock','other');
insert into o$event_type values ('ARCH wait for process death 1','other');
insert into o$event_type values ('ARCH wait for process death 2','other');
insert into o$event_type values ('ARCH wait for process death 3','other');
insert into o$event_type values ('ARCH wait for process death 4','other');
insert into o$event_type values ('ARCH wait for process death 5','other');
insert into o$event_type values ('ARCH wait for process start 1','other');
insert into o$event_type values ('ARCH wait for process start 2','other');
insert into o$event_type values ('ARCH wait for process start 3','other');
insert into o$event_type values ('ARCH wait for process start 4','other');
insert into o$event_type values ('ARCH wait on c/f tx acquire 1','other');
insert into o$event_type values ('ARCH wait on c/f tx acquire 2','other');
insert into o$event_type values ('ASM COD rollback operation completion','other');
insert into o$event_type values ('ASM PST query : wait for [PM][grp][0] grant','other');
insert into o$event_type values ('ASM Volume Background','other');
insert into o$event_type values ('ASM background running','other');
insert into o$event_type values ('ASM background starting','other');
insert into o$event_type values ('ASM background timer','bogus');
insert into o$event_type values ('ASM db client exists','other');
insert into o$event_type values ('ASM file metadata operation','other');
insert into o$event_type values ('ASM internal hang test','other');
insert into o$event_type values ('ASM metadata cache frozen','other');
insert into o$event_type values ('ASM mount : wait for heartbeat','other');
insert into o$event_type values ('ASM network foreground exits','other');
insert into o$event_type values ('ASM: OFS Cluster membership update','other');
insert into o$event_type values ('AWR Flush','other');
insert into o$event_type values ('AWR Metric Capture','other');
insert into o$event_type values ('BFILE check if exists','other');
insert into o$event_type values ('BFILE check if open','other');
insert into o$event_type values ('BFILE closure','other');
insert into o$event_type values ('BFILE get length','other');
insert into o$event_type values ('BFILE get name object','other');
insert into o$event_type values ('BFILE get path object','other');
insert into o$event_type values ('BFILE internal seek','other');
insert into o$event_type values ('BFILE open','other');
insert into o$event_type values ('BFILE read','ior');
insert into o$event_type values ('Backup: sbtbackup','other');
insert into o$event_type values ('Backup: sbtbufinfo','other');
insert into o$event_type values ('Backup: sbtclose','other');
insert into o$event_type values ('Backup: sbtclose2','other');
insert into o$event_type values ('Backup: sbtcommand','other');
insert into o$event_type values ('Backup: sbtend','other');
insert into o$event_type values ('Backup: sbterror','other');
insert into o$event_type values ('Backup: sbtgetbuf','other');
insert into o$event_type values ('Backup: sbtinfo','other');
insert into o$event_type values ('Backup: sbtinfo2','other');
insert into o$event_type values ('Backup: sbtinit','other');
insert into o$event_type values ('Backup: sbtinit2','other');
insert into o$event_type values ('Backup: sbtmapbuf','other');
insert into o$event_type values ('Backup: sbtopen','other');
insert into o$event_type values ('Backup: sbtpcbackup','other');
insert into o$event_type values ('Backup: sbtpccancel','other');
insert into o$event_type values ('Backup: sbtpccommit','other');
insert into o$event_type values ('Backup: sbtpcend','other');
insert into o$event_type values ('Backup: sbtpcquerybackup','other');
insert into o$event_type values ('Backup: sbtpcqueryrestore','other');
insert into o$event_type values ('Backup: sbtpcrestore','other');
insert into o$event_type values ('Backup: sbtpcstart','other');
insert into o$event_type values ('Backup: sbtpcstatus','other');
insert into o$event_type values ('Backup: sbtpcvalidate','other');
insert into o$event_type values ('Backup: sbtread','other');
insert into o$event_type values ('Backup: sbtread2','other');
insert into o$event_type values ('Backup: sbtrelbuf','other');
insert into o$event_type values ('Backup: sbtremove','other');
insert into o$event_type values ('Backup: sbtremove2','other');
insert into o$event_type values ('Backup: sbtrestore','other');
insert into o$event_type values ('Backup: sbtwrite','other');
insert into o$event_type values ('Backup: sbtwrite2','other');
insert into o$event_type values ('CGS skgxn join retry','other');
insert into o$event_type values ('CGS wait for IPC msg','other');
insert into o$event_type values ('Cluster Suspension wait','other');
insert into o$event_type values ('Cluster stabilization wait','other');
insert into o$event_type values ('DBFG waiting for reply','other');
insert into o$event_type values ('DBMS_LDAP: LDAP operation ','other');
insert into o$event_type values ('DFS db file lock','other');
insert into o$event_type values ('DFS lock handle','other');
insert into o$event_type values ('DIAG idle wait','bogus');
insert into o$event_type values ('Data Guard Broker Wait','other');
insert into o$event_type values ('Data Guard: process clean up','other');
insert into o$event_type values ('Data Guard: process exit','other');
insert into o$event_type values ('EMON slave idle wait','bogus');
insert into o$event_type values ('EMON slave messages','other');
insert into o$event_type values ('EMON termination','other');
insert into o$event_type values ('FAL archive wait 1 sec for REOPEN minimum','other');
insert into o$event_type values ('GCS lock cancel','other');
insert into o$event_type values ('GCS lock cvt S','other');
insert into o$event_type values ('GCS lock cvt X','other');
insert into o$event_type values ('GCS lock esc X','other');
insert into o$event_type values ('GCS lock esc','other');
insert into o$event_type values ('GCS lock open S','other');
insert into o$event_type values ('GCS lock open X','other');
insert into o$event_type values ('GCS lock open','other');
insert into o$event_type values ('GCS recovery lock convert','other');
insert into o$event_type values ('GCS recovery lock open','other');
insert into o$event_type values ('GV$: slave acquisition retry wait time','other');
insert into o$event_type values ('Global transaction acquire instance locks','other');
insert into o$event_type values ('HS message to agent','bogus');
insert into o$event_type values ('IORM Scheduler Slave Idle Wait','bogus');
insert into o$event_type values ('IPC busy async request','other');
insert into o$event_type values ('IPC send completion sync','other');
insert into o$event_type values ('IPC wait for name service busy','other');
insert into o$event_type values ('IPC waiting for OSD resources','other');
insert into o$event_type values ('JOX Jit Process Sleep','bogus');
insert into o$event_type values ('JS coord start wait','other');
insert into o$event_type values ('JS external job','bogus');
insert into o$event_type values ('JS kgl get object wait','other');
insert into o$event_type values ('JS kill job wait','other');
insert into o$event_type values ('KJC: Wait for msg sends to complete','other');
insert into o$event_type values ('KSV master wait','bogus');
insert into o$event_type values ('Kupp process shutdown','other');
insert into o$event_type values ('L1 validation','other');
insert into o$event_type values ('LGWR simulation latency wait','other');
insert into o$event_type values ('LGWR wait for redo copy','other');
insert into o$event_type values ('LGWR wait on full LNS buffer','other');
insert into o$event_type values ('LGWR-LNS wait on channel','other');
insert into o$event_type values ('LMON global data update','other');
insert into o$event_type values ('LNS ASYNC archive log','bogus');
insert into o$event_type values ('LNS ASYNC dest activation','bogus');
insert into o$event_type values ('LNS ASYNC end of log','bogus');
insert into o$event_type values ('LNS simulation latency wait','other');
insert into o$event_type values ('LNS wait for LGWR redo','other');
insert into o$event_type values ('LogMiner: builder idle','bogus');
insert into o$event_type values ('LogMiner: client waiting for transaction','bogus');
insert into o$event_type values ('LogMiner: generic process sleep','bogus');
insert into o$event_type values ('LogMiner: preparer idle','bogus');
insert into o$event_type values ('LogMiner: reader idle','bogus');
insert into o$event_type values ('LogMiner: reader waiting for more redo','bogus');
insert into o$event_type values ('LogMiner: slave waiting for activate message','bogus');
insert into o$event_type values ('LogMiner: waiting for processes to soft detach','bogus');
insert into o$event_type values ('LogMiner: waiting for redo from new branch','other');
insert into o$event_type values ('LogMiner: waiting for session to become visible','other');
insert into o$event_type values ('Logical Standby Apply Delay','bogus');
insert into o$event_type values ('Logical Standby Apply shutdown','other');
insert into o$event_type values ('Logical Standby Terminal Apply','other');
insert into o$event_type values ('Logical Standby dictionary build','other');
insert into o$event_type values ('Logical Standby pin transaction','other');
insert into o$event_type values ('MMON (Lite) shutdown','other');
insert into o$event_type values ('MMON slave messages','other');
insert into o$event_type values ('MRP redo arrival','bogus');
insert into o$event_type values ('MRP wait on archivelog archival','other');
insert into o$event_type values ('MRP wait on archivelog arrival','other');
insert into o$event_type values ('MRP wait on archivelog delay','other');
insert into o$event_type values ('MRP wait on process death','other');
insert into o$event_type values ('MRP wait on process restart','other');
insert into o$event_type values ('MRP wait on process start','other');
insert into o$event_type values ('MRP wait on startup clear','other');
insert into o$event_type values ('MRP wait on state change','other');
insert into o$event_type values ('MRP wait on state n_a','other');
insert into o$event_type values ('MRP wait on state reset','other');
insert into o$event_type values ('NFS read delegation outstanding','other');
insert into o$event_type values ('OLAP Aggregate Client Deq','other');
insert into o$event_type values ('OLAP Aggregate Client Enq','other');
insert into o$event_type values ('OLAP Aggregate Master Deq','other');
insert into o$event_type values ('OLAP Aggregate Master Enq','other');
insert into o$event_type values ('OLAP DML Sleep','other');
insert into o$event_type values ('OLAP Null PQ Reason','other');
insert into o$event_type values ('OLAP Parallel Temp Grew','other');
insert into o$event_type values ('OLAP Parallel Temp Grow Request','other');
insert into o$event_type values ('OLAP Parallel Temp Grow Wait','other');
insert into o$event_type values ('OLAP Parallel Type Deq','other');
insert into o$event_type values ('OSD IPC library','other');
insert into o$event_type values ('PING','bogus');
insert into o$event_type values ('PL/SQL lock timer','bogus');
insert into o$event_type values ('PMON to cleanup pseudo-branches at svc stop time','other');
insert into o$event_type values ('PX Deq Credit: Session Stats','other');
insert into o$event_type values ('PX Deq Credit: free buffer','other');
insert into o$event_type values ('PX Deq Credit: need buffer','bogus');
insert into o$event_type values ('PX Deq Credit: send blkd','bogus');
insert into o$event_type values ('PX Deq: Execute Reply','bogus');
insert into o$event_type values ('PX Deq: Execution Msg','bogus');
insert into o$event_type values ('PX Deq: Index Merge Close','bogus');
insert into o$event_type values ('PX Deq: Index Merge Execute','bogus');
insert into o$event_type values ('PX Deq: Index Merge Reply','bogus');
insert into o$event_type values ('PX Deq: Join ACK','bogus');
insert into o$event_type values ('PX Deq: Msg Fragment','bogus');
insert into o$event_type values ('PX Deq: OLAP Update Close','other');
insert into o$event_type values ('PX Deq: OLAP Update Execute','other');
insert into o$event_type values ('PX Deq: OLAP Update Reply','other');
insert into o$event_type values ('PX Deq: Parse Reply','bogus');
insert into o$event_type values ('PX Deq: Signal ACK EXT','other');
insert into o$event_type values ('PX Deq: Signal ACK RSG','other');
insert into o$event_type values ('PX Deq: Slave Join Frag','other');
insert into o$event_type values ('PX Deq: Slave Session Stats','other');
insert into o$event_type values ('PX Deq: Table Q Close','other');
insert into o$event_type values ('PX Deq: Table Q Get Keys','other');
insert into o$event_type values ('PX Deq: Table Q Normal','bogus');
insert into o$event_type values ('PX Deq: Table Q Sample','bogus');
insert into o$event_type values ('PX Deq: Table Q qref','other');
insert into o$event_type values ('PX Deq: Test for credit','other');
insert into o$event_type values ('PX Deq: Test for msg','other');
insert into o$event_type values ('PX Deq: Txn Recovery Reply','bogus');
insert into o$event_type values ('PX Deq: Txn Recovery Start','bogus');
insert into o$event_type values ('PX Deq: kdcph_mai','bogus');
insert into o$event_type values ('PX Deq: kdcphc_ack','bogus');
insert into o$event_type values ('PX Deq: reap credit','other');
insert into o$event_type values ('PX Deque wait','bogus');
insert into o$event_type values ('PX Idle Wait','bogus');
insert into o$event_type values ('PX Nsq: PQ descriptor query','other');
insert into o$event_type values ('PX Nsq: PQ load info query','other');
insert into o$event_type values ('PX Send Wait','other');
insert into o$event_type values ('PX create server','other');
insert into o$event_type values ('PX qref latch','other');
insert into o$event_type values ('PX server shutdown','other');
insert into o$event_type values ('PX signal server','other');
insert into o$event_type values ('PX slave connection','other');
insert into o$event_type values ('PX slave release','other');
insert into o$event_type values ('RFS announce','other');
insert into o$event_type values ('RFS attach','other');
insert into o$event_type values ('RFS close','other');
insert into o$event_type values ('RFS create','other');
insert into o$event_type values ('RFS detach','other');
insert into o$event_type values ('RFS dispatch','other');
insert into o$event_type values ('RFS ping','other');
insert into o$event_type values ('RFS register','other');
insert into o$event_type values ('RVWR wait for flashback copy','other');
insert into o$event_type values ('Replication Dequeue ','other');
insert into o$event_type values ('SGA: MMAN sleep for component shrink','bogus');
insert into o$event_type values ('SGA: allocation forcing component growth','other');
insert into o$event_type values ('SGA: sga_target resize','other');
insert into o$event_type values ('SQL*Net break/reset to client','other');
insert into o$event_type values ('SQL*Net break/reset to dblink','other');
insert into o$event_type values ('SQL*Net message from client','bogus');
insert into o$event_type values ('SUPLOG PL wait for inflight pragma-d PL/SQL','other');
insert into o$event_type values ('Shared IO Pool Memory','other');
insert into o$event_type values ('Space Manager: slave idle wait','bogus');
insert into o$event_type values ('Space Manager: slave messages','other');
insert into o$event_type values ('Streams AQ: QueueTable kgl locks','other');
insert into o$event_type values ('Streams AQ: RAC qmn coordinator idle wait','bogus');
insert into o$event_type values ('Streams AQ: deallocate messages from Streams Pool','bogus');
insert into o$event_type values ('Streams AQ: delete acknowledged messages','bogus');
insert into o$event_type values ('Streams AQ: emn coordinator idle wait','bogus');
insert into o$event_type values ('Streams AQ: emn coordinator waiting for slave to start','other');
insert into o$event_type values ('Streams AQ: qmn coordinator idle wait','bogus');
insert into o$event_type values ('Streams AQ: qmn coordinator waiting for slave to start','other');
insert into o$event_type values ('Streams AQ: qmn slave idle wait','bogus');
insert into o$event_type values ('Streams AQ: waiting for busy instance for instance_name','other');
insert into o$event_type values ('Streams AQ: waiting for messages in the queue','bogus');
insert into o$event_type values ('Streams AQ: waiting for time management or cleanup tasks','bogus');
insert into o$event_type values ('Streams capture: filter callback waiting for ruleset','other');
insert into o$event_type values ('Streams capture: waiting for archive log','bogus');
insert into o$event_type values ('Streams capture: waiting for database startup','other');
insert into o$event_type values ('Streams fetch slave: waiting for txns','bogus');
insert into o$event_type values ('Streams miscellaneous event','other');
insert into o$event_type values ('Streams: RAC waiting for inter instance ack','other');
insert into o$event_type values ('Streams: apply reader waiting for DDL to apply','other');
insert into o$event_type values ('Sync ASM rebalance','other');
insert into o$event_type values ('VKTM Init Wait for GSGA','bogus');
insert into o$event_type values ('VKTM Logical Idle Wait','bogus');
insert into o$event_type values ('WCR: RAC message context busy','other');
insert into o$event_type values ('WCR: Sync context busy','other');
insert into o$event_type values ('WCR: replay client notify','bogus');
insert into o$event_type values ('WCR: replay clock','bogus');
insert into o$event_type values ('WCR: replay lock order','other');
insert into o$event_type values ('Wait for TT enqueue','other');
insert into o$event_type values ('Wait for Table Lock','other');
insert into o$event_type values ('Wait for shrink lock','other');
insert into o$event_type values ('Wait for shrink lock2','other');
insert into o$event_type values ('Wait on stby instance close','other');
insert into o$event_type values ('XDB SGA initialization','other');
insert into o$event_type values ('affinity expansion in replay','other');
insert into o$event_type values ('alter rbs offline','other');
insert into o$event_type values ('alter system set dispatcher','other');
insert into o$event_type values ('auto-sqltune: wait graph update','bogus');
insert into o$event_type values ('block change tracking buffer space','other');
insert into o$event_type values ('blocking txn id for DDL','other');
insert into o$event_type values ('broadcast mesg queue transition','other');
insert into o$event_type values ('broadcast mesg recovery queue transition','other');
insert into o$event_type values ('buffer busy waits','other');
insert into o$event_type values ('buffer busy','other');
insert into o$event_type values ('buffer deadlock','other');
insert into o$event_type values ('buffer dirty disabled','other');
insert into o$event_type values ('buffer exterminate','other');
insert into o$event_type values ('buffer freelistbusy','other');
insert into o$event_type values ('buffer invalidation wait','other');
insert into o$event_type values ('buffer latch','other');
insert into o$event_type values ('buffer pool resize','other');
insert into o$event_type values ('buffer read retry','ior');
insert into o$event_type values ('buffer rememberlist busy','other');
insert into o$event_type values ('buffer resize','other');
insert into o$event_type values ('buffer write wait','other');
insert into o$event_type values ('buffer writeList full','other');
insert into o$event_type values ('change tracking file parallel write','other');
insert into o$event_type values ('change tracking file synchronous read','other');
insert into o$event_type values ('change tracking file synchronous write','other');
insert into o$event_type values ('check CPU wait times','other');
insert into o$event_type values ('checkpoint advanced','other');
insert into o$event_type values ('checkpoint completed','other');
insert into o$event_type values ('class slave wait','bogus');
insert into o$event_type values ('cleanup of aborted process','other');
insert into o$event_type values ('cmon timer','bogus');
insert into o$event_type values ('connection pool wait','other');
insert into o$event_type values ('control file diagnostic dump','other');
insert into o$event_type values ('control file heartbeat','other');
insert into o$event_type values ('control file sequential read','ior');
insert into o$event_type values ('cr request retry','other');
insert into o$event_type values ('cursor: mutex S','other');
insert into o$event_type values ('cursor: mutex X','other');
insert into o$event_type values ('cursor: pin S wait on X','other');
insert into o$event_type values ('cursor: pin S','other');
insert into o$event_type values ('cursor: pin X','other');
insert into o$event_type values ('db file parallel read','ior');
insert into o$event_type values ('db file scattered read','ior');
insert into o$event_type values ('db file sequential read','ior');
insert into o$event_type values ('dbverify reads','ior');
insert into o$event_type values ('debugger command','other');
insert into o$event_type values ('direct path read temp','ior');
insert into o$event_type values ('direct path read','ior');
insert into o$event_type values ('dispatcher shutdown','other');
insert into o$event_type values ('dispatcher timer','bogus');
insert into o$event_type values ('dma prepare busy','other');
insert into o$event_type values ('dupl. cluster key','other');
insert into o$event_type values ('enq: AD - allocate AU','other');
insert into o$event_type values ('enq: AD - deallocate AU','other');
insert into o$event_type values ('enq: AD - relocate AU','other');
insert into o$event_type values ('enq: AE - lock','other');
insert into o$event_type values ('enq: AF - task serialization','other');
insert into o$event_type values ('enq: AG - contention','other');
insert into o$event_type values ('enq: AM - ASM ACD Relocation','other');
insert into o$event_type values ('enq: AM - ASM cache freeze','other');
insert into o$event_type values ('enq: AM - background COD reservation','other');
insert into o$event_type values ('enq: AM - client registration','other');
insert into o$event_type values ('enq: AM - rollback COD reservation','other');
insert into o$event_type values ('enq: AM - shutdown','other');
insert into o$event_type values ('enq: AO - contention','other');
insert into o$event_type values ('enq: AS - service activation','other');
insert into o$event_type values ('enq: AT - contention','other');
insert into o$event_type values ('enq: AU - audit index file','other');
insert into o$event_type values ('enq: AV - persistent DG number','other');
insert into o$event_type values ('enq: AW - AW generation lock','other');
insert into o$event_type values ('enq: AW - AW state lock','other');
insert into o$event_type values ('enq: AW - AW$ table lock','other');
insert into o$event_type values ('enq: AW - user access for AW','other');
insert into o$event_type values ('enq: AY - contention','other');
insert into o$event_type values ('enq: BF - PMON Join Filter cleanup','other');
insert into o$event_type values ('enq: BF - allocation contention','other');
insert into o$event_type values ('enq: BR - file shrink','other');
insert into o$event_type values ('enq: BR - multi-section restore header','other');
insert into o$event_type values ('enq: BR - multi-section restore section','other');
insert into o$event_type values ('enq: BR - proxy-copy','other');
insert into o$event_type values ('enq: BR - space info datafile hdr update','other');
insert into o$event_type values ('enq: CA - contention','other');
insert into o$event_type values ('enq: CF - contention','other');
insert into o$event_type values ('enq: CI - contention','other');
insert into o$event_type values ('enq: CL - compare labels','other');
insert into o$event_type values ('enq: CL - drop label','other');
insert into o$event_type values ('enq: CM - gate','other');
insert into o$event_type values ('enq: CM - instance','other');
insert into o$event_type values ('enq: CN - race with init','other');
insert into o$event_type values ('enq: CN - race with reg','other');
insert into o$event_type values ('enq: CN - race with txn','other');
insert into o$event_type values ('enq: CO - master slave det','other');
insert into o$event_type values ('enq: CQ - contention','other');
insert into o$event_type values ('enq: CT - CTWR process start/stop','other');
insert into o$event_type values ('enq: CT - change stream ownership','other');
insert into o$event_type values ('enq: CT - global space management','other');
insert into o$event_type values ('enq: CT - local space management','other');
insert into o$event_type values ('enq: CT - reading','other');
insert into o$event_type values ('enq: CT - state change gate 1','other');
insert into o$event_type values ('enq: CT - state change gate 2','other');
insert into o$event_type values ('enq: CT - state','other');
insert into o$event_type values ('enq: CU - contention','other');
insert into o$event_type values ('enq: DB - contention','other');
insert into o$event_type values ('enq: DD - contention','other');
insert into o$event_type values ('enq: DF - contention','other');
insert into o$event_type values ('enq: DG - contention','other');
insert into o$event_type values ('enq: DL - contention','other');
insert into o$event_type values ('enq: DM - contention','other');
insert into o$event_type values ('enq: DN - contention','other');
insert into o$event_type values ('enq: DO - Staleness Registry create','other');
insert into o$event_type values ('enq: DO - disk online operation','other');
insert into o$event_type values ('enq: DO - disk online recovery','other');
insert into o$event_type values ('enq: DO - disk online','other');
insert into o$event_type values ('enq: DO - startup of MARK process','other');
insert into o$event_type values ('enq: DP - contention','other');
insert into o$event_type values ('enq: DR - contention','other');
insert into o$event_type values ('enq: DS - contention','other');
insert into o$event_type values ('enq: DT - contention','other');
insert into o$event_type values ('enq: DV - contention','other');
insert into o$event_type values ('enq: DW - contention','other');
insert into o$event_type values ('enq: DX - contention','other');
insert into o$event_type values ('enq: FA - access file','other');
insert into o$event_type values ('enq: FB - contention','other');
insert into o$event_type values ('enq: FC - open an ACD thread','other');
insert into o$event_type values ('enq: FC - recover an ACD thread','other');
insert into o$event_type values ('enq: FD - Flashback coordinator','other');
insert into o$event_type values ('enq: FD - Flashback on/off','other');
insert into o$event_type values ('enq: FD - Marker generation','other');
insert into o$event_type values ('enq: FD - Restore point create/drop','other');
insert into o$event_type values ('enq: FD - Tablespace flashback on/off','other');
insert into o$event_type values ('enq: FE - contention','other');
insert into o$event_type values ('enq: FG - FG redo generation enq race','other');
insert into o$event_type values ('enq: FG - LGWR redo generation enq race','other');
insert into o$event_type values ('enq: FG - serialize ACD relocate','other');
insert into o$event_type values ('enq: FL - Flashback database log','other');
insert into o$event_type values ('enq: FL - Flashback db command','other');
insert into o$event_type values ('enq: FM - contention','other');
insert into o$event_type values ('enq: FP - global fob contention','other');
insert into o$event_type values ('enq: FR - contention','other');
insert into o$event_type values ('enq: FS - contention','other');
insert into o$event_type values ('enq: FT - allow LGWR writes','other');
insert into o$event_type values ('enq: FT - disable LGWR writes','other');
insert into o$event_type values ('enq: FU - contention','other');
insert into o$event_type values ('enq: FX - issue ACD Xtnt Relocation CIC','other');
insert into o$event_type values ('enq: HD - contention','other');
insert into o$event_type values ('enq: HP - contention','other');
insert into o$event_type values ('enq: HQ - contention','other');
insert into o$event_type values ('enq: HV - contention','other');
insert into o$event_type values ('enq: HW - contention','other');
insert into o$event_type values ('enq: IA - contention','other');
insert into o$event_type values ('enq: ID - contention','other');
insert into o$event_type values ('enq: IL - contention','other');
insert into o$event_type values ('enq: IM - contention for blr','other');
insert into o$event_type values ('enq: IR - contention','other');
insert into o$event_type values ('enq: IR - contention2','other');
insert into o$event_type values ('enq: IS - contention','other');
insert into o$event_type values ('enq: IT - contention','other');
insert into o$event_type values ('enq: JD - contention','other');
insert into o$event_type values ('enq: JI - contention','other');
insert into o$event_type values ('enq: JQ - contention','other');
insert into o$event_type values ('enq: JS - aq sync','other');
insert into o$event_type values ('enq: JS - contention','other');
insert into o$event_type values ('enq: JS - evt notify','other');
insert into o$event_type values ('enq: JS - evtsub add','other');
insert into o$event_type values ('enq: JS - evtsub drop','other');
insert into o$event_type values ('enq: JS - job recov lock','other');
insert into o$event_type values ('enq: JS - job run lock - synchronize','other');
insert into o$event_type values ('enq: JS - q mem clnup lck','other');
insert into o$event_type values ('enq: JS - queue lock','other');
insert into o$event_type values ('enq: JS - sch locl enqs','other');
insert into o$event_type values ('enq: JS - wdw op','other');
insert into o$event_type values ('enq: KM - contention','other');
insert into o$event_type values ('enq: KO - fast object checkpoint','other');
insert into o$event_type values ('enq: KP - contention','other');
insert into o$event_type values ('enq: KQ - access ASM attribute','other');
insert into o$event_type values ('enq: KT - contention','other');
insert into o$event_type values ('enq: MD - contention','other');
insert into o$event_type values ('enq: MH - contention','other');
insert into o$event_type values ('enq: MK - contention','other');
insert into o$event_type values ('enq: ML - contention','other');
insert into o$event_type values ('enq: MN - contention','other');
insert into o$event_type values ('enq: MO - contention','other');
insert into o$event_type values ('enq: MR - contention','other');
insert into o$event_type values ('enq: MS - contention','other');
insert into o$event_type values ('enq: MW - contention','other');
insert into o$event_type values ('enq: MX - sync storage server info','other');
insert into o$event_type values ('enq: OC - contention','other');
insert into o$event_type values ('enq: OD - Serializing DDLs','other');
insert into o$event_type values ('enq: OL - contention','other');
insert into o$event_type values ('enq: OQ - xsoq*histrecb','other');
insert into o$event_type values ('enq: OQ - xsoqhiAlloc','other');
insert into o$event_type values ('enq: OQ - xsoqhiClose','other');
insert into o$event_type values ('enq: OQ - xsoqhiFlush','other');
insert into o$event_type values ('enq: OQ - xsoqhistrecb','other');
insert into o$event_type values ('enq: OW - initialization','other');
insert into o$event_type values ('enq: OW - termination','other');
insert into o$event_type values ('enq: PD - contention','other');
insert into o$event_type values ('enq: PE - contention','other');
insert into o$event_type values ('enq: PF - contention','other');
insert into o$event_type values ('enq: PG - contention','other');
insert into o$event_type values ('enq: PH - contention','other');
insert into o$event_type values ('enq: PI - contention','other');
insert into o$event_type values ('enq: PL - contention','other');
insert into o$event_type values ('enq: PR - contention','other');
insert into o$event_type values ('enq: PS - contention','other');
insert into o$event_type values ('enq: PT - contention','other');
insert into o$event_type values ('enq: PV - syncshut','other');
insert into o$event_type values ('enq: PV - syncstart','other');
insert into o$event_type values ('enq: PW - flush prewarm buffers','other');
insert into o$event_type values ('enq: PW - perwarm status in dbw0','other');
insert into o$event_type values ('enq: RB - contention','other');
insert into o$event_type values ('enq: RC - Result Cache: Contention','other');
insert into o$event_type values ('enq: RE - block repair contention','other');
insert into o$event_type values ('enq: RF - DG Broker Current File ID','other');
insert into o$event_type values ('enq: RF - FSFO Observer Heartbeat','other');
insert into o$event_type values ('enq: RF - RF - Database Automatic Disable','other');
insert into o$event_type values ('enq: RF - atomicity','other');
insert into o$event_type values ('enq: RF - new AI','other');
insert into o$event_type values ('enq: RF - synch: DG Broker metadata','other');
insert into o$event_type values ('enq: RF - synchronization: aifo master','other');
insert into o$event_type values ('enq: RF - synchronization: critical ai','other');
insert into o$event_type values ('enq: RN - contention','other');
insert into o$event_type values ('enq: RO - contention','other');
insert into o$event_type values ('enq: RO - fast object reuse','other');
insert into o$event_type values ('enq: RP - contention','other');
insert into o$event_type values ('enq: RR - contention','other');
insert into o$event_type values ('enq: RS - file delete','other');
insert into o$event_type values ('enq: RS - persist alert level','other');
insert into o$event_type values ('enq: RS - prevent aging list update','other');
insert into o$event_type values ('enq: RS - prevent file delete','other');
insert into o$event_type values ('enq: RS - read alert level','other');
insert into o$event_type values ('enq: RS - record reuse','other');
insert into o$event_type values ('enq: RS - write alert level','other');
insert into o$event_type values ('enq: RT - contention','other');
insert into o$event_type values ('enq: RU - contention','other');
insert into o$event_type values ('enq: RU - waiting','other');
insert into o$event_type values ('enq: RW - MV metadata contention','other');
insert into o$event_type values ('enq: RX - relocate extent','other');
insert into o$event_type values ('enq: SB - contention','other');
insert into o$event_type values ('enq: SE - contention','other');
insert into o$event_type values ('enq: SF - contention','other');
insert into o$event_type values ('enq: SH - contention','other');
insert into o$event_type values ('enq: SI - contention','other');
insert into o$event_type values ('enq: SJ - Slave Task Cancel','other');
insert into o$event_type values ('enq: SK - contention','other');
insert into o$event_type values ('enq: SL - escalate lock','other');
insert into o$event_type values ('enq: SL - get lock for undo','other');
insert into o$event_type values ('enq: SL - get lock','other');
insert into o$event_type values ('enq: SO - contention','other');
insert into o$event_type values ('enq: SQ - contention','other');
insert into o$event_type values ('enq: SR - contention','other');
insert into o$event_type values ('enq: SS - contention','other');
insert into o$event_type values ('enq: ST - contention','other');
insert into o$event_type values ('enq: SU - contention','other');
insert into o$event_type values ('enq: SW - contention','other');
insert into o$event_type values ('enq: TA - contention','other');
insert into o$event_type values ('enq: TB - SQL Tuning Base Cache Load','other');
insert into o$event_type values ('enq: TB - SQL Tuning Base Cache Update','other');
insert into o$event_type values ('enq: TC - contention','other');
insert into o$event_type values ('enq: TC - contention2','other');
insert into o$event_type values ('enq: TD - KTF dump entries','other');
insert into o$event_type values ('enq: TE - KTF broadcast','other');
insert into o$event_type values ('enq: TF - contention','other');
insert into o$event_type values ('enq: TH - metric threshold evaluation','other');
insert into o$event_type values ('enq: TK - Auto Task Serialization','other');
insert into o$event_type values ('enq: TK - Auto Task Slave Lockout','other');
insert into o$event_type values ('enq: TL - contention','other');
insert into o$event_type values ('enq: TM - contention','other');
insert into o$event_type values ('enq: TO - contention','other');
insert into o$event_type values ('enq: TQ - DDL contention','other');
insert into o$event_type values ('enq: TQ - DDL-INI contention','other');
insert into o$event_type values ('enq: TQ - INI contention','other');
insert into o$event_type values ('enq: TQ - TM contention','other');
insert into o$event_type values ('enq: TS - contention','other');
insert into o$event_type values ('enq: TT - contention','other');
insert into o$event_type values ('enq: TW - contention','other');
insert into o$event_type values ('enq: TX - allocate ITL entry','other');
insert into o$event_type values ('enq: TX - contention','other');
insert into o$event_type values ('enq: TX - index contention','other');
insert into o$event_type values ('enq: TX - row lock contention','other');
insert into o$event_type values ('enq: UL - contention','other');
insert into o$event_type values ('enq: US - contention','other');
insert into o$event_type values ('enq: WA - contention','other');
insert into o$event_type values ('enq: WF - contention','other');
insert into o$event_type values ('enq: WG - delete fso','other');
insert into o$event_type values ('enq: WG - lock fso','other');
insert into o$event_type values ('enq: WL - contention','other');
insert into o$event_type values ('enq: WM - WLM Plan activation','other');
insert into o$event_type values ('enq: WP - contention','other');
insert into o$event_type values ('enq: WR - contention','other');
insert into o$event_type values ('enq: XH - contention','other');
insert into o$event_type values ('enq: XL - fault extent map','other');
insert into o$event_type values ('enq: XQ - recovery','other');
insert into o$event_type values ('enq: XQ - relocation','other');
insert into o$event_type values ('enq: XR - database force logging','other');
insert into o$event_type values ('enq: XR - quiesce database','other');
insert into o$event_type values ('enq: XY - contention','other');
insert into o$event_type values ('enq: ZG - contention','other');
insert into o$event_type values ('events in waitclass Other','other');
insert into o$event_type values ('extent map load/unlock','other');
insert into o$event_type values ('fbar timer','bogus');
insert into o$event_type values ('flashback buf free by RVWR','other');
insert into o$event_type values ('flashback free VI log','other');
insert into o$event_type values ('flashback log switch','other');
insert into o$event_type values ('free buffer waits','iow');
insert into o$event_type values ('free global transaction table entry','other');
insert into o$event_type values ('free process state object','other');
insert into o$event_type values ('gc assume','other');
insert into o$event_type values ('gc block recovery request','other');
insert into o$event_type values ('gc buffer busy acquire','other');
insert into o$event_type values ('gc buffer busy release','other');
insert into o$event_type values ('gc claim','other');
insert into o$event_type values ('gc cr block 2-way','other');
insert into o$event_type values ('gc cr block 3-way','other');
insert into o$event_type values ('gc cr block busy','other');
insert into o$event_type values ('gc cr block congested','other');
insert into o$event_type values ('gc cr block lost','other');
insert into o$event_type values ('gc cr block unknown','other');
insert into o$event_type values ('gc cr cancel','other');
insert into o$event_type values ('gc cr disk read','other');
insert into o$event_type values ('gc cr disk request','other');
insert into o$event_type values ('gc cr failure','other');
insert into o$event_type values ('gc cr grant 2-way','other');
insert into o$event_type values ('gc cr grant busy','other');
insert into o$event_type values ('gc cr grant congested','other');
insert into o$event_type values ('gc cr grant unknown','other');
insert into o$event_type values ('gc cr multi block request','other');
insert into o$event_type values ('gc cr request','other');
insert into o$event_type values ('gc current block 2-way','other');
insert into o$event_type values ('gc current block 3-way','other');
insert into o$event_type values ('gc current block busy','other');
insert into o$event_type values ('gc current block congested','other');
insert into o$event_type values ('gc current block lost','other');
insert into o$event_type values ('gc current block unknown','other');
insert into o$event_type values ('gc current cancel','other');
insert into o$event_type values ('gc current grant 2-way','other');
insert into o$event_type values ('gc current grant busy','other');
insert into o$event_type values ('gc current grant congested','other');
insert into o$event_type values ('gc current grant unknown','other');
insert into o$event_type values ('gc current multi block request','other');
insert into o$event_type values ('gc current request','other');
insert into o$event_type values ('gc current retry','other');
insert into o$event_type values ('gc current split','other');
insert into o$event_type values ('gc domain validation','other');
insert into o$event_type values ('gc freelist','other');
insert into o$event_type values ('gc object scan','other');
insert into o$event_type values ('gc quiesce','other');
insert into o$event_type values ('gc recovery free','other');
insert into o$event_type values ('gc recovery quiesce','other');
insert into o$event_type values ('gc remaster','other');
insert into o$event_type values ('gcs ddet enter server mode','other');
insert into o$event_type values ('gcs domain validation','other');
insert into o$event_type values ('gcs drm freeze begin','other');
insert into o$event_type values ('gcs drm freeze in enter server mode','other');
insert into o$event_type values ('gcs enter server mode','other');
insert into o$event_type values ('gcs log flush sync','other');
insert into o$event_type values ('gcs remastering wait for read latch','other');
insert into o$event_type values ('gcs remastering wait for write latch','other');
insert into o$event_type values ('gcs remote message','bogus');
insert into o$event_type values ('gcs resource directory to be unfrozen','other');
insert into o$event_type values ('gcs to be enabled','other');
insert into o$event_type values ('ges LMD suspend for testing event','other');
insert into o$event_type values ('ges LMD to inherit communication channels','other');
insert into o$event_type values ('ges LMD to shutdown','other');
insert into o$event_type values ('ges LMON for send queues','other');
insert into o$event_type values ('ges LMON to get to FTDONE ','other');
insert into o$event_type values ('ges LMON to join CGS group','other');
insert into o$event_type values ('ges RMS0 retry add redo log','other');
insert into o$event_type values ('ges cached resource cleanup','other');
insert into o$event_type values ('ges cancel','other');
insert into o$event_type values ('ges cgs registration','other');
insert into o$event_type values ('ges enter server mode','other');
insert into o$event_type values ('ges generic event','other');
insert into o$event_type values ('ges global resource directory to be frozen','other');
insert into o$event_type values ('ges inquiry response','other');
insert into o$event_type values ('ges lmd and pmon to attach','other');
insert into o$event_type values ('ges lmd/lmses to freeze in rcfg - mrcvr','other');
insert into o$event_type values ('ges lmd/lmses to unfreeze in rcfg - mrcvr','other');
insert into o$event_type values ('ges master to get established for SCN op','other');
insert into o$event_type values ('ges performance test completion','other');
insert into o$event_type values ('ges pmon to exit','other');
insert into o$event_type values ('ges process with outstanding i/o','other');
insert into o$event_type values ('ges reconfiguration to start','other');
insert into o$event_type values ('ges remote message','bogus');
insert into o$event_type values ('ges resource cleanout during enqueue open','other');
insert into o$event_type values ('ges resource cleanout during enqueue open-cvt','other');
insert into o$event_type values ('ges resource directory to be unfrozen','other');
insert into o$event_type values ('ges retry query node','other');
insert into o$event_type values ('ges reusing os pid','other');
insert into o$event_type values ('ges user error','other');
insert into o$event_type values ('ges wait for lmon to be ready','other');
insert into o$event_type values ('ges1 LMON to wake up LMD - mrcvr','other');
insert into o$event_type values ('ges2 LMON to wake up LMD - mrcvr','other');
insert into o$event_type values ('ges2 LMON to wake up lms - mrcvr 2','other');
insert into o$event_type values ('ges2 LMON to wake up lms - mrcvr 3','other');
insert into o$event_type values ('ges2 proc latch in rm latch get 1','other');
insert into o$event_type values ('ges2 proc latch in rm latch get 2','other');
insert into o$event_type values ('global cache busy','other');
insert into o$event_type values ('global enqueue expand wait','other');
insert into o$event_type values ('i/o slave wait','iow');
insert into o$event_type values ('imm op','other');
insert into o$event_type values ('inactive session','other');
insert into o$event_type values ('inactive transaction branch','other');
insert into o$event_type values ('index (re)build online cleanup','other');
insert into o$event_type values ('index (re)build online merge','other');
insert into o$event_type values ('index (re)build online start','other');
insert into o$event_type values ('index block split','other');
insert into o$event_type values ('instance state change','other');
insert into o$event_type values ('job scheduler coordinator slave wait','other');
insert into o$event_type values ('jobq slave TJ process wait','other');
insert into o$event_type values ('jobq slave shutdown wait','other');
insert into o$event_type values ('jobq slave wait','bogus');
insert into o$event_type values ('kcbzps','other');
insert into o$event_type values ('kcrrrcp','other');
insert into o$event_type values ('kdblil wait before retrying ORA-54','other');
insert into o$event_type values ('kdic_do_merge','other');
insert into o$event_type values ('kfcl: instance recovery','other');
insert into o$event_type values ('kgltwait','other');
insert into o$event_type values ('kjbdomalc allocate recovery domain - retry','other');
insert into o$event_type values ('kjbdrmcvtq lmon drm quiesce: ping completion','other');
insert into o$event_type values ('kjbopen wait for recovery domain attach','other');
insert into o$event_type values ('kjctcisnd: Queue/Send client message','other');
insert into o$event_type values ('kjctssqmg: quick message send wait','other');
insert into o$event_type values ('kjudomatt wait for recovery domain attach','other');
insert into o$event_type values ('kjudomdet wait for recovery domain detach','other');
insert into o$event_type values ('kjxgrtest','other');
insert into o$event_type values ('kkdlgon','other');
insert into o$event_type values ('kkdlhpon','other');
insert into o$event_type values ('kkdlsipon','other');
insert into o$event_type values ('kksfbc child completion','other');
insert into o$event_type values ('kksfbc research','other');
insert into o$event_type values ('kkshgnc reloop','other');
insert into o$event_type values ('kksscl hash split','other');
insert into o$event_type values ('knpc_acwm_AwaitChangedWaterMark','other');
insert into o$event_type values ('knpc_anq_AwaitNonemptyQueue','other');
insert into o$event_type values ('knpsmai','other');
insert into o$event_type values ('kpodplck wait before retrying ORA-54','other');
insert into o$event_type values ('ksbcic','other');
insert into o$event_type values ('ksbsrv','other');
insert into o$event_type values ('ksdxexeother','other');
insert into o$event_type values ('ksdxexeotherwait','other');
insert into o$event_type values ('ksim generic wait event','other');
insert into o$event_type values ('kslwait unit test event 1','other');
insert into o$event_type values ('kslwait unit test event 2','other');
insert into o$event_type values ('kslwait unit test event 3','other');
insert into o$event_type values ('ksv slave avail wait','other');
insert into o$event_type values ('ksxr poll remote instances','other');
insert into o$event_type values ('ksxr wait for mount shared','other');
insert into o$event_type values ('ktfbtgex','other');
insert into o$event_type values ('ktm: instance recovery','other');
insert into o$event_type values ('ktsambl','other');
insert into o$event_type values ('kttm2d','other');
insert into o$event_type values ('kupp process wait','other');
insert into o$event_type values ('kxfxse','other');
insert into o$event_type values ('kxfxsp','other');
insert into o$event_type values ('latch activity','other');
insert into o$event_type values ('latch free','other');
insert into o$event_type values ('latch: Change Notification Hash table latch','other');
insert into o$event_type values ('latch: In memory undo latch','other');
insert into o$event_type values ('latch: MQL Tracking Latch','other');
insert into o$event_type values ('latch: Undo Hint Latch','other');
insert into o$event_type values ('latch: cache buffer handles','other');
insert into o$event_type values ('latch: cache buffers chains','other');
insert into o$event_type values ('latch: cache buffers lru chain','other');
insert into o$event_type values ('latch: change notification client cache latch','other');
insert into o$event_type values ('latch: checkpoint queue latch','other');
insert into o$event_type values ('latch: enqueue hash chains','other');
insert into o$event_type values ('latch: gc element','other');
insert into o$event_type values ('latch: gcs resource hash','other');
insert into o$event_type values ('latch: ges resource hash list','other');
insert into o$event_type values ('latch: lob segment dispenser latch','other');
insert into o$event_type values ('latch: lob segment hash table latch','other');
insert into o$event_type values ('latch: lob segment query latch','other');
insert into o$event_type values ('latch: messages','other');
insert into o$event_type values ('latch: object queue header operation','other');
insert into o$event_type values ('latch: parallel query alloc buffer','other');
insert into o$event_type values ('latch: redo allocation','other');
insert into o$event_type values ('latch: redo copy','other');
insert into o$event_type values ('latch: redo writing','other');
insert into o$event_type values ('latch: row cache objects','other');
insert into o$event_type values ('latch: session allocation','other');
insert into o$event_type values ('latch: shared pool','other');
insert into o$event_type values ('latch: undo global data','other');
insert into o$event_type values ('latch: virtual circuit queues','other');
insert into o$event_type values ('library cache load lock','other');
insert into o$event_type values ('library cache lock','other');
insert into o$event_type values ('library cache pin','other');
insert into o$event_type values ('library cache revalidation','other');
insert into o$event_type values ('library cache shutdown','other');
insert into o$event_type values ('library cache: mutex S','other');
insert into o$event_type values ('library cache: mutex X','other');
insert into o$event_type values ('listen endpoint status','other');
insert into o$event_type values ('lms flush message acks','other');
insert into o$event_type values ('lock close','other');
insert into o$event_type values ('lock deadlock retry','other');
insert into o$event_type values ('lock escalate retry','other');
insert into o$event_type values ('lock release pending','other');
insert into o$event_type values ('lock remastering','other');
insert into o$event_type values ('log buffer space','other');
insert into o$event_type values ('log file sequential read','ior');
insert into o$event_type values ('log file switch (archiving needed)','iow');
insert into o$event_type values ('log file switch (checkpoint incomplete)','iow');
insert into o$event_type values ('log file switch (clearing log file)','iow');
insert into o$event_type values ('log file switch (private strand flush incomplete)','iow');
insert into o$event_type values ('log file switch completion','iow');
insert into o$event_type values ('log switch/archive','other');
insert into o$event_type values ('log write(even)','iow');
insert into o$event_type values ('log write(odd)','iow');
insert into o$event_type values ('logout restrictor','other');
insert into o$event_type values ('master exit','other');
insert into o$event_type values ('multiple dbwriter suspend/resume for file offline','other');
insert into o$event_type values ('name-service call wait','other');
insert into o$event_type values ('no free buffers','other');
insert into o$event_type values ('no free locks','other');
insert into o$event_type values ('null event','other');
insert into o$event_type values ('opishd','other');
insert into o$event_type values ('optimizer stats update retry','other');
insert into o$event_type values ('os thread startup','other');
insert into o$event_type values ('parallel recovery change buffer free','other');
insert into o$event_type values ('parallel recovery control message reply','other');
insert into o$event_type values ('parallel recovery coord send blocked','other');
insert into o$event_type values ('parallel recovery coord wait for reply','other');
insert into o$event_type values ('parallel recovery coordinator waits for slave cleanup','bogus');
insert into o$event_type values ('parallel recovery read buffer free','other');
insert into o$event_type values ('parallel recovery slave idle wait','bogus');
insert into o$event_type values ('parallel recovery slave next change','other');
insert into o$event_type values ('parallel recovery slave wait for change','other');
insert into o$event_type values ('pending global transaction(s)','other');
insert into o$event_type values ('pi renounce write complete','other');
insert into o$event_type values ('pipe get','bogus');
insert into o$event_type values ('pipe put','other');
insert into o$event_type values ('pmon timer','bogus');
insert into o$event_type values ('pool server timer','bogus');
insert into o$event_type values ('prewarm transfer retry','other');
insert into o$event_type values ('prior spawner clean up','other');
insert into o$event_type values ('process shutdown','other');
insert into o$event_type values ('process startup','other');
insert into o$event_type values ('process terminate','other');
insert into o$event_type values ('qerex_gdml','other');
insert into o$event_type values ('queue slave messages','other');
insert into o$event_type values ('rdbms ipc message block','other');
insert into o$event_type values ('rdbms ipc message','bogus');
insert into o$event_type values ('rdbms ipc reply','other');
insert into o$event_type values ('read by other session','ior');
insert into o$event_type values ('readable standby redo apply remastering','other');
insert into o$event_type values ('recovery area: computing applied logs','other');
insert into o$event_type values ('recovery area: computing backed up files','other');
insert into o$event_type values ('recovery area: computing dropped files','other');
insert into o$event_type values ('recovery area: computing obsolete files','other');
insert into o$event_type values ('recovery buffer pinned','other');
insert into o$event_type values ('recovery read','ior');
insert into o$event_type values ('reliable message','other');
insert into o$event_type values ('resmgr:I/O prioritization','other');
insert into o$event_type values ('resmgr:become active','other');
insert into o$event_type values ('resmgr:cpu quantum','other');
insert into o$event_type values ('resmgr:internal state change','other');
insert into o$event_type values ('resmgr:internal state cleanup','other');
insert into o$event_type values ('resmgr:sessions to exit','other');
insert into o$event_type values ('retry contact SCN lock master','other');
insert into o$event_type values ('rollback operations active','other');
insert into o$event_type values ('rollback operations block full','other');
insert into o$event_type values ('rolling migration: cluster quiesce','other');
insert into o$event_type values ('row cache lock','other');
insert into o$event_type values ('row cache read','other');
insert into o$event_type values ('scginq AST call','other');
insert into o$event_type values ('secondary event','other');
insert into o$event_type values ('securefile direct-read completion','ior');
insert into o$event_type values ('select wait','other');
insert into o$event_type values ('set director factor wait','other');
insert into o$event_type values ('simulated log write delay','bogus');
insert into o$event_type values ('single-task message','bogus');
insert into o$event_type values ('slave exit','other');
insert into o$event_type values ('smon timer','bogus');
insert into o$event_type values ('sort segment request','other');
insert into o$event_type values ('standby query scn advance','other');
insert into o$event_type values ('statement suspended, wait error to be cleared','other');
insert into o$event_type values ('storage device registration','other');
insert into o$event_type values ('switch logfile command','other');
insert into o$event_type values ('switch undo - offline','other');
insert into o$event_type values ('test long ops','other');
insert into o$event_type values ('timer in sksawat','other');
insert into o$event_type values ('transaction','other');
insert into o$event_type values ('tsm with timeout','other');
insert into o$event_type values ('txn to complete','other');
insert into o$event_type values ('unbound tx','other');
insert into o$event_type values ('undo segment extension','other');
insert into o$event_type values ('undo segment recovery','other');
insert into o$event_type values ('undo segment tx slot','other');
insert into o$event_type values ('undo_retention publish retry','other');
insert into o$event_type values ('unspecified wait event','other');
insert into o$event_type values ('virtual circuit status','bogus');
insert into o$event_type values ('wait active processes','other');
insert into o$event_type values ('wait for EMON to process ntfns','other');
insert into o$event_type values ('wait for EMON to spawn','other');
insert into o$event_type values ('wait for FMON to come up','other');
insert into o$event_type values ('wait for IMR CSS join retry','other');
insert into o$event_type values ('wait for MTTR advisory state object','other');
insert into o$event_type values ('wait for a paralle reco to abort','other');
insert into o$event_type values ('wait for a undo record','other');
insert into o$event_type values ('wait for another txn - rollback to savepoint','other');
insert into o$event_type values ('wait for another txn - txn abort','other');
insert into o$event_type values ('wait for another txn - undo rcv abort','other');
insert into o$event_type values ('wait for assert messages to be sent','other');
insert into o$event_type values ('wait for change','other');
insert into o$event_type values ('wait for kkpo ref-partitioning *TEST EVENT*','other');
insert into o$event_type values ('wait for master scn','other');
insert into o$event_type values ('wait for membership synchronization','other');
insert into o$event_type values ('wait for message ack','other');
insert into o$event_type values ('wait for possible quiesce finish','other');
insert into o$event_type values ('wait for record update','other');
insert into o$event_type values ('wait for rr lock release','other');
insert into o$event_type values ('wait for scn ack','other');
insert into o$event_type values ('wait for split-brain resolution','other');
insert into o$event_type values ('wait for stopper event to be increased','other');
insert into o$event_type values ('wait for sync ack','other');
insert into o$event_type values ('wait for tmc2 to complete','other');
insert into o$event_type values ('wait for unread message on broadcast channel','bogus');
insert into o$event_type values ('wait for unread message on multiple broadcast channels','bogus');
insert into o$event_type values ('wait for verification ack','other');
insert into o$event_type values ('wait for votes','other');
insert into o$event_type values ('wait list latch activity','other');
insert into o$event_type values ('wait list latch free','other');
insert into o$event_type values ('waiting to get CAS latch','other');
insert into o$event_type values ('waiting to get RM CAS latch','other');
insert into o$event_type values ('watchdog main loop','bogus');
insert into o$event_type values ('write complete waits','iow');
insert into o$event_type values ('writes stopped by instance recovery or database suspension','other');
insert into o$event_type values ('xdb schema cache initialization','other');


-----------------------------------------------------------------------------------------
----- DO NOT REMOVE THE BELOW LINES
-----------------------------------------------------------------------------------------

update o$event_type set type='iow' where event = 'free buffer waits';
update o$event_type set type='other' where event like 'latch%';
update o$event_type set type='other' where event like 'enq%';
update o$event_type set type='other' where event like 'cursor%';
update o$event_type set type='iow' where event like 'log%write%';
update o$event_type set type='iow' where event like 'db%write%';
update o$event_type set type='iow' where event like 'log%file%switch%';
update o$event_type set type='ior' where event like 'log%read%';
update o$event_type set type='ior' where event like 'db%read%';
insert into o$event_type values ('other','enqueue');
update o$event_type set type='other' where event = 'wait for unread message on broadcast channel';
update o$event_type set type='other' where event = 'wait for unread message on multiple broadcast channels';

commit;
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------