Re: ORA-04031 during export

> 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".

i know the error description but i increased the shared pool size but it didnīt help?!

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

i got:

SQL> select * from v$sgastat where name = 'free memory';

POOL        NAME                            BYTES
----------- -------------------------- ----------
shared pool free memory                  50372360
large pool  free memory                   1048576
java pool   free memory                      4096

maybe i have to go back to the default JAVA_POOL_SIZE of 20mb?

thanks!
bye
andre Received on Wed Nov 21 2001 - 07:11:03 CST