CONSULTAR MEMORIA ORACLE DATABASE

sga_target

sga_max_size

select component,current_size/1024/1024 from v$sga_dynamic_components

memory_target

memory_max_target

select component,current_size/1024/1024 from v$memory_dynamic_components

VER PARAMETROS DE MEMORIA INSTANCIA DE BASE DE DATOS

select name, value, isdefault from v$parameter where name like '%size%'