异常代码:
[14:24:39.118] {http--80-351$15200178} Caused by: java.sql.SQLException: ORA-006
04: error occurred at recursive SQL level 1
[14:24:39.118] {http--80-351$15200178} ORA-04031: unable to allocate 4096 bytes
of shared memory ("shared pool","select user#,type# from user...","Typecheck hea
p","kgghteInit")
[14:24:39.118] {http--80-351$15200178}
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.DatabaseError.thro
wSqlException(DatabaseError.java:124)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CTTIoer.processE
rror(T4CTTIoer.java:304)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CTTIoer.processE
rror(T4CTTIoer.java:271)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4C8Oall.receive(T
4C8Oall.java:622)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.doOall8(T4CPreparedStatement.java:180)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.execute_for_describe(T4CPreparedStatement.java:419)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OracleStatement.ex
ecute_maybe_describe(OracleStatement.java:895)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.execute_maybe_describe(T4CPreparedStatement.java:451)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OracleStatement.do
ExecuteWithTimeout(OracleStatement.java:985)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OraclePreparedStat
ement.executeInternal(OraclePreparedStatement.java:2887)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OraclePreparedStat
ement.executeQuery(OraclePreparedStatement.java:2928)
[14:24:39.118] {http--80-351$15200178} at org.apache.commons.dbcp.DelegatingPre
paredStatement.executeQuery(DelegatingPreparedStatement.java:93)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.jdbc.AbstractBatcher.ge
tResultSet(AbstractBatcher.java:186)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.getResult
Set(Loader.java:1787)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doQuery(L
oader.java:674)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doQueryAn
dInitializeNonLazyCollections(Loader.java:236)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doList(Lo
ader.java:2220)
[14:24:39.118] {http--80-351$15200178} ... 130 more
[14:24:39.118] {http--80-351$15200178} Caused by: java.sql.SQLException: ORA-006
04: error occurred at recursive SQL level 1
[14:24:39.118] {http--80-351$15200178} ORA-04031: unable to allocate 4096 bytes
of shared memory ("shared pool","select user#,type# from user...","Typecheck hea
p","kgghteInit")
[14:24:39.118] {http--80-351$15200178}
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.DatabaseError.thro
wSqlException(DatabaseError.java:124)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CTTIoer.processE
rror(T4CTTIoer.java:304)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CTTIoer.processE
rror(T4CTTIoer.java:271)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4C8Oall.receive(T
4C8Oall.java:622)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.doOall8(T4CPreparedStatement.java:180)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.execute_for_describe(T4CPreparedStatement.java:419)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OracleStatement.ex
ecute_maybe_describe(OracleStatement.java:895)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.T4CPreparedStateme
nt.execute_maybe_describe(T4CPreparedStatement.java:451)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OracleStatement.do
ExecuteWithTimeout(OracleStatement.java:985)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OraclePreparedStat
ement.executeInternal(OraclePreparedStatement.java:2887)
[14:24:39.118] {http--80-351$15200178} at oracle.jdbc.driver.OraclePreparedStat
ement.executeQuery(OraclePreparedStatement.java:2928)
[14:24:39.118] {http--80-351$15200178} at org.apache.commons.dbcp.DelegatingPre
paredStatement.executeQuery(DelegatingPreparedStatement.java:93)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.jdbc.AbstractBatcher.ge
tResultSet(AbstractBatcher.java:186)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.getResult
Set(Loader.java:1787)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doQuery(L
oader.java:674)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doQueryAn
dInitializeNonLazyCollections(Loader.java:236)
[14:24:39.118] {http--80-351$15200178} at org.hibernate.loader.Loader.doList(Lo
ader.java:2220)
[14:24:39.118] {http--80-351$15200178} ... 130 more
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
不然肯定会发出代码的
unable to allocate 4096 bytes
of shared memory ("shared pool","select user#,type# from user...","Typecheck hea
p","kgghteInit")
主要是看这里的。
之前也是说什么共享池太小了 我已经改了oracle的配置文件了 但是没有用
show sga看一下结果
p","kgghteInit")
我刚刚上网查了下
是无法分配 4096 字节的共享内存
哪位可以告诉我如何增加这个共享内存呢