SkillAdvance SkillAdvance

Efficient, effective training services for
database, programming and web applications
Click for immediate contact!


Home > Oracle Training > Oracle Database Administration

Oracle Database Administration

Duration: 3 - 5 days Level: Intermediate

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly Print this page

Class Summary

Oracle Database Administration is a skill that has been growing in demand over recent years, despite the downturn in the global economy. This class builds on the SQL*Plus and PL/SQL skills from the perspective of a technician responsible for creating and administering physical and logical file structures in this powerful relational database product.

The class consists of a mixture of lecture and hands on lab exercises.

Who Should Attend

This class is intended for technical staff who are becoming responsible for creating and administering Oracle databases. Development staff may also benefit from attending this class, to gain an overview of the work of a Database Administrator to aid in developing effective software systems that will be based on Oracle.

For experienced DBA's cross training from other products or earlier versions of Oracle, our Oracle DBA FastTrack class may be more appropriate.


A grounding in relational database concepts; familiarity with the use of graphical user interfaces.

Some expertise with both SQL and PL/SQL in an Oracle environment is expected.


  • Database Administration: Memory, process and disk structure; instances and databases; storage structures; backup and recovery; SQL and database tuning; network resource management

  • Oracle Architecture: Disk structures; parameter files; control files; data files; redo log files; password files; segments, extents and blocks; memory areas; shared pool; buffer cache; redo log buffer; processes; database writer; log writer; system monitor; process monitor; archiver; processing overview.

  • Creating a Database: Configuring the operating system; privileged account authentication; creating a parameter file; creating a database; creation commands; post creation actions; data dictionary management.

  • Starting and Stopping Oracle: Instance processing overview; startup command; startup stages; command options; shutdown commands and options; checking instance status; using the alert logs; trace files.

  • Tablespaces, Datafiles and Rollback Segments: Structure review; tablespace types; system tablespace; non-system tablespaces; inside a tablespace; locally managed and dictionary managed tablespaces; datafiles; tablespace and datafile management; segments, extents and blocks; rollback segment operations; creating and managing rollback segments.

  • Tables and Indexes: Creating tables; data types; creation and management commands; inside a table; table management (alter, drop, move); partitioned tables; indexes; creating indexes and setting storage criteria; index management.

  • Database Integrity: Creating, altering and dropping constraints; enabling and disabling constraints; constraints and indexes; more on index types; index-organised tables; bitmap indexes; reverse key indexes.

  • User and Resource Management: User accounts overview; resource profiles; system and password limits; profile management; authentication choices - password, operating system, database; users and tablespaces; privileges and roles; creating and managing user accounts; tablespace quotas; data dictionary information.

  • Privileges: User and system privileges; assigning privileges to users; using roles; stored code privileges; invoker and definers rights.

  • Oracle Best Practices: User and system privileges; assigning privileges to users; using roles; stored code privileges; invoker and definers rights.

Sample notes

Please contact us for a sample lesson.

Suggested next class

Oracle Backup and Recovery, Oracle Performance Tuning, Oracle Networking


This page last updated on
June 2, 2004 3:18
Site Meter

Live chat by Boldchat
Online chat by Boldchat
 Search this site...