{"id":321,"date":"2012-03-07T23:40:44","date_gmt":"2012-03-07T23:40:44","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=321"},"modified":"2012-03-07T23:40:44","modified_gmt":"2012-03-07T23:40:44","slug":"wait-event-name","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=321","title":{"rendered":"Wait event name"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nOracle Wait Interface event names<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 135\r\nSET PAGESIZE 9999\r\nSET VERIFY   OFF\r\n\r\nCOLUMN event#      FORMAT 999      HEADING 'Event #'\r\nCOLUMN name        FORMAT a58      HEADING 'Event Name'\r\nCOLUMN parameter1  FORMAT a32      HEADING 'Parameter 1' TRUNC\r\nCOLUMN parameter2  FORMAT a12      HEADING 'Parameter 2' TRUNC\r\nCOLUMN parameter3  FORMAT a14      HEADING 'Parameter 3' TRUNC\r\n\r\n\r\nSELECT\r\n    en.event#               event#\r\n  , en.name                 name\r\n  , en.parameter1           parameter1\r\n  , en.parameter2           parameter2\r\n  , en.parameter3           parameter3\r\nFROM v$event_name  en\r\nORDER BY en.event#\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 135<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   OFF<\/p>\n<p>COLUMN event#      FORMAT 999      HEADING 'Event #'<br \/>\nCOLUMN name        FORMAT a58      HEADING 'Event Name'<br \/>\nCOLUMN parameter1  FORMAT a32      HEADING 'Parameter 1' TRUNC<br \/>\nCOLUMN parameter2  FORMAT a12      HEADING 'Parameter 2' TRUNC<br \/>\nCOLUMN parameter3  FORMAT a14      HEADING 'Parameter 3' TRUNC<\/p>\n<p>SELECT<br \/>\n    en.event#               event#<br \/>\n  , en.name                 name<br \/>\n  , en.parameter1           parameter1<br \/>\n  , en.parameter2           parameter2<br \/>\n  , en.parameter3           parameter3<br \/>\nFROM v$event_name  en<br \/>\nORDER BY en.event#<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Wait Interface event names SET LINESIZE 135 SET PAGESIZE 9999 SET VERIFY OFF COLUMN event# FORMAT 999 HEADING &#8216;Event #&#8217; COLUMN name FORMAT a58 HEADING &#8216;Event Name&#8217; COLUMN parameter1 FORMAT a32 HEADING &#8216;Parameter 1&#8217; TRUNC COLUMN parameter2 FORMAT a12 HEADING &#8216;Parameter 2&#8217; TRUNC COLUMN parameter3 FORMAT a14 HEADING &#8216;Parameter 3&#8217; TRUNC SELECT en.event# event# [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":59,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-321","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5b","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=321"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/321\/revisions"}],"predecessor-version":[{"id":322,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/321\/revisions\/322"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/59"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}