标题: ORA-29770: global enqueue process string (OSID string) is hung for more than ... [打印本页] 作者: 刘泽宇 时间: 2024-5-11 17:40 标题: ORA-29770: global enqueue process string (OSID string) is hung for more than ... ORA-29770: global enqueue process string (OSID string) is hung for more than string seconds
原因: The specified process mades no progress within the maximum allowed time.
这是一种数据库错误，系统检测到OSID类型的全局锁定进程超时，从而导致无法进行余下的操作。
一般处理方法及步骤
1.确认受影响的OSID和进程号。可以通过以下查询查找这些信息：
SELECT s.sid || ',' || s.serial# ki , os.ksvbris, s.status FROM v$session s, v$process os WHERE s.paddr = os.addr ORDER BY s.status;