x$kglna gone crazy !!

List, (8.1.5 AIX)
i tried to get the sql_text from x$kglna where kglnahsh = nnnn the session waited ..and waited on a "library cache latch" and just hanged...!!
and when i give a select withoug the hash value condition, the rows retured were duplicated !!!
same addr,kglhadr, and same hash values !! it was displaying the pieces over and over again !!!

i have tried flushing the shared pool but no luck.,. how to diag this kind of problem ??

TIA Received on Wed Sep 06 2000 - 07:03:15 CDT