How to Choose an Oracle Database

Oracle dominates the world's database market today and runs on over 60 platforms, from mainframes to Macs. Oracle is a relational database management system that may not be the fastest platform for databases, but they take on other virtues, such as a proactive approach. Often Oracle introduces new features and functions before the market demands.

Difficulty: Moderate

Instructions

1. Note that Oracle is a high concurrent database system. In a high concurrent system environment, readers do not block the writers and writers do not block the readers.

2. Know that there is a high degree of recoverability and accuracy. Oracle will automatically recover itself to the moment of the contingency. Your data will be in a consistent accurate state; any incomplete transaction will be rolled back and the committed data will be available for you after you startup your instance.

3. Learn to use the automatic workload repository-monitoring feature that comes with Oracle. The AWR feature collects metrics for analysis and tuning, collects database performance statistics, shows you the amount of time you've spent in the database and even saves information from the session.

4. Take advantage of Oracle's backward compatibility, meaning it works with earlier versions of the same product. A new version of Oracle must be able to use the files and data created with an older version of Oracle to be backward compatible.

5. Acknowledge that Oracle is user friendly. When they release each new version, Oracle includes documentation with a list of all the features new to this version. This makes it user friendly, which makes it easer for someone to be aware of and learn the additional features.

Resources

• Visit Oracle.com to view their tutorial.