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
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.
There are Two Component of PLSQL Hierarchical profile.
1) Data Collection: it will Collect the all the Row profile data from PLSQL Code execution and store into system-text file to further analysis.
2) Analyzer Collection : it will take the Row profile data and load into data tables like ETL.
So, Above answer id Correct!
B
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm#CHDEEABH
B
hierarchical profiler has Data collector and Analyzer two component.
Data collector collect profiler data into file.
Analyzer analyze file and load result into table.