Re: ORACLE 8 OPS can't create index-- latch free Waiting

From: Yong Huang <yong321_at_yahoo.com>
Date: 2 Dec 2002 09:00:40 -0800
Message-ID: <b3cb12d6.0212020900.719b4423@posting.google.com>

Hi, Nilanjan,

How do you know it's the shared pool latch? In 8.0.5, it's the "loader state object freelist" latch. On my 9.0.1 database, latch# 43 is "ges process hash list". In 8.1.7, it's "dlm shared communication latch".

Yong Huang

rnilanjan_at_hotmail.com (Nilanjan Ray) wrote in message news:<b2cd9d22.0212020301.d07bcc3_at_posting.google.com>...
> Hi,
>
> The latch free is for shared pool latch. Try increase the size of
> shared pool and db block lru latches
>
> Ray
>
> ydias_at_hotmail.com (dias) wrote in message news:<55a68b47.0212010613.4bc46c04_at_posting.google.com>...
> > > 102 21961
> > > latch free
> > > address 9465528648
> > > 0700000000008148
> > > number 43
Received on Mon Dec 02 2002 - 11:00:40 CST