|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-troubleshooting-and-tuning/
课程评论：没有评论
**Oracle 数据库调优与故障排除 - AWR 报告解读** 本课程旨在教授学员 Oracle 数据库的高级调优与故障排除技术，引导学员超越标准方法，掌握分析和诊断性能问题的深度技巧。课程结束后，学员将能够解读 AWR 报告，准确识别数据库是否存在性能问题，并找出问题的根本原因。 **课程主要内容：** * **理解数据库执行与资源利用：** * CPU、内存和 I/O 使用模式 * 数据库何时使用何种资源 * **设计 - 性能问题的根源与解决方案：** * 设计基础 * 数据类型 * 约束的使用 * 权衡替代存储技术 * **添加硬件能否解决性能问题？** * 响应时间 = 服务时间 + 等待时间 * **准确识别性能指标：** * 理解等待事件生态系统 * 等待事件基础知识 * 基于等待事件诊断问题 * 理解比率分析 * 内存问题 * I/O 问题 * 空间问题 * **理解物理设计与优化存储配置：** * 硬件/磁盘优化（了解你的存储） * 空间 vs IOPS vs MBPS - 存储需求分析 * 文件放置策略 - 结合条带化 * **如何阅读 AWR 报告：** * AWR 报告的重要部分 * AWR 报告的解读方法 * 五分钟分析和识别首要问题的关键术语 * **最大化 SGA 内存利用：** * 调整 Buffer Cache - Keep/Recycle 池，配置方法 * 使用 Flash Cache * 调整 Shared Pool * 为什么共享游标？ * 如何识别游标是否共享 * 将对象保留在 Shared Pool 中 * 使用 Result Cache * 调整 PGA * 串行重用性 * 释放未使用内存 * **识别 I/O 热点：** * 文件与表空间 I/O 统计信息 * 消耗 I/O 的 Top 对象 * **识别坏 SQL：** * 什么是坏 SQL？ * 磁盘读取还是内存读取更好？ * 内存和 CPU 消耗是否存在阈值？ * 识别出坏 SQL 后该做什么？ *注意：课程讲义、实践指南等附加资源包含在第 10 讲中。*
This training will enable participants to learn Advanced Tuning and Troubleshooting techniques for Oracle Databases. It will enable the participants to go beyond standard troubleshooting methods and get to advanced techniques analysis to diagnose performance problems. At the end of the training, you will be able to interpret an AWR report and identify whether there is any problem in your database, and if they exist, what are the top problems / root causes of problems.Additional resources( slide deck , practice guide etc) are part of Lecture 10.The topics covered in this course areUnderstanding Database Execution and Resource Utilization- CPU, Memory and I/O usage patterns- When does the Database use what ResourceDesign - Why is it the best and first place to fix Performance Issues- Design Fundamentals- Data Type- Using Constraints- Considering Alternate Storage techniquesWill Adding Hardware solve Performance Issues?- Response Time = Service Time + Wait TimeAccurately Identifying Performance Metrics- Understanding the Wait Event Ecosystemo Wait Event Fundamentalso Diagnosing Problems based on Wait Events- Understanding Ratio Analysiso Memory Issueso I/O Issueso Space IssuesUnderstanding Physical Design Optimizing Storage Configuration- Hardware / Disk Optimization ( Understand your Storage)- Space Vs IOPS Vs MBPS - What do you ask when you need Storage- File placement Strategies - With StripingHow to Read an AWR Report- Important Sections of an AWR Report- Approach to read an AWR Report- Important terms to know to do a 5 minute Analysis and identify the top issue/ problemGet the Best out of SGA Memory- Tuning Buffer Cache - Keep/Recycle Pools, how to configure them- Using Flash Cache- Tuning Shared Pool- Why to Share Cursors- How to identify if Cursors are Shared- Keeping Objects in Shared Pool- Using Result Cache- Tuning PGA- Serial Reuseability- FREE Unused MemoryIdentify I/O Hotspots- File & Tablespace I/O Statistics- Top Objects consuming I/OIdentify Bad SQL- What is Bad SQL- Is it good to do Disk Reads or Memory Reads- Is there a Threshold for Memory and CPU Consumption- What to do after Identifying them
