2020-06-28

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.

2020-06-25

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.

2020-06-24

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.

2020-06-23

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 4th 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. 

2020-06-22

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: 
 


2020-06-20

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. 

2020-06-19

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.

2020-06-08

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