hi
can u please explain me the usage of x$kglna.
with regards,
shiva
----- Original Message -----
From: "Rahul" <rahul_at_ratelindo.co.id>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, December 21, 2000 3:55 AM
Subject: RE: x$kglna - memory corruption ?
> Mike, it works perfectly well. !!!!!!!! what;s the problem with this
column
> ?
>
> i read the docs @metalink also... this is the only workaround...
>
> thanks
>
> > ----------
> > From: Hately, Mike[SMTP:Mike.Hately_at_Derwent.co.uk]
> > Sent: Wednesday, December 20, 2000 5:45 PM
> > To: 'Rahul'; 'Oracle List II'
> > Subject: RE: x$kglna - memory corruption ?
> >
> > Rahul,
> >
> > This sounds like it's related to bug 904088 ("select from v$sqltext
> > hangs") which manifests itself by causing queries of the form :
> >
> > select sql_text from v$sqltext where hash_value = n;
> >
> > to spin and eat CPU.
> >
> > What do you get if you run the statement as :
> >
> > select * from x$kglna WHERE KGLNAHSH+0 = nnnnnnnn;
> >
> > This bug is fixed in 8.1.6.
> >
> > Regards,
> >
> > Mike Hately
> > Oracle DBA
> >
> >
> >
> > **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager.
> >
> > This footnote also confirms that this email message has been swept by
> > MIMEsweeper for the presence of computer viruses.
> >
> > www.mimesweeper.com
> > **********************************************************************
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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 Dec 21 2000 - 03:24:51 CST
