{"id":1270,"date":"2018-02-05T17:19:15","date_gmt":"2018-02-05T09:19:15","guid":{"rendered":"http:\/\/www.821121.com\/?p=1270"},"modified":"2021-01-06T17:20:23","modified_gmt":"2021-01-06T09:20:23","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e6%9f%a5%e7%9c%8b%e6%95%b4%e4%bd%93%e8%bf%90%e8%a1%8c%e6%97%b6%e9%97%b4%e6%9c%80%e9%95%bf%e7%9a%84sql","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1270","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u67e5\u770b\u6574\u4f53\u8fd0\u884c\u65f6\u95f4\u6700\u957f\u7684sql"},"content":{"rendered":"<p>\u67e5\u770b\u6574\u4f53\u8fd0\u884c\u65f6\u95f4\u6700\u957f\u7684sql<\/p>\n<pre><code class=\"language-sql\">SELECT a.INST_ID,a.SQL_ID,\na.CPU_TIME, --CPU\u65f6\u95f4 \u767e\u4e07\u5206\u4e4b\u4e00\uff08\u5fae\u79d2\uff09        \n      a.OPTIMIZER_MODE,--\u4f18\u5316\u65b9\u5f0f        \n      a.EXECUTIONS,--\u6267\u884c\u6b21\u6570        \n      a.DISK_READS,--\u8bfb\u76d8\u6b21\u6570        \n      a.SHARABLE_MEM,--\u5360\u7528shared pool\u7684\u5185\u5b58\u591a\u5c11        \n      a.BUFFER_GETS,--\u8bfb\u53d6\u7f13\u51b2\u533a\u7684\u6b21\u6570        \n      a.COMMAND_TYPE,--\u547d\u4ee4\u7c7b\u578b(3:select,2:insert;6:update;7delete; 47l\/sql\u7a0b\u5e8f\u5355\u5143)        \n      a.SQL_TEXT,--Sql\u8bed\u53e5        \n      a.SHARABLE_MEM,        \n      a.PERSISTENT_MEM,        \n      a.RUNTIME_MEM,        \n      a.PARSE_CALLS,        \n      a.DISK_READS,        \n      a.DIRECT_WRITES,        \n      a.CONCURRENCY_WAIT_TIME,        \n      a.USER_IO_WAIT_TIME   \nfrom gV$SQLAREA a  \norder by a.CPU_TIME desc;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u6574\u4f53\u8fd0\u884c\u65f6\u95f4\u6700\u957f\u7684sql SELECT a.I<\/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-1270","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\/1270","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=1270"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1270\/revisions"}],"predecessor-version":[{"id":1272,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1270\/revisions\/1272"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1270"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}