Re: Passing the Windows Memory Limits

On Tue, 11 Mar 2003 09:59:21 -0800, Chuck <ccarson_at_echeeba.com> wrote:
>
>I keep hearing rumors of people using a full 4Gb of memory for Windows
>based Oracle databases, but cannot fidn any bonafide documentation.

See
http://technet.oracle.com/tech/windows/rdbms/rdbmswin.htm

"At this point, the number of applications running on Windows that need 16GB of database buffers are very few indeed as most applications that need to scale this high typically are hosted on UNIX servers."

4 GB Tuning KBase:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q291988

>I am mainly a UNIX guy but do have one Oracle 8.1.7 database running on
>W2K advanced server. We currently have the SGA set to 1.7Gb. I would
>love to bump this up to about 3Gb.
>
>One other question; Under Windows, all oracle memory is under one
>process correct?

Yes - but they are in separate threads

>Thus, all incoming database connections require memory
>from the 1.7Gb pool, correct? Is there anyway to prevent this behavior?

All incoming connections require PGA memory - same as UNIX, I'd assume this is split across the threads.

>Thanks,
>CC
>
>
>
>-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
>-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

-
Simon Sheppard
http://www.ss64.com
- Received on Tue Mar 11 2003 - 15:00:44 CST