Overview

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

Skills

Reviews