Oracle OCA series

Oracle DBA

Introduction

 Install Oracle Software, Tools  Security (Auditing)

 Manage Database Users  Networking

 Storage : Datafiles ,Tablespaces  Exporting / Importing Data

 Performance Issues  Recover From Disasters

 Manage Database Objects



SQL Plus Vs ISQL Plus

 Connecting  Your Environment ( Sql Path)

 Editor Shortcuts  Dynamic Scripts

 Saving The Evidence  Isql Plus



Oracle Installation And Database Creation

 Oracle Editions o Response Files (Quiet Install)

 Installations Pre Reqs o Manually

 Oracle Universal Installer Special Considerations For

 Creating A Database Win/Linux/Unix

o Dbca



Oracle Architecture

 Database Vs Instance  Server Process

 Rac Overview  Physical Structure

 Memory Structure  Logical Structure

 Background Process



Start Up, Shut Down & Parameter File

 Special Admin Privilages  Creating Pfile From Spfile

 Startup/Shutdown Process  Creating Spfile From Pfile

 Initialization Vs Spfile  Data Dictionary Views

 Changing Initialization Parameters



Managing Tables, Views, Constraints & Sequences

 Table Structure : Storage Classses  Views

 Constraints  Updatable / Non Updatable Views

 Sequences – Auto Incrementing!





Data Moving Utilities

 Exporting / Importing  Trasportable Tablespace

 Database Level  10g Datapump

 Schema Level  Sql Loader

 Table Level

Pl-Sql Basics

 Why Pl-Sql?  Reusability

 Control Flow  Types Of Pl-Sql Code

 Anonymous Blocks 2. Composite

 Procedureds/Functions 3. Reference

 Packages  Statements : Control Flow

 Triggers o If....End If

 Data Types : Variables o Loops

1. Scalar C Ursors & Exceptional Handling





Procedures, Functions & Triggers

 Procedurs

 Functions o Triggers

 Passing Parameters o Table Triggers

 Named,Positional,Mixed Notations o Ddl Triggers

 Hidingcodding With Wrapping o Log On/ Log Off Triggers

 Dropping Procedures And Functions o Disabling/Enabling





Managing Packages

 Why Use Packages? o Dbms_Stats

 Common Packages o Dbms_Scheduler

o Standard  Creating Packages (Spec,Body)

o Dbms_Output  Data Dictionary Views





Managing Undo

 Why Undo?  Undo Adviser

 Undo Vs Rollback Segments  Creating, Altering, Dropping &

 Configuring Undo Switching Undo Tablespace

 Sizing The Undo Tablespace





Managing Tablespaces

 What Is That Tablespace Anyway? 4. Regular, Undo, Temp Tablespace

 Assingning Tablespace Quotas  Temp Tablespace Groups

 Locally Vs Dictonarymanaged Tbs  Creating, Renaming,Dropping

 Types Of Tablespaces Tablespaces

1. Locally Vs Dictionary Manager  Viewing Info On Tablespaces

2. Big File Tablespace

3. Read Only Tablespaace





Managing Users

 Users & Schemas  Session Finding & Killing Them

 Creating, Altering, Dropping Users  Simple Auditing

 Profiles  Data Dictionary Views

 Privilages





Oracle Net Services

 Benefits : Features  Performance / Security Benefits

 Hetrogenious, Distrubuted Env  The Listeners

 Requires Little Networking Knowledge  Naming Methods

 Local Naming  Trouble Sooting Tools (Ping, Tnsping,

 Ldap Trace Files)

 Easy Connect (10g)  Distrubuted Query Examples





Shared Server

 Shared Server Concepts  Configuring Parameters

1. Dedicated Vs Shared Server  Configuring Memory

2. Dispatchers  Forced Dedicated Server For Client

3. Server Processes  Monitoring Shared Server

4. Request, Response, Queues





Oracle Security

 Moniter Sysdba Privs 2. Check Os Privs For Datafiles

(V$Pwfile_Users)  Register For Security Updates

 Moniter Os Authentication  Network Security

 Passwords 1. Use Secure Protocol W/Apps

1. Change Default 2. Password Product Listener

Usernames/Passwords 3. Close Unessary Open Ports

2. Strong Password Rules Through  Database Auditing

Profiles 1. Log On / Log Off Triggers

3. Passwor Vault 2. Created / Dropped Objects

 Privilages 3. Fine Grained Auditing

1. Object /System Privs With (Dba_Fga_Aaudit_Trail)

(Grant/Admin Options)





Oracle Locks, Latches & Waits

 Latches Vs Locks 2. V$Session_Event

1. Lock Modes 3. V$Session_Wait

2. Data Dict Views 4. V$Event_Name

 Types Of Latches And Locks  Types Of Waits

1. Transaction Locks, Row_Level Locks 1. Dbfile Seqential Read

2. Buffer Locks 2. Dbfile Scattered Read

3. Data Dictionary Locks 3. Direct Path Read/Write

4. Enqueue 4. Enqueue

5. Library Cache 5. Buffer Busy Waits

 Owi Components 6. Library Cache Pin

1. V$System_Event





Oracle Performance

 System Tuning  Sql Tuning

1. Tuning Log Switches 1. Index

2. Pga_Aggregate Target 2. Oracle Optimizer

3. Tuning Advisors 3. Explain Plan

4. Pinning Packages In Memory 4. Hints

5. Stats Pack 5. Stored Outlines

Backup – Recovery Concepts

 Types Of Failure  Types Of Backup (Full Vs Incrimantal,

 Configuring Archive Log Mode Block Change Tracking)

 Components To Backup  Hot Vs Cold Backups

Oracle RMAN (Recovery Manager)

 Catalog Vs Nocatalog Mode  Basic Rman Commands

 Registering And Connecting To Rman  Rman Data Dictionary Views

Catalog

 Configuring Rman





Restore- Recover Tactics

 Control Files  Recovering Critical Datafiles

 Redo Logs  Tuning : Monitoring Recovery

 Recovering Non – Critical Datafiles





(OEM) Oracle Enterprise Manager DBconsole

 Configuring & Connecting  Clone Database

 Monotering Performance  Manage Backup & Recovery

 Basic Maintainence

















C-Point

#402, 4th Floor, ADR Estate, Opp: RS Brothers, Above Bank of India, KPHB Main Road, Hyderabad-72



Ph: 66332737, 9290929394

website: http://www.c-point.in Email: trainings@c-point.in