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.