Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> session_cached_cursors

session_cached_cursors

From: <bulbultyagi_at_now-india.net.in>
Date: Sat, 26 Jul 2003 20:27:57 +0530
Message-Id: <26025.339746@fatcity.com>


Hello list ,
Performance tuning docs say that : "To enable the caching of session cursors you must set the initialization parameter set session_cached_cursors. You can also enable it dynamically with alter session set"

But neither of the following works on 9.2.0.1.0 enterprise edition (win32)

alter system set session_cached_cursors=10 scope=memory;
alter system set session_cached_cursors=10 scope=spfile;
alter system set session_cached_cursors=10 scope=both;

However this works
alter session set session_cached_cursors=10 ;

Why ?

................
Received on Sat Jul 26 2003 - 09:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US