Database Software

Hi All,

I am using oracle 11gR2. I want to configure the value manually for db_cache_size and shared_pool_size.

I set the memory_target=0 and also i set the sga_target=0
and db_cache_size=36G. when i try to set the value for shared pool size to 4Gb i am getting an error.

SQL> alter system set shared_pool_size=4G sid='ubshost1';
alter system set shared_pool_size=4G sid='ubshost1'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04034: unable to shrink pool to specified size

Do i need to set the sga_target to some values to tell the oracle to use the manual value. I dont want oracle to decide for sga by setting sga_target?
What is the way to set the value for sga parameters in oracle 11g so that oracle will used the value which is configure by us.

Thanks and Regards