Home » RDBMS Server » Server Administration » ORA-04031: unable to allocate 4096 bytes of shared memory
ORA-04031: unable to allocate 4096 bytes of shared memory [message #49782] Fri, 08 February 2002 22:09 Go to next message
Chetan
Messages: 21
Registered: November 2000
Junior Member
Oracle Version 8.1.7

We are getting following error:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin :1 := dbms_lob.getLeng...","PL/SQL MPCODE","BAMIMA: Bam Buffer")

We have used CLOB and BLOB columns in tables and we are fetching the data using JDBC 2.0.

We have set the shared_pool_size = 30728640 and
shared_pool_reserved_size = 1572864

Please let me know the cause of the problem and how to fix it.
Re: ORA-04031: unable to allocate 4096 bytes of shared memory [message #49784 is a reply to message #49782] Sat, 09 February 2002 01:07 Go to previous messageGo to next message
Harish Lingegowda
Messages: 5
Registered: February 2002
Junior Member
try to check java_pool_size and increase shared_pool_size.
sizing SGA depends on available memory

definetly its problem of SGA so increase the size.

Harish.
Re: ORA-04031: unable to allocate 4096 bytes of shared memory [message #51392 is a reply to message #49782] Mon, 20 May 2002 23:31 Go to previous message
sbmm
Messages: 1
Registered: May 2002
Junior Member
set Large pool value to 10% of Shared pool , your problems should be solved
Previous Topic: SCN Mistery
Next Topic: Renaming a column in a table
Goto Forum:
  


Current Time: Wed Dec 25 09:39:09 CST 2024