Already a member?
Sign in
Welcome! Wikis are websites that everyone can build together. It's easy!
Location:
Oracle On Windows
Discussion: Best Practices for using Oracle RDBMS on Windows
Watch
 amccurdy |
Best Practices for using Oracle RDBMS on Windows
Nov 30 2007, 4:46 AM EST If you've been considering using Oracle on Windows then I strongly recommend that you check out Christian Shay's excellent OpenWorld 2007 presentation. If you're looking for links to OpenWorld session presentation materials, you can find them on here: * OpenWorld 2007 Best Practices for Performance of Oracle Database on Windows * http://www28.cplan.com/cbo_export/PS_S291788_291788_176-1_FIN_v2.pdf * Userid: cboracle * Password: oraclec6 5 out of 10 found this valuable. Do you? |
 tomcatkev |
RE: Best Practices for using Oracle RDBMS on Windows
Dec 7 2007, 11:44 AM EST LOL. Best practice for using Oracle on Windows is to install Linux and run on that. Well perhaps the one saving grace of Oracle on Windows is Heterogeneous Connectivity, if you need to easily integrate with non-Oracle databases and have ODBC drivers for those other databases handy. 1 out of 6 found this valuable. Do you? |
|
amccurdy |
RE: Best Practices for using Oracle RDBMS on Windows
Dec 9 2007, 6:10 PM EST Actually your wrong to assume that Linux is better for running Oracle. Check out the latest TCP benchmarks to see what OS has the cheapest and fast footprint with Oracle and you will be mighty surprised. Not that I want to bust your Linux bubble! 2 out of 4 found this valuable. Do you? |
 fraserhtalbot |
RE: Best Practices for using Oracle RDBMS on Windows
Dec 9 2007, 11:15 PM EST I have traditionally worked exclusviely with UNIX systems hosting Oracle, until recently and reluctantly, have had to engineer some backup solutions on several windows system hosting Oracle. I have found that the performance is generally more than adequate, and that there is a ton of Windows system administrators willing to help. It seems that the UNIX admins tend to be the curmudgenous types that used to be assocaiated with, well, the Oracle DBA. In short, the operating system is more approachable to more people, while the UNIX world seems more esoteric. However on Windows systems that I see running Oracle, in particular production systems, it seems that the server is “purposed” for a specific application and has only a sigle instance running on it. This may be a function of the “cheapest and fastest OS”, but I never see a server loaded down with mulitple instances or applications like a 8 way HP/UX or Sun box. 1 out of 3 found this valuable. Do you? |
|
amccurdy |
RE: Best Practices for using Oracle RDBMS on Windows
Dec 10 2007, 10:31 AM EST Fraser thanks for the input. Yes I completely agree with what you are saying, however I feel that a lot of Oracle Admins/DBA's fear Microsoft Windows and even find it strange that Oracle has a very good working relationship with the Microsoft OS development team. According to recent stats Windows is the fastest growing OS for RDBMS sales even over Linux. This is mainly due to 64bit Windows and the lifting of the memory restriction that 32bit gave us. I think over time you will see a gradual change with more people picking windows to put multiple production systems on. 64bit and Oracle VM is just the start. 2 out of 4 found this valuable. Do you? |