Re: memory per database connection on windows

On 9/15/05, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
>
> When we running Oracle 8I on Windows we implemented Multi-threaded server
> and added the /3gb switch to the boot.ini file so we could have a larger
> process size. We are now running Oracle 9I with MTS still active. I am
> considering eliminating MTS. We have pga_aggregate_target set so sessions
> would share sort memory. I am trying to located a note giving an idea of
> amount of memory per database connection to see if by eliminating MTS and
> the Large Pool if we would have a wash in terms of memory usage.
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

Jeff,

Is the /3GB switch actually working with 8.1.7.x in your environment? AFAIK, support for "large" memory on win32 was broken with the 8.1.7.3.0patchset and was not fixed in any of the 8.1.7.4.x patchsets.
It has always worked in the 9.2.x and 10.1.x releases for me.

Is there any chance that you can upgrade to 9.2 or 10.1 prior to making these changes?

Check out the orastack utility for reducing the per process memory footprint.

Paul

ps - I don't cross-post.

--
http://www.freelists.org/webpage/oracle-l