OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Cached Cursor

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

Cached Cursor [message #275992]

Tue, 23 October 2007 10:23

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

On Oracle 10g the count of cached cursor is too high,is it possible to set CLOSE_CACHED_OPEN_CURSORS to true without restart the database

Report message to a moderator

Re: Cached Cursor [message #275994 is a reply to message #275992]

Tue, 23 October 2007 10:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

too bad you are unwilling or incapable to simply try it yourself.

SQL> alter system set CLOSE_CACHED_OPEN_CURSORS=true;
alter system set CLOSE_CACHED_OPEN_CURSORS=true
*
ERROR at line 1:
ORA-25138: CLOSE_CACHED_OPEN_CURSORS initialization parameter has been made
obsolete

Report message to a moderator

Re: Cached Cursor [message #276006 is a reply to message #275992]

Tue, 23 October 2007 11:13

Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How could this be too high?
Why do you think it is?
How do you measure it?

Regards
Michel

Report message to a moderator

Previous Topic:	Performance impact on Oracle
Next Topic:	Join query gettin poor performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 22:22:52 CST 2024