Which three statements are true about hierarchical profiling? (Choose three.)
A.
It provides function-level summaries.
B.
It produces an aggregated report of the SQL and PL/SQL execution times.
C.
It is useful for understanding the structure and control flow of complex programs.
D.
It can be used to identify hotspots and tuning opportunities in PL/SQL applications.
E.
It generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table.
A, C, D
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDBCIDI
B C D
A,C,D
A.
plshprof Utility
HTML Report from a Single Raw Profiler Output File. Function-Level Reports
The function-level reports provide a flat view of the profile information.
Each function-level report includes the following information for each function:
-Function time (time spent in the function itself, also called “self time”)
-Descendants time (time spent in the descendants of the function)
-Subtree time (time spent in the subtree of the function—function time plus descendants time)
-Number of calls to the function
-Function name
-The function name is hyperlinked to the Parents and Children Report for the function.
C.
9 Using the PL/SQL Hierarchical Profiler
The profiler reports the dynamic execution profile of a PL/SQL program organized by function calls, and accounts for SQL and PL/SQL execution times separately. No special source or compile-time preparation is required; any PL/SQL program can be profiled.
D.
9 Using the PL/SQL Hierarchical Profiler
You can use the PL/SQL hierarchical profiler to identify bottlenecks and performance-tuning opportunities in PL/SQL applications.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDBCIDI