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 are:

  • A very basic task is to add users in Oracle.
  • One of the most important tasks is to establish and perform an Oracle Backup. Without it, you are leading a dangerous life...
  • As a professional Oracle DBA, after having established sound backup procedures, let us hope you never will need to perform an Oracle Recovery. Chances are, however, that you may have to some day...
  • If you need to, you can export parts of, or the complete database, to a flat file using Oracle Export. Nice feature, but very old-fashioned...
  • After you have performed an Oracle Export, you can use the Oracle Import function to load data into another database. Very useful feature, but as with Oracle Export: A bit old-fashioned. However, it does the job.
  • Some database tables may contain millions of rows, and performance may slow down. A good solution for the Oracle DBA may be to split such tables into Oracle Partitions.
  • Instead of manually starting different database tasks, the Oracle DBA can automate the whole process by using the Oracle Scheduler.
  • In order to perform Oracle backup and recovery, you need to have a redo log up and running. This article looks at aspects when dealing with Oracle log files. The last article in the Oracle DBA section is about performing real-time changes to tables and other database objects: Redefining Oracle Objects.


STEP 1 - Next Topics
This contains a brief overview of Oracle database administration. Learn Oracle DBA Step 1 by clicking links below:
What is a Oracle Database?Oracle DBA
Common Oracle DBA TasksOracle DBA
Tools for Administering the Database
Oracle Database Architecture
How Oracle Works

More Tutorials on Oracle dba ...

Source : Oracle Documentation

Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info