instrumentation in Informatica

 Instrumentation in applications is important. Especially when it comes to troubleshooting performance 😏. Unfortunately some applications seems to miss this feature. 

For me, Informatica Workflow Manager is such an application. I might be wrong - if I am, please tell me! 

But recently I was facing several issues in Oracle databases where I was only told the workflow name and workflow instance. After a lot of guesswork to identify the problematic sessions and SQLs, I was sure there must be something more useful, so I started to browse & search the internet. 

I found the Transaction Environment SQL. Even not explicit stated, for mee it seems a good point to identify a specific activity. Informatica has some Built-in Variables which are valid candidates, e.g. $PMWorkflowName. 

My first suggestion

BEGIN
DBMS_APPLICATION_INFO.set_module(
    module_name => '$PMWorkflowName',
    action_name => '$PMWorkflowRunInstanceName');
END;

failed with some internal errors:

ORA-06550: line 4, column 35:

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

 

   := . ( % ;

 

Database driver error...

Function Name : executeDirect

SQL Stmt : BEGIN

DBMS_APPLICATION_INFO.set_module(

    module_name => 'WF_SHAREPOINT_MYCOMPLAINCE',

    action_name => 's_M_STG_MC_RUN')

Oracle Fatal Error

Database driver error...

Function Name : ExecuteDirect

 

Oracle Fatal Error

]

Some more research and another KB article showed  a small additional requirements: 
Semicolons ( ; ) are seen as termination character. As there are multiple semicolons inside the PL/SQL block, they must be escaped by a backslash ( \ ).

With this knowledge, the working code is 

BEGIN
DBMS_APPLICATION_INFO.set_module(
    module_name => '$PMWorkflowName',
    action_name => '$PMSessionName')\;
DBMS_SESSION.set_identifier( $PMWorkflowRunId )\;
DBMS_SESSION.set_context('E2E_CONTEXT', 'ECID_UID', $PMWorkflowRunId )\;
END\;

This solution wil not fit every need, but hopefully it can be seen as a valid startingpoint for better instrumentation in Informatica. 

the size of a thumb

The size of a thumb was used by humans as a measurement for very long time. Used by craftsmen, the size of body parts like a thumb, hand, forearm, foot and so on were both good enough to be used within a team, and even the ratio between those measurement were acceptable accurate and comparable for each individual. 

But such a system comes to its limits. Different regions had different commonly agreed definitions for the same unit. This makes it hard to properly compare and convert, especially when it comes to written contracts between different regions. 

The metric system was designed to overcome problems in converting units between regions and types of units. 

Still it took some time and effort to show the advantage of this system. As an example, around 1999 NASA invested approx $125 million to teach some engineers in Colorado the difference between pound and newton.    

For me it seems, this problem is also exists in rules of thumb. Some of them are similar, still different. 

My current example is a rule of thumb to decide, if an access path of a SQL statement is acceptable.

The first rule I found by Jeff Holt and Cary Millsap in Optimize Oracle Performance (2003):

High LIO count (more than about 10 LIO calls per nonaggregate row returned per table in the FROM clause)  

It was explained in more detail by Cary in Mastering Oracle Trace Data (2019): 

The quantity 10 is a nice round number that represents the most touches on the buffer cache you should need for plunging an index from root to leaf, plus accessing a data block (even if you have row migration or row chaining). On average, you shouldn’t need more than 10 LIOs to find a row from a single-table query. You shouldn’t need more than 20 LIOs to find a row from a two-table join, more than 30 LIOs to find a row from a three-table join, and so on. You shouldn’t need more than 420 LIOs to retrieve 7 rows from a 6-table join.

A similar, but different rule by Chris Antognini in Troubleshooting Oracle Performance (2019): 

• Access paths that lead to less than about 5 logical reads per returned row are probably good.
• Access paths that lead to up to about 10–15 logical reads per returned row are probably acceptable.
• Access paths that lead to more than about 20 logical reads per returned row are probably inefficient. In other words, there’s probably room for improvement.

These different rules might be based on different assumptions. 

The example of 420 LIOs for 7 rows from a 6 table join is acceptable for Cary, maybe because he accepts the schema which enforces this 6 table join as given, but Chris might suggest a schema redesign or physical design optimization. 

At the end, all rules of thumb must be considered with reasonable care. It's never a law, but can be seen as a starting point. 

---

Update 2020-06-30: Chris Antognini informed me about a very important error I made:
He is referring to Access paths, not full complete execution plans.
Access paths are defined as

An access path is a technique used by a query to retrieve rows from a row source.

This means there is no big difference between Chris and Carys rules - which makes this post kind of useless. Still it will stay to document the importance of accurate reading!
I have to apologize to Chris and Cary for artificially generating a disagreement.

Draw an GANTT chart of how your workload fits together

In this Post I try tho provide a different view on ASH.
Again I'm focussed more on a specific user experience than general system overview.
The Idea again is from Cary Millsap - for details see this Youtube Video.

This time I rely on a script from my post Oceans, Islands, and Rivers in ASH and will show how it can provide a GANTT diagram of a specific user experience.

I created 2 dummy experiences - both by a user A. With a small extension of the yesterdays script and a filter on only this user_id and only current samples, 

...
WHERE 1=1 
  AND USER_ID=111
  AND SAMPLE_ID > 293910
...

the result is

It shows 17 different sessions which were active at some time. And with some experience and good imagination, the 2 different experiences can be separated. 
But as my testcases are properly instrumented, with an additional filter it's easy to show only the one experience I'm interested in.

...

WHERE 1=1 
  AND USER_ID=111
  D SAMPLE_ID > 293910
    AND CLIENT_ID='R1'
...

This shows only those 7 lines which matches my CLIENT_ID='R1' user experience. 
It also shows 4 parallel proceses in lines 3-6. 2 of them completed slightly faster. 

Because of these parallel processes, the user experience is 816 seconds, but DB-time is 1195 seconds! (Another reason why simple aggregates on ASH are often misleading). 

This result can be used as a starting point for further investigation - often together with the applications responsible. 

The full statement is here, the GANTT_LENGTH defines how many characters the Gantt diagram should have for better visibility.

WITH CONST as (
SELECT /*+ qb_name(CONST) */
    100 as GANTT_LENGTH -- unit: characters
  , 1   as RIVER_WIDTH  -- unit: sample_periode of ASH. --everything else IDLE is an OCEAN
FROM DUAL  
) ,FILTER_FIRST as (
SELECT /*+ qb_name('FILTER_FIRST') */  ash.* 
FROM gv$active_session_history ash
WHERE 1=1 
--  AND USER_ID=123
--  AND ....
--  AND SAMPLE_ID < 487871 -->
--  AND CLIENT_ID='R1'
), ISLANDS as (
SELECT /*+ qb_Name('ISLANDS') */
      min(BEGIN_SAMPLE_ID) OVER () total_min_sample_ID
   ,  max(END_SAMPLE_ID) OVER () total_max_sample_ID      
   ,   BEGIN_SAMPLE_ID
   ,  END_SAMPLE_ID
   ,  END_SAMPLE_ID - BEGIN_SAMPLE_ID +1  as ISLAND_LENGTH
   ,  ACTIVE_COUNT
   ,  inst_id
   ,  session_id
   ,  session_serial#
FROM FILTER_FIRST ff
       MATCH_RECOGNIZE(
         PARTITION BY inst_id, session_id, session_serial#
         ORDER BY SAMPLE_ID 
         MEASURES 
           first(SAMPLE_ID) as BEGIN_SAMPLE_ID,
           LAST(sample_id)  as END_SAMPLE_ID,
           COUNT(sample_id) as ACTIVE_COUNT
         ONE ROW PER MATCH
         PATTERN( frst cont*)
         DEFINE cont as SAMPLE_ID - prev(SAMPLE_ID) <= (SELECT RIVER_WIDTH FROM CONST)  -->
       )  
), DERIVED as (
SELECT /*+ qb_name (DERIVED) */ 
 (select (total_max_sample_id - total_min_sample_id) / ( SELECT GANTT_LENGTH FROM CONST)
   FROM ISLANDS
   WHERE rownum =1) as divisor
FROM DUAL
)
SELECT i.begin_sample_id
     , i.end_sample_id
     , i.inst_id
     , i.session_id
     , i.session_serial#
     , rpad('>', trunc( (begin_sample_id - total_min_sample_ID)/ d.divisor ,1)+1, ' ') || 
         rpad('*',ceil(island_length/ d.divisor) ,'*') AS GANTT
from ISLANDS i
   , DERIVED d
WHERE     END_SAMPLE_ID - BEGIN_SAMPLE_ID +1 > 2   
ORDER BY BEGIN_SAMPLE_ID, ISLAND_LENGTH, INST_ID, SESSION_ID
/

and is also availalbe on github.

Oceans, Islands, and Rivers in ASH

The Idea of Oceans, Islands and Rivers in performance data from Oracle sessions comes from Cary Millsap. I recommend reading his Presentation - especially page 33+. 

