Part 21
Part 21
Part 21
Tracing code is a crucial technique to measure the code performance during the runtime.
Different methods for tracing includes
DBMS_APPLICATION_INFO
DBMS_TRACE
DBMS_SESSION and DBMS_MONITOR
trcsess and tkproof utilities
The hierarchical profiler could profile the calls made in PL/SQL, apart from filling the gap
between the loopholes and the expectations of performance tracing. The efficiencies of the
hierarchical profiler includes
PLVprs: It is an extension for string parsing for PL/SQL, and it is the lowest level of
string parsing functionality
PLVprsps: It is the highest level package to parse PL/SQL source code into separate
atomics. It relies on other parsing packages to get work done.