RE: x$kglna gone crazy !!

Steve/List,

the script returns this..

VERSION_COUNT CURSORS

-------------------- ---------
1                          869
2 to 3                     215
4 to 7                      22
9 to 12                      3
16 to 27                     4

very few statements have a high version count, now the statement "select * from x$kglna where kglnahsh=nnn" DOES NOT HANG instead it starts returning row and never stops !! same "piece" is repeated over an over again..(for the same hash, x$kglcursor returns only ONE row).
Another interesting thing is...when i do a select * from x$kglna (without the "where" clause)
it returns rows in a normal way !!(no duplicates)

the instance is 3 days old, optimizer mode is CHOOSE and all the schema is analyzed.
Latch free is the number one in system_event. library_cache latch has the most number of
sleeps(v$latch) and v$latch_children shows one one of the 7 latches is responsible for more
than 80% of the total sleeps. i have also identified objects protected by this latch (ixora's script).

Regards
Rahul

> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Sent: Wednesday, September 06, 2000 8:24 PM
> To: Rahul; 'Oracle List I'; 'Oracle List II'
> Subject: RE: x$kglna gone crazy !!
>
> 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
>
>
> --------
> 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
Received on Wed Sep 06 2000 - 21:48:23 CDT