Getting Started with Database Administration: Types of Oracle Data base users – Database Administrators – Task of a Database administrators – Database administrator Security and Privileges – Database Administrator Authentication.

Starting up a Database – Altering Database availability – Shutting down a Database – Quiescing a Database – Suspending and Resuming a Database. Managing Processes: Dedicated Server Process - shared Server Process – Configuring Database resident Connection pooling

Monitoring Database operations: Monitoring Errors and alerts – Monitoring performance. Managing control files: Guidelines for control files – Creating control files – Backing up control files - Dropping control files. ManagingTablespaces:CreatingTablespaces–AlteringTablespaceavailability–Altering and managing Tablespaces – Dropping Tablespaces

Managing Data files and Temp files: Changing Data file size – Dropping Data files – Altering data file availability. Managing undo: Automatic Undo Management – Managing undo Tablespaces. ManagingTables:CreatingTables–LoadingTables–AlteringTables–RedefiningTables online – Dropping Tables – Managing Externaltables.

Managing Indexes: Creating Indexes – Altering Indexes – Monitoring space use of Indexes – DroppingIndexes. Managing Distributed Databases: Creating Database Links – Using shared Database Links – Managing Database Links – Viewing information about Database Links – creating Location Transparency.