{"id":319,"date":"2012-03-07T23:37:29","date_gmt":"2012-03-07T23:37:29","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=319"},"modified":"2012-03-07T23:37:29","modified_gmt":"2012-03-07T23:37:29","slug":"file-waits","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=319","title":{"rendered":"File waits"},"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>\nBusy Buffer Waits per file<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 145\r\nSET PAGESIZE 9999\r\n\r\nCOLUMN filename  FORMAT a58           HEAD \"File Name\"\r\nCOLUMN file#     FORMAT 999           HEAD \"File #\"\r\nCOLUMN ct        FORMAT 999,999,999   HEAD \"Waits (count)\"\r\nCOLUMN time      FORMAT 999,999,999   HEAD \"Time (cs)\"\r\nCOLUMN avg       FORMAT 999.999       HEAD \"Avg Time\"\r\n\r\n\r\nSELECT\r\n    a.indx + 1  file#\r\n  , b.name      filename\r\n  , a.count     ct\r\n  , a.time      time\r\n  , a.time\/(DECODE(a.count,0,1,a.count)) avg\r\nFROM\r\n    x$kcbfwait   a\r\n  , v$datafile   b\r\nWHERE\r\n      indx < (SELECT count(*) FROM v$datafile)\r\n  AND a.indx+1 = b.file#\r\nORDER BY a.time\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 145<br \/>\nSET PAGESIZE 9999<\/p>\n<p>COLUMN filename  FORMAT a58           HEAD \"File Name\"<br \/>\nCOLUMN file#     FORMAT 999           HEAD \"File #\"<br \/>\nCOLUMN ct        FORMAT 999,999,999   HEAD \"Waits (count)\"<br \/>\nCOLUMN time      FORMAT 999,999,999   HEAD \"Time (cs)\"<br \/>\nCOLUMN avg       FORMAT 999.999       HEAD \"Avg Time\"<\/p>\n<p>SELECT<br \/>\n    a.indx + 1  file#<br \/>\n  , b.name      filename<br \/>\n  , a.count     ct<br \/>\n  , a.time      time<br \/>\n  , a.time\/(DECODE(a.count,0,1,a.count)) avg<br \/>\nFROM<br \/>\n    x$kcbfwait   a<br \/>\n  , v$datafile   b<br \/>\nWHERE<br \/>\n      indx < (SELECT count(*) FROM v$datafile)\n  AND a.indx+1 = b.file#\nORDER BY a.time\n\/\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Busy Buffer Waits per file SET LINESIZE 145 SET PAGESIZE 9999 COLUMN filename FORMAT a58 HEAD &#8220;File Name&#8221; COLUMN file# FORMAT 999 HEAD &#8220;File #&#8221; COLUMN ct FORMAT 999,999,999 HEAD &#8220;Waits (count)&#8221; COLUMN time FORMAT 999,999,999 HEAD &#8220;Time (cs)&#8221; COLUMN avg FORMAT 999.999 HEAD &#8220;Avg Time&#8221; SELECT a.indx + 1 file# , b.name filename , [&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-319","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-59","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/319","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=319"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/319\/revisions"}],"predecessor-version":[{"id":320,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/319\/revisions\/320"}],"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=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}