Re: MTS and Memory

hjr_at_dizwell.com (Howard J. Rogers) wrote in message news:<14a1f766.0409091950.31038142_at_posting.google.com>...

>
> My point was that although the SGA will get bigger, the amount of
> dedicated PGA will decrease, and therefore the overall memory
> allocation should stay more or less the same.

Perhaps he was just looking for something like this: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1012046.6

> Memory increase? Nope. Memory redistributed, true.

True, but the OP was asking if one _should proactively_ increase memory for MTS. Both you and the ridiculously old metalink document effectively say "one should measure, then decide."

I have a vague memory of something apropos in an MTS configuration class I took circa 1995, if I think of it whilst basement-rooting I'll find the booklet and see.

jg

--
@home is bogus.
http://www.firedetect.noaa.gov/viewer.htm