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;