SQL> show sga Total System Global Area 524288000 bytes Fixed Size 2046008 bytes Variable Size 423626696 bytes Database Buffers 92274688 bytes Redo Buffers 6340608 bytes SQL> show parameter sga_max_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 500M select value/1024/1024 shared_pool_size from v$parameter where name = 'shared_pool_size'; select * From v$sgastat; select 'Memory Allocation' " " , round(s.sgasize/1024/1024,2) "Total SGA (Mb)" , round(f.bytes/1024/1024,2) " Free (Mb)" , round(f.bytes*100/s.sgasize,2) " Free (%)" from (select sum(bytes) sgasize from sys.v_$sgastat) s , sys.v_$sgastat f where f.name = 'free memory' / select round(used.bytes /1024
db_recovery_file_dest_size usage The following scripts will check space utilization for db_recovery_file_dest_size : col name format a32 col size_mb format 999,999,999 col used_mb format 999,999,999 col pct_used format 999 select name, ceil( space_limit / 1024 / 1024) size_mb, ceil( space_used / 1024 / 1024) used_mb, decode( nvl( space_used, 0),0, 0, ceil ( ( space_used / space_limit) * 100) ) pct_used from v$recovery_file_dest order by name desc; ********************************* set lines 100 col name format a60 select name, floor(space_limit / 1024 / 1024) "Size MB", ceil(space_used / 1024 / 1024) "Used MB", from v$recovery_file_dest order by name;