Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 64-Bit Oracle on Windows 2003

RE: 64-Bit Oracle on Windows 2003

From: Freeman, Donald <>
Date: Wed, 16 Aug 2006 16:47:41 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C060B969B@enhbgpri05.backup>

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 [] 
	Sent: Wednesday, August 16, 2006 1:07 PM
	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 Mullin | Sr. Oracle Applications DBA | | P 415-536-6901 |         

[] On Behalf Of Freeman, Donald

	Sent: Wednesday, August 16, 2006 8:38 AM
	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 

Received on Wed Aug 16 2006 - 15:47:41 CDT

Original text of this message