To find sga details

To find sga details
============

SQL> set linesize 500
SQL> set pages 200
SQL> col name for a35
col value for a35
 SQL> select name, value from v$parameter2 where name in ('sga_target','java_pool_size','large_pool_size','shadow_core_dump','db_cac
2 he_size','sga_max_size','sga_target','shared_pool_reserved_size','shared_pool_size');

NAME VALUE
----------------------------------- -----------------------------------
sga_max_size 3221225472
shared_pool_size 1677721600
large_pool_size 218103808
java_pool_size 536870912
shared_pool_reserved_size 335544320
sga_target 0
shadow_core_dump NONE

7 rows selected.

SQL>

SQL> select name from v$database;

NAME
-----------------------------------
EBSTEST