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

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 - 05:01:42 CST