Message-Id: <10717.125091@fatcity.com> From: "siva" Date: Thu, 21 Dec 2000 09:24:51 -0000 Subject: Re: x$kglna - memory corruption ? hi can u please explain me the usage of x$kglna. with regards, shiva ----- Original Message ----- From: "Rahul" To: "Multiple recipients of list ORACLE-L" 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@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@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@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).