{"id":442,"date":"2025-03-10T09:55:49","date_gmt":"2025-03-10T00:55:49","guid":{"rendered":"https:\/\/sejiwon.com\/?p=442"},"modified":"2025-03-10T09:55:49","modified_gmt":"2025-03-10T00:55:49","slug":"%ed%85%8c%ec%9d%b4%eb%b8%94%ec%97%90-%ec%88%98%ed%96%89%eb%90%9c-%ec%a0%84%ec%b2%b4-sql-%eb%82%a0%ec%a7%9c-%ec%8b%9c%ea%b0%84%eb%b3%84-%ea%b7%b8%eb%a3%b9","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=442","title":{"rendered":"\ud14c\uc774\ube14\uc5d0 \uc218\ud589\ub41c \uc804\uccb4 SQL \ub0a0\uc9dc\/\uc2dc\uac04\ubcc4 \uadf8\ub8f9"},"content":{"rendered":"\n<p>&#8211;SQL_ID\uc5d0 \uc704\uc5d0\uc11c \ucd94\ucd9c\ud55c SQL_ID\ub97c \uc785\ub825\ud6c4 \uc218\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT RST.BEGIN_INTERVAL_TIME\n      ,RST.SQL_ID\n      ,(SELECT SQL_OPNAME\n          FROM OWNER.TB_DBA_SQL_HIST_DETAIL X\n         WHERE X.SQL_ID = RST.SQL_ID\n           AND ROWNUM &lt;= 1) SQL_TYPE\n      ,TO_NUMBER(LISTAGG(DECODE(RST.INSTANCE_NUMBER, 1, RST.EXECUTIONS, NULL))) NODE_1\n      ,TO_NUMBER(LISTAGG(DECODE(RST.INSTANCE_NUMBER, 2, RST.EXECUTIONS, NULL))) NODE_2\n      ,TO_NUMBER(LISTAGG(DECODE(RST.INSTANCE_NUMBER, 3, RST.EXECUTIONS, NULL))) NODE_3\n      ,TO_NUMBER(LISTAGG(DECODE(RST.INSTANCE_NUMBER, 4, RST.EXECUTIONS, NULL))) NODE_4\n  FROM ( SELECT A.INSTANCE_NUMBER\n               ,TO_CHAR(B.BEGIN_INTERVAL_TIME, 'YYYY\/MM\/DD HH24')  BEGIN_INTERVAL_TIME\n               ,A.SQL_ID\n               ,SUM(A.EXECUTIONS_DELTA) EXECUTIONS\n           FROM DBA_HIST_SQLSTAT A,\n                (SELECT INSTANCE_NUMBER\n                       ,SNAP_ID\n                       ,BEGIN_INTERVAL_TIME\n                       ,END_INTERVAL_TIME\n                   FROM DBA_HIST_SNAPSHOT\n                ) B\n          WHERE 1=1\n            AND A.SNAP_ID = B.SNAP_ID\n            AND A.INSTANCE_NUMBER = B.INSTANCE_NUMBER\n            AND (A.MODULE IN ('JDBC Thin Client', 'SQL*Plus')\n                OR A.MODULE LIKE 'FC%'\n                OR A.MODULE LIKE 'sqlplus%'\n                )\n            AND TO_CHAR(B.BEGIN_INTERVAL_TIME, 'YYYYMMDDHH24') >= TO_CHAR(SYSDATE-30, 'YYYYMMDD')  --1 MONTH\n            AND A.SQL_ID IN ( 'sql_id'\n                             ,'sql_id'\n                             ,'sql_id'\n                            )\n       GROUP BY A.INSTANCE_NUMBER\n               ,TO_CHAR(B.BEGIN_INTERVAL_TIME, 'YYYY\/MM\/DD HH24')\n               ,A.SQL_ID\n       ORDER BY BEGIN_INTERVAL_TIME\n      ) RST\nGROUP BY RST.BEGIN_INTERVAL_TIME, RST.SQL_ID\nORDER BY RST.BEGIN_INTERVAL_TIME;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;SQL_ID\uc5d0 \uc704\uc5d0\uc11c \ucd94\ucd9c\ud55c SQL_ID\ub97c \uc785\ub825\ud6c4 \uc218\ud589\ud55c\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/442"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=442"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"predecessor-version":[{"id":443,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions\/443"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}