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

From: melocy <melocy_at_hotmail.com>
Date: 27 Nov 2002 03:06:47 GMT
Message-ID: <8FF972712melocy21cncom@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 Tue Nov 26 2002 - 21:06:47 CST