sqlplus hangs on infinite calling times(null)

sqlplus hangs on infinite calling times(null)



输入sqlplus回车没有反映,strace sqlplus跟踪发现在不停地调用times(NULL)

这是sqlplus 10.2.0.1的BUG, 在linux x86系统上如果运行时间大于249天就会发生
Bug 4612267 - OCI client spins when machine uptime >= 249 days

OCI clients may spin once the machine has been up for longer than
249 days (24.9 days on some machines).
The spin will show repeated calls to times() from sltrgatime64().

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

补丁:OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS
或升级到10.2.0.2及以后版本

-fin-