SGA SIZE (V$SGA) (V$SGASTAT)


prompt .
prompt ==============================
prompt . SGA SIZE (V$SGA) (V$SGASTAT)
prompt ==============================
column Size format 99,999,999,999
select decode(name, 'Database Buffers',
 'Database Buffers (DB_BLOCK_SIZE*DB_BLOCK_BUFFERS)',
 'Redo Buffers',
 'Redo Buffers (LOG_BUFFER)', name) "Memory",
 value "Size"
 from sys.v_$sga
UNION ALL
 select '-------------------' "Memory",
 to_number(null) "Size"
 from dual
UNION ALL
 select 'Total Memory' "Memory",
 sum(value) "Size"
 from sys.v_$sga;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: