Home » RDBMS Server » Performance Tuning » Cached Cursor
Cached Cursor [message #275992] Tue, 23 October 2007 10:23 Go to next message
preet_kumar
Messages: 195
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
Re: Cached Cursor [message #275994 is a reply to message #275992] Tue, 23 October 2007 10:27 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: Cached Cursor [message #276006 is a reply to message #275992] Tue, 23 October 2007 11:13 Go to previous message
Michel Cadot
Messages: 64151
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
Previous Topic: Performance impact on Oracle
Next Topic: Join query gettin poor performance
Goto Forum:
  


Current Time: Fri Dec 09 19:13:42 CST 2016

Total time taken to generate the page: 0.12790 seconds