今天查数据库, 有400多个INACTIVE 的 JDBC DEDICATED 连接,
22038 2008/12/14 10:44:42 813 JDBC Thin Client INACTIVE 284029 497517
22048 2008/12/14 10:44:45 808 JDBC Thin Client INACTIVE 284029 497517
22053 2008/12/14 10:44:46 806 JDBC Thin Client INACTIVE 284029 497517
22063 2008/12/14 10:44:48 801 JDBC Thin Client INACTIVE 284029 497517
22065 2008/12/14 10:44:48 800 JDBC Thin Client INACTIVE 284029 497517
22067 2008/12/14 10:44:48 799 JDBC Thin Client INACTIVE 284029 497517
22069 2008/12/14 10:44:49 798 JDBC Thin Client INACTIVE 284029 497517
22071 2008/12/14 10:44:49 797 JDBC Thin Client INACTIVE 284029 497517
22073 2008/12/14 10:44:49 796 JDBC Thin Client INACTIVE 284029 497517
SQL> host ps -ef|grep 15567
oracle 15567 1 0 Jan16 ? 00:00:01 oracleORASTAGE (LOCAL=NO)
oracle 8120 8067 0 13:07 pts/0 00:00:00 /bin/bash -c ps -ef|grep 15567
oracle 8122 8120 0 13:07 pts/0 00:00:00 grep 15567
SQL> host ps -el|grep 15567
0 S 500 15567 1 0 76 0 - 327954 353124 ? 00:00:01 oracle
用KILL -9 杀了 1月1日以前的INACTIVE JDBC SESSION后, 结果用户说不能跑SQL 了, 只能重启APPLICATION SERVER.
怎么回事?