{"id":619,"date":"2013-01-17T17:30:41","date_gmt":"2013-01-17T09:30:41","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=619"},"modified":"2013-01-22T23:34:38","modified_gmt":"2013-01-22T15:34:38","slug":"scripts%e6%9f%a5%e7%9c%8brman%e5%a4%87%e4%bb%bd%e6%81%a2%e5%a4%8d%e8%bf%9b%e5%ba%a6","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=619","title":{"rendered":"scripts:\u67e5\u770brman\u5907\u4efd\u6062\u590d\u8fdb\u5ea6"},"content":{"rendered":"<p>\u67e5\u770brman\u5907\u4efd\u6062\u590d\u8fdb\u5ea6<br \/>\n<coolcode lang=\"sql\"><br \/>\nset line 200<br \/>\ncol sid for 9999<br \/>\ncol opname for a35<\/p>\n<p>select inst_id,<br \/>\n       sid,<br \/>\n       serial#,<br \/>\n       opname,<br \/>\n       COMPLETE,<br \/>\n       trunc(((to_char(last_update_time, 'dd') - to_char(start_time, 'dd')) * 60 * 24 +<br \/>\n             (to_char(last_update_time, 'hh24') -<br \/>\n             to_char(start_time, 'hh24')) * 60 +<br \/>\n             (to_char(last_update_time, 'mi') - to_char(start_time, 'mi'))) * 100 \/<br \/>\n             complete) min<br \/>\n  from (SELECT inst_id,<br \/>\n               sid,<br \/>\n               serial#,<br \/>\n               opname,<br \/>\n               ROUND(SOFAR \/ TOTALWORK * 100, 2) COMPLETE,<br \/>\n               LAST_UPDATE_TIME,<br \/>\n               START_TIME<br \/>\n          FROM gV$SESSION_LONGOPS<br \/>\n         WHERE OPNAME LIKE 'RMAN%'<br \/>\n           AND OPNAME NOT LIKE '%aggregate%'<br \/>\n           AND TOTALWORK != 0<br \/>\n           AND SOFAR <> TOTALWORK);<br \/>\n<\/coolcode><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770brman\u5907\u4efd\u6062\u590d\u8fdb\u5ea6 set line 200 col sid for 9999 col opname f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[74,71,72,73],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/619"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=619"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/619\/revisions"}],"predecessor-version":[{"id":635,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/619\/revisions\/635"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=619"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}