Saturday, May 3, 2008

Common Oracle DBA Tasks

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

Installing Oracle software

Creating Oracle databases

Performing upgrades of the database and software to new release levels

Starting up and shutting down the Oracle database

Managing the database's storage structures

Managing users and security

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

Making Oracle database backups and performing recovery when necessary

Proactively monitoring the database's health and taking preventive or corrective action as required

Monitoring and tuning 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.

Few more can be read at http://Oracleonline.info/dba_task.html

0 comments: