Home » RDBMS Server » Server Administration » Open Cursors (merged)
Open Cursors (merged) [message #229023] Thu, 05 April 2007 01:35 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
its urgent
can any one let know how to find how many cursors have been used and opened if opened whether it is closed in my init.ora file i have given value for open_cursors = 300 (default)
i am getting error
1.ORA-01000: maximum open cursors exceeded
2.Fails with ORA-0100 error after inserting around 298 records against open_cursor limit of 300.
thanxs

Re: open cursors [message #229027 is a reply to message #229023] Thu, 05 April 2007 01:42 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
select from v$open_cursor. Also, see http://orafaq.com/node/758

PS: Best solution is to increase the parameter and get it done with.

Re: open cursors [message #229065 is a reply to message #229027] Thu, 05 April 2007 04:33 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
how to find how many cursor is opened and closed
do u have any way to find how many cursor is closed
is there any way i can close cursor
i have increased open_cursor value from 300 to 1000 by altering the system parameter but still i get the error
dictionary table not found [message #229075 is a reply to message #229023] Thu, 05 April 2007 04:52 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
sorry got it
its v$open_cursor;

SQL> desc v$open_cursors;
ERROR:
ORA-04043: object v$open_cursors does not exist
both in 9i and 10g

[Updated on: Thu, 05 April 2007 04:54]

Report message to a moderator

Re: dictionary table not found [message #229083 is a reply to message #229075] Thu, 05 April 2007 05:33 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

What user are you connecting as ?
Does that user have the correct priviliges ?

Oki red your update Razz

[Updated on: Thu, 05 April 2007 05:40]

Report message to a moderator

Previous Topic: How to Find ML Level
Next Topic: sysman audit question
Goto Forum:
  


Current Time: Tue Dec 06 10:39:19 CST 2016

Total time taken to generate the page: 0.11756 seconds