Overview

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

Skills

Reviews