{"id":325,"date":"2012-03-07T23:47:33","date_gmt":"2012-03-07T23:47:33","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=325"},"modified":"2012-03-07T23:47:33","modified_gmt":"2012-03-07T23:47:33","slug":"log-switch-size","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=325","title":{"rendered":"Log switch size"},"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>\nLog switch daily (size)<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 250\r\nSET PAGESIZE 9999\r\nSET TRIMSPOOL ON\r\nSET VERIFY   off\r\nCOLUMN H00   FORMAT 99,999     HEADING '00'\r\nCOLUMN H01   FORMAT 99,999     HEADING '01'\r\nCOLUMN H02   FORMAT 99,999     HEADING '02'\r\nCOLUMN H03   FORMAT 99,999     HEADING '03'\r\nCOLUMN H04   FORMAT 99,999     HEADING '04'\r\nCOLUMN H05   FORMAT 99,999     HEADING '05'\r\nCOLUMN H06   FORMAT 99,999     HEADING '06'\r\nCOLUMN H07   FORMAT 99,999     HEADING '07'\r\nCOLUMN H08   FORMAT 99,999     HEADING '08'\r\nCOLUMN H09   FORMAT 99,999     HEADING '09'\r\nCOLUMN H10   FORMAT 99,999     HEADING '10'\r\nCOLUMN H11   FORMAT 99,999     HEADING '11'\r\nCOLUMN H12   FORMAT 99,999     HEADING '12'\r\nCOLUMN H13   FORMAT 99,999     HEADING '13'\r\nCOLUMN H14   FORMAT 99,999     HEADING '14'\r\nCOLUMN H15   FORMAT 99,999     HEADING '15'\r\nCOLUMN H16   FORMAT 99,999     HEADING '16'\r\nCOLUMN H17   FORMAT 99,999     HEADING '17'\r\nCOLUMN H18   FORMAT 99,999     HEADING '18'\r\nCOLUMN H19   FORMAT 99,999     HEADING '19'\r\nCOLUMN H20   FORMAT 99,999     HEADING '20'\r\nCOLUMN H21   FORMAT 99,999     HEADING '21'\r\nCOLUMN H22   FORMAT 99,999     HEADING '22'\r\nCOLUMN H23   FORMAT 99,999     HEADING '23'\r\nCOLUMN TOTAL FORMAT 999,999    HEADING 'Total'\r\nSELECT\r\n    SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)                                                               DAY\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'00',ROUND(((blocks*block_size)\/1024\/1024)),0)) H00\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'01',ROUND(((blocks*block_size)\/1024\/1024)),0)) H01\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'02',ROUND(((blocks*block_size)\/1024\/1024)),0)) H02\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'03',ROUND(((blocks*block_size)\/1024\/1024)),0)) H03\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'04',ROUND(((blocks*block_size)\/1024\/1024)),0)) H04\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'05',ROUND(((blocks*block_size)\/1024\/1024)),0)) H05\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'06',ROUND(((blocks*block_size)\/1024\/1024)),0)) H06\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'07',ROUND(((blocks*block_size)\/1024\/1024)),0)) H07\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'08',ROUND(((blocks*block_size)\/1024\/1024)),0)) H08\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'09',ROUND(((blocks*block_size)\/1024\/1024)),0)) H09\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'10',ROUND(((blocks*block_size)\/1024\/1024)),0)) H10\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'11',ROUND(((blocks*block_size)\/1024\/1024)),0)) H11\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'12',ROUND(((blocks*block_size)\/1024\/1024)),0)) H12\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'13',ROUND(((blocks*block_size)\/1024\/1024)),0)) H13\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'14',ROUND(((blocks*block_size)\/1024\/1024)),0)) H14\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'15',ROUND(((blocks*block_size)\/1024\/1024)),0)) H15\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'16',ROUND(((blocks*block_size)\/1024\/1024)),0)) H16\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'17',ROUND(((blocks*block_size)\/1024\/1024)),0)) H17\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'18',ROUND(((blocks*block_size)\/1024\/1024)),0)) H18\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'19',ROUND(((blocks*block_size)\/1024\/1024)),0)) H19\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'20',ROUND(((blocks*block_size)\/1024\/1024)),0)) H20\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'21',ROUND(((blocks*block_size)\/1024\/1024)),0)) H21\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'22',ROUND(((blocks*block_size)\/1024\/1024)),0)) H22\r\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'23',ROUND(((blocks*block_size)\/1024\/1024)),0)) H23\r\n  , ROUND(SUM((blocks*block_size)\/1024\/1024))                                                                                                           TOTAL\r\nFROM\r\n  v$archived_log  a\r\nGROUP BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)\r\nORDER BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 250<br \/>\nSET PAGESIZE 9999<br \/>\nSET TRIMSPOOL ON<br \/>\nSET VERIFY   off<br \/>\nCOLUMN H00   FORMAT 99,999     HEADING '00'<br \/>\nCOLUMN H01   FORMAT 99,999     HEADING '01'<br \/>\nCOLUMN H02   FORMAT 99,999     HEADING '02'<br \/>\nCOLUMN H03   FORMAT 99,999     HEADING '03'<br \/>\nCOLUMN H04   FORMAT 99,999     HEADING '04'<br \/>\nCOLUMN H05   FORMAT 99,999     HEADING '05'<br \/>\nCOLUMN H06   FORMAT 99,999     HEADING '06'<br \/>\nCOLUMN H07   FORMAT 99,999     HEADING '07'<br \/>\nCOLUMN H08   FORMAT 99,999     HEADING '08'<br \/>\nCOLUMN H09   FORMAT 99,999     HEADING '09'<br \/>\nCOLUMN H10   FORMAT 99,999     HEADING '10'<br \/>\nCOLUMN H11   FORMAT 99,999     HEADING '11'<br \/>\nCOLUMN H12   FORMAT 99,999     HEADING '12'<br \/>\nCOLUMN H13   FORMAT 99,999     HEADING '13'<br \/>\nCOLUMN H14   FORMAT 99,999     HEADING '14'<br \/>\nCOLUMN H15   FORMAT 99,999     HEADING '15'<br \/>\nCOLUMN H16   FORMAT 99,999     HEADING '16'<br \/>\nCOLUMN H17   FORMAT 99,999     HEADING '17'<br \/>\nCOLUMN H18   FORMAT 99,999     HEADING '18'<br \/>\nCOLUMN H19   FORMAT 99,999     HEADING '19'<br \/>\nCOLUMN H20   FORMAT 99,999     HEADING '20'<br \/>\nCOLUMN H21   FORMAT 99,999     HEADING '21'<br \/>\nCOLUMN H22   FORMAT 99,999     HEADING '22'<br \/>\nCOLUMN H23   FORMAT 99,999     HEADING '23'<br \/>\nCOLUMN TOTAL FORMAT 999,999    HEADING 'Total'<br \/>\nSELECT<br \/>\n    SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)                                                               DAY<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'00',ROUND(((blocks*block_size)\/1024\/1024)),0)) H00<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'01',ROUND(((blocks*block_size)\/1024\/1024)),0)) H01<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'02',ROUND(((blocks*block_size)\/1024\/1024)),0)) H02<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'03',ROUND(((blocks*block_size)\/1024\/1024)),0)) H03<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'04',ROUND(((blocks*block_size)\/1024\/1024)),0)) H04<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'05',ROUND(((blocks*block_size)\/1024\/1024)),0)) H05<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'06',ROUND(((blocks*block_size)\/1024\/1024)),0)) H06<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'07',ROUND(((blocks*block_size)\/1024\/1024)),0)) H07<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'08',ROUND(((blocks*block_size)\/1024\/1024)),0)) H08<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'09',ROUND(((blocks*block_size)\/1024\/1024)),0)) H09<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'10',ROUND(((blocks*block_size)\/1024\/1024)),0)) H10<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'11',ROUND(((blocks*block_size)\/1024\/1024)),0)) H11<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'12',ROUND(((blocks*block_size)\/1024\/1024)),0)) H12<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'13',ROUND(((blocks*block_size)\/1024\/1024)),0)) H13<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'14',ROUND(((blocks*block_size)\/1024\/1024)),0)) H14<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'15',ROUND(((blocks*block_size)\/1024\/1024)),0)) H15<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'16',ROUND(((blocks*block_size)\/1024\/1024)),0)) H16<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'17',ROUND(((blocks*block_size)\/1024\/1024)),0)) H17<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'18',ROUND(((blocks*block_size)\/1024\/1024)),0)) H18<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'19',ROUND(((blocks*block_size)\/1024\/1024)),0)) H19<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'20',ROUND(((blocks*block_size)\/1024\/1024)),0)) H20<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'21',ROUND(((blocks*block_size)\/1024\/1024)),0)) H21<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'22',ROUND(((blocks*block_size)\/1024\/1024)),0)) H22<br \/>\n  , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'23',ROUND(((blocks*block_size)\/1024\/1024)),0)) H23<br \/>\n  , ROUND(SUM((blocks*block_size)\/1024\/1024))                                                                                                           TOTAL<br \/>\nFROM<br \/>\n  v$archived_log  a<br \/>\nGROUP BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)<br \/>\nORDER BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)<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>Log switch daily (size) SET LINESIZE 250 SET PAGESIZE 9999 SET TRIMSPOOL ON SET VERIFY off COLUMN H00 FORMAT 99,999 HEADING &#8217;00&#8217; COLUMN H01 FORMAT 99,999 HEADING &#8217;01&#8217; COLUMN H02 FORMAT 99,999 HEADING &#8217;02&#8217; COLUMN H03 FORMAT 99,999 HEADING &#8217;03&#8217; COLUMN H04 FORMAT 99,999 HEADING &#8217;04&#8217; COLUMN H05 FORMAT 99,999 HEADING &#8217;05&#8217; COLUMN H06 FORMAT [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":61,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-325","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5f","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/325","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=325"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/325\/revisions"}],"predecessor-version":[{"id":326,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/325\/revisions\/326"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/61"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}