How to change __shared_pool_size parameter
700998Jul 9 2009 — edited Jul 10 2009I just took over support for some 10.1.0.3.0 databases and yes we are putting together plans to upgrade them to 11.
The previous support person used ASMM and I want to quit using it due to our shared pool being 600M the memory when it should be about 400M and our data cache is 500M when it should be 700M.
I have set the SGA_TARGET to 0, but every time I try to shrink the shared pool, I get the following error message:
ALTER SYSTEM SET shared_pool_size = 419430400 SCOPE=BOTH SID='DWPRD1'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04034: unable to shrink pool to specified size
I have a feeling it is because the __shared_pool_size parameter is set to 592M.
I cannot figure out a syntax to change __shared_pool_size.
The only option I can think of that I have left is to create a pfile, edit it, and then create a new spfile.
Any other suggestions?