| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Why event "global cache lock open x " wait forever?
Evironment:2 * RS6000 AIX4.3.2 Oracle805 OPS(db1,db2)
on db2,one transaction is that:
set transaction use rollback segment rbig;
delete from aaa.t1;
insert into aaa.t1 select * from bbb.t1;
commit;
WHEN execute statement "Insert into ....",
process hang.
query v$session_wait,event is "global cache lock open x "
query v$session_event,event "global cache lock open x"
total_waits is adding continually and total_timeouts is adding too.
Help me ,Pls.
Thx.
Received on Tue Oct 08 2002 - 21:12:57 CDT
 |
 |