In this 3 day instructor led class, students will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management.
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, SQL*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
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 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
- 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
- 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
To Hire a proven Oracle Database Subject Matter Expert Consultant and Instructor who teaches this class, call 800-798-3901 today!