执行程序时抱错
java.sql.SQLException: ORA-00018: 超过阶段作业数目上限
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:517)是不是需要修改init.ora里面的processes参数? 还有一个sessions参数是做甚么用的, 是否也需要修改? 他们俩个修改为多少合适, 现在是processes=150, sessions=170
java.sql.SQLException: ORA-00018: 超过阶段作业数目上限
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:517)是不是需要修改init.ora里面的processes参数? 还有一个sessions参数是做甚么用的, 是否也需要修改? 他们俩个修改为多少合适, 现在是processes=150, sessions=170
我现在想调整SESSIONS为500, 其它两个值最好跳到甚么程度?
而且SESSIONS 的值只有 update v$parameter 来实现吗?