Common Oracle DBA Tasks

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

• Installing Oracle software

• Creating Oracle databases

• Upgrading the database software to new releases

• Starting up and shutting down the database

• Managing the storage structures of the database

• Managing user accounts and security

• Managing schema objects, such as tables, indexes, and views

• Making database backups and performing database recovery, when necessary

• Monitoring proactively the condition of the database and taking preventive or corrective actions, as required

• Monitoring and tuning database performance

This guide describes how to accomplish the last two tasks in the preceding list.