Kingbase数据库中查询锁表以及解锁
根据被锁表的表名,查询出oid(表名区分大小写)
select oid from sys_class where relname = '表名';
根据查询出的oid,查询出pid
select pid from sys_locks where relation = 'oid';
根据pid,强制结束该进程
select sys_terminate_backend(pid);
根据被锁表的表名,查询出oid(表名区分大小写)
select oid from sys_class where relname = '表名';
根据查询出的oid,查询出pid
select pid from sys_locks where relation = 'oid';
根据pid,强制结束该进程
select sys_terminate_backend(pid);