Shulou(Shulou.com)06/01 Report--

Buy the Oracle database course package and enjoy a 15% discount!

Oracle Database 11g (Q1): development and Advanced Management

Http://edu.51cto.com/pack/view/id-1040.html

Oracle Database 11g (Q2): backup recovery and performance optimization

Http://edu.51cto.com/pack/view/id-1041.html

Performance Optimization of Oracle 11g R2 Database

The performance problem of database is the most discussed topic in the database field, because it involves database principle, IO storage, server performance, foreground application and so on, so the performance problem tests the internal skills of optimizers. This course will describe the tuning scheme of ORACLE database in various application environments, so that you can take part-time courses inside (optimization principles, optimization ideas) and outside (optimization tools, skills), so that you can become an optimization expert as soon as possible.

The Oracle database series includes the following courses:

1. Oracle data base (one of OCP): SQL and PLSQL

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

2. Oracle database 11gR2 (OCP II): installation of Oracle11gR2 on Linux

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

3. Oracle database 11gR2 (OCP III): senior management

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

4. Oracle database 11gR2 (OCP IV): 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

It will be released soon

It is recommended that students start from the first course and learn step by step, so that they can better grasp and understand the contents of the Oracle database.

The syllabus of "Oracle Database 11gR2 (V): performance Optimization"

Chapter I Overview of the course

(*) Overview of each chapter

(*) Overview of Oracle database performance optimization

(*) use OEM to monitor database performance

Chapter II basic optimization tools

(*) alarm log

(*) Statistics

(*) implementation of the plan

(*) tracking file

(*) dynamic performance View

(*) auto trace

Chapter III Oracle Database performance report

(*) what are snapshots of AWR and AWR

(*) generate AWR snapshot

(*) generate three performance reports for Oracle database

(*) what is the statspack report

Chapter IV case study

(*) write test cases

(*) run test cases and generate performance reports

(*) Analysis of AWR reports

(*) Analysis of ADDM and ASH reports

Chapter V use of metrics and early warning

(*) several basic concepts

(*) View the metrics of statistics

(*) Server early warning

(*) Custom Metric

Chapter VI baseline

(*) what is the baseline

(*) create and manage baselines

(*) use the baseline to set the threshold for early warning

(*) use OEM to quickly configure adaptive thresholds

(*) template for baseline

Chapter 7 optimized data caching (Buffer Cache)

(*) structure of Buffer Cache

(*) calculation of BufferCache-related data dictionary and hit rate

(*) the process of searching for Buffer Cache

(*) guidelines for using Buffer Cache

(*) wait events related to Buffer Cache

(*) DBWn processes and child processes

Chapter 8 optimized shared Pool (Shared Pool)

(*) structure of shared pool and related data dictionary

(*) View AWR reports of shared pools

(*) Diagnostic LibraryCache one: avoid hard parsing

(*) Diagnostic LibraryCache II: avoid soft parsing

(*) Diagnostic LibraryCache III: avoid fragmentation

(*) Diagnostic data dictionary cache and ResultCache

(*) guidance for using shared pool optimization

Chapter 9 optimizing PGA

(*) memory structure and connection establishment process of Oracle database

(*) the composition and structure of PGA and related data dictionary

(*) soft and hard parsing

(*) set the initial value of PGA

Chapter 10 Optimization of temporary Space

(*) what is temporary data

(*) Best way to manage temporary tablespaces

(*) Monitoring temporary tablespaces

(*) use temporary tablespace groups

Chapter 11 affects the optimization procedure

(*) Overview of optimizer

(*) one of the behaviors that affects the optimizer: using hints

(*) influence optimizer behavior II: optimizer statistics

(*) influence optimizer behavior 3: use parameters to control optimizer behavior

(*) affect optimizer behavior IV: affect access path

(*) part 5 that affects the behavior of the optimizer: link operation

(*) influence optimizer behavior part VI: sorting operation

Chapter XII optimized input and output (Igamo)

(*) basic knowledge of disk

(*) reduce physical Ibank O through index

(*) striping of files: distributed Ippo

(*) wait events related to IWeiO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.