Re: ORA-01000 when altering table

D Morrow (morrowd_at_ci.portsmouth.va.us) wrote:
: Has anyone encountered the ORA-01000: maximum number of cursors exceeded
: error when trying to add a column to a table using the ALTER TABLE command.
: I changed the value of OPEN_CURSORS from default of 50 up to 200 and still
: received the error. It is not a large table (51 columns/about 5000 rows).
:
: Any direction or guidance would be appreciated.
:
: Thanx in advance

Three things:
1) You must shut down and restart the database for the new OPEN_CURSORS

   value to take effect. Make sure you do this. 2) You should explicitly CLOSE your cursors if you are opening them in

   PL/SQL or third-party tools. Otherwise you will continue to accumulate    cursors until you exceed your limit. 3) You can find out how many cursors are open with:

   SELECT * FROM V$SYSSTAT WHERE NAME LIKE '%cursor%';

Best of luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 175+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->