Demonstrate DBMS_PROFILER : DBMS_PROFILER « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_PROFILER
SQL>
SQL> create or replace procedure modtest
  2  as
  3  begin
  4    dbms_profiler.start_profiler('mod');
  5    for x in 1..1000 loop
  6      if mod(x,100) = 0 then null; end if;
  7    end loop;
  8    dbms_profiler.stop_profiler;
  9  end;
 10  /
SQL>
SQL>








31.20.DBMS_PROFILER
31.20.1.DBMS_PROFILER.get_version
31.20.2.Capture DBMS_PROFILER information for the specified script
31.20.3.Demonstrate DBMS_PROFILER
31.20.4.dbms_profiler.start_profiler
31.20.5.Use DBMS_PROFILER to compare the performance differences between row-at-a-time processing and bulk processing
31.20.6.Profiler for recursive function
31.20.7.Call dbms_profiler.start_profiler to start profiler