Re: Why event "global cache lock open x " wait forever?

1.i query which sql the transaction is processing: select sid,username,sql_hash_value,status from v$session where sid=xx; select sql_text from v$sqlarea where hash_value= the transaction is processing "insert into aaa.t1 select * from bbb.t1".

2. i query which event the session is waiting select sid,event,p1raw,p2raw from v$session where sid=xx; and i find the event is "global cache lock open x" and p1raw is 17 /*file#*/
and p2raw is 998 /*block#*/

3. i query which object is in file# 17 and block# 998 select name,kind from ext_to_obj_view
where file#=17
and lowb<=998
and highb>=998;

and it tell me the object is a INDEX.

4 so i try to DROP INDEX all indexes on aaa.t1 and DISABLE CONSTRAINT   all constraints
  and reexecute my transaction,and NOW SUCCESSFULLY.

5 RESULT:i think perhaps some block corruptions of indexes. Received on Wed Oct 09 2002 - 03:10:23 CDT