17,377
社区成员
发帖
与我相关
我的任务
分享關於ORA-04031錯誤
我在做一個 簡單的查詢時出現ORA-04031錯誤，
ORA-04031：無法分配共享記憶體的8704位元組(''large pool'',''unknown object'',
''cursor work he''....);
到ORCLE官方網站獲得的信息是增加共享池的大小
我已經增大共享池的大小，但沒有用。
請問各位大哥有沒有什麼好的解決方法！
我的數據庫剛由806生機到817
ORA-04031：無法分配共享記憶體的8704位元組(''large pool'',''unknown object'',
''cursor work he''....);
到ORCLE官方網站獲得的信息是增加共享池的大小
我已經增大共享池的大小，但沒有用。
請問各位大哥有沒有什麼好的解決方法！
我的數據庫剛由806生機到817
...全文
请发表友善的回复…
发表回复
baojianjun 2004-07-05
- 打赏
- 举报
我已經找到ORA-04031的補丁了！
atao245993 2004-07-01
- 打赏
- 举报
baojianjun 2004-07-01
- 打赏
- 举报
樓上貼的我也有，我想問問有誰解決過類似的問題嗎？
dinya2003 2004-07-01
- 打赏
- 举报
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, 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 of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, 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 of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
