PL/SQL Elapsed Time (microsecs) Analysis

18230 microsecs (elapsed time) & 58 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 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18230 100% 15 0.1% 18215 100% 2 3.4% __plsql_vm
18215 100% 139 0.8% 18076 99.2% 2 3.4% __anonymous_block
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
122 0.7% 42 0.2% 80 0.4% 26 44.8% __plsql_vm@1
80 0.4% 80 0.4% 0 0.0% 26 44.8% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 1.7% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Cum% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18076 99.2% 17954 98.5% 98.5% 122 0.7% 1 1.7% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
18215 100% 139 0.8% 99.2% 18076 99.2% 2 3.4% __anonymous_block
80 0.4% 80 0.4% 99.7% 0 0.0% 26 44.8% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
122 0.7% 42 0.2% 100% 80 0.4% 26 44.8% __plsql_vm@1
18230 100% 15 0.1% 100% 18215 100% 2 3.4% __plsql_vm
0 0.0% 0 0.0% 100% 0 0.0% 1 1.7% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
SQL ID Elapsed Time (microsecs) Data sorted by SQL ID for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

SQL ID SQL TEXT Function Ind% Calls Ind%
b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B0 0.0% 1 1.7%
Function Elapsed Time (microsecs) Data sorted by Function Name for 'case1_fix'

Function Elapsed Time (microsecs) Data sorted by Function Name

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18215 100% 139 0.8% 18076 99.2% 2 3.4% __anonymous_block
18230 100% 15 0.1% 18215 100% 2 3.4% __plsql_vm
122 0.7% 42 0.2% 80 0.4% 26 44.8% __plsql_vm@1
80 0.4% 80 0.4% 0 0.0% 26 44.8% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 1.7% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
Function Elapsed Time (microsecs) Data sorted by Total Descendants Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18230 100% 15 0.1% 18215 100% 2 3.4% __plsql_vm
18215 100% 139 0.8% 18076 99.2% 2 3.4% __anonymous_block
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
122 0.7% 42 0.2% 80 0.4% 26 44.8% __plsql_vm@1
0 0.0% 0 0.0% 0 0.0% 1 1.7% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
80 0.4% 80 0.4% 0 0.0% 26 44.8% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
Function Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Cum% Function Name SQL ID SQL TEXT
122 0.7% 42 0.2% 80 0.4% 26 44.8% 44.8% __plsql_vm@1
80 0.4% 80 0.4% 0 0.0% 26 44.8% 89.7% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
18215 100% 139 0.8% 18076 99.2% 2 3.4% 93.1% __anonymous_block
18230 100% 15 0.1% 18215 100% 2 3.4% 96.6% __plsql_vm
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% 98.3% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
0 0.0% 0 0.0% 0 0.0% 1 1.7% 100% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Subtree Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% 18077 17955 123 __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
18230 100% 15 0.1% 18215 100% 2 3.4% 9115 8 9108 __plsql_vm
18215 100% 139 0.8% 18076 99.2% 2 3.4% 9108 70 9038 __anonymous_block
122 0.7% 42 0.2% 80 0.4% 26 44.8% 5 2 3 __plsql_vm@1
80 0.4% 80 0.4% 0 0.0% 26 44.8% 3 3 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 1.7% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Function Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% 18077 17955 123 __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
18215 100% 139 0.8% 18076 99.2% 2 3.4% 9108 70 9038 __anonymous_block
18230 100% 15 0.1% 18215 100% 2 3.4% 9115 8 9108 __plsql_vm
80 0.4% 80 0.4% 0 0.0% 26 44.8% 3 3 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
122 0.7% 42 0.2% 80 0.4% 26 44.8% 5 2 3 __plsql_vm@1
0 0.0% 0 0.0% 0 0.0% 1 1.7% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Function Elapsed Time (microsecs) Data sorted by Mean Descendants Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Mean Subtree Mean Function Mean Descendants Function Name SQL ID SQL TEXT
18230 100% 15 0.1% 18215 100% 2 3.4% 9115 8 9108 __plsql_vm
18215 100% 139 0.8% 18076 99.2% 2 3.4% 9108 70 9038 __anonymous_block
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% 18077 17955 123 __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
122 0.7% 42 0.2% 80 0.4% 26 44.8% 5 2 3 __plsql_vm@1
80 0.4% 80 0.4% 0 0.0% 26 44.8% 3 3 0 SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
0 0.0% 0 0.0% 0 0.0% 1 1.7% 0 0 0 SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Module Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Module Ind% Cum% Calls Ind% Module Name
18150 99.6% 99.6% 31 53.4%
80 0.4% 100% 26 44.8% SCOTT.F_CHANGE_TX
0 0.0% 100% 1 1.7% SYS.DBMS_HPROF
Module Elapsed Time (microsecs) Data sorted by Module Name for 'case1_fix'

