Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!fu-berlin.de!uni-berlin.de!not-for-mail From: Chuck Newsgroups: comp.databases.oracle.server Subject: Re: MTS and Memory Date: 9 Sep 2004 19:29:51 GMT Lines: 41 Message-ID: References: <4140adc5$0$27888$afc38c87@news.optusnet.com.au> X-Trace: news.uni-berlin.de iWLEo64bhiUN3Ljs+JiuSwH2oBLiWGFfVXy9GcdHzTZYH4RPU= User-Agent: Xnews/5.04.25 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224609 "Howard J. Rogers" wrote in news:4140adc5$0$27888$afc38c87@news.optusnet.com.au: > 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)? Prior to implementing MTS they were in the dedicated server's memory space, not part of the sga at all. Or did I miss something that changed between 8i and 9i? > 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? Because when you switched to MTS, they moved out of the dedicated server and into the SGA. The SGA therefor needs to be bigger.