Think APEX

Oracle PL/SQL · Performance Tuning What is DBMS_PROFILER ? An interface to profile existing PL/SQL applications and identify performance bottlenecks — collecting and persistently storing granular execution data at the virtual machine level. Overview DBMS_PROFILER provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. It let us to collect and persistently store profiler data. The profiler gathers information at the PL/SQL virtual machine level , including the total number of times each line has been executed, the total time spent on that line, and the minimum and maximum execution times for each line. Key Steps STEP 01 Run PROFTAB.SQL to create the required database tables. STEP 02 Warm up the database by running the app once without profiling to avoid skewed timings. STEP 03 ...