Re: close_cached_open_cursors "error"

From: <Shreepad.Vaidya_at_alltel.com>
Date: Thu, 22 Nov 2001 01:18:52 -0800
Message-ID: <F001.003CB599.20011122005517@fatcity.com>

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                                                         
     
                    <EvaD_at_TFMC.co.       To:     Multiple recipients of list ORACLE-L  
     
                    za>                   <ORACLE-L_at_fatcity.com>                       
     
                                         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: Shreepad.Vaidya_at_alltel.com

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: ListGuru_at_fatcity.com (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). Received on Thu Nov 22 2001 - 03:18:52 CST