Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Database Architectures

Choosing the correct database architecture (hardware platform, operating system) is critical to the success of any new Oracle database application. Architecture decisions were simple when the mainframe was the only architecture available. But architecture selection is not as clear-cut now that Microsoft Windows platforms, UNIX and LINUX are viable database environments. Oracle is more than happy to offer their flagship database on a wide-variety of hardware and operating system combinations. As a result, IT shops have more hardware and software choices available to them than ever before. The key to success is choosing the right ones.

A correctly chosen architecture will result in an application that performs to expectations, scales easily to meet increased user demands, and is easily administered. Incorrect architecture decisions may result in poor performance, limited functionality, complex administration and tuning, lack of scalability, poor vendor support, poor reliability and availability and a high total cost of ownership.

Architecture decisions should not be made in a vacuum or based on personal preference. It is important for all large IT shops to create a part-time architecture selection team consisting of members drawn from the following areas: LAN/WAN communications, O/S support, operations, architectures and database administration. This team should be responsible for determining the best architecture for a particular application.
 

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA