Re: Oracle 9i Latching Issue

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: Fri, 28 Mar 2008 10:25:11 -0700 (PDT)
Message-ID: <9860409d-2976-4f74-8274-c9c09857854c@a23g2000hsc.googlegroups.com>

>
> You might look at Metalink Note 163424.1 to investigate the 'hot
> block' angle.
>

Thanks David, that was a great pointer. As I suspected Discoverer has caused some issues with latch waits on the DUAL table (I had already created a local dual table for all EUL schemas to minimise this).

There was also high waits on the SYS.I_OBJ2 index on the sys.I_OBJ2 table.

SEGMENT_NAME	TCH
SYS.I_OBJ2	2028
OPSKPI_EUL.DUAL	1648

Im going to investigate further but it looks likely i will move all our Discoverer EUL schemas onto their own server.

cheers Received on Fri Mar 28 2008 - 12:25:11 CDT

Original text of this message