0 pts.
 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

Software/Hardware used:
ASKED: December 27, 2005  4:03 PM
UPDATED: December 27, 2005  5:27 PM

Answer Wiki:
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.
Last Wiki Answer Submitted:  December 27, 2005  4:59 pm  by  Bit4man   0 pts.
All Answer Wiki Contributors:  Bit4man   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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.
http://www.linkersystems.com
sol@linker.com
800-315-1174
+1-949-552-1904

 15 pts.