There is not much info available on X$ tables (from Oracle). Check Steve Adam's site (http://www.ixora.com.au/). Search for x$ table. You may find what you are looking for.
- Kirti > -----Original Message----- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Friday, November 23, 2001 4:40 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: close_cached_open_cursors "error" > > 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:[EMAIL PROTECTED]] > 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. > > > --- [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
