-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Advanced Oracle PL/SQL Developer's Guide (Second Edition)
By :

Tracing program execution is an important exercise in a scrum based database development environment. Sometimes, in a modular programming model, it becomes difficult to track the program execution path. Oracle provides the DBMS_TRACE
package to trace PL/SQL program code.
DBMS_TRACE
is an Oracle supplied package that can be used to enable and disable tracing in database sessions. The program execution path is traced when you execute a PL/SQL program in a trace-enabled session. The trace information is captured and stored in database tables. These trace tables can be further analyzed to examine the execution path of a PL/SQL program.
The following figure shows the steps involved in PL/SQL code tracing:
PL/SQL code tracing cannot be done in a shared server environment
You can install the DBMS_TRACE
package by running the following scripts from the $ORACLE_HOME/rdbms/admin
folder:
dbmspbt.sql
: This script creates the DBMS_TRACE...
Change the font size
Change margin width
Change background colour