New courses on-line: Oracle database 11GR2 (v): Performance tuning

Buy Oracle Database Course package and enjoy 85 discount!!

Package Address: http://edu.51cto.com/pack/view/id-807.html

Performance optimization for Oracle 11g R2 database

Database performance problem is the most discussed topic in database field, because it involves database principle, IO storage, server performance, foreground application and so on, so the performance problem is very test the optimization of internal strength. This course will describe the tuning options for Oracle databases in a variety of application environments, allowing you to build on (optimization, optimization, tools, and techniques), and to become an optimized person at an early date.

The Oracle database family of courses includes the following courses:

1. Oracle database (one of the OCP): SQL and Plsql

http://edu.51cto.com/course/course_id-6719.html

2. Oracle Database 11GR2 (OCP II): ORACLE11GR2 installation on Linux

http://edu.51cto.com/course/course_id-7088.html  

3. Oracle Database 11gR2 (OCP III): Advanced Management

Http://edu.51cto.com/course/course_id-7247.html

4. Oracle Database 11gR2 (OCP four): Backup and Recovery

Http://edu.51cto.com/course/course_id-6787.html

5. Oracle Database 11gR2 (v): Performance optimization

Http://edu.51cto.com/course/course_id-8321.html

6. Oracle Database 11gR2 (VI): Cluster RAC

Upcoming Releases

Students are advised to start with the first course and learn more about the content of Oracle database.

Oracle Database 11gr2 (v): Performance Optimization Course Outline

Chapter One Course overview

Overview of the chapters (*)

(*) Oracle Database Performance Tuning Overview

(*) Use OEM to monitor database performance

Chapter II Basic Optimization Tools

(*) Alarm Log

(*) Statistical information

(*) Implementation plan

(*) Trace file

(*) Dynamic performance view

(*) Auto Trace

Chapter III Performance reports for Oracle databases

(*) What is a snapshot of awr and awr

(*) generate an AWR snapshot

(*) generate three performance reports for Oracle database

(*) What is the Statspack report

The fourth chapter case analysis

(*) Writing test Cases

(*) Run test cases and generate performance reports

(*) Analysis of AWR reports

(*) Analysis of ADDM reports and Ash reports

Fifth. Using metrics and Alerts

(*) Several basic concepts

(*) View metrics for statistical information

(*) Server alerts

(*) Custom metrics

Sixth Chapter Baseline

(*) What is a baseline

(*) Create and manage baselines

(*) Use baseline to set thresholds for alerts

(*) Use OEM to quickly configure adaptive thresholds

(*) template for baselines

Seventh. Optimizing the data cache (buffer cache)

(*) The structure of the Buffer cache

(*) Calculation of Buffercache related data dictionary and hit ratio

(*) The process of searching for buffer cache

(*) Using the buffer cache guidance recommendations

(*) Buffer Cache-related wait events

(*) DBWN processes and sub-processes

Eighth. optimize shared pool

(*) Structure of shared pool and related data dictionary

(*) View the AWR report for a shared pool

(*) Diagnose one of the Librarycache: avoid hard parsing

(*) Diagnostic Librarycache: Avoid soft parsing

(*) Diagnosis Librarycache: Avoid fragmentation

(*) Diagnostic data dictionary cache and Resultcache

(*) Using Shared pool optimization guidance

Nineth. Optimizing PGA

(*) The process of establishing the memory structure and connection of the Oracle database

(*) PGA composition structure and related data dictionary

(*) Soft parsing and hard parsing

(*) Set the initial value of the PGA

Tenth. Optimizing temporary space

(*) What is temporary data

(*) Best practices for managing temporal tablespace

(*) Monitoring temporary tablespace

(*) Use temporary tablespace groups

11th. Impact Optimization Program

(*) Optimizer overview

(*) affects one of the optimizer behaviors: using hints
(*) affects optimizer behavior two: Optimizer statistics
(*) affects the behavior of the optimizer three: Using parameters to control the behavior of the optimizer
(*) Impact optimizer behavior four: affect access path
(*) Impact optimizer behavior five: Link action
(*) affects the optimizer's behavior six: sort operations

12th. Optimizing input and output (I/O)

(*) basic knowledge of disk

(*) Reduce physical I/O by index

(*) Stripe of file: distributed I/O

(*) I/O-related wait events

This article is from my blog blog, so be sure to keep this source http://collen7788.blog.51cto.com/2788082/1913979

New courses on-line: Oracle database 11GR2 (v): Performance tuning