What version do you use?

And Check Oracle Parameter


10G=>

SQL> show parameter sga_target;
sga_target big integer 7G

if sga_target > 0 , you need to change sga_max_size and sga_target
initialized parameters.

SQL> alter system set sga_max_size=10G scope=spfile;

SQL> alter system set sga_target=10G scope=spfile;

If you have used spfile.
SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
spfile string +ARCH/bedb/spfilebedb.ora


If you haven't used spfile. you need edit pfile in ORACLE_HOME/dbs/ dir
for Unix.

Anyway If sga_target = 0, you need to change shared_pool_size
initialized parameter.


Before you increase the shared memory, you should know Share max size in
your OS.

M.Shahbaz wrote:
> 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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>

Oracle LazyDBA home page