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.
Why the answer “B” is not correct?
The statistic “Namespace Elapsed Time (microsecs)” showing time for SQL and PLSQL environments… No?
I think that only “E” is not correct answer.
I passed the exam with 100%, my answer: A, B, D
C- not correct!!!
100% doesn’t mean that all your answers were correct. 10 random questions are NOT scored. I guess exactly because of this 🙂
B is not a correct answer because hprof provide DESPERATE reports for SQL and PL/SQL
SEPARATE sorry
A,C,D
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDBADCD
answer a) b) d)
Oracle official materials about Hierarchical Profiling Concepts:
Definition:
– Used to identify hotspots and performance tuning
opportunities in PL/SQL applications
– Reports the dynamic execution profile of a PL/SQL program
organized by function calls
– Reports SQL and PL/SQL execution times separately
– Provides function level summaries
Benefits:
– Provides more information than a flat profiler
– Can be used to understand the structure and control flow of
complex programs
Correct answers are:
A, C, D