increase shared_pool
Hi friends,
I've created 10.2.0.4 database on 32-bit platform using Automatic Shared Memory Management, below are the memory parameters in the init file
db1.__db_cache_size=805306368
db1.__java_pool_size=4194304
db1.__large_pool_size=4194304
db1.__shared_pool_size=255852544
db1.__streams_pool_size=0
*.sga_target=1073741824
*.pga_aggregate_target=209715200
I would like to increase shared_pool_size to 600MB and db_cache_size to 400MB, streams_pool_size to 4MB- to mimic Live database. I tried below commands to change them, but I still do not see the changed values in the init file or the enterprise manager dbcontrol..
alter system set shared_pool_size =600M scope=both;
alter system set db_cache_size = 400M scope=both;
alter system set streams_pool_size=4M scope=both;
I also would like to know if the shared pool size will just grow based upon the need with the automatic memory management enabled...
Thanks a lot