Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> x$kglna gone crazy !!

x$kglna gone crazy !!

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 6 Sep 2000 19:03:15 +0700
Message-Id: <10611.116291@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US