Oracle Database Tuning

This section provides the basic information needed to create an Oracle schema for Atlas Hub. We recommend using the Server Administration tool to create the schema, but if you prefer to create your own, follow the guidelines provided in this section.

The most efficient way to tune your Oracle database is to start with the recommended database settings and monitor the instance using the advisories. In addition to that, we recommend the use of Automatic Workload Repository (AWR) to collect performance statistics, including wait events used to identify performance problems. A detailed description of AWR is beyond the scope of this document. Please refer to your Oracle 10g performance tuning guide for more information.