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