I'm running around 0,1% (By the way, thanx for this query) so if you should
have more, I sure should have !
> -----Original Message-----
> From: Leyden, Joseph [SMTP:LeydenJ_at_MTA.NET]
> Sent: Thursday, October 05, 2000 5:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SGA Free Memory
>
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
> INET: LeydenJ_at_MTA.NET
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 06 2000 - 05:09:20 CDT
