{"id":1264,"date":"2018-02-04T10:23:05","date_gmt":"2018-02-04T02:23:05","guid":{"rendered":"http:\/\/www.821121.com\/?p=1264"},"modified":"2021-01-05T17:54:05","modified_gmt":"2021-01-05T09:54:05","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e5%bd%92%e6%a1%a3%e6%97%a5%e5%bf%97%e7%94%9f%e6%88%90%e6%83%85%e5%86%b5","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1264","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u5f52\u6863\u65e5\u5fd7\u751f\u6210\u60c5\u51b5"},"content":{"rendered":"

--\u67e5\u770b\u751f\u6210\u5f52\u6863\u65e5\u5fd7\u4e2a\u6570<\/p>\n

SELECT \n      trunc(completion_time) "Date",\n      to_char(completion_time, 'Dy') "Day",\n      THREAD#,\n      dest_id,\n      count(1) "Total",\n      SUM(decode(to_char(completion_time, 'hh24'),'00',1,0)) "h0_1",\n      SUM(decode(to_char(completion_time, 'hh24'),'01',1,0)) "h1_2",\n      SUM(decode(to_char(completion_time, 'hh24'),'02',1,0)) "h2_3",\n      SUM(decode(to_char(completion_time, 'hh24'),'03',1,0)) "h3_4",\n      SUM(decode(to_char(completion_time, 'hh24'),'04',1,0)) "h4_5",\n      SUM(decode(to_char(completion_time, 'hh24'),'05',1,0)) "h5_6",\n      SUM(decode(to_char(completion_time, 'hh24'),'06',1,0)) "h6_7",\n      SUM(decode(to_char(completion_time, 'hh24'),'07',1,0)) "h7_8",\n      SUM(decode(to_char(completion_time, 'hh24'),'08',1,0)) "h8_9",\n      SUM(decode(to_char(completion_time, 'hh24'),'09',1,0)) "h9_10",\n      SUM(decode(to_char(completion_time, 'hh24'),'10',1,0)) "h10_11",\n      SUM(decode(to_char(completion_time, 'hh24'),'11',1,0)) "h11_12",\n      SUM(decode(to_char(completion_time, 'hh24'),'12',1,0)) "h12_13",\n      SUM(decode(to_char(completion_time, 'hh24'),'13',1,0)) "h13_14",\n      SUM(decode(to_char(completion_time, 'hh24'),'14',1,0)) "h14_15",\n      SUM(decode(to_char(completion_time, 'hh24'),'15',1,0)) "h15_16",\n      SUM(decode(to_char(completion_time, 'hh24'),'16',1,0)) "h16_17",\n      SUM(decode(to_char(completion_time, 'hh24'),'17',1,0)) "h17_18",\n      SUM(decode(to_char(completion_time, 'hh24'),'18',1,0)) "h18_19",\n      SUM(decode(to_char(completion_time, 'hh24'),'19',1,0)) "h19_20",\n      SUM(decode(to_char(completion_time, 'hh24'),'20',1,0)) "h20_21",\n      SUM(decode(to_char(completion_time, 'hh24'),'21',1,0)) "h21_22",\n      SUM(decode(to_char(completion_time, 'hh24'),'22',1,0)) "h22_23",\n      SUM(decode(to_char(completion_time, 'hh24'),'23',1,0)) "h23_24"\nFROM v$archived_log\ngroup by trunc(completion_time), \n         to_char(completion_time, 'Dy'),\n         THREAD#,\n         dest_id\nOrder by 1 desc,3,4 \n; <\/code><\/pre>\n
--\u67e5\u770b\u751f\u6210\u5f52\u6863\u65e5\u5fd7\u5927\u5c0f<\/p>\n
SELECT \n      trunc(completion_time) "Date",\n      to_char(completion_time, 'Dy') "Day",\n      THREAD#,\n      dest_id,\n      round(sum(blocks*block_size)\/1024\/1024) "Total_mb",\n      round(SUM(decode(to_char(completion_time, 'hh24'),'00',blocks*block_size,0))\/1024\/1024) h0_1_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'01',blocks*block_size,0))\/1024\/1024) h1_2_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'02',blocks*block_size,0))\/1024\/1024) h2_3_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'03',blocks*block_size,0))\/1024\/1024) h3_4_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'04',blocks*block_size,0))\/1024\/1024) h4_5_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'05',blocks*block_size,0))\/1024\/1024) h5_6_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'06',blocks*block_size,0))\/1024\/1024) h6_7_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'07',blocks*block_size,0))\/1024\/1024) h7_8_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'08',blocks*block_size,0))\/1024\/1024) h8_9_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'09',blocks*block_size,0))\/1024\/1024) h9_10_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'10',blocks*block_size,0))\/1024\/1024) h10_11_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'11',blocks*block_size,0))\/1024\/1024) h11_12_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'12',blocks*block_size,0))\/1024\/1024) h12_13_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'13',blocks*block_size,0))\/1024\/1024) h13_14_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'14',blocks*block_size,0))\/1024\/1024) h14_15_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'15',blocks*block_size,0))\/1024\/1024) h15_16_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'16',blocks*block_size,0))\/1024\/1024) h16_17_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'17',blocks*block_size,0))\/1024\/1024) h17_18_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'18',blocks*block_size,0))\/1024\/1024) h18_19_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'19',blocks*block_size,0))\/1024\/1024) h19_20_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'20',blocks*block_size,0))\/1024\/1024) h20_21_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'21',blocks*block_size,0))\/1024\/1024) h21_22_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'22',blocks*block_size,0))\/1024\/1024) h22_23_mb,\n      round(SUM(decode(to_char(completion_time, 'hh24'),'23',blocks*block_size,0))\/1024\/1024) h23_24_mb\nFROM v$archived_log\ngroup by trunc(completion_time), \n         to_char(completion_time, 'Dy'),\n         THREAD#,\n         dest_id\nOrder by 1 desc,3,4\n; <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
–\u67e5\u770b\u751f\u6210\u5f52\u6863\u65e5\u5fd7\u4e2a\u6570 SELECT trunc<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,48],"tags":[],"class_list":["post-1264","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-sql"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1264"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1264\/revisions"}],"predecessor-version":[{"id":1265,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1264\/revisions\/1265"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1264"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}