Oracle Database 11g Release 2 DBA Performance & Tuning
Course
In London-City
Description
-
Type
Course
-
Location
London-city
This Oracle Database 11g Release 2 DBA Performance & Tuning course introduces the DBA to the main concepts of Oracle Database performance tuning and management. DBAs will gain practical experience in analyzing and tuning database performance.The Oracle Database 11g Release 2 DBA Performance & Tuning course is suitable for users of Oracle Database 11g and Oracle Database 12c.Delegates on the Oracle Database 11g Release 2 DBA Performance & Tuning course will learn to identify tuning contentions and how to take corrective action. By the end of the course, delegates will be able to:Use tuning goals and methodologiesDetect and tune common database performance problemsUse the database advisors to proactively tune a databaseUse the AWR and ADDM tools to tune a databaseUse Enterprise Manager to monitor an Oracle databaseWho will the Course Benefit?The Oracle Database 11g Release 2 DBA Performance & Tuning course is suitable for database administrators and technical support staff who are required to monitor and tune an Oracle Database 11g Release or Oracle Database 12c. Target Audience The Oracle Database 11g Release 2 DBA Performance & Tuning course is suitable for database administrators, application developers and technical support staff who are required to monitor and tune an Oracle Database 11g or Oracle Database 10g. Learning Objectives The objective of the Oracle Database 11g Release 2 DBA Performance & Tuning course is to provide the skills needed to monitor and tune an Oracle Database 11g Release or Oracle Database 12c. The delegate will practice: Tuning database applications for optimal performanceIdentifying and resolving common tuning problemsUsing diagnostic sourcesManaging database statisticsIdentifying and correcting problem SQL statementsExamining the execution plan of a SQL statement using Explain PlanExamining the efficiency of SQL statements using SQL trace and autotraceUsing tools for monitoring and diagnosing SQL...
Facilities
Location
Start date
Start date
About this course
A working knowledge of SQL, PL/SQL and Oracle Database administration is required. These skills can be obtained by attendance on the pre-requisite Oracle SQL, Oracle PL/SQL and Oracle Database Administration courses. Pre-Requisite Courses Oracle SQLOracle Database 11g Release 2 DBA - Part IOracle PL/SQL
Reviews
Subjects
- Statistics
- Database training
- SQL
- Database
- Staff
- Access
- Monitoring
Course programme
DAY 1Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Overview of Oracle Database Tuning
- Application Developer Tuning Responsibilities
- Oracle DBA Tuning Responsibilities
- How to Tune an Oracle Database
- The Oracle Tuning Methodology
- Performance Tuning Diagnostics, Features, and Tools
- DB Time
- CPU and Wait Time Tuning Dimensions
- Time Model
- Dynamic Performance Views
- Statistics
- Wait Events
- Log Files and Trace Files
- The Processing Phases of a SQL Statement
- Monitoring SQL Statements
- Generating SQL Execution Plans
- Using the DBMS_XPLAN Package
- The EXPLAIN PLAN and Autotrace Commands
- Reading an Execution Plan
- The SQL Trace and tkprof Programs
- Generate and Interpret an Optimizer Trace
- Overview of the SQL Query Optimizer
- Manage the Optimizer Statistics
- Use Parameters to Influence the Behaviour of the Optimizer
- Enable Query Optimizer Features
- Use Hints to Influence the Optimizer
- Understand Access Paths
- Understand Join Operations
- Sort Operations
- Maintain Indexes
- The SQL Access Advisor
- Maintain Tables
- Reorganize Tables
- Manage Extents
- Compress Tables
- Row Chaining and Row Migration
- Segment Shrink
- An Overview of the SQL Performance Analyzer
- Usage of the SQL Performance Analyzer
- Capture a SQL Workload
- Create a SQL Performance Analyzer Task
- Generate Comparison Reports
- Tune Regressed Statements
- Guided Workflow Analysis
- SQL Performance Analyzer Views
- Maintenance of the Optimizer Statistics
- Automated Statistics Gathering
- Gather Statistics Options
- Defer Publishing Statistics
- Automatic SQL Tuning
- The SQL Tuning Advisor
- The SQL Access Advisor
- SQL Plan Management
- Overview of the Shared Pool Architecture
- Latches and Mutexes
- Diagnostic Tools for Tuning the Shared Pool
- Avoiding Hard Parses
- Size the Shared Pool
- Avoiding Fragmentation of the Shared Pool
- The Data Dictionary Cache
- The SQL Query Result Cache
- Overview of the Database Buffer Cache Architecture
- Buffer Cache Tuning Goals and Techniques
- Buffer Cache Performance Symptoms and Solutions
- Database Smart Flash Cache
- When to Flush the Buffer Cache
- Overview of the PGA
- SQL Memory Usage
- Automatic PGA Memory Mode Configuration
- PGA Target Advice Statistics and Histograms
- Automatic PGA and AWR Reports
- Temporary Tablespace Management
- Temporary Tablespace Group
- Multiple Temporary Tablespaces
- Monitoring Temporary Tablespaces
- Temporary Tablespace Shrink
- Data Dictionary Views and Sort Segments
- Overview of Automatic Shared Memory Management
- Dynamic SGA
- Parameters for Sizing the SGA
- Enable and Disable Automatic Shared Memory Management
- Use the SGA Advisor
- Overview of Automatic Memory Management
- Enable and Disable Automatic Memory Management
- Monitor Automatic Memory Management
- An Overview of the Automatic Workload Repository
- AWR Data
- Enterprise Manager and the AWR
- Create and Compare Snapshots
- Examine AWR Reports
- Create and Compare Baselines
- Moving Window Baseline
- Baseline Templates
- Baselines Views
- Performance Monitoring and Baselines
- Define Alert Thresholds Using a Static Baseline
- Configure Adaptive Thresholds
- An Overview of Monitoring and Tuning Tools
- Common Tuning Problems
- Define the Problem and Limiting the Scope
- Set the Priority of a Performance Issue
- View the Top SQL Reports
- Tune During the Life Cycle of a problem
- Generate and Analyze ADDM Reports
- Performance Tuning Resources
- An Overview of Metrics and Alerts
- The Benefits and Limitations of Metrics and Alerts
- System Generated, Threshold Generated and Event Based Alerts
- Set Thresholds
- View Metric History Information
- View Histograms
- Metric and Alert Views
- Automatic Maintenance Tasks
- ADDM Performance Monitoring
- Active Session History
- Generate an ASH Report
- Real-time ADDM
- Overview of Real Time Database Operation Monitoring
- Database Operation Concepts
- Define a Database Operation
- Enable the Monitoring of Database Operations
- Identify, Start and Complete a Database Operation
- Monitor the Progress of a Database Operation
- Database Operation Views
- Database Operation Tuning
- The Attributes and Types of Services
- Create Services
- Use Services with Client Applications
- Use Services with the Resource Manager
- Use Services the Oracle Scheduler
- Services and Metric Thresholds
- Use Aggregation of Services with Tracing
- The Top Services Performance Page
- Overview of Database Replay Architecture
- Use Enterprise Manager to Capture and Replay a Workload
- Use the Database Replay Packages to Capture and Replay a Workload
- Capture a Workload
- Pre-process the Captured Workload
- Configure Replay Clients
- Replay the Workload
- Replay Workload Options
- Analyze the Replayed Workload
- Database Replay Views
- An Overview of Database I/O Management
- I/O Architecture and Modes
- Important I/O Metrics for Oracle Databases
- I/O Calibration
- I/O Statistics and Diagnostics
- Database I/O Tuning
- Automatic Storage Management (ASM)
- The Potential Impact of Initialization Parameters on Performance
- Initially Size Memory for a Database
- Recommended Best Practices for Different Types of Tablespaces
- Determine and Use Block Sizes
- Size the Redo Log Buffer and the Redo Log Files
- Configure Automatic Statistics Gathering
Oracle Database 11g Release 2 DBA Performance & Tuning