Oracle DBA

Introduction

• Install  Oracle  Software, Tools
• Manage Database Users
• Storage :  Datafiles ,Tablespaces
• Performance  Issues
• Manage  Database  Objects
• Security (Auditing)
• Networking
• Exporting /  Importing Data
• Recover From Disasters

SQL Plus Vs ISQL Plus

• Connecting
• Editor Shortcuts
• Saving The Evidence
• Your  Environment   ( Sql Path)
• Dynamic Scripts
• Isql Plus

Oracle Installation And Database Creation

• Oracle Editions
• Installations Pre Reqs
• Oracle Universal Installer
• Creating A Database
  • Dbca
  • Response Files (Quiet Install)
  • Manually

Special Considerations For Win/Linux/Unix

Oracle Architecture

• Database Vs Instance
• Rac Overview
• Memory Structure
• Background Process
• Server Process
• Physical Structure
• Logical Structure

Start Up, Shut Down & Parameter File

• Special Admin Privilages
• Startup/Shutdown Process
• Initialization Vs Spfile
• Changing Initialization Parameters
• Creating Pfile From Spfile
• Creating Spfile From Pfile
• Data Dictionary Views

Managing Tables, Views, Constraints & Sequences

• Table Structure  : Storage Classses
• Constraints
• Sequences – Auto Incrementing!
• Views
• Updatable / Non Updatable Views

Data Moving Utilities

• Exporting / Importing
• Database  Level
• Schema  Level
• Table Level
• Trasportable Tablespace
• 10g Datapump
• Sql Loader

Pl-Sql Basics

• Why Pl-Sql?
• Control Flow
• Reusability
• Types Of Pl-Sql Code
• Anonymous Blocks
• Procedureds/Functions
• Packages
• Triggers
• Data Types : Variables
• Scalar
• Composite
• Reference
• Statements : Control Flow
• If....End If
• Loops

C Ursors & Exceptional Handling

Procedures, Functions & Triggers

• Procedurs
• Functions
• Passing Parameters
• Named,Positional,Mixed Notations
• Hidingcodding With Wrapping
• Dropping Procedures And Functions

• Triggers
• Table Triggers
• Ddl Triggers
• Log On/ Log Off Triggers
• Disabling/Enabling

Managing Packages

• Why Use Packages?
• Common Packages
  • Standard
  • Dbms_Output
  • Dbms_Stats
  • Dbms_Scheduler
• Creating Packages (Spec,Body)
• Data Dictionary Views

Managing Undo

• Why Undo?
• Undo Vs Rollback Segments
• Configuring Undo
• Sizing The Undo Tablespace
• Undo Adviser
• Creating, Altering,  Dropping & Switching Undo Tablespace

Managing Tablespaces

• What Is That  Tablespace Anyway?
• Assingning Tablespace Quotas
• Locally Vs Dictonarymanaged Tbs
• Types Of Tablespaces
• Locally Vs Dictionary Manager
• Big File Tablespace
• Read Only Tablespaace
• Regular, Undo, Temp Tablespace
• Temp Tablespace Groups
• Creating, Renaming,Dropping Tablespaces
• Viewing Info On Tablespaces

Managing Users

• Users & Schemas
• Creating, Altering, Dropping Users
• Profiles
• Privilages
• Session Finding & Killing Them
• Simple Auditing
• Data Dictionary Views

Oracle Net Services

• Benefits : Features
• Hetrogenious, Distrubuted Env
• Requires Little Networking Knowledge
• Performance / Security Benefits
• The Listeners
• Naming Methods
• Local Naming
• Ldap
• Easy Connect (10g)
• Trouble Sooting Tools (Ping, Tnsping, Trace Files)
• Distrubuted Query Examples

Shared Server

• Shared Server Concepts
• Dedicated Vs Shared Server
• Dispatchers
• Server Processes
• Request, Response, Queues
• Configuring Parameters
• Configuring Memory
• Forced Dedicated Server For Client
• Monitoring Shared Server

Oracle Security

• Moniter Sysdba Privs (V$Pwfile_Users)
• Moniter Os Authentication
• Passwords
• Change Default Usernames/Passwords
• Strong Password Rules Through Profiles
• Passwor Vault
• Privilages
• Object /System Privs With (Grant/Admin Options)
• Check Os Privs For Datafiles
• Register For Security Updates
• Network Security
• Use Secure Protocol W/Apps
• Password Product Listener
• Close Unessary Open Ports
• Database Auditing
• Log On / Log Off Triggers
• Created / Dropped Objects
• Fine Grained Auditing (Dba_Fga_Aaudit_Trail)

Oracle Locks, Latches & Waits

• Latches Vs Locks
• Lock Modes
• Data Dict Views
• Types Of Latches And Locks
• Transaction Locks, Row_Level Locks
• Buffer Locks
• Data Dictionary Locks
• Enqueue
• Library Cache
• Owi Components
• V$System_Event
• V$Session_Event
• V$Session_Wait
• V$Event_Name
• Types Of Waits
• Dbfile Seqential Read
• Dbfile Scattered Read
• Direct Path Read/Write
• Enqueue
• Buffer Busy Waits
• Library Cache Pin

Oracle Performance

• System Tuning
• Tuning Log Switches
• Pga_Aggregate Target
• Tuning Advisors
• Pinning Packages In Memory
• Stats Pack
• Sql Tuning
• Index
• Oracle Optimizer
• Explain Plan
• Hints
• Stored Outlines

Backup – Recovery Concepts

• Types Of Failure
• Configuring Archive Log Mode
• Components To Backup
• Types Of Backup (Full Vs Incrimantal, Block Change Tracking)
• Hot Vs Cold Backups

Oracle RMAN (Recovery Manager)

• Catalog Vs Nocatalog Mode
• Registering And Connecting To Rman Catalog
• Configuring Rman
• Basic Rman Commands
• Rman Data Dictionary Views

Restore- Recover Tactics

• Control Files
• Redo Logs
• Recovering Non – Critical Datafiles
• Recovering Critical Datafiles
• Tuning  :  Monitoring Recovery

(OEM) Oracle Enterprise Manager DBconsole

• Configuring & Connecting
• Monotering Performance
• Basic Maintainence
• Clone Database
• Manage Backup & Recovery