Interesting.
We noticed the same thing on Windows2000, it doesn't get mentioned often.
Does it mean not many people maintain databases that require more than 1.5G
of memory on their Windows servers?
My impression so far:
- one can't use virtual memory on the Windows platform for a busy database,
CLE-L
<[EMAIL PROTECTED]> cc:
Subject: RE: NT -> Win2K causes
performance degradation..We run oracle 9.2.0.3 on Win 2000 and have
observed that whenever thememory on ora.exe process reaches around 1.4G,
our applicati
:
RE: NT -> Win2K causes performance degradation..
I'll
throw gasoline on the fire here...
On
Win2K you may hit resource limits when you get to 1.5G or so memory used on a
4G server...
Because Windows allocates half the memory to the kernel processes, half
to
L PROTECTED]
> 12/16/2003 02:04 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: NT -> Win2K causes
> performance degradation..
>
>
>
t; |
| cc: |
| Subject: RE: NT -> Win2K causes performance degradation.. |
>--|
I'll thro
r 11, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: NT -> Win2K causes performance degradation..
The /3GB does not work for the simple reason that in W2K you have 3GB
as max address space. At least that what my sysadmin tells me (after
ssage-From: Yechiel Adar
[mailto:[EMAIL PROTECTED] Sent: December 11, 2003 10:40
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
NT -> Win2K causes performance degradation..
The /3GB does not work for the simple reason that in W2K
you have 3GB as max address space. At le
Mark,
MS w2k3 server supports large memory in the standard product, advanced edition not required. For me, those (client) systems are still in acceptance testing, and I have not yet actually run them with a process memory > 2 GB. I'll let you know after I do, sounds like a good test for a rainy e
Hi all,
Thanks for the pointers that you have all supplied. Sage advice that they
shouldn't have changed Oracle whilst changing their OS at the same time.
I also did some checking up on the /3GB switch before it was mentioned
(having seen it on here in the past) - Windows 2000 does in fact suppor
: Wednesday, December 10, 2003 6:49
PM
Subject: Re: NT -> Win2K causes
performance degradation..
Mark,
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be
allocated to filesystem caching,
Mark,
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver (and domain controller, web server, print server, etc) until you tell it otherwise.
Th
Might also be they bumped shared_pool way up and they aren't using bind
variables?
> -Original Message-
>
> When they upgraded the memory, by just now much did they increase
> db_block_buffers?
>
> If increased too much, they could be spending a lot of time
> waiting on latches, as the
Mark,
This is pure speculation, as you didn't provide any particulars.
Upgrading to Win2k is not likely the culprit, or at least, I have
experienced any kind of problem in moving a database from NT -> Win2k.
When they upgraded the memory, by just now much did they increase
db_block_buffers?
If
Mark,
I have not done a MicroSlop upgrade, but I have in the past upped the SGA size
and gotten when I really did not want, which was database performance degradation.
You might ask them to check the pagefile size. If it's system maintained or too small
funny things do happen. BTW: M
Hi Mark,
no thoughts specific to Oracle, but I'd recommend using the principle of "change only
one element at a time". I'd say they were unwise to upgrade to W2K, and at the same
time change their Oracle parameters. If possible, I'd advise they set all their Oracle
parameters back to their pre-
15 matches
Mail list logo