rem ----------------------------------------------------------------------- rem Filename: sga_free.sql rem Purpose: Reports free memory available in the SGA rem Date: 09-Jun-1998 rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- select name, sgasize/1024/1024 "Allocated (M)", bytes/1024 "Free (K)", round(bytes/sgasize*100, 2) "% Free" from (select sum(bytes) sgasize from sys.v_$sgastat) s, sys.v_$sgastat f where f.name = 'free memory' /