SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

2 months ago

Find the bottlenecks in PL/SQL code with the hierarchical profiler DECLARE DBMS_HPROF.CREATE_TABLES (); id := DBMS_HPROF.START_PROFILING; <code> DBMS_HPROF.STOP_PROFILING; DBMS_HPROF.ANALYZE ( id, report_clob => html ); END; Enhanced in 18c to store trace data in tables

Find the bottlenecks in PL/SQL code with the hierarchical profiler DECLARE DBMS_HPROF.CREATE_TABLES (); id := DBMS_HPROF.START_PROFILING; &lt;code&gt; DBMS_HPROF.STOP_PROFILING; DBMS_HPROF.ANALYZE ( id, report_clob =&gt; html ); END; Enhanced in 18c to store trace data in tables