|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-performance-e-tuning-1z0-064/
课程评论：没有评论
## Oracle 数据库性能调优入门课程摘要 本课程旨在为数据库管理员 (DBA) 提供 Oracle 数据库 11g 的性能调优入门知识。课程涵盖了 Oracle 提供的各种先进调优工具和技术，包括： * **基础诊断：** 了解时间模型，解释等待事件，并通过 V$ 视图诊断性能问题。 * **自动工作负载存储库 (AWR)：** 使用 AWR 报告分析数据库性能，并通过指标和警报进行监控。 * **基线与工具：** 利用 AWR 基线监控性能，并通过自动数据库诊断监视器 (ADDM) 和 ASH 报告诊断性能问题。 * **实时监控：** 实现和使用实时数据库操作监控，以及通过配置服务来监控数据库性能。 * **SQL 调优：** 识别问题 SQL 语句，解释执行计划，并使用 SQL Trace 或优化器跟踪来识别低效 SQL。 * **优化器影响：** 理解统计信息对优化器行为的影响，并配置参数以影响优化器。 * **SQL 操作成本降低：** 使用自动段空间管理、表压缩和 SQL 性能分析器来优化空间管理和评估数据库变更的影响。 * **SQL 性能管理：** 管理优化器统计信息，使用 SQL Profiles 和 Advisors，以及 SQL Plan Management 来调优 SQL。 * **数据库重演 (Database Replay)：** 使用 Database Replay 检查系统变更对性能的影响。 * **共享池调优：** 诊断和解决硬解析、软解析及共享池相关的性能问题。 * **缓冲区缓存调优：** 诊断和解决缓冲区缓存相关的性能问题。 * **PGA 和临时空间调优：** 诊断和解决 PGA 和临时表空间相关的性能问题。 * **自动内存管理：** 使用和调优自动共享内存管理 (ASMM) 和自动内存管理 (AMM)。 * **I/O 调优：** 诊断数据库 I/O 问题，并为最大可用性配置自动存储管理 (ASM)。 * **数据库资源管理器：** 理解和配置数据库资源管理器。 课程重点在于 DBA 在性能调优过程中的最佳实践，并提供了基础的调优技术讲解。尽管部分实践演示可能因环境限制而无法完全呈现，但所介绍的技术在任何环境中均可应用。
Neste treinamento, você irá aprender a utlizar as features de tuning do Oracle database 11g como SQL Tuning Advisor, SQL Access Advisor, relatório AWR (Automátic Workload Repository) e ADDM (Automatic Database Diagnostic Monitor) além de aprender a empregar as melhores práticas no processo de tuning em banco de dados. Este treinamento foca o processo de tuning do ponto de vista do DBA. Os capítulos apresentados são introdutórios ao Tuning. Em alguns casos não consigo demonstrar na prática pois não tenho um ambiente pronto para isso, mas as técnicas são as mesmas para você usar em seu ambiente.Basic Tuning DiagnosticsDescribe the time modelExplain wait eventsDiagnose performance problems using V$ views Using Automatic Workload RepositoryAnalyze database performance using AWR reportsUsing Metrics and AlertsMonitor performance using metric thresholds and alertsUsing BaselinesUse AWR baselines to monitor performanceUsing AWR-Based ToolsDiagnose performance issues using ADDMDiagnose performance issues using ASH reportsMonitoring Real-Time Database OperationImplement Real-Time Database Operation MonitoringMonitoring ApplicationsConfigure and use services to monitor database performanceIdentifying Problem SQL StatementsInterpret execution plansUse formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements Influencing the OptimizerExplain how statistics influence the optimizerConfigure parameters to influence the optimizerReducing the Cost of SQL OperationsUse Automatic Segment Space Management to optimize space managementUse table compressionDiagnose and tune space related issuesUsing SQL Performance AnalyzerUse SQL Performance Analyzer to test the impact of database changes SQL Performance ManagementManage optimizer statisticsUse SQL Profiles and Advisors to tune SQL statementsUse SQL Plan Management to tune SQL statementsUsing Database ReplayUse Database Replay to check impact of system change on performanceTuning the Shared PoolDiagnose and resolve hard and soft parsing problemsDiagnose and resolve performance issues related to the shared poolTuning the Buffer CacheDiagnose and resolve performance issues related to the buffer cacheTuning PGA and Temporary SpaceDiagnose and resolve performance issues related to PGADiagnose and resolve performance issues related to temporary tablespaceUsing Automatic MemoryUse and tune Automatic Shared Memory ManagementUse and tune Automatic Memory ManagementTuning I/ODiagnose database I/O issuesConfigure Automatic Storage Management (ASM) for maximum availabilityUsing the Database Resource ManagerUnderstand and configure the Database Resource Manager
