set sga for oracle 10g

1. select sum(value)/1024/1024 mbytes from v$sga;

 

2. alter system  set sga_target=200m  scope=both

    shared_pool_size = 0
    large_pool_size = 0
    java_pool_size = 0
    db_cache_size = 0

 

3.

    alter system set db_cache_size = 2G scope=memory;
    alter system set large_pool_size = 512M scope=memory;
    alter system set java_pool_size = 1.5G scope=memory;

 

4.

   select current_size from v$buffer_pool;
   select pool,sum(bytes)/1024/1024 mbytes from v$sgastat;