Hi...
how i can come to know about all x$ tables...
is there dictionary is there for it?
Please let me know.
Rgds,
Nirmal.
-----Original Message-----
From: Christian Trassens [SMTP:ctrassens_at_yahoo.com]
Sent: Thursday, November 22, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: close_cached_open_cursors "error"
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.
- Shreepad.Vaidya_at_alltel.com 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
>
> <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).
ENG. Christian Trassens
Senior DBA
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
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: ctrassens_at_yahoo.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 Fri Nov 23 2001 - 05:40:22 CST
