--查看事件描述
col enqueue for a15
col "enqueue type" for a15
col description for a25
col p1 for a15
col p2 for a15
col p3 for a15
set pagesize 190
SELECT
    eq_name              "Enqueue",
    ev.name              "Enqueue Type",
    eq.req_description   "Description" ,
    ev.parameter1        "P1",
    ev.parameter2        "P2",
    ev.parameter3        "P3"
FROM
    v$enqueue_statistics   eq,
    v$event_name           ev
WHERE
    eq.event#(+) = ev.event#
    AND ev.name LIKE '%&event_name%'
ORDER BY
    ev.name;
  • No labels
Write a comment…