{"id":406,"date":"2024-12-13T16:38:39","date_gmt":"2024-12-13T07:38:39","guid":{"rendered":"https:\/\/sejiwon.com\/?p=406"},"modified":"2024-12-13T16:38:39","modified_gmt":"2024-12-13T07:38:39","slug":"query-%ec%84%b1%eb%8a%a5%ed%99%95%ec%9d%b8-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=406","title":{"rendered":"Query \uc131\ub2a5\ud655\uc778 \ubc29\ubc95"},"content":{"rendered":"\n<p>\uba3c\uc800, ASIS\uc640 TOBE\uc758 SQLID\ub97c \ube44\uad50\ud558\ub294 \uac83\uc774 \uc88b\uc744 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uac04\ub2e8\ud55c \uc0ac\ud56d\ub9cc \ud655\uc778\ud560 \uacbd\uc6b0\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SQL_ID\n      ,DISK_READS\n      ,PHYSICAL_READ_BYTES\n      ,LAST_LOAD_TIME\n      ,OPTIMIZER_COST\n      ,OPTIMIZER_MODE\n      ,FIRST_LOAD_TIME\n      ,END_OF_FETCH_COUNT\n      ,EXECUTIONS\n      ,BUFFER_GETS\n  FROM V$SQL\n WHERE SQL_ID ID ('ASIS_SQLID', 'TOBE_SQLID')\nORDER BY 4\n;<\/code><\/pre>\n\n\n\n<p>\uc704 \ubcf4\ub2e4 \ub354 \uc790\uc138\ud788 \ub0b4\uc6a9\uc744 \ud655\uc778\ud574 \ubcf4\uace0 \uc2f6\uc744 \ub54c\ub294 \uc544\ub798\uc640 \uac19\uc774 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SQL_ID\n      ,CHILD_NUMBER\n      ,PARSING_SCHEMA_NAME\n      ,SHARABLE_MEM\n      ,PERSISTENT_MEM\n      ,RUNTIME_MEM\n      ,LOADS\n      ,INVALIDATIONS\n      ,PARSE_CALLS\n      ,EXECUTIONS\n      ,FETCHES\n      ,ROWS_PROCESSED\n      ,CPU_TIME\n      ,ELAPSED_TIME\n      ,BUFFER_GETS\n      ,DISK_READS\n      ,SORTS\n      ,APPLICATION_WAIT_TIME\n      ,CONCURRENCY_WAIT_TIME\n      ,CLUSTER_WAIT_TIME\n      ,USER_IO_WAIT_TIME\n      ,FIRST_LOAD_TIME\n      ,LAST_ACTIVE_TIME\n  FROM V$SQL\n WHERE SQL_ID ID ('ASIS_SQLID', 'TOBE_SQLID')\nORDER BY FIRST_LOAD_TIME, CHILD_NUMBER\n;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-verse\">\uc704\uc640 \uc544\ub798\ub97c \uc801\uc808\ud788 \uc11e\uc5b4\uc11c \ud544\uc694\ud55c \ubd80\ubd84\uc744 \ud655\uc778\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uba3c\uc800, ASIS\uc640 TOBE\uc758 SQLID\ub97c \ube44\uad50\ud558\ub294 \uac83\uc774 \uc88b\uc744 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ub429\ub2c8\ub2e4. \uac04\ub2e8\ud55c \uc0ac\ud56d\ub9cc \ud655\uc778\ud560 \uacbd\uc6b0\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc704 \ubcf4\ub2e4 \ub354 \uc790\uc138\ud788 \ub0b4\uc6a9\uc744 \ud655\uc778\ud574 \ubcf4\uace0 \uc2f6\uc744 \ub54c\ub294 \uc544\ub798\uc640 \uac19\uc774 \ud569\ub2c8\ub2e4. \uc704\uc640 \uc544\ub798\ub97c \uc801\uc808\ud788 \uc11e\uc5b4\uc11c \ud544\uc694\ud55c \ubd80\ubd84\uc744 \ud655\uc778\ud558\uc2dc\uba74 \ub429\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\/406"}],"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=406"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/406\/revisions"}],"predecessor-version":[{"id":407,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/406\/revisions\/407"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}