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 laterInformation 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.
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 |