To summarize it very short: in an ocean of idle states (where the application doesn't interact with the session at all) there are islands of activity, but within these islands, there still can be rivers of idle events - when there is communication between the server process and the application. 

Even the algorithm was defined for trace data, I'm sure it can be implemented based on ASH data. Of course, the resolution isn't as fine as trace data, but if only big islands are of interest, and these islands doesn't have to many rivers, sampled ASH sould be acceptable.

This can be done quite easy with a statement like this.

I tried to keep it simple by having a CONST CTE at the beginning. there the RIVER_WIDTH can be set. It defines how many idle (non visible) samples define the widest river. Everything greater is an ocean which separates islands. 

In the 2nd CTE FILTER_FIRST, additional filters can be applied to ASH. Everything which narrows the focus can help, like USER_ID, SAMPLE_ID or timestamps. The idea matches proper scoping in SQL*Trace.

WITH CONST as (
SELECT /*+ qb_name(QB_CONST) */
    100 as GANTT_LENGTH -- unit: characters
  , 1   as RIVER_WIDTH  -- unit: sample_periode of ASH. --everything else IDLE is an OCEAN
FROM DUAL  
) ,FILTER_FIRST as (
SELECT /*+ qb_name(QB_FILTER_FIRST) */  ash.* 
FROM gv$active_session_history ash
WHERE 1=1 
--  AND USER_ID=123
--  AND ....
--  AND SAMPLE_ID < 487871
), ISLANDS as (
SELECT /*+ qb_Name(QB_ISLANDS) */
      min(BEGIN_SAMPLE_ID) OVER () total_min_sample_ID
   ,  max(END_SAMPLE_ID) OVER () total_max_sample_ID      
   ,   BEGIN_SAMPLE_ID
   ,  END_SAMPLE_ID
   ,  END_SAMPLE_ID - BEGIN_SAMPLE_ID +1  as ISLAND_LENGTH
   ,  ACTIVE_COUNT
   ,  inst_id
   ,  session_id
   ,  session_serial#
FROM FILTER_FIRST ff
       MATCH_RECOGNIZE(
         PARTITION BY inst_id, session_id, session_serial#
         ORDER BY SAMPLE_ID 
         MEASURES 
           first(SAMPLE_ID) as BEGIN_SAMPLE_ID,
           LAST(sample_id)  as END_SAMPLE_ID,
           COUNT(sample_id) as ACTIVE_COUNT
         ONE ROW PER MATCH
         PATTERN( frst cont*)
         DEFINE cont as SAMPLE_ID - prev(SAMPLE_ID) <= (SELECT RIVER_WIDTH FROM CONST) 
       )  
)
SELECT /*+ qb_name(QB_MAIN)*/ isl.begin_sample_id
     , isl.end_sample_id
     , isl.island_length
     , isl.active_count
     , isl.inst_id
     , isl.session_id
     , isl.session_serial#
FROM ISLANDS isl
Order by isl.begin_sample_id
        , isl.inst_id
        , isl.session_id
/

The result on my sandbox is like this:

BEGIN SAMPLE_ID	END SAMPLE_ID	ISLAND LENGTH	ACTIVE COUNT	INST ID	SESSION ID	SESSION SERIAL#
487760	487776	17	17	1	21	6605
487777	487780	4	4	1	274	7693
487781	487782	2	2	1	264	65268
487785	487785	1	1	1	278	22792
487791	487792	2	2	1	22	17104
487794	487794	1	1	1	22	37292
487795	487795	1	1	1	284	36814
487796	487797	2	2	1	278	22792
487798	487798	1	1	1	22	37292
487800	487800	1	1	1	31	44098
487800	487803	4	4	1	278	22792
487802	487875	74	71	1	22	37292
487807	487807	1	1	1	282	7351

BEGIN_SAMPLE_ID, END_SAMPLE_ID, INST_ID, SESSION_ID and SESSION_SERIAL# together describe every single island. It can be userd later on to do specific analysis on this island. 

ISLAND_LENGTH show the total length of the island, and ACTIVE_COUNT is the amount of "land" on this island. The lower this number, the more rivers were found. 

This can be a total different approach to analyse ASH data.

sampling everything

Oracle ASH is a great tool! 

It's on by default, and (when properly licensed) can give a lot of information about a system.
Unfortunately there are some drawbacks. One is the limited information for users experience, when part of the work is spent outside of the instance (and it's subsystems like disk-IO). Normally this part is spent on application side. 
Oracle indicates this with wait event SQL*Net message from client. As this wait event belongs to the wait class idle, it's not visible in ASH for a simple reason: ASH stands for Active Session History.  And idle just doesn't count as active. 
In my previous post I shortly explained why idle stati can be of some interest from users experience perspective. 

There is a parameter which transforms ASH into ALL Session History:

_ash_sample_all = TRUE

With this undocumented (and unsupported) setting, all sessions (not only those not idle) are sampled and the sample are written into ASH memory ring buffer. 
(There are more ash related undocumented parameters) 

On my sandbox system a small test created these entries:

SAMPLE_ID	SQL_ID	EVENT	SEQ#	WAIT_CLASS
485161		ON CPU	8
485162	30kanbhk5wg4m	SQL*Net message from client	32	Idle
485163	30kanbhk5wg4m	SQL*Net message from client	32	Idle
485164	817dp83nj72zp	ON CPU	32
485165		SQL*Net message from client	36	Idle
485166		SQL*Net message from client	36	Idle

This corresponds quite well with the matching tracefile (filtered for SQL*Net message form client) 

WAIT #139691636527808: nam='SQL*Net message from client' ela= 22382 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=740940045
WAIT #139691636521672: nam='SQL*Net message from client' ela= 217489 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=741185838
WAIT #139691636521672: nam='SQL*Net message from client' ela= 11484 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=741200014
WAIT #139691637134592: nam='SQL*Net message from client' ela= 2241071 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=743459220
WAIT #139691636521672: nam='SQL*Net message from client' ela= 11994 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=743475271
WAIT #0: nam='SQL*Net message from client' ela= 2223365 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=745699337
  

In this specific case we can match the event of sample_id 485162 and 485163 (it is the same event, as seq# doesn't change) matches the 4^th line of the trace excerpt (the one which lasts 2241071 ). 
The event of samles 485165 and 485166 match to the last line in the trace excerpt - ela= 2223365. 

---

Of course putting additional load onto the system comes at some risk. Let's consider how risky it is - especially if enabled for short time for specific analysis.

First a busy system where most sessions are active doing some work. 

In this instance most of the sessions are sampled anyhow - because active. The additional idle samples only add a relative small amount of lines - little additional load. 

Next a system where most sessions are idle. 

In this instance, much more lines will appear in ASH. Initially this can be seend as dangerous load. 
But all these idle sessions can become active anyhow - in worst case all together. 
If the instance is sized for the load of most sessions active, writing ALL sessions information to ASH will not hurt while it's idle. If the instance is NOT sized for the sessions coming active, the system is in high structural danger anyhow. 

 

Still another detail sould be cared of: ASH is written to AWR at some time - which will lead to more storage used when enabled for longer time. 

When compared with DBMS_MONITOR.DATABASE_TRACE_ENABLE, both methods have slightly different impact. When the system is busy, it will have a lot of quite fast wait events. A lot will be written to tracefiles and many lines will appear in ASH. 
But when the system has events which last quite long (as the 2 events in my example ago) they will create only one entry in the tracefile, but more lines in ASH. 

IDLE wait events can indicate work done

Oracle wait events are categorized into different wait classes. One of these classes is called Idle. 

As far as I know, wait events were defined by oracle kernel developers. 

From their perspective, this class makes sense: There is no work to be done by this specific session / process, so the session indicates it's waiting for new requests. 

This classification does not help when application performance or user experience is the focus. 

Even when the server process is idle - e.g. in event SQL*Net message from client, the application might do some work. 

Of course, from the server process perspective it can not be decided if somewhere some work is done, or all involved processes are idle and the user falled asleep.

A slightly differenciation could be done: from server process, there is a difference if for any open cursor (statement) more data can be provided, or there is nothing the server process can deliver to the client. Unfortunately this is not indicated in the event. 

From application perspective, idle events are misleading. That's why I prefer to call them timed events. 

This naming is not invented by me, I got some great help: 

 

They are really timed events of all sorts.

— RogerMacNicol (@RogerMacNicol) May 31, 2020

comparison between SQL*TRACE and ASH - get the right information

I'm quite interested in analyzing and improving Performance in Oracle databases. 

There are different approaches. A lot was discussed already if tracing or sampling is appropriate. Namely SQL*Trace or ASH/AWR. 

I will not favor one side here, just pick one aspect and compare both methods. 

Todays aspect is to compare how a specific user experience can be identified. As samples (ASH) are always enabled, it means to filter the right data out of this heap of data; In SQL*Trace it's to scope what or where SQL*Trace should be enabled. 

As I'm a lazy guy, I refer to Cary Millsaps Mastering Oracle Trace Data. In my copy of the book, Chapter 3 (Tracing Oracle) he shows an ordered list of tracing preferences. I will follow this list:

1. If the application set a distinct client ID for each business task execution ...
   SQL*Trace can be enabled by DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE
   ASH can be filtered on column CLIENT_ID
2. If the application set a distinct module and action name ... 
   SQL*Trace can be enabled by DBMS_MONITOR.SERV_MODE_ACT_TRACE_ENABLE
   ASH can be filtered on columns MODULE and ACTION
3. If the program run long enough to be identified ... and still run long enough ... 
   SQL*Trace can be enabled for this session by DBMS_MONITOR.SESSION_TRACE_ENABLE 
   ASH can be filtered on columns SESSION_ID and SESSION_SERIAL# 
4. If there is any x such as SYS_CONTEXT('USERENV', x)  ...
   SQL*Trace can be enabled by an AFTER LOGON trigger
   ASH use this AFTER LOGON trigger to set CLIENT_ID, MODULE or ACTION and then filter on any of those
5. If a new service can be created for the problematic experience ... 
   SQL*Trace can be enabled by DBMS_MONITOR.SERV_MODE_ACT_TRACE_ENABLE
   ASH can be filtered on column SERVICE_HASH (with a little join of DBA_SERVICES)
6. If nothing else helps ... 
   SQL*Trace can be enabled for everything a short period of time by DBMS_MONITOR.DATABASE_TRACE_ENABLE and the user experience can be identified later
   ASH is on all the time, still the user experience mist be identified by the same investigation effort 

This comparison seems to be equal between SQL*Trace and ASH sampling. But I know of a small but specific difference: Wherever the user experience can not be accurately enabled by any setting, it must be filtered by other means. Here SQL*Trace has a big advantage, especially when investigated by a toolset like mrskew in Method-R Workbench: Some activities can be identified by specific start and stop statements, e.g. getting some parameters from a configuration table with a SELECT at the beginning, and write a trace line at the end. mrskew can be used to generate an artificial experience-ID for every experience between these 2 markers. In ASH, as the sampling might not catch any of these statements for a specific execution. This needs additional triggers on the statements to set any CLIENT_ID, MODULE or ACTION as in point 4 above. For sure more work in  this case, especially for SELECTs. 

My high level summary on identifying the users experience: both SQL*Trace and ASH are comparable. The big advantage of ASH is it's always on implementation, whereas SQL*Trace has advantages when it's about specific SQLs as markers. 

unauditable select

 

Source: Natalie Berger

 Oracle Unified Audit is a great and flexible tool. 
Unfortunately I found a little gap where a SELECT is not audited. 
It is an edge-case: a common use in a CDB selects the object via the CONTAINERS() syntax.

Please follow this example to see the details. 

As I'm lazy, I used a lot of code from Tims example. 

First the preparations:
SYSTEM@CDB

CREATE USER c##common_user IDENTIFIED BY Common1 QUOTA UNLIMITED ON users;

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM TO c##common_user CONTAINER=ALL;

SYSTEM@PDB

CREATE USER local_user IDENTIFIED BY Local1 QUOTA UNLIMITED ON users;

GRANT CREATE SESSION, CREATE TABLE TO local_user;

CREATE TABLE local_user.local_user_tab AS
    SELECT level AS ID
    FROM   dual
    CONNECT BY level <= 2; 

GRANT SELECT, INSERT, UPDATE, DELETE ON local_user.local_user_tab TO c##common_user;

Now let's enable & test an audit policy:
SYSTEM@PDB1

Create Audit Policy local_user_select
        ACTIONS
          ALL on local_user.local_user_tab
    ;

select * from local_user.local_user_tab;
  ID
   1
   2
   
select event_timestamp, action_name, object_name, sql_text,  system_privilege_used
    from unified_audit_trail u
    where UNIFIED_AUDIT_POLICIES='LOCAL_USER_SELECT'
    order by u.event_timestamp desc;   

EVENT_TIMESTAMP                   DBUSERNAME       ACTION_NAME   OBJECT_NAME      SQL_TEXT                                    SYSTEM_PRIVILEGE_USED
19-JUN-20 09.36.35.912206000 AM   SYSTEM           SELECT        LOCAL_USER_TAB   select * from LOCAL_USER.LOCAL_USER_TAB     SELECT ANY TABLE

Let's continue the setup:
C##COMMON_USER@CDB

CREATE TABLE c##common_user.local_user_tab_v (id NUMBER);

C##COMMON_USER@PDB1

CREATE VIEW c##common_user.local_user_tab_v AS
    SELECT * FROM local_user.local_user_tab;
    
select * from local_user_tab_v;
  ID
   1
   2    

SYSTEM@PDB1

/

EVENT_TIMESTAMP                   DBUSERNAME       ACTION_NAME   OBJECT_NAME      SQL_TEXT                                    SYSTEM_PRIVILEGE_USED
19-JUN-20 09.42.44.379274000 AM   C##COMMON_USER   SELECT        LOCAL_USER_TAB   select * from local_user_tab_v                                                   
19-JUN-20 09.42.33.786949000 AM   C##COMMON_USER   SELECT        LOCAL_USER_TAB   CREATE VIEW c##common_user.local_use  ...   CREATE VIEW
19-JUN-20 09.36.35.912206000 AM   SYSTEM           SELECT        LOCAL_USER_TAB   select * from LOCAL_USER.LOCAL_USER_TAB     SELECT ANY TABLE

Everything fine so far.
But the following statement is not audited:
C##COMMON_USER@CDB

SELECT con_id, id
    FROM   CONTAINERS(local_user_tab_v)
    ORDER BY con_id, id;

CON_ID   ID
       3    1
       3    2

But there is nothing in the audit trail on PDB1:
SYSTEM@PDB1

/

EVENT_TIMESTAMP                   DBUSERNAME       ACTION_NAME   OBJECT_NAME      SQL_TEXT                                    SYSTEM_PRIVILEGE_USED
19-JUN-20 09.42.44.379274000 AM   C##COMMON_USER   SELECT        LOCAL_USER_TAB   select * from local_user_tab_v                                                   
19-JUN-20 09.42.33.786949000 AM   C##COMMON_USER   SELECT        LOCAL_USER_TAB   CREATE VIEW c##common_user.local_use  ...   CREATE VIEW
19-JUN-20 09.36.35.912206000 AM   SYSTEM           SELECT        LOCAL_USER_TAB   select * from LOCAL_USER.LOCAL_USER_TAB     SELECT ANY TABLE

I can't enable a proper audit in the CDB, as the object does not exist in ALL containers:
SYSTEM@CDB

Create Audit Policy local_user_select
            ACTIONS
              ALL on local_user.local_user_tab
    Container=ALL;

          ALL on local_user.local_user_tab
                            *
ERROR at line 3:
ORA-00942: table or view does not exist

Here it's visible, there is a SELECT which is not audited properly.

---

But it's not totally invisible to Oracle. Performing privilege analysis in the PDB shows the activity:
After a quick sequence

 DBMS_PRIVILEGE_CAPTURE.enable_capture (on PDB) - SELECT (C##COMMON_USER@CDB) - DBMS_PRIVILEGE_CAPTURE.disable_capture & DBMS_PRIVILEGE_CAPTURE.generate_result (on PDB), 

at least these results are available:

select * from DBA_USED_OBJPRIVS       where capture not in ('ORA$DEPENDENCY') ;
CAPTURE   SEQUENCE   OS_USER   USERHOST   MODULE                      USERNAME         USED_ROLE        OBJ_PRIV   OBJECT_OWNER   OBJECT_NAME     OBJECT_TYPE  
db_pol          1    oracle    localhost  java@localhost (TNS V1-V3)  C##COMMON_USER   C##COMMON_USER   SELECT     LOCAL_USER     LOCAL_USER_TAB  TABLE            

If you have any idea how to audit this select properly, please leave a comment.

V$EVENT_NAME

This post is a simple content of V$EVENT_NAME as of 19.7. 
It's here mostly for my easy lookup. As I had to start my sandbox twice (on a Sunday) to check some uncommon waits, this is worth for me.  

EVENT_ID	NAME	PARAMETER1	PARAMETER2	PARAMETER3	WAIT CLASS	DISPLAY_NAME
2516578839	null event				Other	<- name
3934444552	logout restrictor				Concurrency	<- name
939791390	VKTM Logical Idle Wait				Idle	<- name
1513856046	VKTM Init Wait for GSGA				Idle	<- name
1421578053	IORM Scheduler Slave Idle Wait				Idle	<- name
3767648750	acknowledge over PGA limit	limit	margin	growth	Scheduler	<- name
1179235204	Parameter File I/O	blkno	#blks	read/write	User I/O	<- name
866018717	rdbms ipc message	timeout			Idle	<- name
3222461937	remote db operation	clientid	operation	timeout	Network	<- name
2171045634	remote db file read	clientid	count	intr	Network	<- name
538064841	remote db file write	clientid	count	intr	Network	<- name
1867721841	io done	msg ptr			System I/O	<- name
4259433894	i/o slave wait	msg ptr			Idle	<- name
4120085931	RMAN Disk slave I/O	wait count	wait flags	timeout	System I/O	<- name
2828390964	RMAN Tape slave I/O	tape operation	operation flags	timeout	System I/O	<- name
3671110102	DBWR slave I/O	wait count	wait flags	timeout	System I/O	<- name
1180269184	LGWR slave I/O	wait count	wait flags	timeout	System I/O	<- name
1260687889	Archiver slave I/O	wait count	wait flags	timeout	System I/O	<- name
166678035	Disk file operations I/O	FileOperation	fileno	filetype	User I/O	<- name
2215689832	Disk file I/O Calibration	count			User I/O	<- name
13102552	Disk file Mirror Read	fileno	blkno	filetype	User I/O	<- name
2577606720	Disk file Mirror/Media Repair Write	fileno	blkno	filetype	User I/O	<- name
2093619153	direct path sync	File number	Flags		User I/O	<- name
2006672057	Clonedb bitmap file write	blkno	size		System I/O	<- name
4155572307	Datapump dump file I/O	count	intr	timeout	User I/O	<- name
1791724291	dbms_file_transfer I/O	count	intr	timeout	User I/O	<- name
432473858	DG Broker configuration file I/O	count	intr	timeout	User I/O	<- name
2326919048	Data file init write	count	intr	timeout	User I/O	<- name
3992632846	Log file init write	count	intr	timeout	User I/O	<- name
2089793129	Log archive I/O	count	intr	timeout	System I/O	<- name
3107297351	RMAN backup & recovery I/O	count	intr	timeout	System I/O	<- name
2431534215	RMAN lost write reread	count	intr	timeout	System I/O	<- name
3511162007	Standby redo I/O	count	intr	timeout	System I/O	<- name
2907891391	Network file transfer	count	intr	timeout	System I/O	<- name
171909448	Pluggable Database file copy	count	intr	timeout	User I/O	<- name
4053220855	File Copy	count	intr	timeout	User I/O	<- name
708427085	Backup: MML initialization				Administrative	<- name
90799346	Backup: MML v1 open backup piece				Administrative	<- name
1699816995	Backup: MML v1 read backup piece				Administrative	<- name
2733564901	Backup: MML v1 write backup piece				Administrative	<- name
3963262976	Backup: MML v1 close backup piece				Administrative	<- name
4157057748	Backup: MML v1 query backup piece				Administrative	<- name
4019590666	Backup: MML v1 delete backup piece				Administrative	<- name
1895924988	Backup: MML create a backup piece				Administrative	<- name
3051341818	Backup: MML commit backup piece				Administrative	<- name
3102084144	Backup: MML command to channel				Administrative	<- name
2388692075	Backup: MML shutdown				Administrative	<- name
1926582779	Backup: MML obtain textual error				Administrative	<- name
2632503569	Backup: MML query backup piece				Administrative	<- name
2690859083	Backup: MML extended initialization				Administrative	<- name
1533823139	Backup: MML read backup piece				Administrative	<- name
2524600641	Backup: MML delete backup piece				Administrative	<- name
2275421618	Backup: MML restore backup piece				Administrative	<- name
3388241768	Backup: MML write backup piece				Administrative	<- name
3815526880	Backup: MML proxy initialize backup				Administrative	<- name
2642609849	Backup: MML proxy cancel				Administrative	<- name
2960327623	Backup: MML proxy commit backup piece				Administrative	<- name
1156967028	Backup: MML proxy session end				Administrative	<- name
583062335	Backup: MML datafile proxy backup?				Administrative	<- name
3346425666	Backup: MML datafile proxy restore?				Administrative	<- name
585335785	Backup: MML proxy initialize restore				Administrative	<- name
2701284369	Backup: MML proxy start data movement				Administrative	<- name
216701082	Backup: MML data movement done?				Administrative	<- name
4278597786	Backup: MML proxy prepare to start				Administrative	<- name
2139086251	Backup: MML obtain a direct buffer				Administrative	<- name
2070697616	Backup: MML release a direct buffer				Administrative	<- name
531815827	Backup: MML get base address				Administrative	<- name
3181276243	Backup: MML query for direct buffers				Administrative	<- name
3421583815	OFS Receive Queue				Idle	<- name
303766224	OFS operation completion				Administrative	<- name
1048659203	OFS idle				Idle	<- name
58311103	VKRM Idle				Idle	<- name
1601747446	resmgr: redo throttle				Scheduler	<- name
218649935	wait for unread message on broadcast channel	channel context	channel handle		Idle	<- name
3224768590	wait for unread message on multiple broadcast channels	channel context	channel handle count		Idle	<- name
1055154682	class slave wait	slave id			Idle	<- name
739096548	RMA: IPC0 completion sync	send count			Idle	<- name
2966135248	IPC group service call	function id			Network	<- name
900394413	PING				Idle	<- name
1668213210	Service operation completion				Cluster	<- name
3615400802	service monitor: inst recovery completion				Cluster	<- name
2748706322	watchdog main loop				Idle	<- name
3939514704	process in prespawned state				Idle	<- name
2656070573	BA: Performance API				Administrative	<- name
565450542	File Repopulation Write	filename_hash	blkno		System I/O	<- name
3539483025	pmon timer	duration			Idle	<- name
635602798	pman timer				Idle	<- name
1233153647	latch: MGA shared context root latch	address	number	why	Concurrency	<- name
2598281784	latch: MGA shared context latch	address	number	why	Concurrency	<- name
500901621	latch: MGA heap latch	address	number	why	Concurrency	<- name
975995734	latch: MGA pid alloc latch	address	number	why	Concurrency	<- name
4082766567	latch: MGA asr alloc latch	address	number	why	Concurrency	<- name
1275333778	DNFS disp IO slave idle				Idle	<- name
3176176482	DIAG idle wait	component	where	wait time(millisec)	Idle	<- name
317011907	ges remote message	waittime	loop	p3	Idle	<- name
2269002043	enq: RI - Reader Farm SQL Isolation	name|mode	0	0	Concurrency	<- name
338940857	SCM slave idle				Idle	<- name
3416399148	LMS CR slave timer	type			Idle	<- name
2910564005	gcs remote message	waittime	poll	event	Idle	<- name
332747553	gcs yield cpu				Idle	<- name
2619295687	heartbeat monitor sleep				Idle	<- name
341609523	GCR sleep				Idle	<- name
3650619114	PBR logfile IO	File ID	blk	nbytes	System I/O	<- name
1197131876	PBR logfile block write	File ID	blk	pbridx	System I/O	<- name
1989349184	SGA: MMAN sleep for component shrink	component id	current size	target size	Idle	<- name
863929674	retry contact SCN lock master				Cluster	<- name
3213517201	control file sequential read	file#	block#	blocks	System I/O	control file read
2383414886	control file single write	file#	block#	blocks	System I/O	control file write
4078387448	control file parallel write	files	block#	requests	System I/O	<- name
2365673131	control file backup creation				Administrative	<- name
2970185817	Shared IO Pool Memory				Concurrency	<- name
1959037329	Shared IO Pool IO Completion				User I/O	<- name
3141712284	enq: PW - flush prewarm buffers	name|mode	0	0	Application	<- name
2779959231	latch: cache buffers chains	address	number	why	Concurrency	<- name
2701153470	free buffer waits	file#	block#	set-id#	Configuration	<- name
1570123276	local write wait	file#	block#		User I/O	<- name
1181827162	checkpoint completed				Configuration	<- name
4229542060	write complete waits	file#	block#		Configuration	<- name
2451603592	write complete waits: flash cache	file#	block#		Configuration	<- name
3761122497	buffer read retry	file#	block#		User I/O	<- name
2161531084	buffer busy waits	file#	block#	class#	Concurrency	<- name
1912606394	gc buffer busy acquire	file#	block#	class#	Cluster	<- name
105117041	gc buffer busy release	file#	block#	class#	Cluster	<- name
3056446529	read by other session	file#	block#	class#	User I/O	<- name
1176352510	multiple dbwriter suspend/resume for file offline				Administrative	<- name
765902655	recovery read				System I/O	<- name
1387386639	pi renounce write complete	file#	block#		Cluster	<- name
1963118444	db flash cache single block physical read				User I/O	<- name
2070455916	db flash cache multiblock physical read				User I/O	<- name
1153916164	db flash cache write				User I/O	<- name
1055954476	db flash cache invalidate wait	file#	block#		Concurrency	<- name
1847602198	db flash cache dynamic disabling wait				Administrative	<- name
23293667	remote log force - commit	thread#	thread scn	session scn	Commit	<- name
2057720172	remote log force - buffer update	file#	block#	class#	Cluster	<- name
1073104909	remote log force - buffer read	file#	block#	class#	Cluster	<- name
2849107610	remote log force - SCN range	file#	block#	class#	Cluster	<- name
3387973199	remote log force - session cleanout	thread#	thread scn	session scn	Cluster	<- name
427932892	DBWR timer				Idle	<- name
3500532018	enq: RO - contention	name|mode	2	0	Application	<- name
143262751	enq: RO - fast object reuse	name|mode	2	0	Application	<- name
4205197519	enq: KO - fast object checkpoint	name|mode	2	0	Application	<- name
1198921735	Data Guard network buffer stall reap				Network	<- name
2369083111	Data Guard: Gap Manager				Idle	<- name
3183521032	Data Guard: controlfile update				Idle	<- name
1460436880	MRP redo arrival				Idle	<- name
3134783330	RFS sequential i/o				System I/O	<- name
3089862638	RFS random i/o				System I/O	<- name
2009048728	RFS write				System I/O	<- name
1799268421	Data Guard: Timer				Idle	<- name
1959287235	ARCH wait for net re-connect				Network	<- name
4051103488	ARCH wait for netserver start				Network	<- name
1304409668	LNS wait on LGWR				Network	<- name
2949988816	LGWR wait on LNS				Network	<- name
406979416	ARCH wait for netserver init 2				Network	<- name
3411133732	ARCH wait for flow-control				Network	<- name
2731366464	ARCH wait for netserver detach				Network	<- name
2836458162	LNS ASYNC archive log				Idle	<- name
3599169768	LNS ASYNC dest activation				Idle	<- name
3378470826	LNS ASYNC end of log				Idle	<- name
549236675	log file sequential read	log#	block#	blocks	System I/O	log file multiblock read
215477332	log file single write	log#	block#	blocks	System I/O	log file header write
3999721902	log file parallel write	files	blocks	requests	System I/O	log file redo write
400279894	log file pmem persist write	thread	group	member	System I/O	<- name
2650776430	log file pmem persist read	thread	group	member	System I/O	<- name
2539661515	latch: redo writing	address	number	why	Configuration	<- name
2107275157	latch: redo copy	address	number	why	Configuration	<- name
3357856061	log buffer space				Configuration	log buffer full - LGWR bottleneck
2867289651	log file switch (checkpoint incomplete)				Configuration	<- name
114164561	log file switch (private strand flush incomplete)				Configuration	<- name
681532028	log file switch (archiving needed)				Configuration	<- name
3845123846	switch logfile command				Administrative	<- name
3834950329	log file switch completion				Configuration	<- name
1328744198	log file sync	buffer#	sync scn		Commit	commit: log file sync
1243695914	log file sync: SCN ordering	buffer#	sync scn		Concurrency	<- name
2915106572	simulated log write delay				Idle	<- name
4233989021	heartbeat redo informer				Idle	<- name
1278638045	LGWR real time apply sync				Idle	standby apply advance notification
91842589	LGWR worker group idle	group_id	slave_id		Idle	<- name
159901149	remote log force - log switch/recovery	thread#	thread SCN	force SCN	Cluster	<- name
2652584166	db file sequential read	file#	block#	blocks	User I/O	db single block read
506183215	db file scattered read	file#	block#	blocks	User I/O	db multiblock read
1307477558	db file single write	file#	block#	blocks	User I/O	db single block write
1620694733	db file parallel write	requests	interrupt	timeout	System I/O	db list of blocks write
133155944	db file async I/O submit	requests	interrupt	timeout	System I/O	<- name
834992820	db file parallel read	files	blocks	requests	User I/O	db list of blocks read
1567037747	enq: MV - datafile move	name|mode	type	file #	Administrative	<- name
3905407295	gc current request	file#	block#	id#	Cluster	<- name
512320954	gc cr request	file#	block#	class#	Cluster	<- name
1136317622	gc cr disk request	file#	block#	class#	Cluster	<- name
661121159	gc cr multi block request	file#	block#	class#	Cluster	<- name
2272899030	gc cr multi block mixed				Cluster	<- name
2774151265	gc cr multi block grant				Cluster	<- name
3897775868	gc current multi block request	file#	block#	id#	Cluster	<- name
1627043053	gc block recovery request	file#	block#	class#	Cluster	<- name
310416032	gc imc multi block request	file#	block#		Cluster	<- name
2628845780	gc imc multi block quiesce	file#	block#		Cluster	<- name
3035277123	gc cr block remote read	file#	block#	class#	Cluster	<- name
737661873	gc cr block 2-way				Cluster	<- name
3046984244	gc cr block 3-way				Cluster	<- name
1520064534	gc cr block busy				Cluster	<- name
2705335821	gc cr block congested				Cluster	<- name
2375802695	gc cr failure				Cluster	<- name
3151901526	gc cr block lost				Cluster	<- name
111015833	gc current block 2-way				Cluster	<- name
3570184881	gc current block 3-way				Cluster	<- name
2701629120	gc current block busy				Cluster	<- name
3785617759	gc current block congested				Cluster	<- name
1742950045	gc current retry				Cluster	<- name
957917679	gc current block lost				Cluster	<- name
1457266432	gc current split				Cluster	<- name
3201690383	gc cr grant 2-way				Cluster	<- name
3666253819	gc cr grant 3-way				Cluster	<- name
3261528052	gc cr grant busy				Cluster	<- name
3794703642	gc cr grant congested				Cluster	<- name
1445598276	gc cr disk read				Cluster	<- name
690277170	gc cr grant ka				Cluster	<- name
1341316678	gc cr grant cluster flash cache read				Cluster	<- name
3015759224	gc cr cluster flash cache read				Cluster	<- name
1236598300	gc cr flash cache copy				Cluster	<- name
3609908235	gc cr grant read-mostly invalidation				Cluster	<- name
1577027000	gc cr grant read-only instance invalidation				Cluster	<- name
2685450749	gc current grant 2-way				Cluster	<- name
1094886395	gc current grant 3-way				Cluster	<- name
2277737081	gc current grant busy				Cluster	<- name
667696377	gc current grant congested				Cluster	<- name
4071646426	gc current grant ka				Cluster	<- name
1301716097	gc current grant cluster flash cache read				Cluster	<- name
1116778291	gc current grant read-mostly invalidation				Cluster	<- name
2183032747	gc current grant read-only instance invalidation				Cluster	<- name
1188530765	gc transaction table	count			Cluster	<- name
4185841437	gc index operation	usn#	slot#	seq#	Cluster	<- name
297486966	gc freelist				Cluster	<- name
75296820	gc remaster	file#	block#	class#	Cluster	<- name
758475196	gc quiesce				Cluster	<- name
3612069565	gc recovery				Cluster	<- name
3726007083	gc flushed buffer				Cluster	<- name
3708514396	gc send complete				Cluster	<- name
3415121734	gc current cancel	le			Cluster	<- name
3289120169	gc cr cancel	le			Cluster	<- name
2369255784	gc assume	le			Cluster	<- name
3893928311	gc current index split	le			Cluster	<- name
3571931909	gc domain validation	file#	block#	class#	Cluster	<- name
2961011386	gc recovery free				Cluster	<- name
3106959643	gc recovery quiesce	file#	block#	class#	Cluster	<- name
830518988	gc claim	file#	block#	class#	Cluster	<- name
3723089570	gc cancel retry				Cluster	<- name
3926164927	direct path read	file number	first dba	block cnt	User I/O	<- name
861319509	direct path read temp	file number	first dba	block cnt	User I/O	<- name
885859547	direct path write	file number	first dba	block cnt	User I/O	<- name
38438084	direct path write temp	file number	first dba	block cnt	User I/O	<- name
428700550	datafile pre-create				Administrative	<- name
2328740855	parallel recovery slave idle wait				Idle	<- name
3230901260	Backup Appliance waiting for work	session_id	serial		Idle	<- name
1629412133	Backup Appliance waiting restore start	session_id	serial		Idle	<- name
1911215282	Backup Appliance Surrogate wait	session_id	serial		Idle	<- name
3411526999	Backup Appliance Servlet wait	session_id	serial		Idle	<- name
614344865	Backup Appliance Comm SGA setup wait	session_id	serial		Idle	<- name
1221077576	LogMiner builder: idle	Session ID			Idle	<- name
2130278899	LogMiner builder: memory	Session ID			Queueing	<- name
3993953808	LogMiner builder: DDL	Session ID			Queueing	<- name
3650510895	LogMiner builder: branch	Session ID			Idle	<- name
37490450	LogMiner preparer: idle	Session ID			Idle	<- name
4176490272	LogMiner preparer: memory	Session ID			Queueing	<- name
2969107883	LogMiner reader: buffer	Session ID			Queueing	<- name
3314391977	LogMiner reader: log (idle)	Session ID	Thread	Sequence	Idle	<- name
1534896503	LogMiner reader: redo (idle)	Session ID	Thread	Sequence	Idle	<- name
3214539112	LogMiner merger: idle	Session ID	Thread		Idle	<- name
2858596797	LogMiner client: transaction	Session ID			Idle	<- name
3893525907	LogMiner: other	Session ID			Idle	<- name
3685504676	LogMiner: activate	Session ID			Idle	<- name
3979031729	LogMiner: reset	Caller ID			Idle	<- name
2694966712	LogMiner: find session	Session ID			Idle	<- name
2989610564	LogMiner: internal	Caller ID			Idle	<- name
226544737	Logical Standby Apply Delay				Idle	<- name
3525876136	wait for possible quiesce finish				Administrative	quiesce database completion
2842195073	parallel recovery coordinator waits for slave cleanup				Idle	<- name
3487232407	flashback log file write	log#	block#	Bytes	System I/O	<- name
2769438501	flashback log file read	log#	block#	Bytes	System I/O	<- name
1760381182	flashback buf free by RVWR				Configuration	<- name
157547587	flashback log file sync				User I/O	<- name
2032998565	parallel recovery coordinator idle wait				Idle	<- name
722766223	parallel recovery control message reply				Idle	<- name
2314562763	cell smart table scan	cellhash#			User I/O	<- name
601047792	cell smart index scan	cellhash#			User I/O	<- name
186581379	cell external table smart scan	cellhash#			User I/O	<- name
447002770	cell statistics gather	cellhash#			User I/O	<- name
2705202413	cell smart incremental backup	cellhash#			System I/O	<- name
2569366771	cell smart file creation	cellhash#			User I/O	<- name
3260626027	cell smart restore from backup	cellhash#			System I/O	<- name
572448743	parallel recovery slave next change				Idle	<- name
4031319789	concurrent I/O completion				Administrative	online move datafile IO completion
1845020027	datafile copy range completion				Administrative	online move datafile copy range completion
1226277798	nologging fetch slave idle				Idle	<- name
445146538	Nologging standby progress	Primary client SCN	Max wait in centi-seconds		Commit	<- name
354850594	nologging standby txn commit				Commit	<- name
2506001814	nologging range consumption list				Configuration	<- name
3669067250	recovery sender idle				Idle	<- name
1872203966	recovery receiver idle				Idle	<- name
3286605538	recovery coordinator idle				Idle	<- name
3619482101	recovery logmerger idle				Idle	<- name
4138829642	block compare coord process idle				Idle	<- name
668627480	enq: TM - contention	name|mode	object #	table/partition	Application	<- name
1649608974	enq: ST - contention	name|mode	0	0	Configuration	<- name
1781586680	undo segment extension	segment#			Configuration	<- name
2539132690	undo segment tx slot	segment#			Configuration	<- name
1107691084	switch undo - offline				Administrative	<- name
1005272400	alter rbs offline				Administrative	<- name
310662678	enq: TX - row lock contention	name|mode	usn<<16 | slot	sequence	Application	<- name
281768874	enq: TX - allocate ITL entry	name|mode	usn<<16 | slot	sequence	Configuration	<- name
1035026728	enq: TX - index contention	name|mode	usn<<16 | slot	sequence	Concurrency	<- name
1435178951	enq: TW - contention	name|mode	0	operation	Administrative	<- name
1817260038	PX Deq: Txn Recovery Start	sleeptime/senderid	passes		Idle	<- name
1029371363	PX Deq: Txn Recovery Reply	sleeptime/senderid	passes		Idle	<- name
1574097577	latch: Undo Hint Latch	address	number	why	Concurrency	<- name
680822103	statement suspended, wait error to be cleared				Configuration	<- name
1394127552	latch: In memory undo latch	address	number	why	Concurrency	<- name
1286443595	latch: MQL Tracking Latch	address	number	why	Concurrency	<- name
2729944181	fbar timer	sleep time	failed		Idle	<- name
1832903562	Archive Manager file transfer I/O	count	intr	timeout	User I/O	<- name
3886663633	SecureFile log buffer				Configuration	<- name
822361323	IM buffer busy				Concurrency	<- name
2468447540	IM buffer busy TXN				Concurrency	<- name
3258151131	IM buffer busy SHR				Concurrency	<- name
1606606310	securefile chain update	seghdr	fsb		Concurrency	<- name
1645217925	enq: HW - contention	name|mode	table space #	block	Configuration	<- name
206780098	enq: BE - Critical Block Allocation	name|mode	tablespace#	block#	Concurrency	<- name
3890744969	enq: SS - contention	name|mode	tablespace #	dba	Configuration	<- name
2672479943	sort segment request				Configuration	<- name
1403232821	smon timer	sleep time	failed		Idle	<- name
3431783400	PX Deq: Metadata Update	ktelc_wait1s			Idle	<- name
2942611488	Space Manager: slave idle wait	Slave ID			Idle	<- name
2322460838	enq: SQ - contention	name|mode	object #	0	Configuration	<- name
818518977	enq: SV - contention	type|mode	id1	id2	Configuration	<- name
2288901790	PX Deq: Index Merge Reply	sleeptime/senderid	passes		Idle	<- name
2881101577	PX Deq: Index Merge Execute	sleeptime/senderid	passes		Idle	<- name
259094851	PX Deq: Index Merge Close	sleeptime/senderid	passes		Idle	<- name
2908893972	enq: HV - contention	name|mode	object #	0	Concurrency	<- name
1775596922	PX Deq: kdcph_mai	kdcph_mai			Idle	<- name
3388026088	PX Deq: kdcphc_ack	kdcphc_ack			Idle	<- name
3311157317	index (re)build online start	object	mode	wait	Administrative	<- name
3507172204	index (re)build online cleanup	object	mode	wait	Administrative	<- name
459595925	index (re)build online merge	object	mode	wait	Administrative	<- name
3347698104	index (re)build lock or pin object	namespace	lock_mode	pin_mode	Administrative	<- name
3999678875	securefile direct-read completion				User I/O	<- name
3535858375	securefile direct-write completion				User I/O	<- name
39333034	SecureFile mutex				Concurrency	<- name
122034066	enq: WG - lock fso	name|mode	kdlw lobid first half	kdlw lobid sec half	Concurrency	<- name
3185393509	imco timer	sleep time	failed		Idle	<- name
542160597	Inmemory Populate: get loadscn				Concurrency	<- name
238930206	IMFS defer writes scheduler				Idle	<- name
1318477709	memoptimize write buffer get				Configuration	<- name
2299584621	memoptimize write drain idle				Idle	<- name
1117386924	latch: row cache objects	address	number	why	Concurrency	<- name
306610566	row cache mutex	cache id	where requested		Concurrency	<- name
1714089451	row cache lock	cache id	mode	request	Concurrency	<- name
3733770256	row cache read	cache id			Concurrency	<- name
670556006	libcache interrupt action by LCK	location			Concurrency	<- name
2563317866	enq: IV - cross instance invalidation	lock idx			Concurrency	<- name
877525844	cursor: mutex X	idn	value	where	Concurrency	<- name
1575214430	cursor: mutex S	idn	value	where	Concurrency	<- name
3085815766	cursor: pin X	idn	value	where	Concurrency	<- name
352301881	cursor: pin S	idn	value	where	Concurrency	<- name
1729366244	cursor: pin S wait on X	idn	value	where	Concurrency	<- name
3015879322	enq: CB - role operation	name|mode	0	0	Concurrency	<- name
850477422	Global transaction acquire instance locks	retries			Configuration	<- name
3304404527	enq: BB - 2PC across RAC instances	name|mode	gtrid hash value	bqual hash value	Commit	<- name
2696347763	latch: shared pool	address	number	why	Concurrency	<- name
2142653731	LCK0 row cache object free	heap ds	min_size	clatch	Concurrency	<- name
2405459892	Unpin a recreatable chunk	chunk addr	max attempt	attempted	Concurrency	<- name
2802704141	library cache pin	handle address	pin address	100*mode+namespace	Concurrency	<- name
916468430	library cache lock	handle address	lock address	100*mode+namespace	Concurrency	<- name
2952162927	library cache load lock	object address	lock address	100*mask+namespace	Concurrency	<- name
1646780882	library cache: mutex X	idn	value	where	Concurrency	<- name
2601513493	library cache: bucket mutex X	idn	value	where	Concurrency	<- name
2382371857	library cache: dependency mutex X	idn	value	where	Concurrency	<- name
2446268751	library cache: mutex S	idn	value	where	Concurrency	<- name
1241467722	BFILE read				User I/O	<- name
1452455426	resmgr:cpu quantum	location	consumer group id		Scheduler	<- name
3911289767	resmgr:large I/O queued	location			Scheduler	<- name
2027842284	resmgr: I/O rate limit	location			Scheduler	<- name
4043670897	resmgr:internal state change	location			Concurrency	<- name
3942551365	resmgr:sessions to exit	location			Concurrency	<- name
1861259087	resmgr:become active	location			Scheduler	<- name
1724186970	resmgr:pq queued	location			Scheduler	<- name
3680756349	TCP Socket (KGAS)				Network	<- name
2804400934	utl_file I/O				User I/O	<- name
639905136	DNFS disp IO slave completion	pnum			User I/O	<- name
4219255068	alter system set dispatcher	waited			Administrative	<- name
2900469894	virtual circuit wait	circuit#	type		Network	<- name
1091942974	virtual circuit next request	circuit#	type		Idle	<- name
1786390478	shared server idle wait				Idle	<- name
4090013609	dispatcher timer	sleep time			Idle	<- name
4195517431	dispatcher listen timer	sleep time			Network	<- name
660387499	dedicated server timer	wait event			Network	<- name
963656759	cmon timer	sleep time			Idle	<- name
3775760766	pool server timer	sleep time			Idle	<- name
1524501944	connection pool wait	op	num procs		Administrative	<- name
604512360	connection broker handoff	connection broker	connection	op	Network	<- name
3113908805	lreg timer	succ	wait	fail	Idle	<- name
2173075130	JOX Jit Process Sleep				Idle	<- name
782339817	jobq slave wait				Idle	<- name
775793103	Wait for Table Lock				Application	<- name
160773985	pipe get	handle address	buffer length	timeout	Idle	<- name
3479211658	pipe put	handle address	record length	timeout	Concurrency	<- name
3835660459	enq: DB - contention	name|mode	EnqMode	0	Administrative	<- name
961027629	PX Deque wait	sleeptime/senderid	passes		Idle	<- name
3382828453	PX Idle Wait	sleeptime/senderid	passes		Idle	<- name
2267953574	PX Deq Credit: need buffer	sleeptime/senderid	passes	qref	Idle	<- name
2610814049	PX Deq Credit: send blkd	sleeptime/senderid	passes	qref	Idle	<- name
77145095	PX Deq: Msg Fragment	sleeptime/senderid	passes		Idle	<- name
4255662421	PX Deq: Parse Reply	sleeptime/senderid	passes		Idle	<- name
2599037852	PX Deq: Execute Reply	sleeptime/senderid	passes		Idle	<- name
98582416	PX Deq: Execution Msg	sleeptime/senderid	passes		Idle	<- name
799271425	PX Deq: Table Q Normal	sleeptime/senderid	passes		Idle	<- name
1062854067	PX Deq: Table Q Sample	sleeptime/senderid	passes		Idle	<- name
3600835498	enq: TG - IMCDT global resource	name|mode	container id #	0	Concurrency	<- name
4196504577	enq: TI - IMCDT object HT	name|mode	query exec id #	qc session id #	Concurrency	<- name
1850448852	external table read	filectx	file#	size	User I/O	<- name
2573156426	external table write	filectx	file#	size	User I/O	<- name
332943844	external table open	filectx	file#		User I/O	<- name
2580575859	external table seek	filectx	file#	pos	User I/O	<- name
4284613698	external table misc IO	filectx	iocode	P3	User I/O	<- name
2649722911	enq: RC - Result Cache: Contention	name|mode	chunkNo	blockNo	Application	<- name
3225147589	result cache lock wait	object no			Concurrency	<- name
1636695715	enq: JX - SQL statement queue	name|mode	sqlid	execid	Scheduler	<- name
3822543692	enq: JX - cleanup of queue	name|mode	sqlid	execid	Scheduler	<- name
3419368467	PX Queuing: statement queue	sleeptime	passes		Scheduler	<- name
3042070696	enq: KV - IMA key vector access	name|mode	node#+sess#, cursor#+kv#	kv #	Concurrency	<- name
892389094	dbverify reads	count	intr	timeout	User I/O	<- name
938380620	REPL Apply: txns				Idle	<- name
463459266	REPL Capture: subscribers to catch up	2=>GoldenGate 1=>XStream 0=>Streams	TYPE		Queueing	<- name
249067227	REPL Capture/Apply: memory	2=>GoldenGate 1=>XStream 0=>Streams			Queueing	<- name
188497226	REPL Apply: commit	2=>GoldenGate 1=>XStream 0=>Streams			Configuration	<- name
2757875356	REPL Apply: dependency	2=>GoldenGate 1=>XStream 0=>Streams			Concurrency	<- name
2524336375	REPL Capture/Apply: flow control	2=>GoldenGate 1=>XStream 0=>Streams			Queueing	<- name
3941979276	REPL Capture/Apply: messages	2=>GoldenGate 1=>XStream 0=>Streams			Idle	<- name
1684328492	REPL Capture: archive log	2=>GoldenGate 1=>XStream 0=>Streams	TYPE		Idle	<- name
1421698562	REPL Capture: filter callback ruleset	2=>GoldenGate 1=>XStream 0=>Streams			Application	<- name
2362278079	REPL Apply: apply DDL	2=>GoldenGate 1=>XStream 0=>Streams	sleep time		Application	<- name
845337552	enq: ZG - contention	name|mode	file group id	version id	Administrative	<- name
2254800293	single-task message				Idle	<- name
2067390145	SQL*Net message to client	driver id	#bytes		Network	<- name
3655533736	SQL*Net message to dblink	driver id	#bytes		Network	<- name
554161347	SQL*Net more data to client	driver id	#bytes		Network	<- name
1958556342	SQL*Net more data to dblink	driver id	#bytes		Network	<- name
1421975091	SQL*Net message from client	driver id	#bytes		Idle	<- name
3530226808	SQL*Net more data from client	driver id	#bytes		Network	<- name
4093028837	SQL*Net message from dblink	driver id	#bytes		Network	<- name
1136294303	SQL*Net more data from dblink	driver id	#bytes		Network	<- name
483818214	SQL*Net vector message from client	driver id	#bytes		Idle	<- name
599122182	SQL*Net vector message from dblink	driver id	#bytes		Idle	<- name
3957226286	SQL*Net vector data to client	driver id	#bytes		Network	<- name
524447658	SQL*Net vector data from client	driver id	#bytes		Network	<- name
380483207	SQL*Net vector data to dblink	driver id	#bytes		Network	<- name
1970154257	SQL*Net vector data from dblink	driver id	#bytes		Network	<- name
1963888671	SQL*Net break/reset to client	driver id	break?		Application	<- name
634664853	SQL*Net break/reset to dblink	driver id	break?		Application	<- name
3879957351	External Procedure initial connection				Application	<- name
1909653202	External Procedure call	HS_SESSION_ID			Application	<- name
818280116	PL/SQL lock timer	duration			Idle	<- name
1564641971	wait for EMON to process ntfns				Configuration	<- name
1053768773	Streams AQ: emn coordinator idle wait				Idle	<- name
1034167112	EMON slave idle wait				Idle	<- name
2249606771	Emon coordinator main loop				Idle	<- name
928709037	Emon slave main loop				Idle	<- name
738183602	enq: UL - contention	name|mode	id	0	Application	<- name
3955192389	Streams AQ: waiting for messages in the queue	queue id	process#	wait time	Idle	<- name
3702640206	Streams AQ: waiting for time management or cleanup tasks				Idle	<- name
2461999423	Streams AQ: enqueue blocked on low memory				Queueing	<- name
764740284	Streams AQ: enqueue blocked due to flow control				Queueing	<- name
1755736138	Streams AQ: delete acknowledged messages				Idle	<- name
1133197228	Streams AQ: deallocate messages from Streams Pool				Idle	<- name
989870553	Streams AQ: qmn coordinator idle wait				Idle	<- name
1830121438	Streams AQ: qmn slave idle wait	Type			Idle	<- name
3888265502	AQ: 12c message cache init wait				Idle	<- name
3013878596	AQ Cross Master idle				Idle	<- name
3367618326	AQPC idle				Idle	<- name
1646312927	Streams AQ: load balancer idle				Idle	<- name
1402142990	Sharded Queues : Part Maintenance idle				Idle	<- name
759460378	Sharded Queues : Part Truncate idle				Idle	<- name
3846605265	REPL Capture/Apply: RAC AQ qmn coordinator	1=>MASTER 2=>SLAVE			Idle	<- name
2874621763	Streams AQ: opt idle	1=>SLAVE0 2=>SLAVE1 3=>SLAVE2 4=>SLAVE3 5=>MASTER			Idle	<- name
255548015	HS message to agent				Idle	<- name
2904668353	TEXT: URL_DATASTORE network wait				Network	<- name
1267930770	TEXT: File System I/O				User I/O	<- name
867069076	OLAP DML Sleep	duration			Application	<- name
2908122354	Cube Build Master Wait for Jobs				Concurrency	<- name
604179256	ASM sync cache disk read	group	obj	block	User I/O	<- name
178886535	ASM sync relocation I/O	count	where	file	System I/O	<- name
1271689928	ASM async relocation I/O	count	where	file	System I/O	<- name
1049283008	ASM COD rollback operation completion	dismount force			Administrative	<- name
1568594048	kfk: async disk IO	count	where	timeout	System I/O	<- name
3288045901	ASM IO for non-blocking poll	count	where	timeout	User I/O	<- name
3423355190	ASM remote SQL				Network	<- name
2042354203	ASM background timer				Idle	<- name
2317972841	ASM cluster membership changes				Idle	<- name
1835713968	iowp io	count	intr	timeout	System I/O	<- name
1931000598	iowp msg	iowp id			Idle	<- name
2213525889	iowp file id	iowp id			Idle	<- name
3936513851	netp network	netp id			Idle	<- name
3193337724	gopp msg	gopp id			Idle	<- name
3800093324	ASM Fixed Package I/O	blkno	bytes	filetype	User I/O	<- name
1299431751	ASM mount : wait for heartbeat				Administrative	<- name
2619540468	ASM PST query : wait for [PM][grp][0] grant				Cluster	<- name
3491398912	lock remastering				Cluster	<- name
3166130	ASM Staleness File I/O	blkno	#blks	diskno	User I/O	<- name
769429583	ASM File Group Sync	op	gn	pdbid	User I/O	<- name
3066824253	auto-sqltune: wait graph update				Idle	<- name
277762365	WCR: replay client notify	who am I			Idle	<- name
1481930431	WCR: replay clock	wait for scn's hi 4 bytes	wait for scn's lo 4 bytes	schedule capture ID	Idle	<- name
3833657348	WCR: replay lock order	wait for scn's hi 4 bytes	wait for scn's lo 4 bytes		Application	<- name
4280671222	WCR: replay paused				Idle	<- name
1955925289	JS kgl get object wait				Administrative	<- name
1045742593	JS external job				Idle	<- name
1371173112	JS kill job wait				Administrative	<- name
2190647165	JS coord start wait				Administrative	<- name
2614864156	cell single block physical read	cellhash#	diskhash#	bytes	User I/O	<- name
443865681	cell multiblock physical read	cellhash#	diskhash#	bytes	User I/O	<- name
3975960017	cell list of blocks physical read	cellhash#	diskhash#	blocks	User I/O	<- name
213372979	cell physical read no I/O	cellhash#	diskhash#	bytes	User I/O	<- name
1963099394	cell single block read request	cellhash#	diskhash#	bytes	User I/O	<- name
631446859	cell multiblock read request	cellhash#	diskhash#	bytes	User I/O	<- name
4067812586	cell list of blocks read request	cellhash#	diskhash#	blocks	User I/O	<- name
1946591843	cell manager opening cell	cellhash#			System I/O	<- name
1617821548	cell manager closing cell	cellhash#			System I/O	<- name
4026210594	cell manager discovering disks	cellhash#			System I/O	<- name
1693614820	cell worker idle				Idle	<- name
1736664284	events in waitclass Other				Other	<- name
2390244800	enq: WM - WLM Plan activation	name|mode	0	0	Other	<- name
3474287957	latch free	address	number	why	Other	<- name
2701202185	latch activity	address	number	process#	Other	<- name
2530878290	wait list latch free	address	number		Other	<- name
2680091115	kslwait unit test event 1	p1	p2	p3	Other	<- name
2424426032	kslwait unit test event 2	p1	p2	p3	Other	<- name
2025755259	kslwait unit test event 3	p1	p2	p3	Other	<- name
2971802445	unspecified wait event				Other	<- name
3498297576	global enqueue expand wait				Other	<- name
2917886901	free process state object				Other	<- name
3757863830	inactive session	session#	serial	instance	Other	<- name
1812220754	process terminate				Other	<- name
139039345	latch: call allocation	address	number	why	Other	<- name
2900750527	latch: session allocation	address	number	why	Other	<- name
1945768837	check CPU wait times				Other	<- name
327222633	ADG switchover completion	pdbid			Other	<- name
1947980297	process allocation slot				Other	<- name
2915720968	session allocation inc count				Other	<- name
1760863753	enq: CI - contention	name|mode	opcode	type	Other	<- name
3733307663	enq: PR - contention	name|mode	type	dtp	Other	<- name
3155844579	enq: AK - contention	type|mode	id1	id2	Other	<- name
2921505296	enq: XK - contention	type|mode	id1	id2	Other	<- name
1210775251	enq: DI - contention	type|mode	id1	id2	Other	<- name
3710671834	enq: RM - contention	type|mode	id1	id2	Other	<- name
3226762304	enq: BO - contention	type|mode	id1	id2	Other	<- name
2383012730	ges resource enqueue open retry sleep				Other	<- name
2151749845	ksim generic wait event	where	wait_count		Other	<- name
1981266442	enq: DE - Update Draining Test	name|mode	0	0	Other	<- name
2030748592	debugger command				Other	<- name
2530266680	oradebug request slot				Other	<- name
367999153	oradebug request completion				Other	<- name
4013410966	latch: ksm sga alloc latch	address	number	why	Other	<- name
1732444908	defer SGA allocation slave	defer segment index	allocation mode		Other	<- name
1785376945	SGA Allocator termination				Other	<- name
1800992443	PGA memory operation				Other	<- name
4129138703	enq: PE - contention	name|mode	parno	0	Other	<- name
925144608	enq: PG - contention	name|mode	0	0	Other	<- name
3228065868	ksbsrv				Other	<- name
3024348788	ksbcic				Other	<- name
875419734	process startup	type	process#		Other	<- name
2726125541	process shutdown	type	process#		Other	<- name
1060877110	prior spawner clean up	process_pid	process_sno		Other	<- name
1973577887	latch: messages	address	number	why	Other	<- name
2616562781	rdbms ipc message block				Other	<- name
2587381521	rdbms ipc reply	from_process			Other	<- name
3999387466	latch: pdb enqueue hash chains	address	number	why	Other	<- name
1847483002	latch: enqueue hash chains	address	number	why	Other	<- name
880740118	imm op	msg ptr			Other	<- name
2914969843	slave exit	nalive	sleeptime	loop	Other	<- name
3750685624	enq: FP - global fob contention	name|mode	low file obj add	high file obj add	Other	<- name
1272752883	enq: RE - block repair contention	name|mode	File Type or File number	block number	Other	<- name
3396302007	enq: BM - clonedb bitmap file write	name|mode	block number	number of blocks	Other	<- name
2505166323	asynch descriptor resize	outstanding #aio	current aio limit	new aio limit	Other	<- name
534373369	OFS interrupted req not found				Other	<- name
2004679423	enq: FO - file system operation contention	name|mode	0	0	Other	<- name
3804628168	resmgr:plan change	con_id			Other	<- name
1504129838	enq: KM - contention	name|mode	type	type	Other	<- name
1301289702	enq: KT - contention	name|mode	plan #	0	Other	<- name
2962754459	enq: CA - contention	name|mode	0	0	Other	<- name
2775294757	enq: KD - determine DBRM master	name|mode	0	0	Other	<- name
906644781	reliable message	channel context	channel handle	broadcast message	Other	<- name
973988003	broadcast mesg queue transition	channel handle	message	location	Other	<- name
1519436045	broadcast mesg recovery queue transition	channel handle	message	location	Other	<- name
1510356050	KSV master wait	indicator			Other	<- name
1628776795	master exit	alive slaves			Other	<- name
1361925913	ksv slave avail wait				Other	<- name
3063016909	enq: PV - syncstart	name|mode	class id	0	Other	<- name
2894614381	enq: PV - syncshut	name|mode	class id	0	Other	<- name
980653535	enq: SP - contention 1	name|mode	id1	id2	Other	<- name
351221043	enq: SP - contention 2	name|mode	id1	id2	Other	<- name
839059449	enq: SP - contention 3	name|mode	id1	id2	Other	<- name
1340803846	enq: SP - contention 4	name|mode	id1	id2	Other	<- name
3678823943	enq: SX - contention 5	name|mode	id1	id2	Other	<- name
2086036097	enq: SX - contention 6	name|mode	id1	id2	Other	<- name
2607158008	first spare wait event	p1	p2	p3	Other	<- name
889843531	second spare wait event	p1	p2	p3	Other	<- name
237562822	Memory: Reg/Dereg	ksmsq context	address	length	Other	<- name
2795431108	IPC send completion sync	send count			Other	<- name
710749070	OSD IPC library	rolling mig			Other	<- name
3327525223	IPC wait for name service busy				Other	<- name
1961805585	IPC busy async request				Other	<- name
429189883	IPC waiting for OSD resources				Other	<- name
3586266983	ksxr poll remote instances				Other	<- name
3974056937	ksxr wait for mount shared				Other	<- name
2278252783	DBMS_LDAP: LDAP operation				Other	<- name
97018265	wait for FMON to come up				Other	<- name
1830645796	enq: FM - contention	name|mode	0	0	Other	<- name
107371275	enq: XY - contention	name|mode	id1	id2	Other	<- name
2767884586	latch: active service list	address	number	why	Other	<- name
2022747370	latch: service drain list	address	number	why	Other	<- name
1086558492	latch: last service list	address	number	why	Other	<- name
753553155	latch: java patching	address	number	why	Other	<- name
2558928434	enq: AS - service activation	name|mode	0	0	Other	<- name
626337999	JAVA patching				Other	<- name
245034220	enq: PD - contention	name|mode	property name	key hash	Other	<- name
4097944222	oracle thread bootstrap	pname			Other	<- name
2423447952	os thread creation	pname	is_process		Other	<- name
2192866519	cleanup of aborted process	location			Other	<- name
4131775738	enq: XM - contention	type|mode	id1	id2	Other	<- name
3530171172	enq: RU - contention	name|mode	0	0	Other	<- name
2020359573	enq: RU - waiting	name|mode	0	0	Other	<- name
2107633232	rolling migration: cluster quiesce	location	waits		Other	<- name
2464601005	LMON global data update				Other	<- name
202883655	rolling migration: orphans detected				Other	<- name
2682948634	process diagnostic dump				Other	<- name
1933295843	enq: MX - sync storage server info	name|mode	nodeid	instanceid	Other	<- name
1992784715	master diskmon startup				Other	<- name
2421679227	master diskmon read				Other	<- name
1624113736	DSKM to complete cell health check				Other	<- name
616694188	pmon dblkr tst event	index			Other	<- name
2329324816	latch: ksolt lwth alloc	address	number	why	Other	<- name
3025569338	lightweight thread operation	PURPOSE	ARG1	ARG2	Other	<- name
219323361	lightweight thread task completion	Tasks left	task_count	ARG3	Other	<- name
2347021890	enq: WN - rw snapshot synchronization	name|mode	pluggable database id	snapshot name	Other	<- name
1218217082	read/write snapshot completion	file object handle	snapshot scn	pluggable database id	Other	<- name
1570927321	enq: ZX - repopulation file write	name|mode	filename	block number	Other	<- name
3466817607	pmon cleanup	op			Other	<- name
937324971	pmon shutdown	type	num		Other	<- name
3765978937	GL: cross instance latch free				Other	<- name
1029869674	RMA: rlog allocate	State Object	Instance		Other	<- name
1166502110	RMA: RAC reconfig				Other	<- name
1511705394	RMA: latch	RMA Latch	Latch Val		Other	<- name
4031831034	DNFS disp IO slave cleanup	clmn pnum			Other	<- name
1440204212	enq: KA - ACL control status	name|mode	0	0	Other	<- name
1591580536	Nest operation				Other	<- name
332825436	DIAG lock acquisition	where			Other	<- name
665933121	latch: ges resource hash list	address	number	why	Other	<- name
3595075359	DFS lock handle	type|mode	id1	id2	Other	<- name
759618117	ges server process to shutdown	type			Other	<- name
3128645467	ges client process to exit				Other	<- name
2627274657	ges global resource directory to be frozen	location			Other	<- name
1761249154	ges resource directory to be unfrozen				Other	<- name
2871858069	gcs resource directory to be unfrozen				Other	<- name
2542045584	ges LMD to inherit communication channels				Other	<- name
1612310333	ges lmd sync during reconfig	location			Other	<- name
2796847522	ges wait for lmon to be ready				Other	<- name
2656205476	ges cgs registration	where			Other	<- name
1183226617	wait for master scn	waittime	startscn	ackscn	Other	<- name
1088316196	ges yield cpu in reconfig	location			Other	<- name
685206108	ges2 proc latch in rm latch get 1				Other	<- name
154184229	ges2 proc latch in rm latch get 2				Other	<- name
695825723	ges lmd/lmses to freeze in rcfg	lmd/lms id			Other	<- name
1010381418	ges lmd/lmses to unfreeze in rcfg	lmd/lms id			Other	<- name
1631772444	ges lms sync during dynamic remastering and reconfig	location	lms id		Other	<- name
818898053	ges LMON to join CGS group				Other	<- name
3008471467	ges pmon to exit				Other	<- name
2595201782	ges lmd and pmon to attach				Other	<- name
4224327511	gcs drm freeze begin				Other	<- name
3116973328	gcs retry nowait latch get	location			Other	<- name
2635889591	gcs remastering wait for read latch	flags	idx1	idx2	Other	<- name
2181430622	ges cached resource cleanup	waittime			Other	<- name
2785624238	ges generic event				Other	<- name
1962787835	ges instance reconfig name entry query	retry	inst		Other	<- name
2857777550	ges process with outstanding i/o	pid			Other	<- name
3957868722	ges user error	error			Other	<- name
2120155596	ges enter server mode				Other	<- name
350643236	gcs enter server mode				Other	<- name
4261098405	ges ipc enter server mode				Other	<- name
2038008095	gcs drm freeze in enter server mode				Other	<- name
1895771704	gcs ddet enter server mode				Other	<- name
2783453682	ges cancel				Other	<- name
26939470	ges resource cleanout during enqueue open				Other	<- name
1260212817	ges resource cleanout during enqueue open-cvt				Other	<- name
3741819151	ges master to get established for SCN op				Other	<- name
1312215341	ges LMON to get to FTDONE				Other	<- name
2863691995	ges1 LMON to wake up LMD - mrcvr				Other	<- name
1687619969	ges2 LMON to wake up LMD - mrcvr				Other	<- name
2414509731	ges2 LMON to wake up lms - mrcvr 2				Other	<- name
2242140456	ges2 LMON to wake up lms - mrcvr 3				Other	<- name
4086135771	ges inquiry response	type|mode|where	id1	id2	Other	<- name
3642965647	ges reusing os pid	pid	count		Other	<- name
505407722	ges LMON for send queues				Other	<- name
643358389	ges LMD suspend for testing event				Other	<- name
2287899877	ges performance test completion				Other	<- name
1166323227	kjbopen wait for recovery domain attach				Other	<- name
361900693	kjudomatt wait for recovery domain attach				Other	<- name
2662540004	kjudomdet wait for recovery domain detach				Other	<- name
1193769478	kjbdomalc allocate recovery domain - retry				Other	<- name
1228081120	kjbdrmcvtq lmon drm quiesce: ping completion	location	lms id		Other	<- name
164764783	ges RMS0 retry add redo log				Other	<- name
2627100592	readable standby redo apply remastering				Other	<- name
2589387632	ges DFS hang analysis phase 2 acks				Other	<- name
2986589560	ges/gcs diag dump	location			Other	<- name
3757130716	global plug and play automatic resource creation	where			Other	<- name
4188419816	gcs lmon dirtydetach step completion	domain id	location		Other	<- name
2134833657	recovery instance recovery completion				Other	<- name
3271968413	ack for a broadcasted res from a remote instance				Other	<- name
2595497065	kill all read-only instances in cluster				Other	<- name
3664355268	latch: kjci process context latch	address	number	why	Other	<- name
3993261106	latch: kjci request sequence latch	address	number	why	Other	<- name
2765459430	DLM cross inst call completion	caller instance number	cluster incarnation number	request identifier	Other	<- name
3534674430	DLM: shared instance mode init				Other	<- name
1656318846	enq: KI - contention	name|mode	client opcode	0	Other	<- name
3296595079	latch: kjoeq omni enqueue hash bucket latch	address	number	why	Other	<- name
3892456182	DLM enqueue copy completion	Owner ID	op|restype	id1|id2	Other	<- name
1575324855	latch: kjoer owner hash bucket	address	number	why	Other	<- name
1793459373	DLM Omni Enq Owner replication	Owner ID			Other	<- name
4079369678	KJC: Wait for msg sends to complete	msg	dest|rcvr	mtype	Other	<- name
1801723349	ges message buffer allocation	pool	request	allocated	Other	<- name
3613653811	kjctssqmg: quick message send wait				Other	<- name
3368851413	gcs domain validation	cluinc	rcvinc		Other	<- name
142175773	latch: gcs resource hash	address	number	why	Other	<- name
2848189392	affinity expansion in replay				Other	<- name
2470511309	wait for sync ack	cluinc	pending_nd		Other	<- name
189592347	wait for verification ack	cluinc	pending_insts		Other	<- name
3428259705	wait for assert messages to be sent				Other	<- name
3937428465	wait for scn ack	pending_nd	scn		Other	<- name
3928537616	lms flush message acks	id			Other	<- name
3954828229	name-service call wait	waittime	op	loc	Other	<- name
1736567536	CGS wait for IPC msg				Other	<- name
2321793642	IMR hang simulation				Other	<- name
4139178294	IMR mount phase II completion				Other	<- name
1175435584	IMR disk votes				Other	<- name
3706379258	IMR rr lock release				Other	<- name
872961962	IMR net-check message ack				Other	<- name
1055131010	IMR rr update				Other	<- name
1123581371	IMR membership resolution				Other	<- name
4003053530	IMR CSS join retry	retry count			Other	<- name
2448812170	IMR slave process init				Other	<- name
2268235780	IMR slave process shutdown	location			Other	<- name
269767187	IMR slave acknowledgement msg				Other	<- name
2151285256	CGS skgxn join retry	retry count			Other	<- name
4241215981	CGS ping operation	location			Other	<- name
1965140390	gcs to be enabled				Other	<- name
3480025058	gcs log flush sync	waittime	poll	event	Other	<- name
2222314230	KA: shared KGA not initialized				Other	<- name
2373399366	enq: PP - contention	type|mode	id1	id2	Other	<- name
2288038353	enq: HM - contention	type|mode	id1	id2	Other	<- name
2948850473	GCR ctx lock acquisition	retry count			Other	<- name
3428914697	GCR CSS group lock				Other	<- name
1308860334	GCR CSS group join	retry count			Other	<- name
3139209677	GCR CSS group leave				Other	<- name
2548959420	GCR CSS group update				Other	<- name
2771226010	GCR CSS group query				Other	<- name
3856692583	enq: AC - acquiring partition id	name|mode	0	0	Other	<- name
894671924	LMA glob lock acquisition	lock	retry count		Other	<- name
3165031328	LMA KGA glob lock acquisition	lock	retry count		Other	<- name
3418985179	latch: GCS logfile block	address	number	why	Other	<- name
812661408	latch: GCS logfile write queue	address	number	why	Other	<- name
2411650447	LMFC reconfig operation	RCFG State	Operation		Other	<- name
3006093898	PCFC: recovery domain valid				Other	<- name
3493282803	SGA: allocation forcing component growth				Other	<- name
3659501038	SGA: sga_target resize				Other	<- name
1230198893	enq: SC - contention	type|mode	id1	id2	Other	<- name
40893507	control file heartbeat				Other	<- name
3061031534	control file diagnostic dump	type	param		Other	<- name
1494394835	enq: CF - contention	name|mode	0	operation	Other	<- name
608373385	enq: SW - contention	name|mode	0	0	Other	<- name
1608438935	enq: DS - contention	name|mode	0	0	Other	<- name
1231322525	enq: TC - contention	name|mode	checkpoint ID	0	Other	<- name
718572278	enq: TC - contention2	name|mode	checkpoint ID	0	Other	<- name
2332720660	buffer exterminate	file#	block#	buf_ptr	Other	<- name
4243513970	kcbw: cache protect wait				Other	<- name
3401628503	latch: cache buffers lru chain	address	number	why	Other	<- name
1340848367	enq: PW - perwarm status in dbw0	name|mode	0	0	Other	<- name
22066106	latch: checkpoint queue latch	address	number	why	Other	<- name
2935866945	latch: cache buffer handles	address	number	why	Other	<- name
3476701947	kcbzps				Other	<- name
912137450	DBWR range invalidation sync	dbwr#			Other	<- name
218992928	buffer deadlock	dba	class*10+mode	flag	Other	<- name
1948834383	buffer latch	latch addr	chain#		Other	<- name
3807851191	cr request retry	file#	block#		Other	<- name
271673613	influx scn	file#	block#	class#	Other	<- name
479497384	writes stopped by instance recovery or database suspension	by thread#	our thread#		Other	<- name
2545148957	lock escalate retry				Other	<- name
3412713426	lock deadlock retry				Other	<- name
1315338218	prefetch warmup block being transferred	file#	block#	id#	Other	<- name
105891848	recovery buffer pinned	file#	block#		Other	<- name
1250260140	tablespace key change	pdb#	ts#	file#	Other	<- name
1531409241	TSE SSO wallet reopen				Other	<- name
3874022972	force-cr-override flush	file#	block#		Other	<- name
2576559565	enq: CR - block range reuse ckpt	name|mode	2	0	Other	<- name
2622395338	enq: TR - serialize TS rekeys	name|mode	pdbid	ts#	Other	<- name
666989299	enq: TR - database key open check	name|mode	pdbid	ts#	Other	<- name
577169102	enq: TR - serialize system rekeys	name|mode	pdbid	ts#	Other	<- name
1898285196	wait for MTTR advisory state object				Other	<- name
295718413	latch: object queue header operation	address	number	why	Other	<- name
4273032105	enq: BU - recovery set construct	name|mode	0	0	Other	<- name
591247898	enq: BU - recovery set takeover	name|mode	0	0	Other	<- name
3102461226	retry CFTXN during close				Other	<- name
1383326310	get branch/thread/sequence enqueue				Other	<- name
2704451831	enq: WL - Test access/locking	name|mode	log # / thread id #	sequence #	Other	<- name
841803369	Data Guard server operation completion				Other	<- name
529335332	FAL archive wait 1 sec for REOPEN minimum				Other	<- name
4036275899	TEST: action sync				Other	<- name
205495275	TEST: action hang				Other	<- name
3845085937	RSGA: RAC reconfiguration				Other	<- name
1128412462	enq: WL - RAC-wide SGA initialize	name|mode	log # / thread id #	sequence #	Other	<- name
3068515786	enq: WL - RAC-wide SGA write	name|mode	log # / thread id #	sequence #	Other	<- name
3376312326	enq: WL - RAC-wide SGA dump	name|mode	log # / thread id #	sequence #	Other	<- name
2123819464	MRP stop				Other	<- name
4125956551	enq: SA - standby redo logfiles	name|mode	0	0	Other	<- name
1423505461	enq: WS - contention	type|mode	id1	id2	Other	<- name
4257177215	MRP wait on process start				Other	<- name
4223476495	MRP wait on process restart				Other	<- name
2370040255	MRP wait on startup clear				Other	<- name
56334152	MRP inactivation				Other	<- name
916189195	MRP wait on archivelog arrival				Other	<- name
649270296	MRP wait on archivelog archival				Other	<- name
2490803321	enq: WL - Far Sync Fail Over	name|mode	log # / thread id #	sequence #	Other	<- name
3285081853	enq: SA - MRP SRL access	name|mode	0	0	Other	<- name
3394915937	Monitor testing				Other	<- name
274926311	enq: WL - redo_db table update	name|mode	log # / thread id #	sequence #	Other	<- name
952807416	enq: WL - redo_log table update	name|mode	log # / thread id #	sequence #	Other	<- name
1722088478	log switch/archive	thread#			Other	<- name
3409933913	enq: WL - Switchover To Primary	name|mode	log # / thread id #	sequence #	Other	<- name
805821516	ARCH wait on c/f tx acquire 1				Other	<- name
3771596012	RFS attach				Other	<- name
4172664383	RFS create				Other	<- name
2508684169	RFS close				Other	<- name
1498277161	RFS announce				Other	<- name
2909083597	RFS register				Other	<- name
1120829189	RFS detach				Other	<- name
571751314	RFS ping				Other	<- name
881117162	RFS dispatch				Other	<- name
784686743	enq: WL - RFS global state contention	name|mode	log # / thread id #	sequence #	Other	<- name
219245212	enq: WL - SNA access/locking	name|mode	log # / thread id #	sequence #	Other	<- name
984914326	LGWR simulation latency wait				Other	<- name
781082802	LNS simulation latency wait				Other	<- name
668166272	ASYNC Remote Write				Other	<- name
3339190814	SYNC Remote Write				Other	<- name
2147654677	ARCH Remote Write				Other	<- name
2528235682	Redo Transport Attach				Other	<- name
33151350	Redo Transport Detach				Other	<- name
3470397773	Redo Transport Open				Other	<- name
1539866381	Redo Transport Close				Other	<- name
2666458816	Redo Transport Ping				Other	<- name
1319950766	Remote SYNC Ping				Other	<- name
3032907492	Redo Transport Slave Startup				Other	<- name
188013640	Redo Transport Slave Shutdown				Other	<- name
3656641042	Redo Writer Remote Sync Notify				Other	<- name
3213124895	Redo Writer Remote Sync Complete				Other	<- name
3944789232	Redo Transport MISC				Other	<- name
566288919	Redo Transport Network Throttle				Other	<- name
649262647	enq: WL - Network Throttle	name|mode	log # / thread id #	sequence #	Other	<- name
3098550178	LGWR-LNS wait on channel				Other	<- name
1211302889	enq: WR - contention	name|mode	thread id #	sequence #	Other	<- name
2617915495	Data Guard: rtrt work				Other	<- name
3291268781	Redo transport testing				Other	<- name
3601986267	enq: RZ - add element	name|mode	0	0	Other	<- name
1802258776	enq: RZ - remove element	name|mode	0	0	Other	<- name
3839860880	Image redo gen delay				Other	redo resource management
3451340452	Long operation CF pause				Other	CF txn pause
4266849434	LGWR wait for redo copy	copy latch #			Other	<- name
266850936	latch: redo allocation	address	number	why	Other	<- name
1561425187	log file switch (clearing log file)				Other	<- name
4160645236	log file sync: PDB shutdown abort	sync scn			Other	<- name
2397844549	target log write size				Other	<- name
1793502753	LGWR any worker group				Other	<- name
1249397642	LGWR all worker groups				Other	<- name
3116432628	LGWR worker group ordering	lwn_id	phase		Other	<- name
771590720	LGWR intra group sync	where	groupid	slaveid	Other	<- name
269666300	LGWR intra group IO completion	where	groupid	slaveid	Other	<- name
1555037586	enq: WL - contention	name|mode	log # / thread id #	sequence #	Other	<- name
1281359820	enq: RN - contention	name|mode	thread number	log number	Other	<- name
1242352358	DFS db file lock	file#			Other	quiesce for datafile offline
665338553	PDB close/open on another instance				Other	<- name
80051109	database open on read-write instance				Other	<- name
217146514	enq: DF - contention	name|mode	0	file #	Other	<- name
1184948750	enq: IS - contention	name|mode	0 or pdbid	type	Other	<- name
1317384776	enq: IP - open/close PDB	name|mode	type	pdbuid	Other	<- name
3839871930	enq: PX - PDB instance recovery	name|mode	0 or thread#	type	Other	<- name
1309055815	enq: FS - contention	name|mode	0 or pdbid	type	Other	<- name
2183635389	enq: FS - online log operation	name|mode	0 or pdbid	type	Other	<- name
3294817508	enq: DM - contention	name|mode	type	type	Other	<- name
178034865	enq: DM - access control	name|mode	type	type	Other	<- name
647852263	enq: RP - contention	name|mode	file #	1 or block	Other	<- name
1925256273	latch: gc element	address	number	why	Other	<- name
4193134291	redo log switch request completion				Other	<- name
1143317824	enq: RT - contention	name|mode	redo thread	type	Other	<- name
2588100800	enq: RT - thread internal enable/disable	name|mode	redo thread	type	Other	<- name
4021392840	enq: IR - contention	name|mode	0	0/1	Other	<- name
3041521765	enq: IR - contention2	name|mode	0	0/1	Other	<- name
457958410	enq: IR - global serialization	name|mode	0	0/1	Other	<- name
3639275442	enq: IR - local serialization	name|mode	0	0/1	Other	<- name
1926932789	enq: IR - arbitrate instance recovery	name|mode	0	0/1	Other	<- name
3113891348	enq: MR - contention	name|mode	0 or file #	type	Other	<- name
3480024039	enq: MR - standby role transition	name|mode	0 or file #	type	Other	<- name
2989355594	enq: MR - multi instance redo apply	name|mode	0 or file #	type	Other	<- name
901508430	enq: MR - any role transition	name|mode	0 or file #	type	Other	<- name
2835520952	enq: MR - PDB open	name|mode	0 or file #	type	Other	<- name
2431157470	enq: MR - datafile online	name|mode	0 or file #	type	Other	<- name
2195955142	enq: MR - adg instance recovery	name|mode	0 or file #	type	Other	<- name
2266304296	enq: MR - preplugin recovery	name|mode	0 or file #	type	Other	<- name
1315198629	enq: MR - datafile pre-create	name|mode	0 or file #	type	Other	<- name
1819372799	shutdown after switchover to standby				Other	<- name
855778212	cancel media recovery on switchover				Other	<- name
2172988940	PDB lock domain invalidation				Other	<- name
2289478848	Recovery: scn growth limit				Other	<- name
2938939381	parallel recovery coord wait for reply				Other	<- name
201710181	parallel recovery coord send blocked				Other	<- name
4008505077	parallel recovery slave wait for change				Other	<- name
3954034543	enq: BR - file shrink	name|mode	operation	file #	Other	<- name
1796838767	enq: BR - proxy-copy	name|mode	operation	file #	Other	<- name
1785130586	enq: BR - multi-section restore header	name|mode	operation	file #	Other	<- name
1429048489	enq: BR - multi-section restore section	name|mode	operation	file #	Other	<- name
3146685455	enq: BR - space info datafile hdr update	name|mode	operation	file #	Other	<- name
4186138071	enq: BR - request autobackup	name|mode	operation	file #	Other	<- name
120917685	enq: BR - perform autobackup	name|mode	operation	file #	Other	<- name
1408460348	enq: BR - perform catalog recovery area	name|mode	operation	file #	Other	<- name
4055016213	enq: ID - contention	name|mode	0	0	Other	<- name
1895301661	Backup Restore Throttle sleep	session_id	serial		Other	<- name
3940042335	Backup Restore Switch Bitmap sleep	session_id	serial		Other	<- name
1158580207	Backup Restore Event sleep	session_id	serial		Other	<- name
2696003729	RMAN wallet access limit				Other	<- name
4254153540	enq: BS - Backup spare1	name|mode	id1	id2	Other	<- name
3572922547	enq: BS - Backup spare2	name|mode	id1	id2	Other	<- name
1519110690	enq: BS - Backup spare3	name|mode	id1	id2	Other	<- name
918511175	enq: BS - Backup spare4	name|mode	id1	id2	Other	<- name
119366042	enq: BS - Backup spare5	name|mode	id1	id2	Other	<- name
4127095906	enq: BS - Backup spare6	name|mode	id1	id2	Other	<- name
890108316	enq: BS - Backup spare7	name|mode	id1	id2	Other	<- name
4010237913	enq: BS - Backup spare8	name|mode	id1	id2	Other	<- name
512631582	enq: BS - Backup spare9	name|mode	id1	id2	Other	<- name
2567538002	enq: BS - Backup spare0	name|mode	id1	id2	Other	<- name
513503674	enq: AB - ABMR process start/stop	name|mode	operation	operation parm	Other	<- name
4289089804	enq: AB - ABMR process initialized	name|mode	operation	operation parm	Other	<- name
1348089685	Auto BMR completion	file#	block#		Other	<- name
3217997244	Auto BMR RPC standby catchup	wrap	base		Other	<- name
1423698111	enq: ZR - ZDLRA lock db	name|mode	operation	id	Other	<- name
2394356444	enq: ZR - ZDLRA lock storage loc	name|mode	operation	id	Other	<- name
165935761	enq: ZR - ZDLRA lock timer queue	name|mode	operation	id	Other	<- name
1636438482	enq: ZR - ZDLRA lock scheduler	name|mode	operation	id	Other	<- name
1002738712	enq: ZR - ZDLRA lock API	name|mode	operation	id	Other	<- name
2470140807	enq: ZR - ZDLRA quiesce tasks	name|mode	operation	id	Other	<- name
1254781511	enq: ZR - ZDLRA check quiesce tasks	name|mode	operation	id	Other	<- name
2590051530	enq: ZR - ZDLRA quiesce servlets	name|mode	operation	id	Other	<- name
4080162904	enq: ZR - ZDLRA check servlet quiescence	name|mode	operation	id	Other	<- name
2124551921	enq: ZR - ZDLRA serialize unregister db	name|mode	operation	id	Other	<- name
466463911	enq: ZR - ZDLRA run scheduler	name|mode	operation	id	Other	<- name
1183844682	enq: ZR - ZDLRA purge storage loc	name|mode	operation	id	Other	<- name
618668824	enq: ZR - ZDLRA spare enq 10	name|mode	operation	id	Other	<- name
204987005	enq: ZR - ZDLRA invalidate plans	name|mode	operation	id	Other	<- name
680840689	enq: ZR - ZDLRA protect plans	name|mode	operation	id	Other	<- name
4290115138	enq: BC - drop container group	name|mode	container group	container id	Other	<- name
995732317	enq: BC - create container	name|mode	container group	container id	Other	<- name
1176032305	enq: BC - group - create container	name|mode	container group	container id	Other	<- name
3553233538	enq: BC - drop container	name|mode	container group	container id	Other	<- name
1267579589	enq: BC - group - create file	name|mode	container group	container id	Other	<- name
623108742	enq: BI - create file	name|mode	group ID / file ID	file ID	Other	<- name
84640895	enq: BI - identify file	name|mode	group ID / file ID	file ID	Other	<- name
2652244696	enq: BI - delete file	name|mode	group ID / file ID	file ID	Other	<- name
2214479234	enq: BZ - resize file	name|mode	group ID / file ID	file ID	Other	<- name
990760803	enq: BV - rebuild/validate group	name|mode	amrv$ key		Other	<- name
1532804659	Backup Appliance container synchronous read	block#	blocks		Other	<- name
3349653204	Backup Appliance container synchronous write	block#	blocks		Other	<- name
2488361479	Backup Appliance container I/O	requests			Other	<- name
823842457	Supplemental logging roles	role id			Other	<- name
2347406356	LogMiner builder: queue full	Session ID			Other	<- name
3592915900	LogMiner reader: redo slot	Session ID	Thread		Other	<- name
1126267022	LogMiner reader: memory	Session ID			Other	<- name
2344841594	LogMiner merger: redo slot	Session ID			Other	<- name
1937230003	LogMiner: txn	Session ID	Lock	State	Other	<- name
146026836	LogMiner: queue	Session ID	Lock	State	Other	<- name
2806308254	LogMiner: session audit list	Session ID	Lock	State	Other	<- name
1047024350	LogMiner FSC: dictionary load completion	Session ID			Other	<- name
1489162918	enq: MN - contention	name|mode	session ID	0	Other	<- name
2417659362	enq: ZL - LogMiner foreign log metadata	name|mode	session ID	0	Other	<- name
622794581	enq: PL - contention	name|mode	0	0	Other	<- name
1930628560	enq: CP - Pluggable database resetlogs	name|mode	Internal	Internal	Other	<- name
260587712	enq: SB - logical standby metadata	name|mode	0	0	Other	<- name
2514944057	enq: SB - table instantiation	name|mode	0	0	Other	<- name
2366696931	Logical Standby Apply shutdown				Other	<- name
2276822405	Logical Standby pin transaction	xidusn	xidslt	xidsqn	Other	<- name
1748443679	Logical Standby dictionary build				Other	<- name
3415281788	Logical Standby Terminal Apply	stage			Other	<- name
993838451	Logical Standby Debug	event			Other	<- name
1061728450	Resolution of in-doubt txns	SCN			Other	<- name
707813539	enq: XR - quiesce database	name|mode	operation	0	Other	<- name
3609173507	enq: XR - database force logging	name|mode	operation	0	Other	<- name
529913931	ADG query scn advance				Other	<- name
4238679773	ADG instance recovery complete				Other	<- name
907871122	latch: obj/range reuse redo processing	address	number	why	Other	<- name
4185983479	standby query scn advance				Other	<- name
1445223374	change tracking file synchronous read	block#	blocks		Other	<- name
424098511	change tracking file synchronous write	block#	blocks		Other	<- name
30036540	change tracking file parallel write	blocks	requests		Other	<- name
513392991	block change tracking buffer space				Other	<- name
4217808978	CTWR media recovery checkpoint request				Other	<- name
1487467637	enq: CT - global space management	name|mode	operation	operation parm	Other	<- name
3466352936	enq: CT - local space management	name|mode	operation	operation parm	Other	<- name
690018733	enq: CT - change stream ownership	name|mode	operation	operation parm	Other	<- name
2979034732	enq: CT - state	name|mode	operation	operation parm	Other	<- name
790405879	enq: CT - state change gate 1	name|mode	operation	operation parm	Other	<- name
2477507895	enq: CT - state change gate 2	name|mode	operation	operation parm	Other	<- name
3488556206	enq: CT - CTWR process start/stop	name|mode	operation	operation parm	Other	<- name
513540187	enq: CT - reading	name|mode	operation	operation parm	Other	<- name
3598948525	recovery area: computing dropped files				Other	<- name
4063976546	recovery area: computing obsolete files				Other	<- name
1877105024	recovery area: computing backed up files				Other	<- name
2825667152	recovery area: computing applied logs				Other	<- name
2897929244	enq: RS - file delete	name|mode	record type	record id	Other	<- name
313351369	enq: RS - record reuse	name|mode	record type	record id	Other	<- name
3504071695	enq: RS - prevent file delete	name|mode	record type	record id	Other	<- name
3170569251	enq: RS - prevent aging list update	name|mode	record type	record id	Other	<- name
3178040924	enq: RS - persist alert level	name|mode	record type	record id	Other	<- name
115643876	enq: RS - read alert level	name|mode	record type	record id	Other	<- name
3488540422	enq: RS - write alert level	name|mode	record type	record id	Other	<- name
3383573524	enq: FL - Flashback database log	name|mode	Log #	zero	Other	<- name
511900941	enq: FL - Flashback db command	name|mode	Log #	zero	Other	<- name
1057119651	enq: FD - Marker generation	name|mode	Internal	Internal	Other	<- name
120716488	enq: FD - Tablespace flashback on/off	name|mode	Internal	Internal	Other	<- name
3377895670	enq: FD - Flashback coordinator	name|mode	Internal	Internal	Other	<- name
1783985711	enq: FD - Flashback on/off	name|mode	Internal	Internal	Other	<- name
795831746	enq: FD - Restore point create/drop	name|mode	Internal	Internal	Other	<- name
2085703061	enq: FD - Flashback logical operations	name|mode	Internal	Internal	Other	<- name
1729254775	flashback free VI log				Other	<- name
3594374201	flashback log switch				Other	<- name
626068540	enq: FW - contention	type|mode	id1	id2	Other	<- name
799112511	RVWR wait for flashback copy	copy latch #			Other	<- name
3601079116	parallel recovery read buffer free				Other	<- name
3312658627	parallel recovery redo cache buffer free				Other	<- name
4215254072	parallel recovery change buffer free				Other	<- name
2620531563	parallel recovery push change				Other	<- name
3995823356	cell smart flash keep	cellhash#			Other	<- name
4081701776	cell smart flash unkeep	cellhash#			Other	<- name
2051476866	cell ram cache population	cellhash#			Other	<- name
3015991344	parallel recovery coord: all replies				Other	<- name
930916630	datafile move cleanup during resize				Other	online move datafile resize cleanup
1699923767	Nologging Standby Unit Test				Other	<- name
3599750200	Nonlogged block fetch	Absolute file	Start block	RCVID or Request	Other	<- name
3747686915	recovery receive buffer free				Other	<- name
261947819	recovery cancel				Other	<- name
689601736	recovery remote file verification				Other	<- name
3798980926	recovery active instance mapping setup				Other	<- name
25545516	recovery new thread enable				Other	<- name
3479514684	recovery file header update for checkpoint				Other	<- name
1591128517	recovery file header update for fuzziness				Other	<- name
376996958	recovery coordinator apply pending				Other	<- name
2158353269	recovery coordinator marker apply				Other	<- name
3702772090	recovery coordinator message				Other	<- name
60575812	recovery merge pending				Other	<- name
3948720099	recovery metadata latch				Other	<- name
4257452445	recovery checkpoint				Other	<- name
1877449207	recovery apply pending				Other	<- name
519712656	recovery fuzzy update				Other	<- name
1797919480	recovery shutdown				Other	<- name
321437621	recovery message				Other	<- name
2011314812	recovery slaves to be informed				Other	<- name
3371685550	recovery move influx buffers				Other	<- name
2421198487	recovery marker apply				Other	<- name
4023429149	recovery timestamp				Other	<- name
3178497879	recovery send buffer free				Other	<- name
4093658961	DBMS_ROLLING instruction completion	Instruction id			Other	<- name
3030855852	Shadow lost write				Other	<- name
2177880604	blocking txn id for DDL	table	scn	only dml	Other	<- name
2153157043	transaction	undo seg#|slot#	wrap#	count	Other	<- name
403545727	inactive transaction branch	branch#	waited		Other	<- name
957725912	txn to complete				Other	<- name
2264655921	PMON to cleanup pseudo-branches at svc stop time				Other	<- name
2206434397	PMON to cleanup detached branches at shutdown				Other	<- name
2091246363	test long ops				Other	<- name
2221529869	latch: undo global data	address	number	why	Other	<- name
1467219297	undo segment recovery	segment#	tx flags		Other	<- name
4224098334	unbound tx				Other	<- name
865316074	wait for change				Other	<- name
1657000051	wait for another txn - undo rcv abort				Other	<- name
1886837281	wait for another txn - txn abort				Other	<- name
2537911001	wait for another txn - rollback to savepoint				Other	<- name
313295972	undo_retention publish retry	where	retry_count		Other	<- name
2742799282	txn cache read version				Other	<- name
2605232529	enq: TA - contention	name|mode	operation	undo segment # / other	Other	<- name
1629782133	enq: TX - contention	name|mode	usn<<16 | slot	sequence	Other	<- name
2458904239	enq: US - contention	name|mode	undo segment #	0	Other	<- name
3065535233	wait for stopper event to be increased				Other	<- name
3020078888	wait for a undo record				Other	<- name
289494273	wait for a paralle reco to abort				Other	<- name
2301151944	enq: IM - contention for blr	name|mode	pool #	0	Other	<- name
1752153790	enq: TD - KTF dump entries	name|mode	0	0	Other	<- name
4241032297	enq: TE - KTF broadcast	name|mode	0	0	Other	<- name
706934628	enq: CN - race with txn	name|mode	reg id	0	Other	<- name
4060759714	enq: CN - race with reg	name|mode	reg id	0	Other	<- name
613420004	enq: CN - race with init	name|mode	reg id	0	Other	<- name
2549235236	latch: Change Notification Hash table latch	address	number	why	Other	<- name
606473003	enq: CO - master slave det	name|mode	inst id	0	Other	<- name
3932945957	enq: FE - contention	name|mode	0	0	Other	<- name
2487720797	latch: change notification client cache latch	address	number	why	Other	<- name
3805228026	latch: SGA Logging Log Latch	address	number	why	Other	<- name
3039512838	latch: SGA Logging Bkt Latch	address	number	why	Other	<- name
305609008	enq: MC - Securefile log	name|mode	0	hash(logname)	Other	<- name
1813165094	enq: MF - flush bkgnd periodic	name|mode	logid	bktId<<16|instid	Other	<- name
2216368433	enq: MF - creating swap in instance	name|mode	logid	bktId<<16|instid	Other	<- name
4015649387	enq: MF - flush space	name|mode	logid	bktId<<16|instid	Other	<- name
1168962483	enq: MF - flush client	name|mode	logid	bktId<<16|instid	Other	<- name
322730247	enq: MF - flush prior error	name|mode	logid	bktId<<16|instid	Other	<- name
3312041081	enq: MF - flush destroy	name|mode	logid	bktId<<16|instid	Other	<- name
3248177810	latch: ILM activity tracking latch	address	number	why	Other	<- name
3307999956	latch: ILM access tracking extent	address	number	why	Other	<- name
3751718539	IM CU busy				Other	<- name
1224810073	enq: ZQ - register	name|mode	ts#	dba	Other	<- name
139032432	enq: ZQ - quiesce	name|mode	ts#	dba	Other	<- name
3524622153	IM ADG space pressure	bucket#|slave#	retry#	count	Other	<- name
896842959	enq: TF - contention	name|mode	PDB ID & tablespace #	relative file #	Other	<- name
310348786	latch: lob segment hash table latch	address	number	why	Other	<- name
2868244995	latch: lob segment query latch	address	number	why	Other	<- name
361584826	latch: lob segment dispenser latch	address	number	why	Other	<- name
2934069603	Wait for shrink lock2	object_id	lock_mode		Other	<- name
3943836588	Wait for shrink lock	object_id	lock_mode		Other	<- name
1330927475	L1 validation	seghdr	l1bmb		Other	<- name
628015238	Wait for TT enqueue	tsn			Other	<- name
3075113618	kttm2d				Other	<- name
1972012953	ktsambl				Other	<- name
2560588841	ktfbtgex	tsn			Other	<- name
319052581	enq: DT - contention	name|mode	0	0	Other	<- name
2667616873	enq: TS - contention	name|mode	tablespace ID	dba	Other	<- name
1238611814	enq: FB - contention	name|mode	tablespace #	dba	Other	<- name
2678203686	enq: SK - contention	name|mode	tablespace #	dba	Other	<- name
2910919470	enq: DW - contention	name|mode	tablespace #	dba	Other	<- name
3652428359	enq: SU - contention	name|mode	table space #	0	Other	<- name
4205956891	enq: TT - contention	name|mode	tablespace ID	operation	Other	<- name
3226067315	ktm: instance recovery	undo segment#			Other	<- name
1525267497	instance state change	layer	value	waited	Other	<- name
1335721068	enq: SM - contention	type|mode	id1	id2	Other	<- name
887351382	enq: SJ - Slave Task Cancel	name|mode	Slave process id	task id	Other	<- name
2705466509	Space Manager: slave messages				Other	<- name
3728789504	enq: FH - contention	name|mode	Instance ID		Other	<- name
4294793344	latch: IM area scb latch	address	number	why	Other	<- name
1911429171	latch: IM area sb latch	address	number	why	Other	<- name
404240180	enq: TZ - contention	name|mode	tablespace #	dba	Other	<- name
3618490056	enq: IN - contention	name|mode	tablespace #	dba	Other	<- name
1409544283	enq: ZB - contention	name|mode	tablespace #	dba	Other	<- name
974506341	latch: IM seg hdr latch	address	number	why	Other	<- name
483380562	latch: IM emb latch	address	number	why	Other	<- name
4152697039	Analyze hash compare				Other	<- name
67546339	index block split	rootdba	level	childdba	Other	<- name
1147524433	internal test event (index split branch)				Other	<- name
2057953336	internal test event (index split leaf)				Other	<- name
2099272158	kdblil wait before retrying ORA-54				Other	<- name
3753064287	dupl. cluster key	dba			Other	<- name
3554823254	internal test event (index merge)				Other	<- name
1349347951	enq: DL - contention	name|mode	object #	0	Other	<- name
403868930	enq: HQ - contention	name|mode	object #	hash value	Other	<- name
893937616	enq: HP - contention	name|mode	tablespace #	dba	Other	<- name
3874544423	Securefile Write Gather Cache Yield Process				Other	<- name
1065985958	enq: KL - contention	type|mode	id1	id2	Other	<- name
3445676385	enq: WG - delete fso	name|mode	kdlw lobid first half	kdlw lobid sec half	Other	<- name
3380482012	enq: SL - get lock	name|mode	kdlw lobid first half	kdlw lobid sec half	Other	<- name
1973889364	enq: SL - escalate lock	name|mode	kdlw lobid first half	kdlw lobid sec half	Other	<- name
3555038872	enq: SL - get lock for undo	name|mode	kdlw lobid first half	kdlw lobid sec half	Other	<- name
2630448508	enq: ZH - compression analysis	name|mode	obj#	ulevel	Other	<- name
2929689230	Compression analysis				Other	<- name
608160643	enq: SZ - contention	name|mode	tablespace #	rdba	Other	<- name
2990561203	enq: ZC - FS Seg contention	name|mode	tsn#	objd#	Other	<- name
2876222906	enq: ZD - FS CU mod	name|mode	segid	startdba	Other	<- name
987611292	enq: SY - IM populate by other session	name|mode	tablespace # & objd	rdba	Other	<- name
2350325668	enq: JZ - Join group dictionary	name|mode	0	0	Other	<- name
2513432000	IM populate completion				Other	<- name
3843389040	IMXT Populate - drop HT				Other	<- name
1035049954	IM FastStart deadlock retry				Other	<- name
1300659046	IM ADO scheduler retry				Other	<- name
3484624144	latch: IMFS defer write list	address	number	why	Other	<- name
882830310	IMFS Flush defer writes				Other	<- name
390916909	In-Memory populate: over pga limit	process number	serial number		Other	<- name
2984698957	latch: Column stats entry latch	address	number	why	Other	<- name
2322167609	row cache cleanup				Other	<- name
1263391620	row cache process	location			Other	<- name
108267531	enq: QA - contention	type|mode	id1	id2	Other	<- name
1139092931	enq: QB - contention	type|mode	id1	id2	Other	<- name
1907863590	enq: QC - contention	type|mode	id1	id2	Other	<- name
3962851118	enq: QD - contention	type|mode	id1	id2	Other	<- name
774455082	enq: QE - contention	type|mode	id1	id2	Other	<- name
2436256250	enq: QF - contention	type|mode	id1	id2	Other	<- name
1347029671	enq: QG - contention	type|mode	id1	id2	Other	<- name
1414776114	enq: QH - contention	type|mode	id1	id2	Other	<- name
1851813854	enq: QI - contention	type|mode	id1	id2	Other	<- name
4087131843	enq: QJ - contention	type|mode	id1	id2	Other	<- name
1542600248	enq: QK - contention	type|mode	id1	id2	Other	<- name
2159175404	enq: QL - contention	type|mode	id1	id2	Other	<- name
1480629321	enq: QM - contention	type|mode	id1	id2	Other	<- name
988442240	enq: QN - contention	type|mode	id1	id2	Other	<- name
1348672103	enq: QO - contention	type|mode	id1	id2	Other	<- name
4077590343	enq: QP - contention	type|mode	id1	id2	Other	<- name
871478667	enq: QQ - contention	type|mode	id1	id2	Other	<- name
188776046	enq: QR - contention	type|mode	id1	id2	Other	<- name
3543257946	enq: QS - contention	type|mode	id1	id2	Other	<- name
2183806234	enq: QT - contention	type|mode	id1	id2	Other	<- name
331767289	enq: QU - contention	type|mode	id1	id2	Other	<- name
251336424	enq: QV - contention	type|mode	id1	id2	Other	<- name
348872490	enq: QX - contention	type|mode	id1	id2	Other	<- name
2109119095	enq: QY - contention	type|mode	id1	id2	Other	<- name
1939400123	enq: QZ - contention	type|mode	id1	id2	Other	<- name
2210508267	enq: DV - contention	name|mode	object #	0	Other	<- name
2584404246	enq: SO - contention	name|mode	object #	0	Other	<- name
2513782899	RAC: row cache lock nowait retry	stub handle	attempt count		Other	<- name
4136932854	enq: VA - contention	type|mode	id1	id2	Other	<- name
143723934	enq: VB - contention	type|mode	id1	id2	Other	<- name
1494426468	enq: VC - contention	type|mode	id1	id2	Other	<- name
948192883	enq: VD - contention	type|mode	id1	id2	Other	<- name
2478141767	enq: VE - contention	type|mode	id1	id2	Other	<- name
1821295450	enq: VF - contention	type|mode	id1	id2	Other	<- name
3151153518	enq: VG - contention	type|mode	id1	id2	Other	<- name
2667965274	enq: VH - contention	type|mode	id1	id2	Other	<- name
2073979996	enq: VI - contention	type|mode	id1	id2	Other	<- name
3548033582	enq: VJ - contention	type|mode	id1	id2	Other	<- name
3854837673	enq: VK - contention	type|mode	id1	id2	Other	<- name
1719975306	enq: VL - contention	type|mode	id1	id2	Other	<- name
2388580865	enq: VM - contention	type|mode	id1	id2	Other	<- name
421100281	enq: VN - contention	type|mode	id1	id2	Other	<- name
3088969444	enq: VO - contention	type|mode	id1	id2	Other	<- name
2517810683	enq: VP - contention	type|mode	id1	id2	Other	<- name
3292945243	enq: VQ - contention	type|mode	id1	id2	Other	<- name
2799228463	enq: VR - contention	type|mode	id1	id2	Other	<- name
1184138424	enq: VS - contention	type|mode	id1	id2	Other	<- name
3090276998	enq: VT - contention	type|mode	id1	id2	Other	<- name
2565788971	enq: VU - contention	type|mode	id1	id2	Other	<- name
4143858120	enq: VV - contention	type|mode	id1	id2	Other	<- name
296128251	enq: VX - contention	type|mode	id1	id2	Other	<- name
4244679353	enq: VY - contention	type|mode	id1	id2	Other	<- name
487077473	enq: VZ - contention	type|mode	id1	id2	Other	<- name
6973873	enq: EA - contention	type|mode	id1	id2	Other	<- name
1795491474	enq: EB - contention	type|mode	id1	id2	Other	<- name
4060429599	enq: EC - contention	type|mode	id1	id2	Other	<- name
1617660300	enq: ED - contention	type|mode	id1	id2	Other	<- name
1236794935	enq: EE - contention	type|mode	id1	id2	Other	<- name
2286575608	enq: EF - contention	type|mode	id1	id2	Other	<- name
2645745678	enq: EG - contention	type|mode	id1	id2	Other	<- name
3577533227	enq: EH - contention	type|mode	id1	id2	Other	<- name
1285941240	enq: EI - contention	type|mode	id1	id2	Other	<- name
1146405468	enq: EJ - contention	type|mode	id1	id2	Other	<- name
3016736045	enq: EK - contention	type|mode	id1	id2	Other	<- name
3992761025	enq: EL - contention	type|mode	id1	id2	Other	<- name
2089285608	enq: EM - contention	type|mode	id1	id2	Other	<- name
2899227099	enq: EN - contention	type|mode	id1	id2	Other	<- name
88490769	enq: EO - contention	type|mode	id1	id2	Other	<- name
3931594708	enq: EP - contention	type|mode	id1	id2	Other	<- name
2541744767	enq: EQ - contention	type|mode	id1	id2	Other	<- name
3235986442	enq: ER - contention	type|mode	id1	id2	Other	<- name
1894918728	enq: ES - contention	type|mode	id1	id2	Other	<- name
3810509754	enq: ET - contention	type|mode	id1	id2	Other	<- name
3336800414	enq: EU - contention	type|mode	id1	id2	Other	<- name
1649381315	enq: EV - contention	type|mode	id1	id2	Other	<- name
1652839384	enq: EX - contention	type|mode	id1	id2	Other	<- name
1483837291	enq: EY - contention	type|mode	id1	id2	Other	<- name
2534915893	enq: EZ - contention	type|mode	id1	id2	Other	<- name
255555647	enq: LA - contention	type|mode	id1	id2	Other	<- name
923714426	enq: LB - contention	type|mode	id1	id2	Other	<- name
3275074137	enq: LC - contention	type|mode	id1	id2	Other	<- name
871599156	enq: LD - contention	type|mode	id1	id2	Other	<- name
2857947505	enq: LE - contention	type|mode	id1	id2	Other	<- name
2639284940	enq: LF - contention	type|mode	id1	id2	Other	<- name
834829421	enq: LG - contention	type|mode	id1	id2	Other	<- name
978782178	enq: LH - contention	type|mode	id1	id2	Other	<- name
278321110	enq: LI - contention	type|mode	id1	id2	Other	<- name
3300838304	enq: LJ - contention	type|mode	id1	id2	Other	<- name
3400360290	enq: LK - contention	type|mode	id1	id2	Other	<- name
2789266358	enq: LL - contention	type|mode	id1	id2	Other	<- name
1670662413	enq: LM - contention	type|mode	id1	id2	Other	<- name
1469305273	enq: LN - contention	type|mode	id1	id2	Other	<- name
3489117640	enq: LO - contention	type|mode	id1	id2	Other	<- name
3355742611	enq: LP - contention	type|mode	id1	id2	Other	<- name
3810098838	enq: LQ - contention	type|mode	id1	id2	Other	<- name
688765145	enq: LR - contention	type|mode	id1	id2	Other	<- name
2437279763	enq: LS - contention	type|mode	id1	id2	Other	<- name
1781121790	enq: LT - contention	type|mode	id1	id2	Other	<- name
3836307699	enq: LU - contention	type|mode	id1	id2	Other	<- name
1320668291	enq: LV - contention	type|mode	id1	id2	Other	<- name
970056814	enq: LX - contention	type|mode	id1	id2	Other	<- name
3540555035	enq: LY - contention	type|mode	id1	id2	Other	<- name
42470383	enq: LZ - contention	type|mode	id1	id2	Other	<- name
4141358912	enq: YA - contention	type|mode	id1	id2	Other	<- name
49303873	enq: YB - contention	type|mode	id1	id2	Other	<- name
16923067	enq: YC - contention	type|mode	id1	id2	Other	<- name
430723601	enq: YD - contention	type|mode	id1	id2	Other	<- name
2777252872	enq: YE - contention	type|mode	id1	id2	Other	<- name
716188495	enq: YF - contention	type|mode	id1	id2	Other	<- name
3273918077	enq: YG - contention	type|mode	id1	id2	Other	<- name
4261727606	enq: YH - contention	type|mode	id1	id2	Other	<- name
3900056393	enq: YI - contention	type|mode	id1	id2	Other	<- name
1086588912	enq: YJ - contention	type|mode	id1	id2	Other	<- name
1546516104	enq: YK - contention	type|mode	id1	id2	Other	<- name
3656843901	enq: YL - contention	type|mode	id1	id2	Other	<- name
1902098915	enq: YM - contention	type|mode	id1	id2	Other	<- name
2694944627	enq: YN - contention	type|mode	id1	id2	Other	<- name
3078550945	enq: YO - contention	type|mode	id1	id2	Other	<- name
3866696202	enq: YP - contention	type|mode	id1	id2	Other	<- name
1945496019	enq: YQ - contention	type|mode	id1	id2	Other	<- name
2349867750	enq: YR - contention	type|mode	id1	id2	Other	<- name
2384470175	enq: YS - contention	type|mode	id1	id2	Other	<- name
104199150	enq: YT - contention	type|mode	id1	id2	Other	<- name
1824966457	enq: YU - contention	type|mode	id1	id2	Other	<- name
1334630542	enq: YV - contention	type|mode	id1	id2	Other	<- name
222894096	enq: YX - contention	type|mode	id1	id2	Other	<- name
3368294287	enq: YY - contention	type|mode	id1	id2	Other	<- name
4162515370	enq: YZ - contention	type|mode	id1	id2	Other	<- name
3149857794	enq: GA - contention	type|mode	id1	id2	Other	<- name
707945442	enq: GB - contention	type|mode	id1	id2	Other	<- name
3184090883	enq: GC - contention	type|mode	id1	id2	Other	<- name
3010766263	enq: GD - contention	type|mode	id1	id2	Other	<- name
2257184003	enq: GE - contention	type|mode	id1	id2	Other	<- name
1470408532	enq: GF - contention	type|mode	id1	id2	Other	<- name
1578294037	enq: GG - contention	type|mode	id1	id2	Other	<- name
356161086	enq: GH - contention	type|mode	id1	id2	Other	<- name
2197298464	enq: GI - contention	type|mode	id1	id2	Other	<- name
3500533291	enq: GJ - contention	type|mode	id1	id2	Other	<- name
3571038774	enq: GK - contention	type|mode	id1	id2	Other	<- name
4115167081	enq: GL - contention	type|mode	id1	id2	Other	<- name
2822381649	enq: GM - contention	type|mode	id1	id2	Other	<- name
1932106797	enq: GN - contention	type|mode	id1	id2	Other	<- name
1220576703	enq: GO - contention	type|mode	id1	id2	Other	<- name
744993121	enq: GP - contention	type|mode	id1	id2	Other	<- name
2885424359	enq: GQ - contention	type|mode	id1	id2	Other	<- name
1692170555	enq: GR - contention	type|mode	id1	id2	Other	<- name
297473731	enq: GS - contention	type|mode	id1	id2	Other	<- name
3224017946	enq: GT - contention	type|mode	id1	id2	Other	<- name
2778953476	enq: GU - contention	type|mode	id1	id2	Other	<- name
959853025	enq: GV - contention	type|mode	id1	id2	Other	<- name
2865689336	enq: GX - contention	type|mode	id1	id2	Other	<- name
2895074916	enq: GY - contention	type|mode	id1	id2	Other	<- name
4024171206	enq: GZ - contention	type|mode	id1	id2	Other	<- name
1348917136	enq: NA - contention	type|mode	id1	id2	Other	<- name
3834846031	enq: NB - contention	type|mode	id1	id2	Other	<- name
2006236678	enq: NC - contention	type|mode	id1	id2	Other	<- name
1871532613	enq: ND - contention	type|mode	id1	id2	Other	<- name
4012219648	enq: NE - contention	type|mode	id1	id2	Other	<- name
3502491416	enq: NF - contention	type|mode	id1	id2	Other	<- name
2471192843	enq: NG - contention	type|mode	id1	id2	Other	<- name
1409485279	enq: NH - contention	type|mode	id1	id2	Other	<- name
672532181	enq: NI - contention	type|mode	id1	id2	Other	<- name
2473475281	enq: NJ - contention	type|mode	id1	id2	Other	<- name
3808553866	enq: NK - contention	type|mode	id1	id2	Other	<- name
1598198340	enq: NL - contention	type|mode	id1	id2	Other	<- name
3050419639	enq: NM - contention	type|mode	id1	id2	Other	<- name
1665290538	enq: NN - contention	type|mode	id1	id2	Other	<- name
1174794313	enq: NO - contention	type|mode	id1	id2	Other	<- name
2004959591	enq: NP - contention	type|mode	id1	id2	Other	<- name
3657424359	enq: NQ - contention	type|mode	id1	id2	Other	<- name
3356952131	enq: NR - contention	type|mode	id1	id2	Other	<- name
2192142731	enq: NS - contention	type|mode	id1	id2	Other	<- name
3427460944	enq: NT - contention	type|mode	id1	id2	Other	<- name
112223784	enq: NU - contention	type|mode	id1	id2	Other	<- name
4128471227	enq: NV - contention	type|mode	id1	id2	Other	<- name
2545284036	enq: NX - contention	type|mode	id1	id2	Other	<- name
1766455960	enq: NY - contention	type|mode	id1	id2	Other	<- name
2086756223	enq: NZ - contention	type|mode	id1	id2	Other	<- name
3753139397	enq: IV - contention	type|mode	id1	id2	Other	<- name
3937527428	enq: TP - contention	name|mode	0	0	Other	<- name
1305530676	enq: RW - MV metadata contention	name|mode	table obj#	0	Other	<- name
1911278064	enq: OC - contention	name|mode	1	2	Other	<- name
3443769614	enq: OL - contention	name|mode	hash value	0	Other	<- name
2380778435	kkdlgon				Other	<- name
987594289	kkdlsipon				Other	<- name
1604845996	kkdlhpon				Other	<- name
355994765	Remote Tool Request Reply				Other	<- name
3009035641	Remote Tool Request Free List				Other	<- name
3770549072	kgltwait				Other	<- name
3834925098	kksfbc research				Other	<- name
695862004	kksscl hash split				Other	<- name
2679325	kksfbc child completion				Other	<- name
325782660	enq: CU - contention	name|mode	handle	handle	Other	<- name
3963940642	enq: AE - lock	name|mode	edition obj#	pdbuid	Other	<- name
3983390698	Revoke: get object	maximum time	amount of time		Other	<- name
2211137592	enq: PF - contention	name|mode	0	0	Other	<- name
3405015922	enq: PZ - flush passwordfile metadata	name|mode	0	0	Other	<- name
2886680154	enq: PZ - load passwordfile metadata	name|mode	0	0	Other	<- name
1682769842	enq: IL - contention	name|mode	object #	0	Other	<- name
1619270516	enq: CL - drop label	name|mode	object #	0	Other	<- name
3032662556	enq: CL - compare labels	name|mode	object #	0	Other	<- name
2966458487	enq: SG - OLS Add Group	name|mode	object #	0	Other	<- name
2242607460	enq: SG - OLS Create Group	name|mode	object #	0	Other	<- name
2337297337	enq: SG - OLS Drop Group	name|mode	object #	0	Other	<- name
2419135517	enq: SG - OLS Alter Group Parent	name|mode	object #	0	Other	<- name
842554107	enq: OP - OLS Store user entries	name|mode	object #	0	Other	<- name
4210998488	enq: OP - OLS Cleanup unused profiles	name|mode	object #	0	Other	<- name
2064902942	move audit tablespace delay				Other	<- name
1548192275	enq: CC - decryption	name|mode	0	0	Other	<- name
3559219295	enq: MK - contention	name|mode	0	0	Other	<- name
4033490427	enq: OW - initialization	name|mode	0	0	Other	<- name
964463181	enq: OW - termination	name|mode	0	0	Other	<- name
3147636141	enq: RK - set key	name|mode	0	0	Other	<- name
3379814898	enq: RK - queue wallet and TS keys	name|mode	0	0	Other	<- name
3158937066	enq: HC - HSM cache write	name|mode	0	0	Other	<- name
663631404	enq: HC - HSM cache read	name|mode	0	0	Other	<- name
2687533677	enq: RL - RAC wallet lock	name|mode	0	0	Other	<- name
4025463557	enq: PJ - modify DV policy	name|mode	0	0	Other	<- name
1522297956	enq: PJ - read DV policy	name|mode	0	0	Other	<- name
3612159796	Row cache for Grant or Revoke	maximum time	amount of time		Other	<- name
1248642937	enq: ZZ - update hash tables	name|mode	KSBXIC Action	0	Other	<- name
387973045	Failed Logon Delay				Other	<- name
1444835457	enq: ZA - add std audit table partition	name|mode	KZAM Aud Partition	0	Other	<- name
2473367936	enq: ZF - add fga audit table partition	name|mode	KZAM Fga Partition	0	Other	<- name
4117873466	enq: ZS - excl access to spill audit file	name|mode	Spillover audit file	0	Other	<- name
2167287208	enq: UT - transfer audit records	name|mode	TRANSFER AUDIT RECORDS	0	Other	<- name
2191852259	enq: PA - modify a privilege capture	name|mode	0	0	Other	<- name
3768392460	enq: PA - read a privilege capture	name|mode	0	0	Other	<- name
3218498929	enq: PC - update privilege capture info	name|mode	0	0	Other	<- name
3478134814	enq: PC - read privilege capture info	name|mode	0	0	Other	<- name
2825881230	enq: KZ - contention	type|mode	id1	id2	Other	<- name
2881503609	enq: DX - contention	name|mode	transaction entry #	0	Other	<- name
721778600	enq: DR - contention	name|mode	0	0	Other	<- name
363664498	pending global transaction(s)	scans			Other	<- name
1932123989	free global transaction table entry	tries			Other	<- name
800384622	library cache revalidation				Other	<- name
1578286316	library cache shutdown				Other	<- name
168007407	BFILE closure				Other	<- name
3242184666	BFILE check if exists				Other	<- name
1942306413	BFILE check if open				Other	<- name
472769133	BFILE get length				Other	<- name
4198001558	BFILE get name object				Other	<- name
33957852	BFILE get path object				Other	<- name
1993008680	BFILE open				Other	<- name
2281626056	BFILE internal seek				Other	<- name
2625557633	resmgr:internal state cleanup	location			Other	<- name
1731053206	xdb schema cache initialization				Other	<- name
378175956	ASM cluster file access	lock	mode		Other	<- name
366154626	CSS initialization				Other	<- name
3315172079	CSS group registration	group_name1	group_name2	mem_id	Other	<- name
321492953	CSS group membership query	group_name1	group_name2	group_name3	Other	<- name
4255804750	CSS operation: data query	function_id			Other	<- name
3392052408	CSS operation: data update	function_id			Other	<- name
1812662268	CSS Xgrp shared operation	function_id			Other	<- name
1558934147	CSS operation: query	function_id			Other	<- name
2051030365	CSS operation: action	function_id			Other	<- name
2821557051	CSS operation: diagnostic	function_id			Other	<- name
1957973247	GIPC operation: dump	function_id			Other	<- name
3269846298	GPnP Initialization				Other	<- name
3458573322	GPnP Termination				Other	<- name
2801929040	GPnP Get Item				Other	<- name
2084604428	GPnP Set Item				Other	<- name
725794275	GPnP Get Error				Other	<- name
660190475	ADR file lock				Other	<- name
1780066010	ADR block file read				Other	<- name
4092822979	ADR block file write				Other	<- name
3329884903	CRS call completion	clsrrestype	kjha_action		Other	<- name
1957311914	ASM: OFS Cluster membership update				Other	<- name
1720615545	dispatcher shutdown	waited			Other	<- name
2160405876	latch: virtual circuit queues	address	number	why	Other	<- name
2803313450	listen endpoint status	end-point#	status		Other	<- name
3085137677	listener registration dump	dump			Other	<- name
3280053043	OJVM: Generic				Other	<- name
3225641117	select wait				Other	<- name
2155415449	jobq slave shutdown wait				Other	<- name
1039441158	jobq slave TJ process wait				Other	<- name
2521301688	job scheduler coordinator slave wait				Other	<- name
2016557033	enq: JD - contention	name|mode	0	0	Other	<- name
4077422893	enq: JQ - contention	name|mode	0	0	Other	<- name
143199788	enq: OD - Serializing DDLs	name|mode	object #	0	Other	<- name
3862184413	RAC referential constraint parent lock	maximum attempts	attempt count		Other	<- name
198056240	RAC: constraint DDL lock	maximum attempts	attempt count		Other	<- name
4264819978	kkshgnc reloop				Other	<- name
3412463764	optimizer stats update retry				Other	<- name
1586753839	wait active processes				Other	<- name
4042173709	SUPLOG PL wait for inflight pragma-d PL/SQL	session_num			Other	<- name
3735259588	enq: MD - contention	name|mode	master object #	0	Other	<- name
3982742587	enq: MS - contention	name|mode	master object #	purpose	Other	<- name
2191672992	wait for kkpo ref-partitioning *TEST EVENT*	where			Other	<- name
2212621438	RAC reference partitioning descendants lock	maximum attempts	attempt count		Other	<- name
197381757	enq: AP - contention	name|mode	0	0	Other	<- name
3350442546	enq: RH - quarantine	name|mode	0	0	Other	<- name
4097381538	PX slave connection				Other	<- name
677587481	PX slave release				Other	<- name
624762663	PX Send Wait				Other	<- name
175758063	PX qref latch	function	sleeptime	qref	Other	<- name
2914763719	PX server shutdown	nalive	sleeptime	loop	Other	<- name
713547867	PX create server	nservers	sleeptime	enqueue	Other	<- name
275064659	PX signal server	serial	error	nbusy	Other	<- name
4205438796	PX Deq: Join ACK	sleeptime/senderid	passes		Other	<- name
2019821942	PX Deq Credit: free buffer	sleeptime/senderid	passes	qref	Other	<- name
4186184097	PX Deq: Test for msg	sleeptime/senderid	passes		Other	<- name
2485206220	PX Deq: Test for credit	sleeptime/senderid	passes		Other	<- name
2705287540	PX Deq: Signal ACK RSG	sleeptime/senderid	passes		Other	<- name
1974015973	PX Deq: Signal ACK EXT	sleeptime/senderid	passes		Other	<- name
146029171	PX Deq: reap credit				Other	<- name
4195961226	PX Nsq: PQ descriptor query				Other	<- name
1721932125	PX Nsq: PQ load info query				Other	<- name
55053127	PX Deq Credit: Session Stats	sleeptime/senderid	passes		Other	<- name
2306891574	PX Deq: Slave Session Stats	sleeptime/senderid	passes		Other	<- name
1826399205	PX Deq: Slave Join Frag	sleeptime/senderid	passes		Other	<- name
2143046196	enq: PI - contention	name|mode	operation	serial #	Other	<- name
2071012023	enq: PS - contention	name|mode	instance	slave ID	Other	<- name
3187918539	enq: DA - Slave Process Array	name|mode	0	0	Other	<- name
676951513	latch: parallel query alloc buffer	address	number	why	Other	<- name
2176755381	kxfxse	kxfxse debug wait: stalling for slave 0			Other	<- name
789727252	kxfxsp	kxfxsp debug wait: stalling for slave 0			Other	<- name
2049127157	PX Deq: Table Q qref	sleeptime/senderid	passes		Other	<- name
4068211615	PX Deq: Table Q Get Keys	sleeptime/senderid	passes		Other	<- name
2044715771	PX Deq: Table Q Close	sleeptime/senderid	passes		Other	<- name
1944760014	GV$: slave acquisition retry wait time				Other	<- name
265138948	PX hash elem being inserted	hashid	element	insert/update	Other	<- name
2185396738	latch: PX hash array latch	address	number	why	Other	<- name
3076848514	enq: AY - contention	name|mode	Op1	Op2	Other	<- name
3701540314	enq: TO - contention	name|mode	object #	1	Other	<- name
3003716442	enq: ZP - Private Temporary Table	name|mode	sess#	ser#	Other	<- name
210464158	IMCDT end of scans cleanup	session id			Other	<- name
2239268215	enq: IT - contention	name|mode	object #	0	Other	<- name
2212717019	enq: BF - allocation contention	name|mode	node#/parallelizer#	bloom#	Other	<- name
2476632936	enq: BF - PMON Join Filter cleanup	name|mode	node#/parallelizer#	bloom#	Other	<- name
3612504684	enq: RD - RAC load	name|mode	sqlid	execid	Other	<- name
720590657	PX key vector flatten	sleeptime	passes		Other	<- name
2134054793	PX hash key vector cell	sleeptime	passes		Other	<- name
3088459204	PX hash key vector merge	sleeptime	passes		Other	<- name
227324969	PX key vector use load	sleeptime	passes		Other	<- name
1640694188	PX key vector create dgk init	sleeptime	passes		Other	<- name
1677991500	enq: MG - MGA allocation	name|mode	qcserial#	rowsource#/mgacode#	Other	<- name
4252762903	enq: MG - client shared context allocation	name|mode	qcserial#	rowsource#/mgacode#	Other	<- name
4172720392	timer in sksawat				Other	<- name
148348926	scginq AST call				Other	<- name
3632212035	kupp process wait				Other	<- name
1677898746	Kupp process shutdown	nalive	sleeptime	loop	Other	<- name
1618891965	Data Pump slave startup				Other	<- name
1990104190	Data Pump slave init				Other	<- name
4149771879	enq: KP - contention	name|mode	0	0	Other	<- name
62357398	Replication Dequeue	sleeptime/senderid	passes		Other	<- name
171343339	knpc_acwm_AwaitChangedWaterMark				Other	<- name
68404501	knpc_anq_AwaitNonemptyQueue				Other	<- name
2722071092	knpsmai				Other	<- name
3056899600	enq: SR - contention	name|mode	operation	sequence # / apply #	Other	<- name
1695560430	enq: RG - Apply coord start/stop	name|mode	0	0	Other	<- name
2065856153	REPL Capture/Apply: database startup	2=>GoldenGate 1=>XStream 0=>Streams			Other	<- name
2721331920	REPL Capture/Apply: miscellaneous	2=>GoldenGate 1=>XStream 0=>Streams	TYPE		Other	<- name
3398735787	enq: SI - contention	name|mode	object #	0	Other	<- name
1864425273	REPL Capture/Apply: RAC inter-instance ack	2=>GoldenGate 1=>XStream 0=>Streams			Other	<- name
2673474179	enq: IA - contention	name|mode	0	0	Other	<- name
2959147725	enq: JI - contention	name|mode	view object #	0	Other	<- name
2379543324	qerex_gdml				Other	<- name
545059663	enq: AT - contention	name|mode	0	0	Other	<- name
3227435068	Retry DB Audit Record Insertion Delay				Other	<- name
2694900870	opishd				Other	<- name
2339167892	secure protocol error delay				Other	<- name
3714800175	kpodplck wait before retrying ORA-54				Other	<- name
4187088707	enq: CQ - contention	name|mode	0	0	Other	<- name
256518009	wait for EMON to spawn				Other	<- name
2145388	EMON termination				Other	<- name
3606851176	enq: AZ - AQ_SRVNTFN_Q Creation	name|mode	0	0	Other	<- name
2204104508	Emon coordinator startup				Other	<- name
3429311972	enq: SE - contention	name|mode	Session-id	Serial#	Other	<- name
4191886805	tsm with timeout				Other	<- name
475650147	Streams AQ: waiting for busy instance for instance_name	where	wait_count		Other	<- name
360694399	Streams AQ: index block pin/row lock	Other			Other	<- name
1371132976	enq: TQ - TM contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
717240345	enq: TQ - DDL contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
451597502	enq: TQ - INI contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
3544909312	enq: TQ - DDL-INI contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
2485099792	enq: TQ - INI sq contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
2161466780	enq: TQ - MC free sync at cross job start	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
3940406592	enq: TQ - MC free sync at cross job stop	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
3556092800	enq: TQ - MC free sync at cross job end	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
1806788557	enq: TQ - MC free sync at export subshard	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
414829123	enq: TQ - create eviction table	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
1253896331	enq: TQ - TM Job cache initialization	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
851010114	enq: TQ - TM Job cache use	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
140858203	enq: TQ - sq TM contention	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
1778940434	enq: TQ - LB drop volatile shard	name|mode	QT_OBJ#	Other=>0 pdbOpen=>1	Other	<- name
184877469	AQ reload SO release				Other	<- name
1604858083	enq: RQ - Enqueue commit uncached	name|mode	Q_OBJ#	shard:mode	Other	<- name
3085538108	enq: RQ - Enqueue commit cached	name|mode	Q_OBJ#	shard:mode	Other	<- name
2919324227	enq: RQ - Dequeue update scn	name|mode	Q_OBJ#	shard:mode	Other	<- name
865607805	enq: RQ - Parallel cross update scn	name|mode	Q_OBJ#	shard:mode	Other	<- name
3441381857	enq: RQ - Cross update scn	name|mode	Q_OBJ#	shard:mode	Other	<- name
2880690823	enq: RQ - Trucate subshard	name|mode	Q_OBJ#	shard:mode	Other	<- name
3170569805	enq: RQ - Cross export subshard	name|mode	Q_OBJ#	shard:mode	Other	<- name
1369383293	enq: RQ - Cross import subshard	name|mode	Q_OBJ#	shard:mode	Other	<- name
1413769130	enq: RQ - Free shadow shard	name|mode	Q_OBJ#	shard:mode	Other	<- name
3015178340	enq: RQ - AQ indexed cached commit	name|mode	Q_OBJ#	shard:mode	Other	<- name
2216156465	enq: RQ - AQ uncached commit WM update	name|mode	Q_OBJ#	shard:mode	Other	<- name
1097722103	enq: RQ - AQ uncached dequeue	name|mode	Q_OBJ#	shard:mode	Other	<- name
2303995540	enq: RQ - AQ Eq Ptn Mapping	name|mode	Q_OBJ#	shard:mode	Other	<- name
880236959	enq: RQ - AQ Dq Ptn Mapping	name|mode	Q_OBJ#	shard:mode	Other	<- name
3508179254	enq: RQ - AQ Trnc mem free	name|mode	Q_OBJ#	shard:mode	Other	<- name
732656061	enq: RQ - AQ Trnc mem free remote	name|mode	Q_OBJ#	shard:mode	Other	<- name
2182291775	enq: RQ - AQ Trnc mem free by LB	name|mode	Q_OBJ#	shard:mode	Other	<- name
2158440508	enq: RQ - AQ Trnc mem free by CP	name|mode	Q_OBJ#	shard:mode	Other	<- name
2511032739	enq: RQ - AQ Enq commit incarnation wrap	name|mode	Q_OBJ#	shard:mode	Other	<- name
992085483	enq: RQ - AQ Rule evaluation segment load	name|mode	Q_OBJ#	shard:mode	Other	<- name
3549861016	enq: RQ - AQ Evict: block truncate	name|mode	Q_OBJ#	shard:mode	Other	<- name
263001462	enq: RQ - AQ Unevict PGA: setup subscriber	name|mode	Q_OBJ#	shard:mode	Other	<- name
1533122454	enq: RQ - AQ Unevict PGA: Queue View	name|mode	Q_OBJ#	shard:mode	Other	<- name
3768201353	enq: RQ - AQ Shid Gen	name|mode	Q_OBJ#	shard:mode	Other	<- name
1316606076	enq: RQ - AQ Enq commit block truncate	name|mode	Q_OBJ#	shard:mode	Other	<- name
2034753927	enq: RQ - AQ Cross update scn for delay	name|mode	Q_OBJ#	shard:mode	Other	<- name
995822741	enq: RQ - AQ Cross Shard mem free	name|mode	Q_OBJ#	shard:mode	Other	<- name
623563369	enq: RQ - AQ rollback retry count update	name|mode	Q_OBJ#	shard:mode	Other	<- name
2906438445	enq: RQ - AQ cached commit WM update	name|mode	Q_OBJ#	shard:mode	Other	<- name
2832768511	enq: RQ - AQ cached dequeue by condition	name|mode	Q_OBJ#	shard:mode	Other	<- name
2877960639	AQ propagation connection				Other	<- name
8998880	enq: KR - Drop rule force	name|mode	R_OBJ#	0	Other	<- name
3809944109	enq: KR - Add rule to ruleset	name|mode	R_OBJ#	0	Other	<- name
1527114466	enq: KR - Remove rule from ruleset	name|mode	R_OBJ#	0	Other	<- name
1150705222	enq: DP - contention	name|mode	0	0	Other	<- name
798324601	enq: MH - contention	name|mode	0	0	Other	<- name
4174613831	enq: ML - contention	name|mode	0	0	Other	<- name
148033462	enq: PH - contention	name|mode	0	0	Other	<- name
3322341088	enq: SF - contention	name|mode	0	0	Other	<- name
3111555168	enq: XH - contention	name|mode	0	0	Other	<- name
3791087697	enq: WA - contention	name|mode	0	0	Other	<- name
2512310275	Streams AQ: QueueTable kgl locks				Other	<- name
1444745059	AQ spill debug idle				Other	<- name
1036481366	AQ master shutdown				Other	<- name
1719027518	AQPC: new master				Other	<- name
521075289	AQ Background Master: slave start				Other	<- name
217236789	enq: AQ - QPT fg map dqpt	name|mode	QT_OBJ#	0	Other	<- name
2886730684	enq: AQ - QPT fg map qpt	name|mode	QT_OBJ#	0	Other	<- name
4020471302	enq: PQ - QPT add qpt	name|mode	QT_OBJ#	0	Other	<- name
588884722	enq: PQ - QPT drop qpt	name|mode	QT_OBJ#	0	Other	<- name
555943052	enq: PQ - QPT add dqpt	name|mode	QT_OBJ#	0	Other	<- name
3301195157	enq: PQ - QPT drop dqpt	name|mode	QT_OBJ#	0	Other	<- name
1959042520	enq: PQ - QPT add qpt fg	name|mode	QT_OBJ#	0	Other	<- name
3836089153	enq: PQ - QPT add dqpt fg	name|mode	QT_OBJ#	0	Other	<- name
861646821	enq: PQ - QPT Trunc	name|mode	QT_OBJ#	0	Other	<- name
2920134246	enq: PQ - QPT LB Trunc sync	name|mode	QT_OBJ#	0	Other	<- name
441889315	enq: PQ - QPT XSTART Trunc sync	name|mode	QT_OBJ#	0	Other	<- name
1492596895	AQ master: time mgmt/task cleanup				Other	<- name
51933697	AQ slave: time mgmt/task cleanup				Other	<- name
4071093774	enq: BA - SUBBMAP contention	name|mode	0	0	Other	<- name
2421053357	AQ:non durable subscriber add or drop				Other	<- name
2363885740	AQ: RAC AQ Network				Other	<- name
93406953	latch: AQ Sharded subscriber statistics latch	address	number	why	Other	<- name
1465038546	AQ OPT Operation Complete	subshard	skiplist		Other	<- name
2371292690	latch: AQ OPT Background Master Latch	address	number	why	Other	<- name
4107448082	enq: CX - TEXT: Index Specific Lock	name|mode	Index Id	Partition Id	Other	<- name
389396261	enq: OT - TEXT: Generic Lock	name|mode	0	0	Other	<- name
1110641933	XDB SGA initialization				Other	<- name
300221745	enq: XC - XDB Configuration	name|mode			Other	<- name
1255252648	NFS read delegation outstanding	delegation count			Other	<- name
4100251918	Data Guard Broker Wait	Broker Component	Wait Argument 1	Wait Argument 2	Other	<- name
2609577957	enq: RF - synch: DG Broker metadata	name|mode	lock operation	lock value	Other	<- name
3779250430	enq: RF - atomicity	name|mode	lock operation	lock value	Other	<- name
1367687622	enq: RF - Broker Chief Lock	name|mode	lock operation	lock value	Other	<- name
770131870	enq: RF - synchronization: aifo master	name|mode	lock operation	lock value	Other	<- name
1283852695	enq: RF - new AI	name|mode	lock operation	lock value	Other	<- name
3573752690	enq: RF - synchronization: critical ai	name|mode	lock operation	lock value	Other	<- name
1173618054	enq: RF - RF - Database Automatic Disable	name|mode	lock operation	lock value	Other	<- name
1422251130	enq: RF - FSFO Observer Heartbeat	name|mode	lock operation	lock value	Other	<- name
2735020950	enq: RF - DG Broker Current File ID	name|mode	lock operation	lock value	Other	<- name
2311929058	enq: RF - FSFO Primary Shutdown suspended	name|mode	lock operation	lock value	Other	<- name
3754864244	enq: RF - Broker State Lock	name|mode	lock operation	lock value	Other	<- name
3053910820	enq: RF - FSFO string buffer	name|mode	lock operation	lock value	Other	<- name
2069842805	enq: RF - Broker NSV Lock	name|mode	lock operation	lock value	Other	<- name
1285804450	enq: RF - Broker LSBY FO Lock	name|mode	lock operation	lock value	Other	<- name
687406475	PX Deq: OLAP Update Reply	sleeptime/senderid	passes		Other	<- name
2722627124	PX Deq: OLAP Update Execute	sleeptime/senderid	passes		Other	<- name
3949837646	PX Deq: OLAP Update Close	sleeptime/senderid	passes		Other	<- name
3728184289	enq: AW - AW$ table lock	name|mode	operation	workspace #	Other	<- name
2438512004	enq: AW - AW state lock	name|mode	operation	workspace #	Other	<- name
541043045	enq: AW - user access for AW	name|mode	operation	workspace #	Other	<- name
2247828282	enq: AW - AW generation lock	name|mode	operation	workspace #	Other	<- name
2009316128	enq: AG - contention	name|mode	workspace #	generation	Other	<- name
2454416615	enq: AO - contention	name|mode	workspace #	object #	Other	<- name
523388040	enq: OQ - xsoqhiAlloc	name|mode	resource id	0	Other	<- name
3682185722	enq: OQ - xsoqhiFlush	name|mode	resource id	0	Other	<- name
681553729	enq: OQ - xsoq*histrecb	name|mode	resource id	0	Other	<- name
2148426979	enq: OQ - xsoqhiClose	name|mode	resource id	0	Other	<- name
4194119705	enq: OQ - xsoqhistrecb	name|mode	resource id	0	Other	<- name
1170604220	enq: IZ - contention	type|mode	id1	id2	Other	<- name
409056071	enq: AM - client registration	name|mode	id1	id2	Other	<- name
4003623979	enq: AM - shutdown	name|mode	id1	id2	Other	<- name
3718305	enq: AM - rollback COD reservation	name|mode	id1	id2	Other	<- name
2163538166	enq: AM - background COD reservation	name|mode	id1	id2	Other	<- name
2512559650	enq: AM - ASM cache freeze	name|mode	id1	id2	Other	<- name
1784903832	enq: AM - ASM ACD Relocation	name|mode	id1	id2	Other	<- name
3865222969	enq: AM - group use	name|mode	id1	id2	Other	<- name
2069926448	enq: AM - group block	name|mode	id1	id2	Other	<- name
827631834	enq: AM - ASM File Destroy	name|mode	id1	id2	Other	<- name
1369527695	enq: AM - ASM User	name|mode	id1	id2	Other	<- name
1010353447	enq: AM - ASM Password File Update	name|mode	id1	id2	Other	<- name
2754586444	enq: AM - ASM Amdu Dump	name|mode	id1	id2	Other	<- name
1111439585	enq: AM - disk offline	name|mode	id1	id2	Other	<- name
1454769910	enq: AM - ASM reserved	name|mode	id1	id2	Other	<- name
279744402	enq: AM - block repair	name|mode	id1	id2	Other	<- name
3396428008	enq: AM - ASM disk based alloc/dealloc	name|mode	id1	id2	Other	<- name
3160612488	enq: AM - ASM file descriptor	name|mode	id1	id2	Other	<- name
92719042	enq: AM - ASM file relocation	name|mode	id1	id2	Other	<- name
2483622550	enq: AM - ASM SR relocation	name|mode	id1	id2	Other	<- name
1063667893	enq: AM - ASM Grow ACD	name|mode	id1	id2	Other	<- name
3837655383	enq: AM - ASM DD update SrRloc	name|mode	id1	id2	Other	<- name
4169101203	enq: AM - ASM file chown	name|mode	id1	id2	Other	<- name
2601059080	enq: AM - Register with IOServer	name|mode	id1	id2	Other	<- name
699477076	enq: AM - ASM metadata replication	name|mode	id1	id2	Other	<- name
985067372	enq: AM - SR slice Clear/Mark	name|mode	id1	id2	Other	<- name
3556433611	enq: AM - Enable Remote ASM	name|mode	id1	id2	Other	<- name
442057748	enq: AM - Disable Remote ASM	name|mode	id1	id2	Other	<- name
4095213098	enq: AM - Credential creation	name|mode	id1	id2	Other	<- name
1623955356	enq: AM - Credential deletion	name|mode	id1	id2	Other	<- name
2677727449	enq: AM - ASM file access req	name|mode	id1	id2	Other	<- name
64802329	enq: AM - ASM client operation	name|mode	id1	id2	Other	<- name
2358860044	enq: AM - ASM client check	name|mode	id1	id2	Other	<- name
1675121924	enq: AM - ASM ATB COD creation	name|mode	id1	id2	Other	<- name
3472725730	enq: AM - Create default DG key in OCR	name|mode	id1	id2	Other	<- name
2680210812	enq: AM - ASM Audit file Delete	name|mode	id1	id2	Other	<- name
2479275509	enq: AM - ASM Audit file Cleanup	name|mode	id1	id2	Other	<- name
2073560035	enq: AM - ASM VAT migration	name|mode	id1	id2	Other	<- name
1975769604	enq: AM - Update SR nomark flag	name|mode	id1	id2	Other	<- name
1591602342	enq: AM - ASM VAL cache	name|mode	id1	id2	Other	<- name
3793499008	enq: AM - ASM SR Segment Reuse	name|mode	id1	id2	Other	<- name
250443378	enq: AM - ASM SR Segment Reuse Lookup	name|mode	id1	id2	Other	<- name
537017889	enq: AM - ASM SR Batch Allocation	name|mode	id1	id2	Other	<- name
1134572957	enq: AM - ASM Sparse Disk IOCTL	name|mode	id1	id2	Other	<- name
1654589745	enq: AM - ASM VAM Active	name|mode	id1	id2	Other	<- name
3363174857	enq: AM - ASM Split Mirror File Create	name|mode	id1	id2	Other	<- name
2694311567	enq: AM - ASM Split Mirror File Delete	name|mode	id1	id2	Other	<- name
2896300204	enq: AM - ASM Mirror Prepare	name|mode	id1	id2	Other	<- name
3154205335	enq: AM - ASM Mirror Split	name|mode	id1	id2	Other	<- name
305997448	enq: AM - ASM Drop Mirror	name|mode	id1	id2	Other	<- name
1949526317	enq: AM - ASM PDB Mirror Split	name|mode	id1	id2	Other	<- name
3578425710	enq: AM - DB Mirror Prepare	name|mode	id1	id2	Other	<- name
621703965	enq: AM - DB Drop Mirror Copy	name|mode	id1	id2	Other	<- name
2893418612	enq: AM - DB Mirror Split	name|mode	id1	id2	Other	<- name
1758319559	enq: AM - PDB Mirror Split	name|mode	id1	id2	Other	<- name
2320430895	enq: AM - Create Prepare Child file group	name|mode	id1	id2	Other	<- name
716767539	enq: AM - Change file group redundancy	name|mode	id1	id2	Other	<- name
525190891	enq: AM - ASM Split Mirror ODM File Crt	name|mode	id1	id2	Other	<- name
2345780184	enq: AM - ASM Split Mirror ODM File Del	name|mode	id1	id2	Other	<- name
2488686235	enq: AM - ASMB Startup	name|mode	id1	id2	Other	<- name
3410638104	enq: AM - ASMB Renew	name|mode	id1	id2	Other	<- name
294867266	enq: AM - ASM: group unblock	name|mode	id1	id2	Other	<- name
1743182406	enq: AM - ASM file create	name|mode	id1	id2	Other	<- name
1956883892	enq: AM - ASM ATE conversion	name|mode	id1	id2	Other	<- name
3446354675	enq: AM - ASM resync from ATE	name|mode	id1	id2	Other	<- name
3550195952	enq: AM - ASM Split Status Write	name|mode	id1	id2	Other	<- name
4245020571	enq: AM - ASM Split Status Read	name|mode	id1	id2	Other	<- name
1314989500	enq: AM - ASM Client Assisted Offline	name|mode	id1	id2	Other	<- name
143193948	enq: AM - ASM Client Assisted Offline Chk	name|mode	id1	id2	Other	<- name
1209620185	ASM internal hang test	test #			Other	<- name
1458436774	ASM Instance startup				Other	<- name
2251737163	buffer busy	group#	obj#	block#	Other	<- name
3520118347	buffer freelistbusy	group#	obj#	block#	Other	<- name
4196750963	buffer rememberlist busy	group#	obj#	block#	Other	<- name
539980354	buffer writeList full	group#	obj#	block#	Other	<- name
3607843151	no free buffers	group#	obj#	block#	Other	<- name
1188005821	buffer write wait	group#	obj#	block#	Other	<- name
1339059840	buffer invalidation wait	group#	obj#	block#	Other	<- name
3809103184	buffer dirty disabled	group#			Other	<- name
3227373516	ASM metadata cache frozen	group#	obj#	block#	Other	<- name
3006239876	enq: FZ - contention	type|mode	id1	id2	Other	<- name
4186342174	enq: CM - gate	name|mode	disk group #	type	Other	<- name
3394651275	enq: CM - instance	name|mode	disk group #	type	Other	<- name
3457552864	enq: CM - diskgroup dismount	name|mode	disk group #	type	Other	<- name
3051305468	enq: XQ - recovery	name|mode	disk group #	unused	Other	<- name
1688174401	enq: XQ - relocation	name|mode	disk group #	unused	Other	<- name
3970804539	enq: XQ - purification	name|mode	disk group #	unused	Other	<- name
2345563243	enq: AD - allocate AU	name|mode	group and disk number	AU number	Other	<- name
143335296	enq: AD - deallocate AU	name|mode	group and disk number	AU number	Other	<- name
2372793991	enq: AD - relocate AU	name|mode	group and disk number	AU number	Other	<- name
2627023149	enq: AD - flush writes to AU	name|mode	group and disk number	AU number	Other	<- name
1035436594	enq: DO - disk online	name|mode	disk group #	disk #	Other	<- name
3543159936	enq: DO - disk online recovery	name|mode	disk group #	disk #	Other	<- name
3796486218	enq: DO - Staleness Registry create	name|mode	disk group #	disk #	Other	<- name
1190657481	enq: DO - startup of MARK process	name|mode	disk group #	disk #	Other	<- name
2314060976	extent map load/unlock	group	file	extent	Other	<- name
3108652202	extent map locked	mid			Other	<- name
187881552	enq: XL - fault extent map	name|mode	map id	nothing	Other	<- name
1759761944	Sync ASM rebalance				Other	<- name
1532208117	Sync ASM discovery				Other	<- name
177573324	File Directory Use				Other	<- name
685231043	enq: DG - contention	name|mode	disk group	type	Other	<- name
3688395675	enq: DD - contention	name|mode	disk group	type	Other	<- name
4039922119	enq: HD - contention	name|mode	disk group	0	Other	<- name
996118641	enq: DQ - contention	type|mode	id1	id2	Other	<- name
2749567914	ASM ioctl to dematerialize blocks	OSS FD	where	timeout	Other	<- name
2043768807	enq: DN - contention	name|mode	0	0	Other	<- name
895023593	Cluster stabilization wait				Other	<- name
1575986328	Cluster Suspension wait				Other	<- name
3861676729	ASMB cookie valid check				Other	<- name
2662459136	ASM background starting				Other	<- name
1187368726	CSS cookie check				Other	<- name
2985320524	ASM db client exists				Other	<- name
3967390525	ASM file metadata operation	msgop	locn		Other	<- name
2340849898	ASM network foreground exits	group#			Other	<- name
3684153710	ASM check disk slices	group#			Other	<- name
1565536645	enq: XB - contention	type|mode	id1	id2	Other	<- name
3182712926	enq: FA - access file	name|mode	disk group number	file number	Other	<- name
2145403328	enq: RX - relocate extent	name|mode	disk group #:file #	virtual extent number	Other	<- name
3415870113	enq: RX - unlock extent	name|mode	disk group #:file #	virtual extent number	Other	<- name
1530586040	enq: AR - contention	type|mode	id1	id2	Other	<- name
2210429417	enq: AH - contention	type|mode	id1	id2	Other	<- name
3902700176	log write(odd)	group#			Other	<- name
1156678023	log write(even)	group#			Other	<- name
2188655897	checkpoint advanced	group#			Other	<- name
1893664477	enq: FR - contention	name|mode	disk group	thread	Other	<- name
3144887602	enq: FR - use the thread	name|mode	disk group	thread	Other	<- name
2085113153	enq: FR - recover the thread	name|mode	disk group	thread	Other	<- name
1457820412	enq: FG - serialize ACD relocate	name|mode	disk group	type	Other	<- name
903153076	enq: FG - FG redo generation enq race	name|mode	disk group	type	Other	<- name
3282679649	enq: FG - LGWR redo generation enq race	name|mode	disk group	type	Other	<- name
4166969980	enq: FT - allow LGWR writes	name|mode	disk group	thread	Other	<- name
3784147810	enq: FT - disable LGWR writes	name|mode	disk group	thread	Other	<- name
1342373550	enq: FC - open an ACD thread	name|mode	disk group	thread	Other	<- name
4041110320	enq: FC - recover an ACD thread	name|mode	disk group	thread	Other	<- name
642072527	enq: FX - issue ACD Xtnt Relocation CIC	name|mode	disk group	unused	Other	<- name
1290945549	rollback operations block full	max operations			Other	<- name
3090342480	rollback operations active	operation count			Other	<- name
11871430	enq: RB - contention	name|mode	disk group	0	Other	<- name
2388386205	ASM: MARK subscribe to msg channel				Other	<- name
356559202	ASM: Send msg to MARK	group#	dginc		Other	<- name
1863410699	IOS client reconnect to dif IOS				Other	<- name
2796523246	enq: II - contention	type|mode	id1	id2	Other	<- name
2402091651	enq: IK - contention	type|mode	id1	id2	Other	<- name
3763393154	IOS worker process startup	process type	process number		Other	<- name
2169926259	IOS worker process exit	process type	process number		Other	<- name
2526851348	call	action			Other	<- name
1149393865	enq: IC - IOServer clientID	name|mode	client id	none	Other	<- name
2190180976	enq: IF - file open	name|mode	client id/group num	File number	Other	<- name
143253470	enq: IF - file close	name|mode	client id/group num	File number	Other	<- name
1698021162	enq: PT - contention	name|mode	disk group #	type	Other	<- name
1341347015	enq: PT - ASM Storage May Split	name|mode	disk group #	type	Other	<- name
4005116367	enq: PM - contention	type|mode	id1	id2	Other	<- name
1675551899	ASM concurrent diskgroup dismount				Other	<- name
1641349801	ASM PST operation	op			Other	<- name
165998259	global cache busy	group	file#	block#	Other	<- name
1178367029	lock release pending	group	file#	block#	Other	<- name
768347202	dma prepare busy	group	obj#	block#	Other	<- name
882942043	GCS lock cancel	le			Other	<- name
1614997189	GCS lock open S	group	obj#	block#	Other	<- name
2914709075	GCS lock open X	group	obj#	block#	Other	<- name
2319975598	GCS lock open	group	obj#	block#	Other	<- name
4196128727	GCS lock cvt S	group	obj#	block#	Other	<- name
1477609608	GCS lock cvt X	group	obj#	block#	Other	<- name
526018501	GCS lock esc X	group	obj#	block#	Other	<- name
3407862862	GCS lock esc	group	obj#	block#	Other	<- name
3438313554	GCS recovery lock open	group	obj#	block#	Other	<- name
3795772310	GCS recovery lock convert	group	obj#	block#	Other	<- name
2200249458	kfcl: instance recovery	group	obj#	block#	Other	<- name
1446952136	no free locks				Other	<- name
3946320739	lock close	group	lms#		Other	<- name
4237717925	enq: KE - contention	type|mode	id1	id2	Other	<- name
3738539678	enq: KQ - access ASM attribute	name|mode	group	entry	Other	<- name
3252202162	ASM Volume Background				Other	<- name
1040863550	ASM volume directive send	msgop	dg	vol	Other	<- name
1113408825	ASM Volume Resource Action				Other	<- name
1869608638	enq: AV - persistent DG number	name|mode	persistent DG number	non-DG number enqs	Other	<- name
3917752439	enq: AV - volume relocate	name|mode	persistent DG number	non-DG number enqs	Other	<- name
1293149770	enq: AV - AVD client registration	name|mode	persistent DG number	non-DG number enqs	Other	<- name
845350487	enq: AV - add/enable first volume in DG	name|mode	persistent DG number	non-DG number enqs	Other	<- name
2067455519	ASM Scrubbing I/O	blkno	bytes	filetype	Other	<- name
1981525493	ASM Async Scrub				Other	<- name
1128811488	ASM Scrub Stop				Other	<- name
1140319009	ASM Scrub Running				Other	<- name
4059731982	ASM: VAM activation	group#			Other	<- name
594948517	DB Split Delay				Other	<- name
1641438405	enq: WF - contention	name|mode	0	0	Other	<- name
1872744606	enq: WT - contention	name|mode	0	0	Other	<- name
2389341073	enq: WP - contention	name|mode	0	0	Other	<- name
2941830639	enq: FU - contention	name|mode	0	0	Other	<- name
2821914527	enq: UF - undo stat flush per PDB	name|mode	0	0	Other	<- name
3539930272	enq: WI - AWR import	name|mode	0	0	Other	<- name
1743780004	enq: WE - AWR auto-export	name|mode	0	0	Other	<- name
2716218059	enq: WD - AWR mail package retrieval	name|mode	0	0	Other	<- name
2288329625	AWR Flush				Other	<- name
2618836277	AWR Metric Capture				Other	<- name
3315745697	enq: TB - SQL Tuning Base Cache Update	name|mode	1	2	Other	<- name
2878002362	enq: TB - SQL Tuning Base Cache Load	name|mode	1	2	Other	<- name
3691188946	enq: SH - contention	name|mode	0	0	Other	<- name
955173113	enq: AF - task serialization	name|mode	task id	0	Other	<- name
761672870	MMON slave messages				Other	<- name
3694317464	MMON (Lite) shutdown	process#	waited		Other	<- name
3932123875	enq: MO - contention	name|mode	0	0	Other	<- name
4246084819	enq: MM - MMON Autotask scheduling	name|mode	0	0	Other	<- name
2407027636	enq: TL - contention	name|mode	0	0	Other	<- name
3243557671	enq: TH - metric threshold evaluation	name|mode	0	0	Other	<- name
917975477	enq: TK - Auto Task Serialization	name|mode	0-MMON, 1-MMON Slave	0	Other	<- name
1739764420	enq: TK - Auto Task Slave Lockout	name|mode	0-MMON, 1-MMON Slave	0	Other	<- name
2152050500	enq: RR - contention	name|mode	lock#	not used	Other	<- name
1171942730	WCR: RAC message context busy				Other	<- name
1692125788	WCR: capture file IO write				Other	<- name
2064810505	WCR: Sync context busy				Other	<- name
339324686	latch: WCR: sync	address	number	why	Other	<- name
1606818110	latch: WCR: processes HT	address	number	why	Other	<- name
3397007672	enq: RA - RT ADDM flood control	name|mode	0	0	Other	<- name
3384888932	enq: MW - contention	name|mode	Schedule Id	0	Other	<- name
1964249173	enq: TU - UMF topology	name|mode	0	0	Other	<- name
3857332111	SPA slave messages				Other	<- name
6961751	enq: JS - job run lock - synchronize	name|mode	service ID	queue type	Other	<- name
1043516589	enq: JS - job recov lock	name|mode	service ID	queue type	Other	<- name
3418411601	enq: JS - wdw op	name|mode	service ID	queue type	Other	<- name
3478457902	enq: JS - evt notify	name|mode	service ID	queue type	Other	<- name
903782161	enq: JS - aq sync	name|mode	service ID	queue type	Other	<- name
1946447820	enq: JG - queue lock	name|mode	service ID	queue type	Other	<- name
4268683640	enq: JG - q mem clnup lck	name|mode	service ID	queue type	Other	<- name
3206939239	enq: JG - contention	name|mode	service ID	queue type	Other	<- name
4137510178	enq: JG - sch locl enqs	name|mode	service ID	queue type	Other	<- name
561979420	enq: JG - evt notify	name|mode	service ID	queue type	Other	<- name
3768795743	enq: JG - evtsub add	name|mode	service ID	queue type	Other	<- name
3926916813	enq: JG - evtsub drop	name|mode	service ID	queue type	Other	<- name
1953322323	enq: AU - ADR Purge Operation	name|mode	0	0	Other	<- name
3791535926	enq: XD - ASM disk drop/add	name|mode	opcode	notused	Other	<- name
3849855823	enq: XD - ASM disk ONLINE	name|mode	opcode	notused	Other	<- name
1707790998	enq: XD - ASM disk OFFLINE	name|mode	opcode	notused	Other	<- name
1178543798	cell worker online completion	cellhash#			Other	<- name
799178018	cell worker retry	cellhash#			Other	<- name
3247799346	cell manager cancel work request				Other	<- name
3295957859	cell manager: CRS DG unmounted list				Other	<- name
4128858080	cell manager: CRS DG start				Other	<- name
3539423858	opening cell offload device	cellhash#			Other	<- name
3591236115	ioctl to cell offload device	cellhash#			Other	<- name
3649276447	reap block level offload operations	slowcellhash#			Other	<- name
1625602236	enq: SN - PDB SGA allocation	name|mode	pdbid	0	Other	<- name
1423149423	enq: SN - PDB SGA free	name|mode	pdbid	0	Other	<- name
3660194637	enq: SN - PDB SGA protection	name|mode	pdbid	0	Other	<- name
3137068004	CDB: Per Instance Query for PDB Info				Other	<- name
4266840842	PDB relocate completion	pdbid			Other	<- name
2667320203	enq: PB - PDB Lock	name|mode	0	type	Other	<- name
1664976218	chunk move metadata prefetch				Other	<- name
3014224958	secondary event	event #	wait time		Other	<- name