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

From: dias <ydias_at_hotmail.com>
Date: 1 Dec 2002 06:13:31 -0800
Message-ID: <55a68b47.0212010613.4bc46c04@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 Sun Dec 01 2002 - 08:13:31 CST