ORA-04031: unable to allocate 4096 bytes of shared memory

Hi all,

I'm getting error when I'm connecting to oracle.

The error message follows...............

        ERROR:
        ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","BEGIN
        DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")

        Error accessing package DBMS_APPLICATION_INFO
        ERROR:
        ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","BEGIN
        DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")

Solutions I tried follows....................

1. When i execute ALTER SYSTEM FLUSH SHARED_POOL the problem is solved, but after some time i get the same error again.
2. I've modified the shared_pool_size, but it shows some memory error when I'm trying to query some huge sql statements. ( Error saying could not read memory location)
   ( shared_pool_size = 17000000 )
   
3. As per the previous records in this group, I've modified "java_pool_size", but still I'm getting the error.
   ( Modified java_pool_size = 5971520)
   
4. Shutdown and restart the oracle server.

Please show me direction.....

Oracle version - 8.1.7.0.0
OS - Windows 2K / 512MB

Shafeek Khalidh
ICQ#81191628 Received on Fri Dec 27 2002 - 01:02:42 CST