Re: Optimal SGA for NT?

if just the DB server, the TNS listener and nothing (remarkable) else is running on the NT server, donīt hesitate and give 2/3 of the memory to the SGA if the memory as such is bigger than 128 MB!

I increased the SGA at a customers NT server(512MB) with heavy query load from 1/2 to 2/3 of physical memory and retrieved a pretty good performance increase.

regards,
--marcus

skubiszewski_at_Eisner.DECUS.Org schrieb in Nachricht ...
>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 Tue Feb 09 1999 - 09:12:07 CST