{"id":91,"date":"2020-07-07T17:08:59","date_gmt":"2020-07-07T08:08:59","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=91"},"modified":"2020-07-07T17:09:00","modified_gmt":"2020-07-07T08:09:00","slug":"post-91","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=91","title":{"rendered":"ASH\u95a2\u9023\u306e\u96a0\u3057SQL"},"content":{"rendered":"<p>\u904e\u53bb\uff11\u6642\u9593\u306e\u5f85\u6a5f\u30a4\u30d9\u30f3\u30c8<br \/>\nselect distinct to_char(sample_time,&#8217;HH24:MI&#8217;) end_time,<br \/>\nevent,<br \/>\ncount(*) sample_count<br \/>\nfrom gv$active_session_history<br \/>\nwhere<br \/>\n&#8212; (sample_time &gt; localtimestamp &#8211; INTERVAL &#8217;60:00&#8242; MINUTE TO SECOND )<br \/>\nsample_time &gt; sysdate &#8211; 1\/24<br \/>\nand event is not null<br \/>\nand wait_class=:WAIT_CLASS<br \/>\ngroup by (sample_time,&#8217;HH24:MI&#8217;),event<br \/>\norder by end_time;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u904e\u53bb\uff11\u6642\u9593\u306e\u5f85\u6a5f\u30a4\u30d9\u30f3\u30c8 select distinct to_char(sample_time,&#8217;HH24<\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=91\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/91"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":1,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":92,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions\/92"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}