现象: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)
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)
解决方案 »
- cmd命令导出oracle数据库出错
- oracle11g http://localhost:1158/em控制台
- 这个问题怎么解决呢??
- Oracle查询语句的奇怪问题
- 安装ORACLE10先决检查通不过,求救
- 关于ORACLE序列连续性的问题请教下
- SQL查询效能优化
- 打开数据库时提示:oracle initializition or shutdown in progress 导致不能打开数据库,怎么解决?急!!!!!!!!!!!
- 『入门』新建用户表空间时候可以选择字典模式的管理以及本地管理,请问,这有什么区别和各自有什么好处呢?
- 请教高手:oracle如何导入?(在线等待,解决马上给分)
- 寻找Linux下强制重启oracle数据库的方法
- 虚拟机下oracle的登录问题
检查下是哪些应用连接数较多。JDBC应用是应用的连接,如果是JDBC的连接过多,应该是程序的连接泄漏问题,也就是连接了数据库后,没有关闭连接,随着应用的不断运行,数据库的连接就越来越多。
你先增大数据库的processes参数暂时缓解问题,最终还是要通过优化应用解决。
另外若连接还是很多,服务器带不起,可用共享式连接方式,不要用专用式