OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » close cursor (oracle 10g)

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

close cursor [message #585644]

Tue, 28 May 2013 11:47

rajasekar.p.n
Messages: 6
Registered: May 2013
Location: chennai

Junior Member

hi

In my environment found maximum open cursor exceeds error.

So how can I found the open cursor list and how can I close that cursor without restarting.

any SQL commands to close the open cursor.

Report message to a moderator

Re: close cursor [message #585645 is a reply to message #585644]

Tue, 28 May 2013 11:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>In my environment found maximum open cursor exceeds error.
the problem is an application bug that needs to be fixed; since OPEN_CURSORS per session value

Report message to a moderator

Re: close cursor [message #585648 is a reply to message #585645]

Tue, 28 May 2013 12:01

rajasekar.p.n
Messages: 6
Registered: May 2013
Location: chennai

Junior Member

Thank you swan

surely bug will be fixed with application .

and I tried out increasing OPEN_CURSORS per session value.

my question is I need to found the open cursors list and need to close/kill that open cursors by any SQL commands.

Report message to a moderator

Re: close cursor [message #585649 is a reply to message #585645]

Tue, 28 May 2013 12:02

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... in addition you cannot close the cursor opened by another session unless you kill this session.

Regards
Michel

Report message to a moderator

Re: close cursor [message #585650 is a reply to message #585648]

Tue, 28 May 2013 12:03

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read my previous answer posted at the same than yours.

Regards
Michel

Report message to a moderator

Previous Topic:	where does the pfile go?
Next Topic:	JavaArch8v3 with Oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 18:55:07 CST 2025