Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 10g DBA II

GK# 8364 Vendor# OR203

Course Overview

TOP

Through hands-on experience in administering an Oracle 10g database, you will learn advanced concepts and fully master Oracle database administration.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Configure for globalization support
  • Secure the Oracle listener
  • Configure and use Recovery Manager
  • Identify and use diagnostic information
  • Recover your database
  • Use the new automation tools
  • Manage database storage
  • Manage memory and other database resources
  • Use Scheduler to automate tasks
  • Why to flashback a database

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

  • Parameters affecting RMAN
  • Flashback recovery area
  • The CONFIGURE command
  • Persistent settings
  • Using RMAN
  • Channel allocation
  • Controlfile Autobackup
  • Retention policies

2. Recovery Manager Operations

  • Using the BACKUP command
  • Creating backup sets and image copies
  • Parallelization
  • Compressed backups
  • Whole database copying
  • Incremental backups
  • Block change tracking
  • RMAN Backup Monitoring

3. Non-Critical Loss Recovery

  • Password files
  • Read-only tablespaces
  • Temporary tablespaces
  • Index tablespaces
  • Redo log members

4. Database Recovery

  • Recovering the control file
  • Reasons for incomplete recovery
  • Recovery after RESETLOGS
  • Incomplete recovery using EM, RMAN, and SQL

5. Flashback Database

  • When to use
  • Configuration
  • Monitoring

6. Flashback Database

  • Using EM for Flashback Database
  • Flash Recovery Area maintenance and monitoring

7. User Error Recovery

  • The new recycle bin
  • Flashback a dropped table using EM

8. Block Corruption Management

  • DBVERIFY and ANALYZE
  • DBMS_REPAIR
  • Block Media Recovery
  • DBMS_BLOCK_CHECKING parameter
  • Using RMAN for block corruption

9. Automatic Database Management

  • Automatic statistics collection
  • Automated workload repository
  • Database advisors
  • SQL Tuning advisors
  • SQL access advisors
  • Automatic undo retention
  • Adjusting thresholds for managed metrics

10. Globalization Support

  • Timezones and datetimes
  • Language-dependent behavior
  • Locales and variants
  • Case and accent insensitive sorts
  • Linguistic sorting
  • Querying GS configuration

11. Resource Management

  • Resource Manager Configuration
  • Resource Management Groups
  • Resource plans and directives
  • Directives for resource allocation
  • Adaptive Consumer Group Mapping

12. Scheduler

  • Creating jobs and job classes
  • Schedules and windows
  • Prioritizing jobs
  • Scheduler component reuse
  • Query Scheduler information

13. Storage Management

  • Tuning archiving
  • Redo Log Size Advisor
  • Segment Advisor
  • Managing resumable operations
  • Proactive tablespace management
  • Table/ index size estimation
  • Optimizing storage options
  • Online index rebuilds

14. Listener Security

  • Password authentication
  • Securing EXTPROC
  • Controlling access

15. Diagnostic Sources

  • Alert logs and trace files
  • Enterprise Manager and Alerts
  • Controlling trace file size
  • Alert notification

16. Memory Management

  • Memory structures
  • Automatic shared memory management
  • SGA configuration
  • Automatic PGA memory management
  • Memory Advisor

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Globalization Support

Lab 2: Listener Security

Lab 3: Configuring Recovery Manager

Lab 4: Using Recovery Manager

Lab 5: Managing Diagnostic Sources

Lab 6: Database Recovery

Lab 7: Flashback Database

Lab 8: User Error Recovery

Lab 9: Dealing with Corruption

Lab 10: Automated Management

Lab 11: Managing Storage

Lab 12: Managing Memory

Lab 13: Managing Resources

Lab 14: Scheduler

Who Should Attend

TOP

Data analysts, database administrators, systems administrators, network managers, and technical support personnel

Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll