Parents and Children Elapsed Time (microsecs) Data



__anonymous_block 

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
1028634 100% 251 0.0% 1028383 100% 3 0.2% __anonymous_block
Parents:
1028634 100% 251 100% 1028383 100% 3 100% __plsql_vm
Children:
565797 55.0% 520995 100% 44802 100% 1 100% __static_sql_exec_line5 (Line 5)
462520 45.0% 393062 100% 69458 100% 1 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
43 0.0% 21 100% 22 100% 1 100% SYS.DBMS_SESSION.IS_ROLE_ENABLED (Line 227)
20 0.0% 20 100% 0 N/A 1 100% SYS.DBMS_APPLICATION_INFO.SET_MODULE (Line 36)
3 0.0% 3 100% 0 N/A 1 100% SYS.DBMS_APPLICATION_INFO.__pkg_init
0 0.0% 0 N/A 0 N/A 1 100% SYS.DBMS_HPROF.STOP_PROFILING (Line 63)
__plsql_vm
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
1029302 100% 668 0.1% 1028634 100% 3 0.2% __plsql_vm
Parents:
1029302 100% 668 100% 1028634 100% 3 100% ORACLE.root
Children:
1028634 100% 251 100% 1028383 100% 3 100% __anonymous_block
__plsql_vm@1
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
44802 4.4% 119 0.0% 44683 4.3% 46 2.9% __plsql_vm@1
Parents:
44802 100% 119 100% 44683 100% 46 100% __static_sql_exec_line5 (Line 5)
Children:
44683 100% 750 100% 43933 100% 44 100% SYS.XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT (Line 3)
CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
462520 44.9% 393062 38.2% 69458 6.7% 1 0.1% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
Parents:
462520 100% 393062 100% 69458 100% 1 100% __anonymous_block
Children:
64279 92.5% 64279 100% 0 N/A 1034 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.SIDES_ARE_UNIQUE (Line 27)
5154 7.4% 5154 100% 0 N/A 179 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.STORE_DUP_SIDES (Line 11)
25 0.0% 25 100% 0 N/A 179 100% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.SIDES_ARE_UNIQUE (Line 27)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
64279 6.2% 64279 6.2% 0 0.0% 1034 65.3% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.SIDES_ARE_UNIQUE (Line 27)
Parents:
64279 100% 64279 100% 0 N/A 1034 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.STORE_DUP_SIDES (Line 11)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
5154 0.5% 5154 0.5% 0 0.0% 179 11.3% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES.STORE_DUP_SIDES (Line 11)
Parents:
5154 100% 5154 100% 0 N/A 179 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
SYS.DBMS_APPLICATION_INFO.SET_MODULE (Line 36)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
20 0.0% 20 0.0% 0 0.0% 1 0.1% SYS.DBMS_APPLICATION_INFO.SET_MODULE (Line 36)
Parents:
20 100% 20 100% 0 N/A 1 100% __anonymous_block
SYS.DBMS_APPLICATION_INFO.__pkg_init
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
3 0.0% 3 0.0% 0 0.0% 1 0.1% SYS.DBMS_APPLICATION_INFO.__pkg_init
Parents:
3 100% 3 100% 0 N/A 1 100% __anonymous_block
SYS.DBMS_HPROF.STOP_PROFILING (Line 63)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
0 0.0% 0 0.0% 0 0.0% 1 0.1% SYS.DBMS_HPROF.STOP_PROFILING (Line 63)
Parents:
0 N/A 0 N/A 0 N/A 1 100% __anonymous_block
SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
25 0.0% 25 0.0% 0 0.0% 179 11.3% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
Parents:
25 100% 25 100% 0 N/A 179 100% CHRIS.PERFECT_TRIANGLES.PERFECT_TRIANGLES (Line 1)
SYS.DBMS_SESSION.IS_ROLE_ENABLED (Line 227)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
43 0.0% 21 0.0% 22 0.0% 1 0.1% SYS.DBMS_SESSION.IS_ROLE_ENABLED (Line 227)
Parents:
43 100% 21 100% 22 100% 1 100% __anonymous_block
Children:
22 100% 22 100% 0 N/A 1 100% SYS.DBMS_UTILITY.CANONICALIZE (Line 802)
SYS.DBMS_UTILITY.CANONICALIZE (Line 802)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
22 0.0% 22 0.0% 0 0.0% 1 0.1% SYS.DBMS_UTILITY.CANONICALIZE (Line 802)
Parents:
22 100% 22 100% 0 N/A 1 100% SYS.DBMS_SESSION.IS_ROLE_ENABLED (Line 227)
SYS.XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT (Line 3)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
44683 4.3% 750 0.1% 43933 4.3% 44 2.8% SYS.XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT (Line 3)
Parents:
44683 100% 750 100% 43933 100% 44 100% __plsql_vm@1
Children:
22078 50.3% 22078 100% 0 N/A 44 100% SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line34 (Line 34)
21855 49.7% 21855 100% 0 N/A 44 100% SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line17 (Line 17)
__static_sql_exec_line5 (Line 5)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
565797 55.0% 520995 50.6% 44802 4.4% 1 0.1% __static_sql_exec_line5 (Line 5)
Parents:
565797 100% 520995 100% 44802 100% 1 100% __anonymous_block
Children:
44802 100% 119 100% 44683 100% 46 100% __plsql_vm@1
SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line17 (Line 17)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
21855 2.1% 21855 2.1% 0 0.0% 44 2.8% SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line17 (Line 17)
Parents:
21855 100% 21855 100% 0 N/A 44 100% SYS.XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT (Line 3)
SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line34 (Line 34)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
22078 2.1% 22078 2.1% 0 0.0% 44 2.8% SYS.XML_SCHEMA_NAME_PRESENT.__dyn_sql_exec_line34 (Line 34)
Parents:
22078 100% 22078 100% 0 N/A 44 100% SYS.XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT (Line 3)