|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-12c-performance-management-tuning-1z0-064/
课程评论：没有评论
课程名称：Oracle数据库12c：性能管理调优1z0-064 课程概述： 本课程旨在教授Oracle数据库的基本调优诊断技术。学员将能够理解时间模型和等待事件，使用V$视图诊断性能问题，并利用自动工作负载库（AWR）分析数据库性能。通过学习AWR报告和监测性能的指标和警报，学员将掌握使用基线监控性能的技能。 课程内容包括： - 使用AWR基准监控性能，并通过AWR相关工具诊断性能问题。 - 实施实时数据库操作监控，并配置服务来监测数据库性能。 - 鉴定问题SQL语句，理解执行计划，并使用SQL跟踪或优化器跟踪的格式化输出识别性能较差的sql语句。 - 解释统计信息如何影响优化器并配置参数以影响优化器的行为。 - 使用自动段空间管理和表压缩来减少SQL操作的成本，诊断和调整空间相关问题。 - 通过SQL性能分析师测试数据库变更的影响，管理优化器统计信息，并使用SQL配置文件和顾问调优SQL语句。 - 使用数据库重放检查系统更改对性能的影响。 - 诊断和解决与共享池、缓冲区缓存、PGA和临时表空间相关的性能问题。 - 配置和优化自动共享内存管理和自动内存管理。 - 诊断数据库I/O问题，配置自动存储管理（ASM）以实现最大可用性。 - 理解和配置数据库资源管理器以有效管理数据库资源。 通过本课程的学习，学员将提升在实际环境中优化Oracle数据库性能的能力。
Basic Tuning DiagnosticsDescribe the time modelExplain wait eventsDiagnose performance problems using V$ viewsUsing 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 statementsInfluencing 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 changesSQL 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
