RE: x$kglna - memory corruption ?

Cool! I tried it and I get it too. On NT 4.0 SP 5.

I guess I'll have to avoid doing that in my apps :).

yosi

> -----Original Message-----
> From: Rahul [mailto:rahul_at_ratelindo.co.id]
> Sent: Wednesday, December 20, 2000 11:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: x$kglna - memory corruption ?
>
>
> List, 4 months ago.. i posted a query regarding the odd behaviour of
> x$kglna... all of the x$men on this list suggested memory corruption
> and re-starting of the instance... i finally found the
> schedule to bounce
> the
> db.. but the same problem is back.....
>
> the odd behaviour of x$kglna....
>
> when i do a "select * from x$kglna" all is ok.... but when i
> select * from
> x$kglna
> WHERE KGLNAHSH = nnnnnnnn... all i get is a same rows
> REPEATED again and
> again...
> the query just returns rows and rows of same lines and never
> stops !!!
>
> all the sql pieces are exactly same the KGLHDADR and ADDR
> columns also shows
> the same value...
>
> when i try select count(*) from x$kglna where KGLNAHSH = nnnnnnnn, the
> session just
> hangs... and keeps waiting (v$session_wait) on latch 99 (lib cache)..
>
> i tried x$kgllk, x$kglcursor and v$sql...with the same
> sql_hash and all is
> ok when selecting
> from these tables...
>
> i'm running AIX 4.3.3 and 8.1.5.... and this seems to be a bug
>
> TIA
>
> Rahul
>
> --
> 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 Wed Dec 20 2000 - 13:59:05 CST