Re: MTS and Memory

On 9 Sep 2004 10:03:55 -0700, "Dave" <david.best_at_gmail.com> wrote:

>Now my question is, since i'm using MTS how far can I bump up my SGA..

first of all: why do you think using MTS you *should* 'bump the SGA'

Secondly: Oracle's guidelines tell not to use more than one third to one half of physical RAM.
Also: Winblows will always use 1 G.
If you want paging, go ahead and 'bump the SGA' as far as you can and face the consequences.
Alternatively, tune your application or replace Winblows for a real O/S.

--
Sybrand Bakker, Senior Oracle DBA