{"id":1000,"date":"2017-08-03T21:53:27","date_gmt":"2017-08-03T12:53:27","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1000"},"modified":"2019-09-01T22:21:50","modified_gmt":"2019-09-01T13:21:50","slug":"tibero-bind_variable_capture","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-bind_variable_capture\/","title":{"rendered":"[Tibero] BIND_VARIABLE_CAPTURE"},"content":{"rendered":"

BIND_VARIABLE_CAPTURE<\/h1>\n

\n \ubd88\ud544\uc694\ud55c hard parse\ub97c \uc904\uc774\uae30 \uc704\ud574\uc11c \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294\ub370, SQL\uc5d0\uc11c \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 \ub300\uc2e0 sql_text\uc5d0 \ud574\ub2f9 \ubcc0\uc218 \uac12\uc774 \uae30\ub85d\ub418\uc9c0 \uc54a\uc544 \ub514\ubc84\uae45\uc774 \uc5b4\ub824\uc6cc\uc9c8 \uc218 \uc788\ub2e4. \uc774\ub7f0 \uacbd\uc6b0 BIND_VARIABLE_CAPTURE \ud30c\ub77c\ubbf8\ud130\ub97c \ud65c\uc131\ud654 \ud558\uc5ec \ud574\ub2f9 \ubcc0\uc218 \uac12\uc744 \uae30\ub85d\ud574\ub458 \uc218 \uc788\ub2e4.\n<\/p><\/blockquote>\n

\uc0ac\uc6a9 \ubc29\ubc95<\/h2>\n

system \uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778\ud558\uc5ec \ub2e4\uc74c \ucffc\ub9ac \uc218\ud589.<\/p>\n

SQL> alter system set BIND_VARIABLE_CAPTURE=Y;\n<\/code><\/pre>\n
\uad00\ub828 \ud30c\ub77c\ubbf8\ud130<\/h2>\n
BIND_VARIABLE_CAPTURE_MAX_COUNT<\/code>
\nv$sql_bind_capture<\/code> \ubdf0\uc5d0\uc11c \uc800\uc7a5\ud560 \ucd5c\ub300 \ubcc0\uc218 \uac1c\uc218<\/p>\n
BIND_VARIABLE_CAPTURE_INTERVAL<\/code>
\n\ud55c \uac00\uc9c0 \ud50c\ub79c\uc5d0 \ub300\ud558\uc5ec \ub9e4\ubc88 \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc218\uc9d1\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uc8fc\uae30\uc801\uc73c\ub85c \uac31\uc2e0\ud558\uac8c \ub418\ub294\ub370 \uc774 \uc8fc\uae30\ub97c \uc9c0\uc815<\/p>\n
BIND_VARIABLE_CAPTURE_MAX_VAR_COUNT<\/code>
\n\ud55c \uac00\uc9c0 \ucffc\ub9ac(\ud50c\ub79c)\uc5d0 \ub300\ud558\uc5ec \uc800\uc7a5\ud560 \ucd5c\ub300 \ubcc0\uc218 \uac1c\uc218<\/p>\n
\uad00\ub828 View<\/h2>\n
V$SQL_BIND_CAPTURE<\/code><\/p>\n
COLUMN_NAME                              TYPE               CONSTRAINT          \n---------------------------------------- ------------------ --------------------\nSQL_HASH_VALUE                           NUMBER(38)         \nPLAN_HASH_VALUE                          NUMBER(38)         \nSQL_ID                                   VARCHAR(13)        \nCHILD_NUMBER                             NUMBER(38)         \nUSER_ID                                  NUMBER(38)         \nNAME                                     VARCHAR(128)       \nPOSITION                                 NUMBER(38)         \nTYPE                                     NUMBER(38)         \nTYPE_NAME                                VARCHAR(128)       \nPRECISION                                NUMBER(38)         \nSCALE                                    NUMBER(38)         \nLENGTH                                   NUMBER(38)         \nTIME_CAPTURED                            DATE               \nVALUE                                    VARCHAR(65532) \n<\/code><\/pre>\n
v$SQL_BIND_CAPTURE_ALL<\/code><\/p>\n
COLUMN_NAME                              TYPE               CONSTRAINT          \n---------------------------------------- ------------------ --------------------\nSQL_HASH_VALUE                           NUMBER(38)         \nPLAN_HASH_VALUE                          NUMBER(38)         \nSQL_ID                                   VARCHAR(13)        \nCHILD_NUMBER                             NUMBER(38)         \nUSER_ID                                  NUMBER(38)         \nNAME                                     VARCHAR(128)       \nPOSITION                                 NUMBER(38)         \nTYPE                                     NUMBER(38)         \nTYPE_NAME                                VARCHAR(128)       \nPRECISION                                NUMBER(38)         \nSCALE                                    NUMBER(38)         \nLENGTH                                   NUMBER(38)         \nTIME_CAPTURED                            DATE               \nVALUE                                    VARCHAR(65532) \n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
BIND_VARIABLE_CAPTURE \ubd88\ud544\uc694\ud55c hard parse\ub97c \uc904\uc774\uae30 \uc704\ud574\uc11c \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294\ub370, SQL\uc5d0\uc11c \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 \ub300\uc2e0 sql_text\uc5d0 \ud574\ub2f9 \ubcc0\uc218 \uac12\uc774 \uae30\ub85d\ub418\uc9c0 \uc54a\uc544 \ub514\ubc84\uae45\uc774 \uc5b4\ub824\uc6cc\uc9c8 \uc218 \uc788\ub2e4. \uc774\ub7f0 \uacbd\uc6b0 BIND_VARIABLE_CAPTURE \ud30c\ub77c\ubbf8\ud130\ub97c \ud65c\uc131\ud654 \ud558\uc5ec \ud574\ub2f9 \ubcc0\uc218 \uac12\uc744 \uae30\ub85d\ud574\ub458 \uc218 \uc788\ub2e4. \uc0ac\uc6a9 \ubc29\ubc95 system \uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778\ud558\uc5ec \ub2e4\uc74c \ucffc\ub9ac \uc218\ud589. SQL> alter system set BIND_VARIABLE_CAPTURE=Y; \uad00\ub828 \ud30c\ub77c\ubbf8\ud130 BIND_VARIABLE_CAPTURE_MAX_COUNT v$sql_bind_capture […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[89,23],"class_list":["post-1000","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-database","tag-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1000"}],"version-history":[{"count":2,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1000\/revisions"}],"predecessor-version":[{"id":1298,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1000\/revisions\/1298"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}