My Oracle Support Banner

Where to Find Information About Performance Related Features (Doc ID 1361401.1)

Last updated on JULY 05, 2024

Applies to:

Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document outlines What Performance Features are available and provides links to content pertaining to those features.

Our goal is to point you towards the most useful information on individual features, without you having to exhaustively search for it or find the right keyword combination. For example:

Best Practices

Pro-Active Problem Avoidance and Diagnostic Collection

Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. A number of these features and tools are recommended by support for collecting such diagnostics. For information on suggested uses, other proactive preparations and diagnostics, see:

<Document 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance Issues
<Document 1477599.1> Best Practices Around Data Collection For Performance Issues

Performance Related Webcasts

A number of Webcasts on Database Performance topics have been delivered. You can find a list of these in the following article:

<Document 740966.1> Oracle Support Advisor Webcasts: Current Schedule and Archived Recordings

Performance Related Technical Brief, Blogs and Documentation

<Document 1337116.1> Technical Brief and Blog Entries for Oracle Optimizer Links to Technical Brief and Blogs for the Oracle Optimizer
<Document 1195363.1> Database Performance and SQL Tuning Documentation on OTN Links to the main Tuning and Performance documentation

 

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Best Practices
 Pro-Active Problem Avoidance and Diagnostic Collection
 Performance Related Webcasts
 Performance Related Technical Brief, Blogs and Documentation
Solution
 Features and Versions
 Oracle Database Licensing Information
 Performance Information Centers
 Performance Troubleshooting
 Links to Recommended Content
 General Features
 Cost Based Optimizer (CBO)
 SQL Test Case Builder
 Adaptive Cursor Sharing
 Adaptive Query Optimization
 Query Result Cache
 Virtual Columns
 Automatic Column Group Detection
 Diagnostic Features
 Real-Time Database Operations Monitoring
 Explain Plan
 SQL_TRACE / Event 10046
 trcsess Utility
 Event 10053
 Statistic Related Features
 DBMS_STATS / (Legacy) Analyze
 User Defined Stats
 Enhanced Statistics Gathering
 Dynamic Sampling of Optimizer Statistics
 Auto DBMS_STATS Collection
 Enhanced Statistics Management
 DBMS_STATS enhancements
 MultiColumn Statistics
 Enhanced Column Histogram Statistics
 Online Statistics Gathering for Bulk Loads
 Session-Private Statistics for Global Temporary Tables
 SQL Plan Directives
 Warehousing Features
 Parallel Query
 Bitmap Indexes
 Partitioning
 Automatic PQ Tuning
 Oracle OLAP
 Materialized View Query Rewrite
 Memory Related Features
 Auto PGA Memory Management
 PGA Memory Advisor
 Dynamic SGA Memory Management
 Automatic Shared Memory Tuning
 Automatic Workload Repository Related Features
 Automatic Workload Repository
 Active Session History
 ASH Reporting
 ADDM
 Real-Time ADDM Analysis
 SQL Execution History
 Other Advisors/Analyzers
 Segment Advisor
 SQL Tuning Advisor / SQL Profiles
 SQL Tuning Sets
 SQL Access Advisor
 SQL Performance Analyzer
 Automatic SQL Tuning
 Upgrade/Change Management Related Features
 Real Application Testing (RAT)
 Plan Stability Features
 Oracle Orion I/O Calibration Tool
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.