Wait event name

March 7th, 2012

Oracle Wait Interface event names

SET LINESIZE 135
SET PAGESIZE 9999
SET VERIFY   OFF

COLUMN event#      FORMAT 999      HEADING 'Event #'
COLUMN name        FORMAT a58      HEADING 'Event Name'
COLUMN parameter1  FORMAT a32      HEADING 'Parameter 1' TRUNC
COLUMN parameter2  FORMAT a12      HEADING 'Parameter 2' TRUNC
COLUMN parameter3  FORMAT a14      HEADING 'Parameter 3' TRUNC


SELECT
    en.event#               event#
  , en.name                 name
  , en.parameter1           parameter1
  , en.parameter2           parameter2
  , en.parameter3           parameter3
FROM v$event_name  en
ORDER BY en.event#
/


Comments are closed.