{"id":1440,"date":"2020-02-11T20:29:36","date_gmt":"2020-02-11T11:29:36","guid":{"rendered":"http:\/\/cromi.com\/?p=1440"},"modified":"2020-02-11T13:35:54","modified_gmt":"2020-02-11T04:35:54","slug":"ora-01000%ec%97%90%eb%9f%ac-maximum-open-cursors-exceeded","status":"publish","type":"post","link":"http:\/\/cromi.com\/?p=1440","title":{"rendered":"ORA-01000\uc5d0\ub7ec (maximum open cursors exceeded)"},"content":{"rendered":"\n<p>SHOW PARAMETER OPEN_CURSORS;\u00a0 \uc124\uc815\ub41c \ucee4\uc11c\u00a0 \ud655\uc778 <\/p>\n<p><b>NAME\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TYPE\u00a0 \u00a0 \u00a0VALUE<\/b><\/p>\n<p><b>&#8212;&#8212;&#8212;&#8212;\u00a0 &#8212;&#8212;-\u00a0 &#8212;&#8212;&#8212;-<\/b><\/p>\n<p><b>open_cursors\u00a0 integer\u00a0 600<\/b><\/p>\n<ul>\n<li><b>\uc138\uc158\ub2f9 600\uac1c\uc758 \ucee4\uc11c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub77c\uace0 \ud45c\uc2dc\u00a0<\/b><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<ul>\n<li>\u00a0<\/li>\n<\/ul>\n<p><b>[\uc624\ud508\ucee4\uc11c \ud655\uc778]<\/b><\/p>\n<p><b>SELECT O.SID, OSUSER, MACHINE, COUNT(*) NUM_CURS<\/b><\/p>\n<p><b>\u00a0 FROM V$OPEN_CURSOR O<\/b><\/p>\n<p><b>\u00a0 \u00a0 \u00a0 \u00a0JOIN V$SESSION S<\/b><\/p>\n<p><b>\u00a0 \u00a0 ON S.SID = O.SID\u00a0<\/b><\/p>\n<p><b>\u00a0WHERE user_name = &#8216;\uc0ac\uc6a9\uc790\uba85 \ub300\ubb38\uc790\ub85c \ud45c\uc2dc&#8217;\u00a0\u00a0<\/b><\/p>\n<p><b>\u00a0GROUP BY O.SID, OSUSER, MACHINE\u00a0<\/b><\/p>\n<p><b>\u00a0ORDER BY NUM_CURS DESC;<\/b><\/p>\n<p><b>[\ucee4\uc11c\uc5d0 \ud574\ub2f9\ud558\ub294 \ucffc\uae30 \ub0b4\uc6a9\uc870\ud68c]<\/b><\/p>\n<p><b>SELECT Q.SQL_TEXT\u00a0<\/b><\/p>\n<p><b>\u00a0 FROM V$OPEN_CURSOR O<\/b><\/p>\n<p><b>\u00a0 \u00a0 \u00a0 \u00a0JOIN V$SQL Q<\/b><\/p>\n<p><b>\u00a0 \u00a0 ON Q.HASH_VALUE=O.HASH_VALUE<\/b><\/p>\n<p><b>\u00a0WHERE O.SID = \uc5f4\ub9b0 \ucee4\uc11c \uc218\uc5d0\uc11c \ud655\uc778\ud55c SID \uac12;<\/b><b><\/b><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>SHOW PARAMETER OPEN_CURSORS;\u00a0 \uc124\uc815\ub41c \ucee4\uc11c\u00a0 \ud655\uc778 NAME\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TYPE\u00a0 \u00a0 \u00a0VALUE &#8212;&#8212;&#8212;&#8212;\u00a0 &#8212;&#8212;-\u00a0 &#8212;&#8212;&#8212;- open_cursors\u00a0 integer\u00a0 600 \uc138\uc158\ub2f9 600\uac1c\uc758 \ucee4\uc11c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub77c\uace0 \ud45c\uc2dc\u00a0 \u00a0 \u00a0 [\uc624\ud508\ucee4\uc11c \ud655\uc778] SELECT O.SID, OSUSER, MACHINE, COUNT(*) NUM_CURS \u00a0 FROM V$OPEN_CURSOR O \u00a0 \u00a0 \u00a0 \u00a0JOIN V$SESSION S \u00a0 \u00a0 ON S.SID = O.SID\u00a0 \u00a0WHERE user_name [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[567,566],"class_list":["post-1440","post","type-post","status-publish","format-standard","hentry","category-working-tip","tag-ora-01000","tag-oracle"],"_links":{"self":[{"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/posts\/1440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/cromi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1440"}],"version-history":[{"count":1,"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/posts\/1440\/revisions"}],"predecessor-version":[{"id":1441,"href":"http:\/\/cromi.com\/index.php?rest_route=\/wp\/v2\/posts\/1440\/revisions\/1441"}],"wp:attachment":[{"href":"http:\/\/cromi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cromi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1440"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cromi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}