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).
