Resizing Shared Pool or SGA Target??
I need to resize my shared pool to 512M
I am using 10g Enterprise Edition. 10.1.0.4 on windows 2003
Do i need to bounce the db or i can do this task using alter system command w/o shutting down the db??
I believe i will hv to resize the sga_maz_size aswell...
However is it true that if i set the sga_target.. everything will be taken care of.
I am trying to upgrade Oracle EM Grid Control from the basic 10.2.0.2 to 10.2.0.5
According to the read me file, the upgrade patch requires shared pool to be a minimum of 512M.
Note : this is a development server.. hence no applications, no testing is done on it now.. as of now for the smooth install and upgrade.. please help me with correct parameter and values to do this task.
Kind regards