Hi Guys,

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

Regards

Joe