| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 64-Bit Oracle on Windows 2003
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_at_salesforce.com] Sent: Wednesday, August 16, 2006 1:07 PM To: dofreeman_at_state.pa.us 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_at_salesforce.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: Wednesday, August 16, 2006 8:38 AM To: oracle-l_at_freelists.org Subject: 64-Bit Oracle on Windows 2003 Hi, I need some feedback on upgrading to 64-Bit. We are a statepublic 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 16 2006 - 15:47:41 CDT
 |
 |