x$kglna - memory corruption ?

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 20 Dec 2000 12:35:06 +0700
Message-Id: <10716.124986@fatcity.com>

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 Received on Tue Dec 19 2000 - 23:35:06 CST