Skip Headers
Oracle® Database 2 Day + Performance Tuning Guide
10g Release 2 (10.2)

Part Number B28051-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Introduction

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:

About This Guide

Before using this guide, you need to:

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.

Common Oracle DBA Tasks

As an Oracle DBA, you can expect to be involved in the following tasks:

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.

Tools for Tuning the Database

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:

Note:

Oracle Diagnostics Pack and Oracle Database Tuning Pack require separate licenses. For more information, see Oracle Database Licensing Information.