Which two statements about the PL/SQL hierarchical profiler are true?
A. Access it using the DBMS_PROFILER package.
B. Access it using the DBMS_HPROF package.
C. Profiler data is recorded in tables and published in HTML reports.
D. It is only accessible after a grant of the CREATE PROFILE privilege.
E. It helps you identify subprograms that are causing bottlenecks in application performance.
B,E are correct option according to 12c document
BE
BC
I would say that DBMS_PROFILER is more for bottlenecks (so no A and E).
I would say A C see:
https://oracle-base.com/articles/11g/plsql-hierarchical-profiler-11gr1
DBMS_PROFILER is more for bottlenecks.
https://oracle-base.com/articles/9i/dbms_profiler
BE