RE: 64-Bit Oracle on Windows 2003
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Aug 2006 16:47:41 -0400
I find your testimonial to be quite helpful even though it's not a
Windows box. This is what I was looking for. I have received a little
bit more direction as to what information is being sought and we have
settled on "case study." I've gone back to Oracle for help on that
one. I was pretty happy to forward yours and others comments to our
team and was going to suggest you contact IBM for a commission if we
manage to get the sale through.
-----Original Message-----
From: Brian Mullin [mailto:bmullin@xxxxxxxxxxxxxx]
Sent: Wednesday, August 16, 2006 1:07 PM
To: dofreeman@xxxxxxxxxxx
Subject: FW: 64-Bit Oracle on Windows 2003
I upgraded our 32 bit Solaris box to a 64 bit one 18 months ago.
It enabled me to create a 10G DB buffer cache which essentially allowed
us to put all AP, AR & GL data into memory. No more disk utilization
once the data had "read" into memory by the user community. The key is
to keep the system online more than 30 days to let all that data get
queried first time by the users.
We noticed reports that used to take 4 hours now complete in
less than 10 minutes. Users can come and go out of the system much
faster because their reporting is expedited by an order of magnitude
(10x faster)...which means more user. So not only is the system faster,
it can also handle THAT many more requests. It was a huge win for us.
Part of that was upgrading the CPU, but we effectively eliminated the
disk subsystem as a performance bottleneck by keeping all data in
memory. I can't stress how life-saving 64-bit can be as your
organization grows. It's relatively easy to do, and you could couple it
with a DB upgrade (64-bit 10g is SOOOO much more efficient than 32-bit
8i.)
Make sure you gather your stats regularly too ;-)
-Brian
Brian Mullin | Sr. Oracle Applications DBA | www.Salesforce.com
| P 415-536-6901 | bmullin@xxxxxxxxxxxxxx
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Wednesday, August 16, 2006 8:38 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 64-Bit Oracle on Windows 2003
Hi, I need some feedback on upgrading to 64-Bit. We are a state
public health agency. My project team has proposed that during our
regular server replacement cycle that our next purchase to replace our
OLTP RAC system should be HP 64-bit servers, each w/ dual 1.6GHz Itanium
processors, 16 GB RAM, 146 GB RAID drives, dual power supplies, and
Windows Server 2003 64-bit.
We are getting a lot of kickback from our director about
performance. All we can do is speculate about how this is going to work
in our environment. We have had Oracle in and they told us we'd get up
to a five-fold increase in performance in an OLTP system. Right now our
32-bit architecture tops out at about 60 users. We should be able to
respond to a public health emergency during which time it should be able
to handle a lot more users. We think this would get us there.
Does anybody have any wonder stories about how their life
changed after 64 bit? Here is the exact quote I am trying to address:
".... I am concerned that we are going to spend over $100,000
for 64 bit servers without understanding what we will get for this. I
understand this should improve performance, but it is not clear that we
have a benchmark in place. I am not in favor of buying equipment in
hopes that performance will improve anecdotically. I would like to see
some hard numbers that will point to whether or not this investment
delivers what is promised?"
Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
(717) 703-5782
Other related posts:
