{"id":60,"date":"2018-04-11T15:20:35","date_gmt":"2018-04-11T18:20:35","guid":{"rendered":"http:\/\/wordpress.rodrigosilvaesilva.com.br\/?p=60"},"modified":"2018-04-11T15:20:35","modified_gmt":"2018-04-11T18:20:35","slug":"ora-01000-maximum-open-cursors-exceeded","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/11\/ora-01000-maximum-open-cursors-exceeded\/","title":{"rendered":"ORA-01000 maximum open cursors exceeded"},"content":{"rendered":"<p>How to. Resolvendo ORA-01000 maximum open cursors exceeded<\/p>\n<p>Verificar configura\u00e7\u00e3o atual de cursores.<\/p>\n<pre class=\"show-plain:3 lang:plsql decode:true\">14:54:39 SYS@NBS &gt; show parameter cursor\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ncursor_bind_capture_destination      string      memory+disk\ncursor_sharing                       string      EXACT\ncursor_space_for_time                boolean     FALSE\nopen_cursors                         integer     300\nsession_cached_cursors               integer     50\n<\/pre>\n<p>Verificar configura\u00e7\u00e3o atual de cursores.<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@orcl &gt; col MAX_OPEN_CUR format a20\nSYS@orcl &gt; select max(a.value) as highest_open_cur, p.value as max_open_cur\nfrom gv$sesstat a, gv$statname b, gv$parameter p\nwhere a.statistic# = b.statistic#\nand b.name = 'opened cursors current'\nand p.name = 'open_cursors'\ngroup by p.value;\n\nHIGHEST_OPEN_CUR MAX_OPEN_CUR\n---------------- --------------------\n      177             300\n<\/pre>\n<p>Cursor aberto por usu\u00e1rio.<\/p>\n<pre class=\"lang:plsql decode:true\">Connected to:\nOracle Database 11g Release 11.2.0.4.0 - 64bit Production\n\nselect s.username, max(a.value)\nfrom v$sesstat a, v$statname b, v$session s\nwhere a.statistic# = b.statistic#\nand s.sid (+)= a.sid\nand b.name = 'opened cursors current'\ngroup by s.username;\n\nUSERNAME                       MAX(A.VALUE)\n------------------------------ ------------\nJSOUZA                                   33\nBMENEZES                                 57\nRALVESMIR                                29\nJMACENA2                                 37\nMASSAO4                                  49\nNLEITAO                                  42\nFGSILVA                                  30\nFFILHO                                  109\nTMIRANDA                                 58\nNBS2                                     67\nJANE20                                   41\nDRALVESFIS                               37\nECARLOSM                                 56\nMBRABO                                  110\nGSOUZA                                  114\nDGALDINO                                 66\nCJUNIOR                                 121\nCVALE                                    94\nASCIOLI                                  51\nLREDIG                                  160\n4VICTORIA                                56\nSYS                                       5\nJMUNIZ                                  177\n\n51 rows selected.\n<\/pre>\n<p>Alterar quantidade\u00a0 cursores.<\/p>\n<pre class=\"lang:default decode:true\">SYS@orcl &gt; alter system set open_cursors=QUANTIDADE;\n<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to. Resolvendo ORA-01000 maximum open cursors exceeded Verificar configura\u00e7\u00e3o atual de cursores. 14:54:39 SYS@NBS &gt; show parameter cursor NAME TYPE VALUE &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; cursor_bind_capture_destination string memory+disk cursor_sharing string EXACT cursor_space_for_time boolean FALSE open_cursors integer 300 session_cached_cursors integer 50 Verificar configura\u00e7\u00e3o atual de cursores. SYS@orcl &gt; col MAX_OPEN_CUR format a20 SYS@orcl &gt; select max(a.value)&#8230;<\/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":[78,193,212],"class_list":["post-60","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-cursors","tag-maximum-open-cursors-exceeded","tag-ora-01000"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}