Description

This course is essential for those who wish to administer their databases while taking advantage of advanced features. Among the points covered are: OEM, advanced network configuration, task scheduling, redefinition of online tables, use of alerts and Flashback.

Who is this training for ?

Oracle 11g database administrators, application administrators, system administrators and consultants.

Training objectives

Training program

• Introduction and reminders
  • - Control files, redo log.
  • - Transactions.
  • - Identification of a database.
  • - Automated installation by response file, application of patches.
• Advanced configuration
  • - Network.
  • - Remote listener.
  • - Connection filtering.
  • - OEM.
  • - Architecture.
  • - Grid Control vs Database Control.
  • - The repository.
  • - Administration console and modules.
  • - Exercise: Configuring the network to to start the database remotely.
  • - Configuring EM Database Control.
• Task Scheduling
  • - Using DBMS_JOB.
  • - Introduction to Oracle Scheduler.
  • - Definition of jobs.
  • - Exercise: Schedule a job with Oracle Scheduler.
• Monitoring, advanced maintenance
  • - Automatic Diagnostic Repository (ADR).
  • - Alert log.
  • - Workbench support.
  • - Set alert thresholds.
  • - Use alerts.
  • - Monitoring used space.
  • - Oracle memory structures.
  • - Automatic management.
  • - Database storage structures.
  • - Flashback techniques: Flashback Transaction, presentation of Flashback Data Archive technology.
  • - Exercise: Monitor the database and its objects.
  • - Redefine tables online.
  • - Use Flashback.
• Resource Manager
  • - Concepts, configuring Database Resource Manager.
  • - Create a new resource allocation plan.
  • - Active session pool.
  • - Maximum execution time.
  • - Create groups of resource consumers.
  • - Exercise: Creating a resource plan with EM.
• Automatic Storage Management (ASM)
  • - Architecture.
  • - Features.
  • - Installing the Grid Infrastructure.
  • - The Oracle Restart tool.
  • - Managing an ASM instance.
  • - ASM disk groups.
  • - Migrating a database into ASM.
  • - Exercise: Update in place of Oracle 11g ASM (Grid Infrastructure).
• Database Replay
  • - System architecture: capture, global load processing, re-execution.
  • - Production system before modification.
  • - Use the Capture wizard.
• Table partitioning
  • - Compression of tables and tablespaces.
  • - Partitioning by interval, by system, by virtual column and by reference.
  • - Maintenance of partitioned tables.
  • - Exercise: Creating and modifying partitioned tables and indexes.