Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: maximum sga size for a given RAM

Re: maximum sga size for a given RAM

From: Tanel Põder <tanel_at_altavista.kom>
Date: Wed, 2 May 2001 19:14:38 +0200
Message-ID: <3af04049$0$265$ba624cac@news.uninet.ee>

> NT after a fresh boot without Oracle. If you go for 60 % on NT you will
 have
> paging.

Why is it so? Do you mean that if you have 60% sga and same amount of user processes you'll have 20% paging + os code + cache? If i have 2GB of ram - 1,7 of sga and 10 users with 10MB for each, we'll have 1,8 GB + OS code + some cache.
NT doesnt even read cache datafiles AFAIK, so where comes the need for paging?

Tanel Poder,
a DBA. Received on Wed May 02 2001 - 12:14:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US