Scribd
Upload
94 views2 pages

Part 21

The document discusses different methods for tracing PL/SQL code including DBMS_APPLICATION_INFO, DBMS_TRACE, DBMS_SESSION and DBMS_MONITOR, and trcsess and tkproof utilities. The hierarchical profiler can profile PL/SQL calls and provide distinct reports on SQL and PL/SQL time consumption along with subprogram call counts and times in HTML format. PLV msg allows assigning text messages to rows, retrieving messages by number, substituting error messages, and loading messages from a database table.

Uploaded by

Sumit K
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
94 views2 pages

Part 21

The document discusses different methods for tracing PL/SQL code including DBMS_APPLICATION_INFO, DBMS_TRACE, DBMS_SESSION and DBMS_MONITOR, and trcsess and tkproof utilities. The hierarchical profiler can profile PL/SQL calls and provide distinct reports on SQL and PL/SQL time consumption along with subprogram call counts and times in HTML format. PLV msg allows assigning text messages to rows, retrieving messages by number, substituting error messages, and loading messages from a database table.

Uploaded by

Sumit K
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

53. Mention what are different methods to trace the PL/SQL code?

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

54. Mention what does the hierarchical profiler does?

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

Distinct reporting for SQL and PL/SQL time consumption


Reports count of distinct sub-programs calls made in the PL/SQL, and the time spent
with each subprogram call
Multiple interactive analytics reports in HTML format by using the command line
utility
More effective than conventional profiler and other tracing utilities

55. Mention what does PLV msg allows you to do?

The PLV msg enables you to

Assign individual text message to specified row in the PL/SQL table


It retrieves the message text by number
It substitutes automatically your own messages for standard Oracle error messages
with restrict toggle
Batch load message numbers and text from a database table directly PLV msg
PL/SQL table
56. Mention what is the PLV (PL/Vision) package offers?

Null substitution value


Set of assertion routines
Miscellaneous utilities
Set of constants used throughout PL vision
Pre-defined datatypes

Mention what is the use of PLVprs and PLVprsps?

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.

You might also like