我用的linux+oracle+tomcat环境下做jsp ,对项目进行压力测试,但没有运行几天就出现了这样的错误:
请高手指教:
Error get connection:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-00018: maximum number of sessions exceeded
请高手指教:
Error get connection:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-00018: maximum number of sessions exceeded
select count(*) from v$session where username is not null;
good luck
Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services. ORA-00018: maximum number of sessions exceeded
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.
建议你把java代码信息打入log中,然后在异常log中查看java所写的sql是否有问题.
2,数据库联接建议使用连接池,不要JDBC直接连接
3, 可以修改数据库的最大prcesee数D:\oracle\product\10.1.0\admin\orcl\pfile
init.ora###########################################
# Processes and Sessions
###########################################
processes=150默认150可以修改大一些如果是pi,10g可以在控制台修改
1、美工 1名 软件界面设计
2、网站制作 1名 HTML + JavaScript(PHP)
3、程序员 2名 Win32 API + C\C++
4、数据库管理员 1名 Oracle; SQL Sever 2000