v$event_name


select EVENT# NU,NAME,PARAMETER1 P1,PARAMETER2 P2,PARAMETER3 P3 from v$event_name;

EVENT# NAME                                   PARAMETER1           PARAMETER2        PARAMETER3
---- ---------------------------------------- -------------------- ----------------- -------------
   0 Null event
   1 latch activity                           address              number             process#
   2 latch free                               address              number             tries
   3 free process state object
   4 pmon timer                               duration
   5 inactive session                         session#             waited
   6 process startup                          type                 process#           waited
   7 debugger command
   8 rdbms ipc message block
   9 rdbms ipc reply                          from_process         timeout
  10 rdbms ipc message                        timeout
  11 enqueue                                  name|mode            id1                id2
  12 DFS enqueue lock acquisition             name|mode            id1                id2
  13 DFS enqueue lock handle                  name|mode            id1                id2
  14 DFS enqueue request cancellation         name|mode            id1                id2
  15 DFS lock request cancellation            options
  16 DFS lock release                         options
  17 DFS lock convert                         mode                 options
  18 DFS lock acquisition                     type|mode            id1                id2
  19 DFS lock handle                          type|mode            id1                id2
  20 trace writer flush
  21 trace writer I/O
  22 trace unfreeze
  23 trace continue                           delay time
  24 control file sequential read             file#                block#             blocks
  25 control file single write                file#                block#             blocks
  26 control file parallel write              files                blocks             requests
  27 free buffer waits                        file#                block#             set-id#
  28 checkpoint completed
  29 buffer for checkpoint                    buffer#              dba                state*10+mode
  30 buffer deadlock                          dba                  class*10+mode      flag
  31 buffer latch                             latch addr           chain#
  32 write complete waits                     file#                block#             id
  33 buffer read retry                        file#                block#
  34 buffer busy waits                        file#                block#             id
  35 checkpoint range buffer not saved
  36 writes stopped by instance recovery      by thread#           our thread#
  37 batched allocate scn lock request
  38 on-going SCN fetch to complete

  38 on-going SCN fetch to complete
  39 on-going reading of SCN to complete
  40 log switch/archive                       thread#
  41 log file sequential read                 log#                 block#             blocks
  42 log file single write                    log#                 block#             blocks
  43 log file parallel write                  files                blocks             requests
  44 log buffer space
  45 log file switch (checkpoint incomplete)
  46 log file switch (archiving needed)
  47 log file switch (clearing log file)
  48 switch logfile command
  49 log file switch completion
  50 log file sync                            buffer#
  51 DFS db file lock                         file#
  52 conversion file read                     file#                block#             blocks
  53 db file sequential read                  file#                block#             blocks
  54 db file scattered read                   file#                block#             blocks
  55 db file single write                     file#                block#             blocks
  56 db file parallel write                   files                blocks             requests
  57 kcl bg acks                              count                loops
  58 lock element waits                       file#                block#             lenum
  59 lock element cleanup                     file#                block#             lenum
  60 pending ast                              lenum
  61 direct access I/O                        descriptor address   first dba          block cnt
  62 queue wait
  63 transaction                              undo seg#|slot#      wrap#              count
  64 undo segment recovery                    segment#             tx flags
  65 undo segment extension                   segment#
  66 undo segment tx slot                     segment#
  67 unbound tx
  68 instance recovery                        undo segment#
  69 instance state change                    layer                value              waited
  70 smon timer                               sleep time           failed
  71 index block split                        rootdba              level              childdba
  72 dupl. cluster key                        dba
  73 row cache lock                           cache id             mode               request
  74 pending global transaction(s)            scans
  75 free global transaction table entry      tries
  76 library cache pin                        handle address       pin address        10*mode+namespace
  77 library cache lock                       handle address       lock address       10*mode+namespace
  78 library cache load lock                  object address       lock address       10*mask+namespace
  79 dispatcher shutdown                      waited
  80 virtual circuit status                   circuit#             status
  81 dispatcher timer                         sleep time
  82 single-task message
  83 SQL*Net message to client                driver id            #bytes
  84 SQL*Net message to dblink                driver id            #bytes
  85 SQL*Net more data to client              driver id            #bytes
  86 SQL*Net more data to dblink              driver id            #bytes
  87 SQL*Net message from client              driver id            #bytes
  88 SQL*Net more data from client            driver id            #bytes
  89 SQL*Net message from dblink              driver id            #bytes
  90 SQL*Net more data from dblink            driver id            #bytes
  91 SQL*Net break/reset to client            driver id            break?
  92 SQL*Net break/reset to dblink            driver id            break?
  93 PL/SQL lock timer                        duration
  94 pipe get                                 handle address       buffer length      timeout
  95 pipe put                                 handle address       record length      timeout
  96 parallel query qref latch                function             sleeptime          qref
  97 parallel query dequeue wait              reason               sleeptime/senderid passes
  98 parallel query server shutdown           nalive               sleeptime          loop
  99 parallel query create server             nservers             sleeptime          enqueue
 100 parallel query signal server             serial               error              nbusy
 101 timer in sksawat
 102 scginq AST call
 103 DBWR I/O to Slave
 104 Slave DBWR Timer
 105 secondary event                          event #              wait time


SQL> desc v$event_name
 Name                            Null?    Type
 ------------------------------- -------- ----
 EVENT#                                   NUMBER
 NAME                                     VARCHAR2(64)
 PARAMETER1                               VARCHAR2(64)
 PARAMETER2                               VARCHAR2(64)
 PARAMETER3                               VARCHAR2(64)

SQL> set pagesize 0
set heading off
column NU  format 999
column NAME format A40
column P1 format A20
column P2 format A18
column P3 format A17
select EVENT# NU,NAME,PARAMETER1 P1,PARAMETER2 P2,PARAMETER3 P3 from v$event_name;


Questions or comments ? Send a note to khailey@fr.oracle.com