profiler.sql - PL/SQL Profiler (MetaLink Note:243755.1)

Profiled Run 7 (plsql_profiler_runs)

Run Date Total Time1 Comment
7 26-JUN-03 07:28:34 17.74 any comment to identify this execution
Note 1: Total Time is in seconds

Profiled PL/SQL Libraries (plsql_profiler_units)

Unit Owner Name Type Timestamp Total Time1 Text Header
1 SYS DBMS_PROFILER PACKAGE BODY 25-NOV-02 10:27:38 0.00
2 APPS PROF_PROCEDURE_X PROCEDURE 26-JUN-03 07:28:31 13.67 /* $Header: proftestx.sql 2003/05/29 12:00:00 pkm ship $ */
3 SYS STANDARD PACKAGE BODY 05-OCT-02 14:14:16 0.00
4 SYS DBMS_OUTPUT PACKAGE BODY 03-MAR-02 11:43:23 0.05
Note 1: Total Time is in seconds

Top 10 profiled source lines in terms of Total Time (plsql_profiler_data)

Top Total Time1 Times Executed Min Time2 Max Time2 Unit Owner Name Type Line Text
1 9.64 1000000 0.00 0.17 2 APPS PROF_PROCEDURE_X PROCEDURE 12 l_instr := INSTR(l_string,'/');
2 2.73 1000000 0.00 0.04 2 APPS PROF_PROCEDURE_X PROCEDURE 13 l_count := l_count + 1;
3 1.29 1000001 0.00 0.01 2 APPS PROF_PROCEDURE_X PROCEDURE 11 WHILE l_count < p_times LOOP
Note 1: Total Time is in seconds
Note 2: Min and Max Time for one execution of this line (in seconds)

Unit:2 APPS.PROF_PROCEDURE_X (all_source)

Line Total Time1 Times Executed Text
1 PROCEDURE prof_procedure_x
2 /* $Header: proftestx.sql 2003/05/29 12:00:00 pkm ship $ */
3 ( p_times IN NUMBER := 1000000 )
4 IS
5 0.00 0 ..l_count NUMBER := 0;
6 ..l_instr NUMBER;
7 0.00 0 ..l_string VARCHAR2(100) := 'This is a dummy string just to test the use of PL/SQL profiler';
8 BEGIN
9 0.00 0 ..DBMS_PROFILER.START_PROFILER('any comment to identify this execution');
10 0.00 3 ..DBMS_OUTPUT.PUT_LINE('START: '||TO_CHAR(SYSDATE,'SSSSS'));
11T3 1.29 1000001 ..WHILE l_count < p_times LOOP
12T1 9.64 1000000 ....l_instr := INSTR(l_string,'/');
13T2 2.73 1000000 ....l_count := l_count + 1;
14 ..END LOOP;
15 0.00 3 ..DBMS_OUTPUT.PUT_LINE('END: '||TO_CHAR(SYSDATE,'SSSSS'));
16 0.00 1 ..DBMS_PROFILER.STOP_PROFILER;
17 0.00 0 END prof_procedure_x;
Note 1: Total Time is in seconds
Note Tn: Top "n" Line in terms of Total Time