My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2023

Applies to:

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


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?


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

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