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 populates profiler tables in the database from raw profiler output.

Show Hint

Leave a Reply 4

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

Nikita

Nikita

B. http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm

Reply

Edgardo

Edgardo

Nikita,

The answer is still A. I got two definitions:

1. From your link:
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. (For an example of a raw profiler output file, see test.trc in Collecting Profile Data.)

You can browse the generated HTML reports in any browser. The browser’s navigational capabilities, combined with well chosen links, provide a powerful way to analyze performance of large applications, improve application performance, and lower development costs.

2. From a Book: “The plshprof executable is a command line located in $ORACLE_HOME/bin/. It can generate HTML reports using either one or two raw profiler output files” Mattew Morris, Study guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL Programming.

Reply

Edgardo

Edgardo

According to the link the Answer is still A.

“The plshprof executable is a command line located in $ORACLE_HOME/bin/. It can generate HTML reports using either one or two raw profiler output files” Mattew Morris, Study guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL Programming.

Reply