PL/SQL Elapsed Time (microsecs) Analysis

368188 microsecs (elapsed time) & 200003 function calls

The PL/SQL Hierarchical Profiler produces a collection of reports that present information derived from the profiler's output log in a variety of formats. The following reports have been found to be the most generally useful as starting points for browsing:

In addition, the following reports are also available:

Function Elapsed Time (microsecs) Data sorted by Total Subtree Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Total Subtree Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
104 0.0% 104 0.0% 0 0.0% 1 0.0% __anonymous_block
0 0.0% 0 0.0% 0 0.0% 1 0.0% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Cum% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
229279 62.3% 229279 62.3% 62.3% 0 0.0% 100000 50.0% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
368188 100% 138805 37.7% 100% 229383 62.3% 100001 50.0% __plsql_vm
104 0.0% 104 0.0% 100% 0 0.0% 1 0.0% __anonymous_block
0 0.0% 0 0.0% 100% 0 0.0% 1 0.0% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
SQL ID Elapsed Time (microsecs) Data sorted by SQL ID for 'case3a'

SQL ID Elapsed Time (microsecs) Data sorted by SQL ID

368188 microsecs (elapsed time) & 200003 function calls

SQL ID SQL TEXT Function Ind% Calls Ind%
Function Elapsed Time (microsecs) Data sorted by Function Name for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Function Name

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
104 0.0% 104 0.0% 0 0.0% 1 0.0% __anonymous_block
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 0.0% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Total Descendants Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Total Descendants Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
104 0.0% 104 0.0% 0 0.0% 1 0.0% __anonymous_block
0 0.0% 0 0.0% 0 0.0% 1 0.0% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Total Function Call Count

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Cum% Function Name SQL ID SQL TEXT
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% 50.0% __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% 100% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
104 0.0% 104 0.0% 0 0.0% 1 0.0% 100% __anonymous_block
0 0.0% 0 0.0% 0 0.0% 1 0.0% 100% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Subtree Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Mean Subtree Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
104 0.0% 104 0.0% 0 0.0% 1 0.0% 105 105 0 __anonymous_block
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% 4 1 2 __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% 2 2 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 0.0% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Function Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Mean Function Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
104 0.0% 104 0.0% 0 0.0% 1 0.0% 105 105 0 __anonymous_block
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% 2 2 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% 4 1 2 __plsql_vm
0 0.0% 0 0.0% 0 0.0% 1 0.0% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Descendants Elapsed Time (microsecs) for 'case3a'

Function Elapsed Time (microsecs) Data sorted by Mean Descendants Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% 4 1 2 __plsql_vm
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% 2 2 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
104 0.0% 104 0.0% 0 0.0% 1 0.0% 105 105 0 __anonymous_block
0 0.0% 0 0.0% 0 0.0% 1 0.0% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Module Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case3a'

Module Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Module Ind% Cum% Calls Ind% Module Name
229279 62.3% 62.3% 100000 50.0% SCOTT.F_CHANGE_TX
138909 37.7% 100% 100002 50.0%
0 0.0% 100% 1 0.0% SYS.DBMS_HPROF
Module Elapsed Time (microsecs) Data sorted by Module Name for 'case3a'

Module Elapsed Time (microsecs) Data sorted by Module Name

368188 microsecs (elapsed time) & 200003 function calls

Module Ind% Calls Ind% Module Name
138909 37.7% 100002 50.0%
229279 62.3% 100000 50.0% SCOTT.F_CHANGE_TX
0 0.0% 1 0.0% SYS.DBMS_HPROF
Module Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case3a'

Module Elapsed Time (microsecs) Data sorted by Total Function Call Count

368188 microsecs (elapsed time) & 200003 function calls

Module Ind% Calls Ind% Cum% Module Name
138909 37.7% 100002 50.0% 50.0%
229279 62.3% 100000 50.0% 100% SCOTT.F_CHANGE_TX
0 0.0% 1 0.0% 100% SYS.DBMS_HPROF
Namespace Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case3a'

Namespace Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs)

368188 microsecs (elapsed time) & 200003 function calls

Function Ind% Cum% Calls Ind% Namespace
368188 100% 100% 200003 100% PLSQL
Namespace Elapsed Time (microsecs) Data sorted by Namespace for 'case3a'

Namespace Elapsed Time (microsecs) Data sorted by Namespace

368188 microsecs (elapsed time) & 200003 function calls

Function Ind% Calls Ind% Namespace
368188 100% 200003 100% PLSQL
Namespace Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case3a'

Namespace Elapsed Time (microsecs) Data sorted by Total Function Call Count

368188 microsecs (elapsed time) & 200003 function calls

Function Ind% Calls Ind% Cum% Namespace
368188 100% 200003 100% 100% PLSQL
Parents and Children Elapsed Time (microsecs) Data for 'case3a'

Parents and Children Elapsed Time (microsecs) Data



__anonymous_block 

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
104 0.0% 104 0.0% 0 0.0% 1 0.0% __anonymous_block
Parents:
104 100% 104 100% 0 N/A 1 100% __plsql_vm
Children:
0 N/A 0 N/A 0 N/A 1 100% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
__plsql_vm
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
368188 100% 138805 37.7% 229383 62.3% 100001 50.0% __plsql_vm
Parents:
368188 100% 138805 100% 229383 100% 100001 100% ORACLE.root
Children:
229279 100% 229279 100% 0 N/A 100000 100% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
104 0.0% 104 100% 0 N/A 1 100% __anonymous_block
SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
229279 62.3% 229279 62.3% 0 0.0% 100000 50.0% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
Parents:
229279 100% 229279 100% 0 N/A 100000 100% __plsql_vm
SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
0 0.0% 0 0.0% 0 0.0% 1 0.0% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Parents:
0 N/A 0 N/A 0 N/A 1 100% __anonymous_block