As an Oracle database administrator (DBA), you are responsible for the performance of your Oracle database. Tuning a database to reach a desirable performance level may be a daunting task, especially for DBAs who are new to Oracle Database. Oracle Database 2 Day + Performance Tuning Guide is a quick start guide that teaches you how to perform day-to-day database performance tuning tasks using features provided by the Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager.
This chapter contains the following sections:
Before using this guide, you need to:
Complete the Oracle Database 2 Day DBA
Obtain the necessary products and tools described in "Tools for Tuning the Database"
Oracle Database 2 Day + Performance Tuning Guide is task oriented. The objective is to describe why and when tuning tasks need to be performed.
This guide is not an exhaustive discussion of all Oracle Database concepts. For this type of information, see Oracle Database Concepts.
This guide does not describe basic Oracle database administrative tasks. For this type of information, see Oracle Database 2 Day DBA. For a complete discussion of administrative tasks, see Oracle Database Administrator's Guide.
The primary interface used in this guide is Oracle Enterprise Manager Database Control console. This guide is not an exhaustive discussion of all Oracle database performance tuning features and does not cover available APIs that provide comparable tuning options to those presented in this guide. For this type of information, see Oracle Database Performance Tuning Guide.
As an Oracle DBA, you can expect to be involved in the following tasks:
Installing Oracle software
Creating an Oracle database
Upgrading the database and software to new releases
Starting up and shutting down the database
Managing the storage structures of the database
Managing users and security
Managing schema objects, such as tables, indexes, and views
Making database backups and performing database recovery, when necessary
Proactively monitoring the condition of the database and taking preventive or corrective actions, as required
Monitoring and tuning database performance
In a small-to-midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs—each with their own specialty—such as database security or database tuning. Oracle Database 2 Day + Performance Tuning Guide describes how to accomplish the last two tasks in this list.
The intent of this guide is to allow you to quickly and efficiently tune and optimize the performance of Oracle Database.
To achieve the goals of this guide, you will need to acquire the following products, tools, and utilities:
Oracle Database 10g Enterprise Edition
Oracle Database 10g Enterprise Edition offers enterprise-class performance, scalability and reliability on clustered and single-server configurations. It includes many performance features that are used in this guide.
Oracle Enterprise Manager
The primary tool to manage your database is Oracle Enterprise Manager, a Web-based interface. After you install the Oracle software, create or upgrade a database, and configure the network, you can use Oracle Enterprise Manager to manage your database. In addition, Oracle Enterprise Manager provides an interface for performance advisors and for Oracle utilities, such as SQL*Loader and Recovery Manager.
Oracle Diagnostics Pack
Oracle Diagnostics Pack offers a complete, cost-effective, and easy-to-use solution to manage the performance of Oracle Database environments by providing unique features, such as automatic identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring. Key features of the Oracle Diagnostics Pack that are used in this guide include the Automatic Database Diagnostics Monitor (ADDM) and the Automatic Workload Repository (AWR).
Oracle Database Tuning Pack
Oracle Database Tuning Pack automates the entire database application tuning process, thereby significantly lowering database management costs while enhancing performance and reliability. Key features of the Oracle Database Tuning Pack that are used in this guide include the SQL Tuning Advisor and the SQL Access Advisor.
Note:
Oracle Diagnostics Pack and Oracle Database Tuning Pack require separate licenses. For more information, see Oracle Database Licensing Information.