{"id":440,"date":"2025-03-10T09:50:35","date_gmt":"2025-03-10T00:50:35","guid":{"rendered":"https:\/\/sejiwon.com\/?p=440"},"modified":"2025-03-10T09:50:35","modified_gmt":"2025-03-10T00:50:35","slug":"%ec%b5%9c%ea%b7%bc-30%ec%9d%bc-%eb%8f%99%ec%95%88-%ed%95%b4%eb%8b%b9-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%97%90-%ec%88%98%ed%96%89%eb%90%9c-sql-%ec%b6%94%ec%b6%9c","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=440","title":{"rendered":"\ucd5c\uadfc 30\uc77c \ub3d9\uc548 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \uc218\ud589\ub41c SQL \ucd94\ucd9c"},"content":{"rendered":"\n<p>\uc544\ub798 \ucffc\ub9ac\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/* 1 MONTH *\/\nSELECT SQL_ID\n  FROM OWNER.TB_DBA_SQL_HIST_DETAIL\n WHERE 1=1\n   AND TO_CHAR(SQL_EXEC_START, 'YYYYMMDD') >= TO_CHAR(SYSDATE-30, 'YYYYMMDD')    \n   AND OBJECT_NAME LIKE '%TABLE_NAME%'  --CHECK TABLE!!\nGROUP BY SQL_ID\n;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc544\ub798 \ucffc\ub9ac\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\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\/440"}],"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=440"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions"}],"predecessor-version":[{"id":441,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions\/441"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}