64 bit Oracle

Hi, I'd like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM's Power servers are tempting, even with the added expense of learning Linux. Bit I'd like to know from people who have experience with this. Is it really true that Oracle on Linux has better performance? What do you think is the future of 2003 64bit Oracle? Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Strange question? Why would you think that enterprise operations work best on Windows??

Basically, Linux requires a more knowledgeable operator; however you have a huge set of flexible options on Linux that you don’t have on Windows – a few are available on Windows for an additional cost.

If you have an organization full of Windows persons changing is a BIIIIG step. Linux is not Windows with a different user-interface. It takes a long time for someone to learn and be confortable with Linux to the degree needed to manage a large database system. Think about how to monitor tuning parameters, finding and tuning settings for devices like Raid etc. – those areas are very different. As well as the plentitude of disk management options you have (Linux allows you to adjust sizes of partitions without rebooting or deleting data first).

Personally, I’ve never found Windows stable enough to be used for enterprise level databases. Even small updates requires reboots and I cannot manage the Oracle processes as everything are Threads (drives me crazy!). We’ve had too many “just reboot” answers in the early stages of using Oracle9i on Windows – so 5 years ago we switched 100% to Linux. And while it’s not childsplay, it works for us. Our boxes are more secure, and remote access is pretty easy (and free).

Oracle publishes performance numbers … they change quite frequently. However, Oracle’s primery platform has always been, and is still unix. Porting new functionality is faster on Linux than it is on Windows. But if you’re unable to manage the database, what good is performance? If you’re unable to manage your linux box, you may very likely end up with a very bad performing database.

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • SheldonLinker
    Although I can't speak to the question of 32-bit versus 64-bit, keep in mind that Oracle can do I/O to files, or to disks. Under Windows, you can do I/O to files only. On Linux and AIX, you can have Oracle use the disks directly, saving a bit on OS file-system overhead. --- Sheldon Linker Linker Systems, Inc. www.linkersystems.com sol@linker.com 800-315-1174 +1-949-552-1904
    30 pointsBadges:
  • 64 bit Oracle (Q/A) | Seek The Sun Slowly
    [...] Address: https://itknowledgeexchange.techtarget.com/itanswers/64-bit-oracle/ (0) Comments Read [...]
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: