DBMS_PROFILER.get_version : DBMS_PROFILER « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_PROFILER
SQL> declare
  2      n_major number;
  3      n_minor number;
  4
  5  begin
  6    DBMS_PROFILER.get_version(n_major, n_minor);
  7
  8    DBMS_OUTPUT.PUT_LINE('DBMS_PROFILER Version '||to_char(n_major)||'.'||to_char(n_minor));
  9
 10    DBMS_OUTPUT.PUT_LINE(DBMS_PROFILER.internal_version_check);
 11  end;
 12  /

PL/SQL procedure successfully completed.

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