这个错误貌似很少见,记录一下
报错信息如下:
Sun Mar 27 20:16:50 2011
Waited too long for library cache load lock. More info in file /oracle/admin/ctais/bdump/ctais_j000_3678664.trc.
Waited too long for library cache load lock. More info in file /oracle/admin/ctais/bdump/ctais_j000_3678664.trc.
暂时处理方法:
通过如下语句查询出使用相关对象(可在相应的trc文件中找到相关对象的信息)的session,kill掉
SELECT Distinct sid using_sid,
s.SERIAL#, kglpnmod "Pin Mode", kglpnreq "Req Pin",kglnaown "Owner", kglnaobj "using_Object"
FROM x$kglpn p, v$session s,x$kglob x
WHERE p.kglpnuse=s.saddr
AND kglpnhdl=kglhdadr
And p.KGLPNUSE = s.saddr
And kglpnreq=0
s.SERIAL#, kglpnmod "Pin Mode", kglpnreq "Req Pin",kglnaown "Owner", kglnaobj "using_Object"
FROM x$kglpn p, v$session s,x$kglob x
WHERE p.kglpnuse=s.saddr
AND kglpnhdl=kglhdadr
And p.KGLPNUSE = s.saddr
And kglpnreq=0
根本原因可能是相关对象被pin死
学会了使用ass分析trc文件
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23452915/viewspace-691205/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23452915/viewspace-691205/