表锁了

mywg

dbimport;

.....
drop database;

...

dbimport


??

考虑考虑？

vanwu

在进行什么操作的时候锁的表？

hzhrh

用户数据库根本就进不去了，但是系统数据库能进去。

小叶子sy

你们的数据库里表是行锁的吗?就是LOCKLEVEL='R'吗?
我们也常锁表,但用下面查查看哪个进程锁的是做频繁的,然后
ONMODE -Z SID,好象就可以恢复了呀!??
Select L.dbsname,L.tabname,L.type as Lock_Type,
       S.username as Owner__Name , W.username as Waiter_Name ,
       S.sid as Own_SID , S.pid as Own_PID , S.uid as Own_UID ,
       W.sid as Wait_SID, W.pid as Wait_PID, W.uid as Wait_UID ,
       Z.logspused as Current_tran_size, Z.maxlogsp as Largest_tran_size
  From sysmaster:syslocks L ,sysmaster:syssessions S ,
       outer sysmaster:syssessions W ,sysmaster:syssesprof Z
Where L.type='X' and L.owner = S.sid and L.Waiter = W.sid and Z.sid = S.sid

zoukunhong

查看系统表syslocks可以知道锁的信息。