Home » RDBMS Server » Server Administration » close cursor (oracle 10g)
close cursor [message #585644] Tue, 28 May 2013 11:47 Go to next message
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.
Re: close cursor [message #585645 is a reply to message #585644] Tue, 28 May 2013 11:53 Go to previous messageGo to next message
BlackSwan
Messages: 22800
Registered: January 2009
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
Re: close cursor [message #585648 is a reply to message #585645] Tue, 28 May 2013 12:01 Go to previous messageGo to next message
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.
Re: close cursor [message #585649 is a reply to message #585645] Tue, 28 May 2013 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... in addition you cannot close the cursor opened by another session unless you kill this session.

Regards
Michel
Re: close cursor [message #585650 is a reply to message #585648] Tue, 28 May 2013 12:03 Go to previous message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read my previous answer posted at the same than yours.

Regards
Michel
Previous Topic: where does the pfile go?
Next Topic: JavaArch8v3 with Oracle 11g
Goto Forum:
  


Current Time: Mon Sep 22 16:04:02 CDT 2014

Total time taken to generate the page: 0.11048 seconds