My Oracle Support Banner

Batch Data Load Performance Improvements using 'Dynamic Sampling'. (Doc ID 2798150.1)

Last updated on AUGUST 10, 2021

Applies to:

Oracle Clinical - Version 5.2.1 and later
Information in this document applies to any platform.

Goal

The  OC 5.2.1 Admin Guide => 'Routine Server Administration' => 'D.6 Using Dynamic Sampling to Improve Batch Data Load Performance' states:

Using Dynamic Sampling to Improve Batch Data Load Performance

After collecting DBMS_STATS (see "Collecting Statistics for Optimization"), delete and lock statistics for the temporary tables used by Batch Data Load in order to optimize performance. When encountering tables with no statistics, Oracle RDBMS dynamically gathers the necessary statistics as part of query optimization. With volatile temporary tables, dynamic sampling contributes to better performance.

What kind of BDL performance improvement can be realized with dynamic sampling?

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
Solution
 BACKGROUND INFORMATION:
 
 DYNAMIC SAMPLING SETUP:
 
 PERFORMANCE GAINS:
References


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