Overview | Package | Object Type | Deprecated | Index | Help
| Oracle Application Server Portal PL/SQL API Reference - 10.1.4
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES
SUMMARY: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE | DETAIL: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE

## Package wwutl_dbms_trace

HTML interface for database profiling package (optional installation). This file contains the wwutl_dbms_trace package definition. Trace data is collected by turning on tracing using the DBMS_TRACE package. The trace data is inserted into the trace tables. This package provides a web based UI for viewing the trace data. It is not installed by default, and must be executed as the Portal schema owner. The scripts rdbms/admin/tracetab.sql and rdbms/admin/dbmspbt.sql must be installed as SYS before installing this package.

Scope:
  Public

Function/Procedure Summary
`action` Invoke the procedure corresponding to the action. | ``
`delete_all_runs` Delete all runs. | ``
`delete_run` Delete a run. | ``
`show` Show the main page listing all the trace runs. | ``
`show_calling_procs` Show procedures which call the specified procedure. | ``
`show_run` Show the trace events for a single run. | ``
`show_source` Show source. | ``

Function/Procedure Detail

### action

    procedure action(
        p_runid in pls_integer,
        p_action in varchar2
    )

  Invoke the procedure corresponding to the action.

  Parameters:
    `p_runid` - run id
    `p_action` - action to perform DELETE - delete run and call show SHOW - show run SHOW_CALLS - show all calls in run

### delete_all_runs

    procedure delete_all_runs

  Delete all runs.

### delete_run

    procedure delete_run(
        p_runid in pls_integer
    )

  Delete a run.

  Parameters:
    `p_runid` - run id

### show

    procedure show

  Show the main page listing all the trace runs. This is the main procedure to access from the browser.

### show_calling_procs

    procedure show_calling_procs(
        p_runid in pls_integer,
        p_proc_unit in varchar2,
        p_proc_name in varchar2 default null,
        p_proc_line in number default null
    )

  Show procedures which call the specified procedure. Show all the procedures which call the specified procedure ordered by the number of calls descending. The maximum number of callers displayed is limited by MAX_NUM_EVENTS. For each caller, the following information is shown: Num Calls - number of calls Line # - source line number in the caller with a link to the source code Package - package name of the caller Procedure - procedure name of the caller Code - source line in the caller where specified procedure is called

  Parameters:
    `p_runid` - run id
    `p_proc_unit` - procedure unit
    `p_proc_name` - procedure name, may be null
    `p_proc_line` - procedure source line number

### show_run

    procedure show_run(
        p_runid in pls_integer
    )

  Show the trace events for a single run. The events are displayed ordered by sequence. The maximum number of events displayed is limited to MAX_NUM_EVENTS. For each trace event, the following information is shown: Seq - sequence of event Depth - call stack depth Event - event type Call - procedure call Return - procedure return Instantiate - package instantiated Exc Raised - exception raised Exc Handled - exception handled Type - event unit type SPEC - package specification BODY - package body PROC - procedure FUNC - function ANON - anonymous block TYPE - type body Event Procedure - fully qualified name of procedure or unit which caused the event with a link to the source code Line # - event source line number Code - event source line Type - procedure unit type Procedure - fully qualified name of procedure or unit which is related to the event with a link to the source code Line # - procedure source line number Code - procedure source line The event procedure and procedure depend on the type of event. For a procedure call, the event procedure is the caller and the procedure is the called procedure. For a procedure call return, the event procedure is the called procedure and the procedure is the caller. For a package instantiation, the event procedure is the caller and the procedure is the package being instantiated.

  Parameters:
    `p_runid` - run id

### show_source

    procedure show_source(
        p_runid in pls_integer,
        p_owner in varchar2,
        p_name in varchar2,
        p_type in varchar2,
        p_line in pls_integer
    )

  Show source. Display the full source code of the specified unit. A named anchor is added to the specified line so it can be linked to. The name of the anchor is the line number itself. The lines for which there are procedure calls have a link to the callers.

  Parameters:
    `p_runid` - run id
    `p_owner` - schema owner
    `p_name` - unit name
    `p_type` - unit type
    `p_line` - line number for which an anchor is defined

Overview | Package | Object Type | Deprecated | Index | Help
| Oracle Application Server Portal PL/SQL API Reference - 10.1.4
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES
SUMMARY: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE | DETAIL: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE