Re: ORA-04031 during export

Andre Doehn wrote:
>
> hi list,
> when I try to export a schema i got an ORA-04031 error at the end
> of db export:
>
> EXP-00008: ORACLE-error 4031 found
> ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> pool","java/io/BufferedWriterSYS","joxlod: in ehe","ioc_allocate_pal")
>
> its a oracle 8.1.7 server running on linux with 512MB and i dont need java
> so i set the JAVA_POOL_SIZE to 1MB
> maybe thats the problem?
>
> here is a small part of my init.ora:
>
> db_block_buffers = 50000
> shared_pool_size = 62914560
> large_pool_size = 1048576
> java_pool_size = 1048576
> processes = 60
> log_buffer = 2097152
>
> any hint?
> bye
> andre

Hi Andre,
more likely you run out of space in the shared pool. $ oerr ORA 04031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"
// *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
//          INIT.ORA parameters "shared_pool_reserved_size" and
//          "shared_pool_size".
//          If the large pool is out of memory, increase the INIT.ORA
//          parameter "large_pool_size". 
 

To get more info issue
SQL> select * from v$sgastat where name = 'free memory'; Maybe this gets you a clue what's going wrong.

Manuela Mueller Received on Wed Nov 21 2001 - 05:29:30 CST