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.

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


gelete

gelete

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.