dbaplus Community
dbaplus Community
Mar 22, 2017 · Databases

Mastering Oracle Dynamic Sampling for Accurate Cardinality Estimates

This article explains Oracle's dynamic sampling feature, outlines typical scenarios such as temporary tables and complex filters, presents real CRM case studies with misestimated cardinalities, demonstrates step‑by‑step solutions using DBMS_STATS commands, and shows how 12c enhancements dramatically improve estimation accuracy for complex queries.

12cDatabase StatisticsDynamic Sampling
0 likes · 8 min read
Mastering Oracle Dynamic Sampling for Accurate Cardinality Estimates
ITPUB
ITPUB
Nov 3, 2016 · Databases

Mastering Oracle Optimizer Statistics: When and How to Collect Them

This guide explains the role of optimizer statistics in Oracle, when to gather them, how to use automatic and manual collection jobs, tune ESTIMATE_PERCENT and METHOD_OPT, manage histograms, handle bind peeking, apply dynamic sampling, and safely test changes with pending statistics.

DBMS_STATSDynamic SamplingESTIMATE_PERCENT
0 likes · 20 min read
Mastering Oracle Optimizer Statistics: When and How to Collect Them
ITPUB
ITPUB
Jun 21, 2016 · Databases

Speed Up PL/SQL Developer on Oracle 12c by Disabling Dynamic Sampling

The article describes a slow PL/SQL Developer experience on an Oracle 12.1.0.2 test database, explains how missing dictionary and fixed object statistics cause delays, shows how to gather these stats, disable optimizer_dynamic_sampling, and restart the database to significantly improve query and autocomplete performance.

Dynamic SamplingOraclePL/SQL Developer
0 likes · 3 min read
Speed Up PL/SQL Developer on Oracle 12c by Disabling Dynamic Sampling