Home » RDBMS Server » Server Administration » Open ref Cursor (11.1.0.7.0)
Open ref Cursor [message #448383] Tue, 23 March 2010 02:13 Go to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
How to Close All open cursors in other session.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
cursor_sharing                       string      EXACT
cursor_space_for_time                boolean     FALSE
open_cursors                         integer     500
session_cached_cursors               integer     50


Ex. as above we have 500 max cursor

seesion show 499 and now we need to flust all open cursors

How ?
Re: Open ref Cursor [message #448384 is a reply to message #448383] Tue, 23 March 2010 02:22 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
alter system flush shared_pool??
Re: Open ref Cursor [message #448385 is a reply to message #448383] Tue, 23 March 2010 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't unless you kill the session.

Modify your application then it closes its cursors when it no more needs them.

Note that OPEN_CURSORS parameter indicate the maximum number of cursors in EACH session.

Regards
Michel
Re: Open ref Cursor [message #448386 is a reply to message #448384] Tue, 23 March 2010 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yasir Hashmi wrote on Tue, 23 March 2010 02:22
alter system flush shared_pool??

Flush shared_pool does not close or flush opened cursors.

Regards
Michel

[Updated on: Tue, 23 March 2010 02:24]

Report message to a moderator

Re: Open ref Cursor [message #448387 is a reply to message #448383] Tue, 23 March 2010 02:26 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.orafaq.com/node/758

sriram Smile
Re: Open ref Cursor [message #448389 is a reply to message #448385] Tue, 23 March 2010 02:32 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Michel Cadot wrote on Tue, 23 March 2010 02:23

Modify your application then it closes its cursors when it no more needs them.

Regards
Michel


we do not have control on application as My dev is Using "Spring" frame work. and "Spring" does not allow to control the closing the Cursor.
Re: Open ref Cursor [message #448391 is a reply to message #448387] Tue, 23 March 2010 02:34 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
ramoradba wrote on Tue, 23 March 2010 02:26
http://www.orafaq.com/node/758

sriram Smile


Thanks Sriram Smile , I have already gone through this page.
Re: Open ref Cursor [message #448453 is a reply to message #448389] Tue, 23 March 2010 08:21 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

rahulvb wrote on Tue, 23 March 2010 02:32
Michel Cadot wrote on Tue, 23 March 2010 02:23

Modify your application then it closes its cursors when it no more needs them.

Regards
Michel


we do not have control on application as My dev is Using "Spring" frame work. and "Spring" does not allow to control the closing the Cursor.


Wow...and by that you mean that you can't close neither statements or result sets ?
Re: Open ref Cursor [message #448480 is a reply to message #448453] Tue, 23 March 2010 11:59 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
tahpush wrote on Tue, 23 March 2010 08:21


Wow...and by that you mean that you can't close neither statements or result sets ?


Spring Frame work takes care of that ..but somehow something has gone wrong someware Smile
Re: Open ref Cursor [message #448481 is a reply to message #448383] Tue, 23 March 2010 12:04 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then you (or someone else) are going to have to track down the problem in Spring, you can't fix this one in the DB.

EDIT: typo

[Updated on: Tue, 23 March 2010 12:04]

Report message to a moderator

Previous Topic: What Oracle EE options are in use - License compliance
Next Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Goto Forum:
  


Current Time: Fri Dec 09 02:09:19 CST 2016

Total time taken to generate the page: 0.09214 seconds