Which statement describes the purpose of the plshprof command?

Which statement describes the purpose of the plshprof command?

Which statement describes the purpose of the plshprof command?

A.
It produces HTML output from raw profiler output.

B.
It produces HTML output from profiler tables in the database.

C.
It populates profiler tables in the database from raw profiler output.

D.
It produces raw profiler output on the most recently run applications.

Show Hint

Leave a Reply 2

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

morriarti

morriarti

A
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.

Reply