sga - liamlamth/blog GitHub Wiki

set pagesize 23
set linesize 139
set feedback off

column value for a30
column name for a30
column inst for 99

show sga;

select inst_id inst, name, value from gv$system_parameter
where lower(name) in ('java_pool_size','db_cache_size','db_cache_advice',
'shared_pool_size','shared_pool_reserved_size','large_pool_size','sga_target')
order by inst_id,name;

exit