When I am trying to execute a PL/SQL script in my DB I am getting the following error
ORA-04031-Unable to allocate 4096 bytes of shared memory ( "Shared pool" "BAMIMA Bam buffer" )
I guess that there is not enough free memory in shared pool. we need to increase the shared_pool_size.What do u guys suggest?
Oracle - 8.1.7
OS -Sun Solaris
1. Restart your database and run the PL/SQL procedure
2. Run the statement " ALTER SYSTEM FLUSH SHARED_POOL;" and run the PL/SQL procedure
If dosen't work after wards, it seems to be a bug. Please post the minor version of the database, ie 8.1.7.xxx.. The value of xxx?