Oracle DBA : Common tasks

Welcome to the Oracle DBA section of this site

In this section, you will find a set of common tasks needed to be mastered and performed by any DBA. The articles are basic level, and some are graphic intensive, so you will need some network speed to read them.

I recommend that you print each article for better reading experience. Use landscape orientation on your printer.

The Oracle Database System from Oracle Corporation is most likely the most widespread and popular Database System in the world. It is increasing with a very high speed in Linux environments, but is also gaining market shares in virtually all environments.
I have wanted to present to you a set of articles for Oracle DBA's, which include:

• Adding users in Oracle
• Backup and restore
• Import and export data
• Job scheduling

and much more. So, here it is:

DISCLAIMER: All programming examples within the articles are meant for illustration purposes only, and The Database Design Resource Center holds no warrant for correctness if used.

• 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...
• Indexes are an important performance enhancement facility. In this article, we look at some options and tools for creating Oracle Indexes.
• 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.

Return to Database Design home