Oracle Database 10g Oracle Database 10g-Administration II

							                10g-
Oracle Database 10g-Administration II
Course Specifications
Course number: 085573
Software:      Oracle Database 10g
Course length: 3.0 day(s)

Course Description
A good Oracle database administrator must gain and maintain a mastery of his or her environment, its
physical structures, and its maintenance routines. An administrator must understand the data being
stored well enough to tune and improve performance, to anticipate and prevent data failure, and to
recover lost data should a failure occur. In this course, you will develop an advanced understanding of
complex Oracle database concepts, maintenance and recovery routines, and database management.
You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative
functionality so that you can maintain the healthiest possible database.
Course Objective: You will learn how to control and manage an Oracle installation.
Target Student: This course is intended for Oracle Database 10g Administrators, Sales Consultants,
Support Engineers, Oracle Software Developers and Technical Consultants. Students should have some
knowledge of Oracle database utilities, architecture, and terminology, including some experience with
SQL*Plus, iSQL*Plus, and PL/SQL.
Prerequisites: The following courses are suggested prerequisites:
    •    Introduction to Programming (Second Edition)
    •    SQL: Fundamentals of Querying (Second Edition)
    •    Object-Oriented Programming: Principles
    •    Java 2: Object-Oriented Analysis and Design using UML
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-
on activities.

Hardware Requirements
•   P4 2600 Mhz processor or more
•   1 GB RAM or more
•   40 GB or larger hard disk
•   2 additional 10 GB or larger hard disks
•   DVD-ROM or CD-ROM drive
•   256 color video adapter

Platform Requirements
•   Windows

Software Requirements
•   Windows XP Professional
•   Oracle 10g Database Enterprise Edition




                                                      –1–
    To find out more about all of the products and services from Masterskill, please visit www.masterskill.co.za
                                                 Course Outline


Performance-
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
•   monitor the database.
•   monitor and manage memory.
•   monitor and manage database performance.
•   monitor and manage storage.
•   restore data with Oracle Flashback.
•   back up and recover data.
•   configure Oracle's Recovery Manager (RMAN).
•   perform RMAN backups.
•   perform RMAN recoveries.
•   utilize Automatic Storage Management.
•   automate tasks with the Scheduler.
•   identify and configure globalization support configuration information.

Course Content
Lesson 1: Monitoring the Database
        Topic 1A: Diagnose Issues Using Trace Files and the Alert Log
        Topic 1B: Adjust Thresholds for Tracked Metrics
        Topic 1C: Secure the Listener

Lesson 2: Monitoring and Managing Memory
        Topic 2A: Manually Configure SGA Parameters for Various Memory Components
        Topic 2B: Using Automatic Shared Memory Management
        Topic 2C: Configure Automatic PGA Memory Management

Lesson 3: Monitoring and Managing Database Performance
        Topic 3A: Improve Database Performance Using the SQL Tuning Advisor
        Topic 3B: Manage Resources
        Topic 3C: Tune Redo Log and Archive Log Operations

Lesson
Lesson 4: Monitoring and Managing Storage
        Topic 4A: Manage Tablespace Usage
        Topic 4B: Reclaim Wasted Space from Tables and Indexes
        Topic 4C: Estimate the Size of New Tables and Indexes
        Topic 4D: Improve Query Performance Using Different Storage Options
        Topic 4E: Rebuild Indexes Online

Lesson 5: Restoring Data With Oracle Flashback
        Topic 5A: Recovering Data Using Flashback Technology
        Topic 5B: Flashback the Database Using the OEM Recovery Wizard
        Topic 5C: Maintaining the Flash Recovery Area
        Topic 5D: Using Automatic Undo Retention Tuning

Lesson 6: Backing Up and Recovering Data
        Topic 6A: Recover Tablespaces and the Password File
        Topic 6B: Perform Incomplete Recoveries
        Topic 6C: Perform Database Recovery Through a RESETLOGS Operation
        Topic 6D: Detect Database Corruption

Lesson 7: Configuring the Recovery Manager (RMAN)
        Topic 7A: Recovery Manager
        Topic 7B: Configure the RMAN Environment

                                                      –2–
    To find out more about all of the products and services from Masterskill, please visit www.masterskill.co.za
                                                Course Outline


Lesson 8: Performing RMAN Backups
        Topic 8A: Create RMAN Image Copies
        Topic 8B: Conduct RMAN Online Backups
        Topic 8C: Conduct RMAN Incremental Online Backups
        Topic 8D: Back Up Archive Logs
        Topic 8E: Manage RMAN Backups

Lesson 9: Performing RMAN Recoveries
        Topic 9A: Perform an RMAN Complete Recovery
        Topic 9B: Perform an RMAN Incomplete Recovery
        Topic 9C: Repair Block Corruptions Using RMAN

Lesson 10: Utilizing Automatic Storage Management (ASM)
        Topic 10A: Automatic Storage Management
        Topic 10B: Set up Initialization Parameters and Start an ASM Instance
        Topic 10C: Administer ASM Disk Groups
        Topic 10D: Migrate Your Database to ASM Using RMAN

Lesson 11: Automating Tasks with the Scheduler
        Topic 11A: Simplify Management Tasks by Using the Scheduler
        Topic 11B: Reuse Scheduler Components for Similar Tasks
        Topic 11C: View Information About Job Executions and Job Instances

           Using
Lesson 12: Using Globalization Support Objectives
        Topic 12A: Obtain Globalization Support Configuration Information
        Topic 12B: Customize Language-Dependent Behavior
        Topic 12C: Specify Different Linguistic Sorts for Queries
        Topic 12D: Use Datetime Datatypes
        Topic 12E: Query Data Using Case-Insensitive and Accent-Insensitive Sorting




                                                     –3–
   To find out more about all of the products and services from Masterskill, please visit www.masterskill.co.za