{"id":330,"date":"2012-03-08T00:28:09","date_gmt":"2012-03-08T00:28:09","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=330"},"modified":"2012-03-08T05:28:36","modified_gmt":"2012-03-08T05:28:36","slug":"waiter-count","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=330","title":{"rendered":"Waiter count"},"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>\nWaits count for each event type<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nset linesize 200\r\n\r\nselect \/*+ ordered *\/\r\n  substr(n.name, 1, 29)  event,\r\n  t0,\r\n  t1,\r\n  t2,\r\n  t3,\r\n  t4,\r\n  t5,\r\n  t6,\r\n  t7,\r\n  t8,\r\n  t9\r\nfrom\r\n  sys.v_$event_name  n,\r\n  (select event e0, count(*)  t0 from sys.v_$session_wait group by event),\r\n  (select event e1, count(*)  t1 from sys.v_$session_wait group by event),\r\n  (select event e2, count(*)  t2 from sys.v_$session_wait group by event),\r\n  (select event e3, count(*)  t3 from sys.v_$session_wait group by event),\r\n  (select event e4, count(*)  t4 from sys.v_$session_wait group by event),\r\n  (select event e5, count(*)  t5 from sys.v_$session_wait group by event),\r\n  (select event e6, count(*)  t6 from sys.v_$session_wait group by event),\r\n  (select event e7, count(*)  t7 from sys.v_$session_wait group by event),\r\n  (select event e8, count(*)  t8 from sys.v_$session_wait group by event),\r\n  (select event e9, count(*)  t9 from sys.v_$session_wait group by event)\r\nwhere\r\n  n.name != 'Null event' and\r\n  n.name != 'null event' and\r\n  n.name != 'rdbms ipc message' and\r\n  n.name != 'pipe get' and\r\n  n.name != 'virtual circuit status' and\r\n  n.name not like '%timer%' and\r\n  n.name not like '%slave wait' and\r\n  n.name not like 'SQL*Net message from %' and\r\n  n.name not like 'io done' and\r\n  n.name != 'queue messages' and\r\n  e0 (+) = n.name and\r\n  e1 (+) = n.name and\r\n  e2 (+) = n.name and\r\n  e3 (+) = n.name and\r\n  e4 (+) = n.name and\r\n  e5 (+) = n.name and\r\n  e6 (+) = n.name and\r\n  e7 (+) = n.name and\r\n  e8 (+) = n.name and\r\n  e9 (+) = n.name and\r\n  nvl(t0, 0) + nvl(t1, 0) + nvl(t2, 0) + nvl(t3, 0) + nvl(t4, 0) +\r\n  nvl(t5, 0) + nvl(t6, 0) + nvl(t7, 0) + nvl(t8, 0) + nvl(t9, 0) > 0\r\norder by\r\n  nvl(t0, 0) + nvl(t1, 0) + nvl(t2, 0) + nvl(t3, 0) + nvl(t4, 0) +\r\n  nvl(t5, 0) + nvl(t6, 0) + nvl(t7, 0) + nvl(t8, 0) + nvl(t9, 0)\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nset linesize 200<\/p>\n<p>select \/*+ ordered *\/<br \/>\n  substr(n.name, 1, 29)  event,<br \/>\n  t0,<br \/>\n  t1,<br \/>\n  t2,<br \/>\n  t3,<br \/>\n  t4,<br \/>\n  t5,<br \/>\n  t6,<br \/>\n  t7,<br \/>\n  t8,<br \/>\n  t9<br \/>\nfrom<br \/>\n  sys.v_$event_name  n,<br \/>\n  (select event e0, count(*)  t0 from sys.v_$session_wait group by event),<br \/>\n  (select event e1, count(*)  t1 from sys.v_$session_wait group by event),<br \/>\n  (select event e2, count(*)  t2 from sys.v_$session_wait group by event),<br \/>\n  (select event e3, count(*)  t3 from sys.v_$session_wait group by event),<br \/>\n  (select event e4, count(*)  t4 from sys.v_$session_wait group by event),<br \/>\n  (select event e5, count(*)  t5 from sys.v_$session_wait group by event),<br \/>\n  (select event e6, count(*)  t6 from sys.v_$session_wait group by event),<br \/>\n  (select event e7, count(*)  t7 from sys.v_$session_wait group by event),<br \/>\n  (select event e8, count(*)  t8 from sys.v_$session_wait group by event),<br \/>\n  (select event e9, count(*)  t9 from sys.v_$session_wait group by event)<br \/>\nwhere<br \/>\n  n.name != 'Null event' and<br \/>\n  n.name != 'null event' and<br \/>\n  n.name != 'rdbms ipc message' and<br \/>\n  n.name != 'pipe get' and<br \/>\n  n.name != 'virtual circuit status' and<br \/>\n  n.name not like '%timer%' and<br \/>\n  n.name not like '%slave wait' and<br \/>\n  n.name not like 'SQL*Net message from %' and<br \/>\n  n.name not like 'io done' and<br \/>\n  n.name != 'queue messages' and<br \/>\n  e0 (+) = n.name and<br \/>\n  e1 (+) = n.name and<br \/>\n  e2 (+) = n.name and<br \/>\n  e3 (+) = n.name and<br \/>\n  e4 (+) = n.name and<br \/>\n  e5 (+) = n.name and<br \/>\n  e6 (+) = n.name and<br \/>\n  e7 (+) = n.name and<br \/>\n  e8 (+) = n.name and<br \/>\n  e9 (+) = n.name and<br \/>\n  nvl(t0, 0) + nvl(t1, 0) + nvl(t2, 0) + nvl(t3, 0) + nvl(t4, 0) +<br \/>\n  nvl(t5, 0) + nvl(t6, 0) + nvl(t7, 0) + nvl(t8, 0) + nvl(t9, 0) > 0<br \/>\norder by<br \/>\n  nvl(t0, 0) + nvl(t1, 0) + nvl(t2, 0) + nvl(t3, 0) + nvl(t4, 0) +<br \/>\n  nvl(t5, 0) + nvl(t6, 0) + nvl(t7, 0) + nvl(t8, 0) + nvl(t9, 0)<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>Waits count for each event type set linesize 200 select \/*+ ordered *\/ substr(n.name, 1, 29) event, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9 from sys.v_$event_name n, (select event e0, count(*) t0 from sys.v_$session_wait group by event), (select event e1, count(*) t1 from sys.v_$session_wait group by event), (select event e2, count(*) t2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":59,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-330","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5k","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/330","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=330"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/330\/revisions"}],"predecessor-version":[{"id":335,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/330\/revisions\/335"}],"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=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}