It is an underscored one. Issue this query to look its value:
select ksppinm,ksppstvl from x$ksppcv b,x$ksppi a where a.indx=b.indx and ksppinm like '%close_cached%'; Regards. --- [EMAIL PROTECTED] wrote: > > Hi Eva , > Closed_cache_open_cursors is a parameter in Oracle > 7.3.4.x .This is > obsolete in oracle 8.x > If set in u r init.ora remove it. > OR > Some product is setting this at Alter > system /Alter session > > HTH > > shreepad. > This parameter controls whether cursors opened and > cached in memory > by PL/SQL are automatically closed at each COMMIT. A > value of > FALSE signifies that cursors opened by PL/SQL are > held open so that > subsequent executions need not open a new cursor. If > PL/SQL cursors > are reused frequently, setting the parameter to > FALSE can cause > subsequent executions to be faster. > A value of TRUE causes open cursors to be closed at > each COMMIT or > ROLLBACK. The cursor can then be reopened as needed. > If cursors are > rarely reused, setting the parameter to TRUE frees > memory used by the > cursor when the cursor is no longer in use. > > > > > Denham Eva > > <[EMAIL PROTECTED] To: > Multiple recipients of list ORACLE-L > za> > <[EMAIL PROTECTED]> > cc: > > 21/11/01 22:26 Subject: > close_cached_open_cursors "error" > Please respond > > to ORACLE-L > > > > > > > > > Hello Guru's > > I hope someone can shed light on this problem, more > a nuisance really. > The below Alter Session statement has been appearing > in the *alrt.log file. > > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > ALTER SESSION SET close_cached_open_cursors > specifies an obsolete parameter > > The system is a Compaq 8500R system, Win2K and > Oracle 817. > Does anyone have an idea of what this is as everyone > I have approached here > at my work claims not to be using it, I suspect a > third party product. > > Absolutely any info will be appreciated. > > TIA > Denham > > _____ > > This e-mail message has been scanned for Viruses and > Content and cleared by > MailMarshal - For more information please visit > www.marshalsoftware.com < > http://www.marshalsoftware.com> > _____ > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
