OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Open ref Cursor (11.1.0.7.0)

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

Open ref Cursor [message #448383]

Tue, 23 March 2010 02:13

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 ?

Report message to a moderator

Re: Open ref Cursor [message #448384 is a reply to message #448383]

Tue, 23 March 2010 02:22

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

alter system flush shared_pool??

Report message to a moderator

Re: Open ref Cursor [message #448385 is a reply to message #448383]

Tue, 23 March 2010 02:23

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

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

Report message to a moderator

Re: Open ref Cursor [message #448386 is a reply to message #448384]

Tue, 23 March 2010 02:23

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

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

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://www.orafaq.com/node/758

sriram Smile

Report message to a moderator

Re: Open ref Cursor [message #448389 is a reply to message #448385]

Tue, 23 March 2010 02:32

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.

Report message to a moderator

Re: Open ref Cursor [message #448391 is a reply to message #448387]

Tue, 23 March 2010 02:34

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

Thanks Sriram Smile

, I have already gone through this page.

Report message to a moderator

Re: Open ref Cursor [message #448453 is a reply to message #448389]

Tue, 23 March 2010 08:21

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 ?

Report message to a moderator

Re: Open ref Cursor [message #448480 is a reply to message #448453]

Tue, 23 March 2010 11:59

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

Report message to a moderator

Re: Open ref Cursor [message #448481 is a reply to message #448383]

Tue, 23 March 2010 12:04

cookiemonster
Messages: 13962
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:22:54 CST 2025