SGA Free Memory

From: Leyden, Joseph <LeydenJ_at_MTA.NET>
Date: Thu, 5 Oct 2000 08:06:19 -0700
Message-Id: <10640.118596@fatcity.com>

My % free memory is running between 2 to 5 %. IS this good or should I have more?

---

$ vi sgafree.sql

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'
/

$
$ sgafree

NAME                       Allocated (M)   Free (K)     % Free
-------------------------- ------------- ---------- ----------
free memory                   201.295216 6465.28906       3.14

Received on Thu Oct 05 2000 - 10:06:19 CDT