How to increase shared memory

How to increase shared memory

 

  

Hi Gurus,
While generating a report I am getting this error:
ORA-04031 - Unable to allocate string bytes of shared memory ("string","string","string" )
When I checked this error I found - "More shared Memory is needed than was allocated in the shared pool .

So, could any one tell me how to increase the shared memory .
Looking for your valuable advise.

Bazz

Oracle LazyDBA home page