Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed-east.nntpserver.com!nntpserver.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail Message-Id: <4140adc5$0$27888$afc38c87@news.optusnet.com.au> From: "Howard J. Rogers" Subject: Re: MTS and Memory Newsgroups: comp.databases.oracle.server Reply-To: hjr@dizwell.com Date: Fri, 10 Sep 2004 05:23:42 +1000 References: User-Agent: KNode/0.7.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 42 NNTP-Posting-Host: 203.164.4.141 X-Trace: 1094757830 27888 203.164.4.141 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224608 Chuck wrote: > Sybrand Bakker wrote in > news:mp41k0pjds927314t0o7ij6l3n02ot2cdk@4ax.com: > >> On 9 Sep 2004 10:03:55 -0700, "Dave" 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' > > Probably because Oracle recommends it with MTS. It does no such thing. > Since the UGA is > allocated primarily out of the large pool, and that is part of the SGA, > you need to increase the size of the SGA (via the large pool) to handle > those UGAs. And where do you think those UGAs were before you implemented a large pool (or before implementing MTS, come to that)? They were with the PGA, or in the shared pool. So now they're not and they're in the large pool instead. So tell me where the memory *increase* is in that, as opposed to the memory re-distribution? HJR > > For the OP, there are other ways to increase the amount of memory Oracle > can access too but I've never found it necessary. Check metalink document > 46001.1. It's for Windows NT but holds true for Win2k as well. It details > how to allow Oracle to access up to 3g of memory. > > Remember too that Windows will use 1g itself.