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

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