请问java中java.sql.SQLException:ORA-04031:.......怎样解决(50分)

  • 主题发起人 clever_boy_2000
  • 开始时间
C

clever_boy_2000

Unregistered / Unconfirmed
GUEST, unregistred user!
本人在做jsp时遇到一个十分奇怪的问题:
java.sql.SQLException:ORA-04031:unable to allocate 24 bytes of shared memory(
"large pool","unknown object","session heap","trigger condition node")
请各位高手指教
只剩50分全部奉送
多谢浏览!
 
这是oracle错误,不是java错误,你应该查阅oracle的手册。
 
ORA-04031: unable to allocate num bytes of shared memory num, num, num
Cause: More shared memory is needed than was allocated in the operating system process. SGA private memory has been exhausted.
Action: Either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value set for the SHARED_POOL_SIZE initialization parameter.
 
多人接受答案了。
 
顶部