OraFAQ Forum: Server Administration » Open Cursors (merged)

Home » RDBMS Server » Server Administration » Open Cursors (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Open Cursors (merged) [message #229023]

Thu, 05 April 2007 01:35

oracle_coorgi
Messages: 188
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

Report message to a moderator

Re: open cursors [message #229027 is a reply to message #229023]

Thu, 05 April 2007 01:42

Frank Naude
Messages: 4580
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.

Report message to a moderator

Re: open cursors [message #229065 is a reply to message #229027]

Thu, 05 April 2007 04:33

oracle_coorgi
Messages: 188
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

Report message to a moderator

dictionary table not found [message #229075 is a reply to message #229023]

Thu, 05 April 2007 04:52

oracle_coorgi
Messages: 188
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:41:15 CDT 2024