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

Hi,

could you explain why do you think that the wait is for the shared pool latch, and why do you advise to increase the "db block lru latches".

thanks

Dias

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>...
> > Hi,
> >
> > Could you give more statistics !
> > Witch latch is involoved ? query v$latch to start.
> >
> > Dias
> >
> > melocy_at_hotmail.com (melocy) wrote in message news:<8FF972712melocy21cncom_at_130.133.1.4>...
> > > ORACLE 8 OPS can't create index-- latch free Waiting
> > > environment£º
> > > ORACLE 805 OPS IS RUNNING 3 NODE RS6000 S7A CLUSTER HACMP AIX 4.3.2
> > > trouble£º
> > > create table t1 (c1 varchar2(20)); -------successful
> > > create index idx_t1 on t1(c1) ; -------hang
> > >
> > > take a look : v$session_wait
> > >
> > > SID SEQ#
> > > ---------- ----------
> > > EVENT
> > > ----------------------------------------------------------------
> > > P1TEXT P1
> > > ---------------------------------------------------------------- ----------
> > > P1RAW
> > > ----------------
> > > P2TEXT P2
> > > ---------------------------------------------------------------- ----------
> > > P2RAW
> > > ----------------
> > > P3TEXT P3
> > > ---------------------------------------------------------------- ----------
> > > P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
> > > ---------------- ---------- --------------- -------------------
> > >
> > > 102 21961
> > > latch free
> > > address 9465528648
> > > 0700000000008148
> > > number 43
> > > 000000000000002B
> > > tries 21356
> > > 000000000000536C 0
> > > 82-------------------------------------------------------------------------
> > > -------
> > >
> > > Anyone Who can give me some advice ?
> > > Thanks.
Received on Mon Dec 02 2002 - 14:50:42 CST