oracle的session过多问题
现象:oracle一到两天,表session中增加至120几条记录,一般在这时,应用系统(web,使用tomcat发布)登录不进去.请帮着分析是什么原因,怎么解决?(此时有很多OSUSER="SYSTEM"的session,状态是inactive状态)
LOGON_TIME SADDR SID PADDR STATUS OSUSER MACHINE PROGRAM
2011-4-19 12:37:48 00000003583CEAD0 141 0000000355321950 INACTIVE Administrator WORKGROUP\DB415E5CC975424 PLSQLDev.exe
2011-4-19 12:39:17 0000000355393DE0 38 00000003582C9210 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:41:52 000000035535CB90 14 00000003552F2530 ACTIVE SYSTEM DELL-LSC ORACLE.EXE (W000)
2011-4-19 12:45:42 0000000358380500 71 00000003553208E0 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:45:42 000000035837A820 75 000000035531C720 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:50:51 00000003553B3CB0 78 0000000355324AA0 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:50:51 00000003583A3240 109 00000003582E6EC0 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:50:51 00000003553E23B0 108 00000003582EB080 INACTIVE SYSTEM dell-dlyy JDBC Thin Client
2011-4-19 12:51:25 0000000355416790 134 0000000355300B50 INACTIVE Administrator db415e5cc975424 JDBC Thin Client
2011-4-19 12:51:25 000000035831ABB0 17 00000003553174F0 INACTIVE Administrator db415e5cc975424 JDBC Thin Client
2011-4-19 12:51:25 000000035842B8D0 201 0000000355301BC0 INACTIVE Administrator db415e5cc975424 JDBC Thin Client
2011-4-19 12:52:03 0000000358457160 233 00000003582E8FA0 INACTIVE NT AUTHORITY\ANONYMOUS LOGON JLC98\DELL-WEB w3wp.exe
2011-4-19 12:52:36 0000000358428A60 203 00000003553229C0 ACTIVE SYSTEM DELL-LSC ORACLE.EXE (J001)
2011-4-19 12:52:36 00000003583FD1D0 171 00000003582E7F30 ACTIVE SYSTEM DELL-LSC ORACLE.EXE (J000)