Wait event name



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#
/

<br />
SET LINESIZE 135<br />
SET PAGESIZE 9999<br />
SET VERIFY   OFF</p>
<p>COLUMN event#      FORMAT 999      HEADING 'Event #'<br />
COLUMN name        FORMAT a58      HEADING 'Event Name'<br />
COLUMN parameter1  FORMAT a32      HEADING 'Parameter 1' TRUNC<br />
COLUMN parameter2  FORMAT a12      HEADING 'Parameter 2' TRUNC<br />
COLUMN parameter3  FORMAT a14      HEADING 'Parameter 3' TRUNC</p>
<p>SELECT<br />
    en.event#               event#<br />
  , en.name                 name<br />
  , en.parameter1           parameter1<br />
  , en.parameter2           parameter2<br />
  , en.parameter3           parameter3<br />
FROM v$event_name  en<br />
ORDER BY en.event#<br />
/<br />