Modalidad de imparticiónEl Formulario Curso Review: Curso de Oracle 11g: SQL Tuning Workshop será impartido a través de un modo presencial.
Número de horasEl tiempo total de duración del programa será de 40 horas.
Titulación oficialLa participación del estudiante en el programa será certificada a través de una constancia oficial.
Valoración del programaEste programa tiene como finalidad principal entregar a los estudiantes la preparación necesaria en el uso de Estadísticas de Database, identificando los problemas de representación. A través del plan de estudios el estudiante encontrará herramientas que le permitirán identificar problemas en la programación SQL, monitoreando diferentes procesos para evitar problemáticas que puedan surgir en el desarrollo de la aplicación.
Precio del cursoConsultar precio.
Dirigido aEste programa está dirigido a Administradores de Database, Ingenieros y consultores técnicos que quieran capacitarse a este respecto.
EmpleabilidadEste conocimiento elevará la calidad en el desempeño de los participantes, para de esta manera estar en continuos procesos de actualización en informática y aplicaciones.
Curso de Oracle 11g: SQL Tuning Workshop
ContenidoCurso de Oracle 11g: SQL Tuning Workshop
Duración: 40 hrs
Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance through a series of workshops. The methodology is practiced in the workshops rather than taught.
This course does not address partition tuning, materialized views, or RAC specific issues as they are covered in courses specifically for these products. This course makes use of many features that require the Enterprise Edition and optional Packs.
Requisito
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II
Dirigido a
Database Administrators
Support Engineer
Technical Consultant
Objetivos
Use Database Statistics and Metrics to identify a performance problem
Interpret Tuning diagnostics
Identify and eliminate performance issues
Set tuning priorities and strategies
Identify problem SQL statements
Influence the optimizer
Temario
Introduction
Tuning Questions
Who tunes
What to tune
How to tune
Monitoring With Basic Tools
Monitoring tools overview
Enterprise Manager
V$ views, Statistics and Metrics
Wait Events
Time Model: Overview
Using Automatic Workload Repository
Automatic Workload Repository: Overview
Automatic Workload Repository Data
Database Control and AWR
Generating AWR Reports in SQL*Plus
Identifying the Problem
Tuning Life Cycle Phases
Identify a Tuning Issue
Remedy one problem
Identifying Problem SQL Statements
Characteristics of a bad SQL statement
Role of the Optimizer
Generate explain plan
Access Paths Choices
Trace the execution
Influencing the Optimizar
Manage Optimizer Statistics
Calibrate I/O
Optimizer Cost
Changing Optimizer Behavior
SQL Plan Management
Automatic Maintenance Tasks
SQL Profiles
SQL Access Advisor
SQL Outlines
SQL Plan Baselines
Change Management
Types of changes
SQL Performance Analyzer
DB Replay
Server-Generated Alerts
Using Metrics and Alerts
Benefits of Metrics
Database Control Usage Model
User-Defined SQL Metrics
Using AWR Based Tools
Automatic Maintenance Tasks
Using ADDM
Using Active Session History
Historical Data View
Monitoring an Application (Using Services)
Service Overview
Managing Service
Service Aggregation and Tracing
Tracing Your Session
Baselines
Working with Metric Baselines
Setting Adaptive Alert Thresholds
Configuring Normalization Metrics
Tuning the Shared Pool
Shared Pool Operation
Mutex
Statspack/AWR Indicators
Library Cache Activity
Diagnostic Tools
UGA and Oracle Shared Server
Large Pool
Tuning the Buffer Cache
Architecture
Tuning Goals and Techniques
Symptoms
Solutions
Tuning PGA and Temporary Space
Monitoring SQL Memory Usage
Temporary Tablespace Management
Automatic Memory Management
Automatic Memory Management Architecture
Dynamic SGA Feature
Managing Automatic Memory Management
Tuning Block Space Usage
Space Management
Extent Management
Anatomy of a Database Block
Block Space Management
Tuning I/O
I/O Architecture
Striping and Mirroring
Using RAID
I/O Diagnostics
Using Automatic Storage Management
Performance Tuning: Summary
Important Initialization Parameters with Performance Impact