Re: Optimal SGA for NT?

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 10 Feb 1999 19:25:58 -0500
Message-ID: <kd4w2.936$24.2690@news.ipass.net>

Very good question. Rule of thumb will probably be about 35% to 45% of physical memory. Set it such that you get the best SGA hit ratios without O/S paging exceeding more than 5 pages/second. See the site below for more details.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

skubiszewski_at_Eisner.DECUS.Org wrote in message ...
>It seems to be common to size the SGA at 1/3rd of physical memory
>but is this true for Windows NT?
>
>What would you recommend as a "rule of thumb" for setting
>the SGA on an NT box?
>
>Thanks,
>
>Rose
Received on Wed Feb 10 1999 - 18:25:58 CST