Parents and Children Elapsed Time (microsecs) Data



__anonymous_block 

Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
4827 98.4% 1426 29.1% 3401 69.4% 5 5.3% __anonymous_block
Parents:
4827 100% 1426 100% 3401 100% 5 100% __plsql_vm
Children:
3013 88.6% 558 100% 2455 100% 1 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
388 11.4% 292 100% 96 100% 3 100% SYS.DBMS_OUTPUT.GET_LINES (Line 180)
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
4904 100% 77 1.6% 4827 98.4% 5 5.3% __plsql_vm
Parents:
4904 100% 77 100% 4827 100% 5 100% ORACLE.root
Children:
4827 100% 1426 100% 3401 100% 5 100% __anonymous_block
STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
3013 61.4% 558 11.4% 2455 50.1% 1 1.1% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
Parents:
3013 100% 558 100% 2455 100% 1 100% __anonymous_block
Children:
1265 51.5% 1265 100% 0 N/A 14 100% STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line19 (Line 19)
513 20.9% 183 100% 330 100% 15 100% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
415 16.9% 64 100% 351 100% 1 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE.EMP_CUR (Line 3)
262 10.7% 262 100% 0 N/A 1 100% STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line12 (Line 12)
STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE.EMP_CUR (Line 3)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
415 8.5% 64 1.3% 351 7.2% 1 1.1% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE.EMP_CUR (Line 3)
Parents:
415 100% 64 100% 351 100% 1 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
Children:
351 100% 351 100% 0 N/A 1 100% STUDENT01.LOOPING_EXAMPLE.__static_sql_exec_line4 (Line 4)
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 1.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.GET_LINE (Line 129)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
96 2.0% 96 2.0% 0 0.0% 17 18.1% SYS.DBMS_OUTPUT.GET_LINE (Line 129)
Parents:
96 100% 96 100% 0 N/A 17 100% SYS.DBMS_OUTPUT.GET_LINES (Line 180)
SYS.DBMS_OUTPUT.GET_LINES (Line 180)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
388 7.9% 292 6.0% 96 2.0% 3 3.2% SYS.DBMS_OUTPUT.GET_LINES (Line 180)
Parents:
388 100% 292 100% 96 100% 3 100% __anonymous_block
Children:
96 100% 96 100% 0 N/A 17 100% SYS.DBMS_OUTPUT.GET_LINE (Line 129)
SYS.DBMS_OUTPUT.NEW_LINE (Line 117)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
83 1.7% 83 1.7% 0 0.0% 15 16.0% SYS.DBMS_OUTPUT.NEW_LINE (Line 117)
Parents:
83 100% 83 100% 0 N/A 15 100% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
SYS.DBMS_OUTPUT.PUT (Line 77)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
247 5.0% 247 5.0% 0 0.0% 15 16.0% SYS.DBMS_OUTPUT.PUT (Line 77)
Parents:
247 100% 247 100% 0 N/A 15 100% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
513 10.5% 183 3.7% 330 6.7% 15 16.0% SYS.DBMS_OUTPUT.PUT_LINE (Line 109)
Parents:
513 100% 183 100% 330 100% 15 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
Children:
247 74.8% 247 100% 0 N/A 15 100% SYS.DBMS_OUTPUT.PUT (Line 77)
83 25.2% 83 100% 0 N/A 15 100% SYS.DBMS_OUTPUT.NEW_LINE (Line 117)
STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line12 (Line 12)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
262 5.3% 262 5.3% 0 0.0% 1 1.1% STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line12 (Line 12)
Parents:
262 100% 262 100% 0 N/A 1 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line19 (Line 19)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
1265 25.8% 1265 25.8% 0 0.0% 14 14.9% STUDENT01.LOOPING_EXAMPLE.__sql_fetch_line19 (Line 19)
Parents:
1265 100% 1265 100% 0 N/A 14 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE (Line 1)
STUDENT01.LOOPING_EXAMPLE.__static_sql_exec_line4 (Line 4)
Subtree Ind% Function Ind% Descendants Ind% Calls Ind% Function Name
351 7.2% 351 7.2% 0 0.0% 1 1.1% STUDENT01.LOOPING_EXAMPLE.__static_sql_exec_line4 (Line 4)
Parents:
351 100% 351 100% 0 N/A 1 100% STUDENT01.LOOPING_EXAMPLE.LOOPING_EXAMPLE.EMP_CUR (Line 3)