ŠKOLENÍ A KURZY




Oracle Database 12c: Performance Management and Tuning


  • In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. Benefits To You: The DBA will analyze the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning and the diagnostic tools used to find ways to improve performance. This will include the use of statistics, profiles to influence the optimizer, and using the SQL Advisors. Maintain SQL Performance - A major task of DBAs is to maintain SQL performance across changes. This course introduces Database Replay and SQL Performance Analyzer which help the DBA test and minimize the impact of change. Influence Instance Behavior - Instance tuning uses the same general method of observing a problem, diagnosing the problem, and implementing a solution. The instance tuning lessons cover the details of major tunable components and describe how you can influence the instance behavior.

  • Automatic Workload Repository Overview
  • Automatic Workload Repository Data
  • Enterprise Manager Cloud Control and AWR
  • Snapshots
  • Reports
  • Compare Periods
  • ADDM Tuning Session
  • Performance Tuning Resource
  • Monitoring and Tuning Tools Overview
  • Metrics and Alerts Overview
  • Limitation of Base Statistics
  • Benefits of Metrics
  • Viewing Metric History Information
  • Viewing Histograms
  • Server-Generated Alerts
  • Setting Thresholds
  • Metrics and Alerts Views
  • Comparative Performance Analysis with AWR Baselines
  • Moving Window Baseline
  • Baseline Templates
  • Creating AWR Baselines
  • Baselines Views
  • Performance Monitoring and Baselines
  • Defining Alert Thresholds Using a Static Baseline
  • Configuring Adaptive Thresholds
  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • Active Session History
  • Additional Automatic Workload Repository Views
  • Real-time ADDM
  • Enabling Monitoring of Database Operations
  • Identifying, Starting, and Completing a Database Operation
  • Monitoring the Progress of a Database Operation
  • Database Operation Views
  • Database Operation Tuning
  • SQL Statement Processing Phases
  • SQL Monitoring
  • Execution Plans
  • DBMS_XPLAN Package
  • EXPLAIN PLAN Command
  • Reading an Execution Plan
  • Using the SQL Trace Facility
  • Generating an Optimizer Trace
  • Functions of the Query Optimizer
  • Optimizer Statistics
  • Controlling the Behavior of the Optimizer by Using Parameters
  • Enabling Query Optimizer Features
  • Using Hints
  • Access Paths
  • Join Operations
  • Sort Operations
  • Index Maintenance
  • SQL Access Advisor
  • Table Maintenance and Reorganization
  • Extent Management
  • Data Storage
  • Migration and Chaining
  • Shrinking Segments
  • Table Compression
  • SQL Performance Analyzer Overview
  • Real Application Testing Overview and Use Cases
  • Capturing the SQL Workload
  • Creating a SQL Performance Analyzer Task
  • Comparison Reports
  • Tuning Regressing Statements
  • Guided Workflow Analysis
  • SQL Performance Analyzer Views
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Statistics Gathering Options and Preferences
  • Deferred Statistics Publishing
  • Automatic SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Plan Management
  • Database Replay Architecture
  • Capture Considerations
  • Replay Options
  • Replay Analysis
  • Database Replay Workflow in Enterprise Manager
  • Database Replay Packages and Procedures
  • Database Replay Views
  • Calibrating Replay Clients
  • Shared Pool Architecture
  • Latch and Mutex
  • Diagnostic Tools for Tuning the Shared Pool
  • Avoiding Hard Parses
  • Sizing the Shared Pool
  • Avoiding Fragmentation
  • Data Dictionary Cache
  • SQL Query Result Cache
  • Database Buffer Cache Architecture
  • Working Sets
  • Buffer Cache Tuning Goals and Techniques
  • Buffer Cache Performance Symptoms
  • Buffer Cache Performance Solutions
  • Database Smart Flash Cache
  • Flushing the Buffer Cache
  • SQL Memory Usage
  • Configuring Automatic PGA Memory
  • PGA Target Advice Statistics and Histograms
  • Automatic PGA and AWR Reports
  • Temporary Tablespace Management
  • Temporary Tablespace Group
  • Monitoring Temporary Tablespaces
  • Temporary Tablespace Shrink
  • Dynamic SGA
  • Automatic Shared Memory Management Overview
  • SGA Sizing Parameters
  • Enabling and Disabling Automatic Shared Memory Management
  • SGA Advisor
  • Automatic Memory Management Overview
  • Enabling Automatic Memory Management
  • Monitoring Automatic Memory Management