Home » RDBMS Server » Performance Tuning » Cached Cursor
Cached Cursor [message #275992] Tue, 23 October 2007 10:23 Go to next message
Messages: 199
Registered: March 2007
Karma: 0
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
Re: Cached Cursor [message #275994 is a reply to message #275992] Tue, 23 October 2007 10:27 Go to previous messageGo to next message
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
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
Re: Cached Cursor [message #276006 is a reply to message #275992] Tue, 23 October 2007 11:13 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
How could this be too high?
Why do you think it is?
How do you measure it?

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

Current Time: Tue Aug 22 09:59:31 CDT 2017

Total time taken to generate the page: 0.10480 seconds