ORA-04031: Please help

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:06:35 CST