Oracle 11 g Database Administration

Pre requisite:

• Working knowledge of SQL & PL / SQL
•  Knowledge of Windows & Linux Basic Administration

 Architecture & Installation

•  Defining an Oracle Server, Database and Instance
• Understanding of Physical and Logical Structure
• Execution of SQL Statements & User Sessions
• Preparing the Database Environment for Installation

·         

Creating and Managing Oracle Database & Instance

• Understanding SGA(System Global Area) – DB Buffer Cache, Log Buffer & Shared Pool
• Understanding Background Process – Mandatory/Optional and their purposes
• Initialization files – PFILE & SPFILE, Advantage of SPFILE over PFILE
• Data Dictionary v Dynamic Performance Views to retrieve the information from Database
• Using DBCA & Manually to Create a Database

Managing Tablespaces

• Tablespace Architecture – TS types, OFA (Optimal Flexible Architecture)
• Creating, Altering & Renaming a Tablespace
• Adding, Resizing, Renaming and Relocating Datafiles
• Creating and Managing a Tablespace using OMF and associated Advantages & Disadvantages
• Tablespaces – offline, online, read only, read-write, multiple blocks
• Temporary TS Groups
• Extent Management – Dictionary and Locally Managed, Advantages & Disadvantages

Storage Management

• Storage Parameters
• Creating and Maintaining tables using Storage parameters
• Working with Constraints and Indexes

User Management

• Creating and Managing Users and Resources
• Managing User Privileges and Roles

UNDO Management

• Understanding Undo / Redo basics
• Managing UNDO Tablespaces
• Flashback Concepts

Managing Control files and Redo Log files

• Purpose of Control files & Redolog files
• Multiplexing & Backing of Control files
• Multiplexing & Archiving of Online Redo Log files

Understanding Networking and their connectivity

• Overview of Oracle Net Architecture
• Different types of Networking
• Oracle Net Service Configurations
• Database Links, Materialized Views
• Oracle Shared Server-configuring shared servers & dispatchers

Backup and Recovery

• Basics of Database Backups & Recoveries
• User Managed Backups –Online, Offline, Exports/Imports & Data Pumps
• User Managed Recoveries – Complete, Incomplete, Point in time Recoveries
• Oracle Recovery Manager (RMAN) – Features & Components
• Configuring, Backup and Recoveries using RMAN
• Transportable Tablespaces (TTS), SQL*Loader

Performance Tuning

• Overview of Tuning
• Application Tuning ,Memory Tuning, SQL Tuning
• TKPROF, Explain Plan

Availability

• Data Guard-configuration,  Switch Over, Fail Over
• LogMiner
• Oracle Automatic Storage Management (Oracle ASM) - Oracle ASM Storage Components, Oracle ASM Instances, using OMF and User-Managed Files

Oracle Enterprise 11g Database Control (GUI tool for Oracle Database Administration)

• Overview of Enterprise Manager
• UNDO Advisor
• Events and Event Notification
• Scheduling Jobs

Difference between 9i, 10g and 11g

• New Features, deprecated features, installations