Description

This training will teach you to identify performance problems with your Oracle11g databases and to implement appropriate solutions to deal with them. You will learn in particular how to size the different areas of memory (PGA, buffer cache, Shared Pool) and how to optimize logging and I/O.

Who is this training for ?

This course is aimed at experienced administrators on Oracle11g.

Training objectives

Training program

• Introduction
  • - The optimization process.
  • - Possible gains.
  • - Determination and control of objectives.
• Statistics, Wait events, AWR

  - n'as pas encore du programme

• The optimizer and SQL Plan Management
  • - Manage statistics and execution plans.
  • - Identify access to database objects.
  • - SQL Plan Management.
  • - Automatic management of maintenance tasks.
  • - Use SQL Profile to optimize queries.
  • - Practical work Calculate statistics for a database.
  • - Generate the execution plans.
  • - Use SQL Plan Management to preserve performance in the case of application developments.
• Management of developments
  • - Types of possible developments.
  • - SQL Performance Analyzer (SPA).
  • - Using DB Replay.
  • - Defining filters.
  • - Replay function.
• Manage baseline measurements
  • - Adaptive thresholds and baseline metrics.
  • - Set adaptive alert thresholds.
  • - Configure normalization metrics.
• Diagnosis and adjustments
  • - Problems related to the SHARED POOL area, buffer cache, PGA memory, temporary tablespaces, I/O.
  • - Architectural elements.
  • - Understand the activity of the library cache area.
  • - Size the buffer cache.
  • - Automatic memory management.
  • - Characteristics.
  • - Manage space in segments.
  • - BIGFILE and SMALLFILE tablespaces.
  • - Optimize I/O.
  • - Stripping and Mirroring.
  • - RAID.
  • - Practical work Configure the database for better conservation of SQL queries in the library cache.
  • - Define the storage zones for blocks of a size other than the default.
• Journaling
  • - Adjustment of checkpoints.
  • - Impact of archiving.
  • - Size the redo log buffer and the redo log files.
  • - Practical work Optimize the size of files and the redo log buffer.