!free
--TotalOracleMem=6G
--sga_max_size=4,2G (TotalOracleMem*0,7)		=> 4200M
--pga_aggregate_target=1,8G (TotalOracleMem*0,3)	=> 1800M
--sga_target=3,36G (sga_max_size*0,8) 			=> 3360M
alter system set sga_max_size=4200M scope=spfile;
alter system set pga_aggregate_target=1800M scope=spfile;
alter system set sga_target=3360M scope=spfile;

System altered.
System altered.
System altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 4412407808 bytes
Fixed Size                  2026520 bytes
Variable Size            1577059304 bytes
Database Buffers         2818572288 bytes
Redo Buffers               14749696 bytes
Database mounted.
Database opened.
SQL>


col name format a40
col value format a40
set lin 300
select name, value
   from v$parameter
  2    3    where name in ('shared_pool_size', 'java_pool_size', 'streams_pool_size',
 'log  4  _buffer', 'db_cache_size', 'db_2k_cache_size', 'db_4k_cache_size',
 'db_8k_cache_size', 'db_16k_cache_size  5  ', 'db_32k_cache_size',
 'db_keep_cache_size', 'db_recycle_ca  6  che_size', 'large_pool_size');

NAME                                     VALUE
---------------------------------------- ----------------------------------------
shared_pool_size                         0
large_pool_size                          0
java_pool_size                           0
streams_pool_size                        0
db_cache_size                            0
db_2k_cache_size                         0
db_4k_cache_size                         0
db_8k_cache_size                         0
db_16k_cache_size                        0
db_32k_cache_size                        0
db_keep_cache_size                       0

NAME                                     VALUE
---------------------------------------- ----------------------------------------
db_recycle_cache_size                    0
log_buffer                               14302720