Run | Date | Total Time1 | Comment |
---|---|---|---|
7 | 26-JUN-03 07:28:34 | 17.74 | any comment to identify this execution |
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 |
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 |
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; |