|
编译的存储过程的时候程序死住等待一会出现ora错误解决办法: 可能被锁住 查看v$lockedselect bsidbserial#bmachinebterminalbprogrambprocessbstatus from v$lock a v$session b where aSID = bSID 得到死锁session的SIDSERIAL#参看这个是否为你自己用户下的然后kill掉session 可能被挂起 查看v$session_waitselect bserial#a* from v$session_wait av$session bwhere asid = bsid得到等待的session的sid和serial#查看dba_ddl_locksselect session_id sid owner name typemode_held held mode_requested request from dba_ddl_locks where name = &your_package_name |
