RE: x$kglna gone crazy !!

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 6 Sep 2000 23:24:35 +1000
Message-Id: <10611.116293@fatcity.com>

Hi Rahul,

This sounds like one of the high version count problems. Why don't you get the version_count.sql script from the Ixora web site and check it out?

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Wednesday, 6 September 2000 22:03
To: 'Oracle List I'; 'Oracle List II'
Subject: 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 Rahul

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Wed Sep 06 2000 - 08:24:35 CDT