{"id":7,"date":"2011-01-05T17:18:46","date_gmt":"2011-01-05T09:18:46","guid":{"rendered":"http:\/\/j178.mtgbb.com\/281"},"modified":"2018-02-19T00:56:25","modified_gmt":"2018-02-18T16:56:25","slug":"%e7%9b%a3%e6%8e%a7-concurrent%e7%95%b0%e5%b8%b8%e8%a8%98%e9%8c%84","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=7","title":{"rendered":"\u76e3\u63a7 concurrent\u7570\u5e38\u8a18\u9304"},"content":{"rendered":"<p>\u76e3\u63a7 Concurrent \u7570\u5e38\u8a18\u9304<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT TO_CHAR(r.request_id) req_id,\r\n       DECODE(r.status_code, 'E', 'Error', 'Warning') status,\r\n       SUBSTR(pt.user_concurrent_program_name, 1, 30) program_name,\r\n       TO_CHAR(r.actual_start_date, 'yyyy\/mm\/dd hh24:mi') start_date,\r\n       TO_CHAR(r.actual_completion_date, 'yyyy\/mm\/dd hh24:mi') end_date,\r\n       (SELECT UPPER(host_name) FROM v$instance) host_name\r\n  INTO &amp;request_id,\r\n       &amp;status,\r\n       &amp;concurrent_name,\r\n       &amp;start_date,\r\n       &amp;comp_date,\r\n       &amp;host_name\r\n  FROM fnd_concurrent_requests r, fnd_concurrent_programs_tl pt\r\n WHERE (r.status_code = 'G' OR r.status_code = 'E')\r\n   AND (r.actual_start_date &lt; SYSDATE - 1 \/ 2 OR\r\n       r.actual_completion_date &lt; SYSDATE - 1 \/ 2)\r\n   AND (SELECT COUNT(r.status_code) err_cnt\r\n          FROM fnd_concurrent_requests r\r\n         WHERE (r.status_code = 'G' OR r.status_code = 'E')\r\n           AND (r.actual_start_date &lt; SYSDATE - 1 \/ 2 OR\r\n               r.actual_completion_date &lt; SYSDATE - 1 \/ 2)) &lt; 2\r\n   AND pt.concurrent_program_id = r.concurrent_program_id\r\n   AND pt.application_id = r.program_application_id\r\n ORDER BY request_id DESC<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u76e3\u63a7 Concurrent \u7570\u5e38\u8a18\u9304 SELECT TO_CHAR(r.request_id) req_id, &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[23,57],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-oracle-erp","tag-oracle-db","tag-oracle-erp"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":1,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":1165,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions\/1165"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}