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

Show Hint

Leave a Reply 3

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

morriarti

morriarti

http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDJEGIA
“The PL/SQL hierarchical profiler is 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.”

Reply