Cached Cursor [message #275992] |
Tue, 23 October 2007 10:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
Re: Cached Cursor [message #276006 is a reply to message #275992] |
Tue, 23 October 2007 11:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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
|
|
|