Oracle 11g数据库性能优化课程


Oracle数据库的性能调优,始终是DBA关注的重要话题,本课程深入剖析与性能有关的各项技术,通过实际案例来进行有针对性的分析与解决。


Oracle 11g数据库性能优化课程定位于数据库高级管理技术,是学员保持技术竞争力的优选课程。


基础要求:

  1. Oracle Database 11g: Administration Workshop I (052)

  2. Oracle Database 11g: Administration Workshop II (053)

  3. Oracle Database 11g: SQL and PL/SQL Fundamentals (051)


学习实验环境:Linux虚拟化云环境。


 
Oracle11g数据库性能优化课程模块说明:

序号 模块说明
1 使用数据库指导进行预先的数据库优化
2 使用基于AWR的工具来优化数据库
3 诊断和优化常见的SQL相关的性能问题
4 诊断和优化常见的实例相关的性能问题
5 使用EM性能相关的页面来监视Oracle数据库


 
课程详细内容介绍

  1. Introduction

序号 授课内容
1) Tuning Methodology
2) Effective Tuning Goals
3) General Tuning Session

  2. Basic Tuning Diagnostics

序号 授课内容
4) View the top wait events to determine the highest wait
5) View the time model to diagnose performance issues
6) Use dynamic performance views to view statistics and wait events
7) Use Enterprise Manager Monitoring
8) Identify the key tuning components of the alert logs
9) Identify the key tuning components of user trace files

  3. Using Automatic Workload Repository

序号 授课内容
10) Create and manage AWR snapshots
11) Generate AWR reports
12) Create Compare Periods reports

  4. Defining Problems

序号 授课内容
13) Identify performance issues
14) Set tuning priorities
15) Interpret tuning diagnostics
16) Tune for life-cycle phase

  5. Using Metrics and Alerts

序号 授课内容
17) IView metrics by using the metrics history views
18) Create metric thresholds
19) Create metric thresholds

  6. Using Baselines

序号 授课内容
20) Create AWR baselines
21) Enable adaptive thresholds
22) Create AWR baselines for future time periods

  7. Using AWR-Based Tools

序号 授课内容
23) Describe tuning automatic maintenance tasks
24) Generate ADDM reports
25) Generate Active Session History (ASH) reports

  8. Monitoring Applications

序号 授课内容
26) Configure and manage services
27) Use services with client applications
28) Use services with the Database Resource Manager
29) Use services with the Scheduler
30) Set performance-metric thresholds on services
31) Configure services aggregation and tracing

  9. Identifying Problem SQL Statements

序号 授课内容
32) Describe SQL statement processing
33) Describe the role of the optimizer
34) View the SQL statement statistics
35) Identify the SQL statements that perform poorly
36) Generate and view an execution plan
37) Generate a tkprof report
38) Generate an optimizer trace

  10. Influencing the Optimizer

序号 授课内容
39) Describe the optimizer’s behavior
40) Explain how statistics can affect the optimizer
41) Describe how data structures affect the optimizer
35) Adjust parameters to influence the optimizer

  11. Reducing the Cost

序号 授课内容
36) Adjust data structures to influence the optimizer
37) Tune segment space management
38) Use Segment Advisor
39) Convert to Automatic Segment Space Management
40) Tune block space management
41) Diagnose and correct row migration
42) Diagnose table fragmentation
43) Use table compression

  12. Using SQL Performance Analyzer

序号 授课内容
44) Identify the benefits of using SQL Performance Analyzer
45) Describe the SQL Performance Analyzer workflow phases
46) Use SQL Performance Analyzer to ascertain performance gains following a database change
47) Use SQL Performance Analyzer to test the impact of proposed changes

  13. SQL Performance Management

序号 授课内容
48) Manage changes to optimizer statistics
49) Capture SQL profiles
50) Use SQL Access Advisor
51) Set up SQL Plan Management
52) Set up various SQL Plan Management scenarios

  14. Using Database Replay

序号 授课内容
53) Identify the benefits of using Database Replay
54) List the steps involved in Database Replay
55) Use Enterprise Manager to record and replay workloads

  15. Tuning the Shared Pool

序号 授课内容
56) Diagnose and resolve hard-parsing problem
57) Diagnose and resolve soft-parsing problem
58) Size the shared pool
59) Diagnose and resolve shared pool fragmentation
60) Keep objects in the shared pool
61) Size the reserved area
62) Manage the results cache

  16. Tuning the Buffer Cache

序号 授课内容
63) Describe the buffer cache architecture
64) Size the buffer cache
65) Resolve common performance issues related to the buffer cache
66) Use common diagnostic indicators to suggest a possible solution

  17. Tuning PGA and Temporary Space

序号 授课内容
67) Diagnose PGA memory issues
68) Size the PGA memory
69) Diagnose temporary space issues
70) Specify temporary tablespace parameters for efficient operation

  18. Automatic Memory Management

序号 授课内容
71 Use memory advisors to size dynamic memory areas
72) Enable Automatic Shared Memory Manager
73) Enable Enterprise Manager memory parameters
74) Set minimum size of auto-tuned SGA components
75) Use the SGA advisor to set SGA_TARGET
76) Enable Automatic Memory Management
77) Use the Memory Advisor to set overall memory parameters

  19. Tuning I/O

序号 授课内容
78) Diagnose database I/O issues
79) Describe the Stripe and Mirror Everything (SAME) concept
80) Set filesystemio_options
81) Choose appropriate I/O solutions
82) Tune Automatic Storage Management (ASM)

  20. Performance Tuning Summary

序号 授课内容
83) List best practices identified throughout the course
84) Summarize the performance tuning methodology

关于我们 | 新闻中心 | 合作伙伴 | 联系我们 |
西安优盛信息技术有限公司  版权所有©2007-2018  陕ICP备07501629号
在线客服系统