{"id":489,"date":"2013-02-04T22:08:41","date_gmt":"2013-02-04T13:08:41","guid":{"rendered":"http:\/\/www.freesens.com\/x\/?p=489"},"modified":"2013-02-04T22:08:41","modified_gmt":"2013-02-04T13:08:41","slug":"toad-plan-%eb%9c%b0%eb%95%8c-ora-01031-%eb%b0%9c%ec%83%9d%ec%8b%9c-%ec%b2%98%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/www.freesens.com\/x\/?p=489","title":{"rendered":"toad plan \ub730\ub54c ORA-01031 \ubc1c\uc0dd\uc2dc \ucc98\ub9ac."},"content":{"rendered":"<p>\ucffc\ub9ac \uc791\uc131 \ud6c4 plan\uc744 \ub5a0\ubcf4\uace0 \uc2f6\uc740\ub370&#8230;..\uc790\uafb8 &#8220;ORA-01031: \uad8c\ud55c\uc774 \ubd88\ucda9\ubd84\ud569\ub2c8\ub2e4&#8221; \ub77c\ub294 \uba54\uc2dc\uc9c0\ub9cc \ubc18\ud658\ud574\uc11c \uc65c \uadf8\ub7f0\uac00 \ud558\uace0 \ucc3e\uc544\ubcf4\ub2c8&#8230;.\uc815\ub9d0 \uad8c\ud55c\uc774 \uc5c6\uc5b4\uc11c \uadf8\ub807\ub2e4\ub294;;;;<br \/>\nsysdba \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud574\uc11c \uad8c\ud55c\uc744 \uc8fc\ub77c\ub294 \ub4f1&#8230;.\uc5ec\ub7ec\uac00\uc9c0 \ud574\uacb0\ucc45\uc774 \uc788\uc73c\ub098 \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud574\uacb0 \uac00\ub2a5\ud568.<\/p>\n<p>Toad\uc5d0\uc11c&#8230;&#8230;  View &#8211; Toad Options &#8211; Oracle &#8211; General &#8211; Explain Plan \uc5d0\uc11c&#8230;.Schema \ubd80\ubd84\uc744 \ube44\uc6b4\ub4a4 \uc801\uc6a9\ud558\uba74 \ub428..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucffc\ub9ac \uc791\uc131 \ud6c4 plan\uc744 \ub5a0\ubcf4\uace0 \uc2f6\uc740\ub370&#8230;..\uc790\uafb8 &#8220;ORA-01031: \uad8c\ud55c\uc774 \ubd88\ucda9\ubd84\ud569\ub2c8\ub2e4&#8221; \ub77c\ub294 \uba54\uc2dc\uc9c0\ub9cc \ubc18\ud658\ud574\uc11c \uc65c \uadf8\ub7f0\uac00 \ud558\uace0 \ucc3e\uc544\ubcf4\ub2c8&#8230;.\uc815\ub9d0 \uad8c\ud55c\uc774 \uc5c6\uc5b4\uc11c \uadf8\ub807\ub2e4\ub294;;;; sysdba \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud574\uc11c \uad8c\ud55c\uc744 \uc8fc\ub77c\ub294 \ub4f1&#8230;.\uc5ec\ub7ec\uac00\uc9c0 \ud574\uacb0\ucc45\uc774 \uc788\uc73c\ub098 \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud574\uacb0 \uac00\ub2a5\ud568. Toad\uc5d0\uc11c&#8230;&#8230; View &#8211; Toad Options &#8211; Oracle &#8211; General &#8211; Explain Plan \uc5d0\uc11c&#8230;.Schema \ubd80\ubd84\uc744 \ube44\uc6b4\ub4a4 \uc801\uc6a9\ud558\uba74 \ub428..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[24,83,61,28,62],"class_list":["post-489","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle","tag-plan","tag-toad","tag-28","tag-62"],"_links":{"self":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=489"}],"version-history":[{"count":1,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/489\/revisions"}],"predecessor-version":[{"id":490,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/489\/revisions\/490"}],"wp:attachment":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=489"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}