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
> **********************************************************************
Received on Wed Dec 20 2000 - 21:46:58 CST