Module Elapsed Time (microsecs) Data sorted by Module Name

18230 microsecs (elapsed time) & 58 function calls

Module Ind% Calls Ind% Module Name
18150 99.6% 31 53.4%
80 0.4% 26 44.8% SCOTT.F_CHANGE_TX
0 0.0% 1 1.7% SYS.DBMS_HPROF
Module Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Module Ind% Calls Ind% Cum% Module Name
18150 99.6% 31 53.4% 53.4%
80 0.4% 26 44.8% 98.3% SCOTT.F_CHANGE_TX
0 0.0% 1 1.7% 100% SYS.DBMS_HPROF
Namespace Elapsed Time (microsecs) Data sorted by Total Function Elapsed Time (microsecs) for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Function Ind% Cum% Calls Ind% Namespace
17954 98.5% 98.5% 1 1.7% SQL
276 1.5% 100% 57 98.3% PLSQL
Namespace Elapsed Time (microsecs) Data sorted by Namespace for 'case1_fix'

Namespace Elapsed Time (microsecs) Data sorted by Namespace

18230 microsecs (elapsed time) & 58 function calls

Function Ind% Calls Ind% Namespace
276 1.5% 57 98.3% PLSQL
17954 98.5% 1 1.7% SQL
Namespace Elapsed Time (microsecs) Data sorted by Total Function Call Count for 'case1_fix'

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

18230 microsecs (elapsed time) & 58 function calls

Function Ind% Calls Ind% Cum% Namespace
276 1.5% 57 98.3% 98.3% PLSQL
17954 98.5% 1 1.7% 100% SQL
Parents and Children Elapsed Time (microsecs) Data for 'case1_fix'

Parents and Children Elapsed Time (microsecs) Data



__anonymous_block 

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18215 100% 139 0.8% 18076 99.2% 2 3.4% __anonymous_block
Parents:
18215 100% 139 100% 18076 100% 2 100% __plsql_vm
Children:
18076 100% 17954 100% 122 100% 1 100% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
0 0.0% 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
18230 100% 15 0.1% 18215 100% 2 3.4% __plsql_vm
Parents:
18230 100% 15 100% 18215 100% 2 100% ORACLE.root
Children:
18215 100% 139 100% 18076 100% 2 100% __anonymous_block
__plsql_vm@1
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
122 0.7% 42 0.2% 80 0.4% 26 44.8% __plsql_vm@1
Parents:
122 100% 42 100% 80 100% 26 100% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
Children:
80 100% 80 100% 0 N/A 26 100% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
80 0.4% 80 0.4% 0 0.0% 26 44.8% SCOTT.F_CHANGE_TX.F_CHANGE_TX (Line 1)
Parents:
80 100% 80 100% 0 N/A 26 100% __plsql_vm@1
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 1.7% SYS.DBMS_HPROF.STOP_PROFILING (Line 453)
Parents:
0 N/A 0 N/A 0 N/A 1 100% __anonymous_block
__static_sql_exec_line4 (Line 4)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name SQL ID SQL TEXT
18076 99.2% 17954 98.5% 122 0.7% 1 1.7% __static_sql_exec_line4 (Line 4)b4pduc9z5xybcSELECT LISTAGG(OWNER_TX,',') WITHIN GROUP (ORDER B
Parents:
18076 100% 17954 100% 122 100% 1 100% __anonymous_block
Children:
122 100% 42 100% 80 100% 26 100% __plsql_vm@1