Which statement describes the purpose of the plshprof command?

The correct answer is A. It produces HTML output from raw profiler output. https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDEEABH Overview of PL/SQL Hierarchical Profiler "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…

Debugging and Profiling PL/SQL Code

Question

Options

AIt produces HTML output from raw profiler output.
BIt produces HTML output from profiler tables in the database.
CIt populates profiler tables in the database from raw profiler output.
DIt produces raw profiler output on the most recently run applications.

How the community answered

(42 responses)

A
71% (30)
B
5% (2)
C
7% (3)
D
17% (7)

Explanation

https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDEEABH Overview of PL/SQL Hierarchical Profiler "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." So it's not D. Analyzing Profile Data "The analyzer component of the PL/SQL hierarchical profiler, DBMS_HPROF.analyze, processes the raw profiler output and stores the results in the hierarchical database tables". C is incorrect answer too. plshprof Utility "The plshprof command-line utility (located in the directory $ORACLE_HOME/bin/) generates simple HTML reports from either one or two raw profiler output files. " The answer is A.

Topics

#plshprof#hierarchical profiler#HTML output#raw profiler data

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice