|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-performance-tuning/
课程评论:没有评论
课程名称:Oracle性能调优 课程概述: 本课程旨在帮助您概念性地理解各种Oracle数据库性能问题,并学习如何查找性能信息以及采取相应的调优方法。课程内容涵盖: * 常见的Oracle数据库性能问题。 * 定位问题根源所需的检查点和调优信息来源。 * 基于不同数据库类型(OLTP vs 数据仓库)的调优方法。 * 数据库统计信息、优化器以及表和索引的维护计划。 * SQL和实例调优的详细内容。 * Oracle数据库避免性能问题的通用指南。
You will get a conceptual understanding of various Oracle database performance issues and learn about different places to check for the performance information along with tuning approach. Broadly this course will cover following: 1. What are common oracle database performance issues? 2. Where to check for messages / tuning information to get to bottom of issue. 3. Different tuning approaches - based on different databases (OLTP vs Data Warehouse). 4. Learn about database statistics, optimizer and maintenance plan for tables and indexes. 5. SQL and Instance tuning details. 6. General guidelines for avoiding performance issues in Oracle database.