Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into
database tables.
A.
the trace file component
B.
the analyzer component
C.
the shared library component
D.
the data collection component
Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into
database tables.
Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into
database tables.
A.
the trace file component
B.
the analyzer component
C.
the shared library component
D.
the data collection component
B. true
The analyzer component processes the raw profiler output and stores the results in hierarchical profiler tables.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm
Overview of PL/SQL Hierarchical Profiler
You can use the “PL/SQL hierarchical profiler” to identify bottlenecks and performance-tuning opportunities in PL/SQL applications.
It s implemented by the DBMS_HPROF package and has two components:
– Data collection
The data collection component is an intrinsic part of the PL/SQL Virtual Machine.
The DBMS_HPROF package provides APIs to turn hierarchical profiling on and off.
The raw profiler output is written to a file.
– Analyzer
The analyzer component processes the raw profiler output and stores the results in hierarchical profiler tables.