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_profile

Profiling and Performance package (optional installation) This file contains the wwutl_profile package definition. This package, in conjunction with the gateway settings before_proc and after_proc, can be used to run a Portal installation in a mode where it will collection SQL Execution Trace profiling information. It is not installed by default, and must be executed as the profile schema owner. The PL/SQL Profiling system (rdbms/admin/profload.sql) must be installed before installing this package.

Scope:
  Public

Function/Procedure Summary
`action` | ``
`delete_all_profiles` | ``
`delete_profile` | ``
`profile_off` Turn off PL/SQL Profiling. | ``
`profile_on` Turn on PL/SQL Profiling. | ``
`show` | ``
`unit_action` | ``

Function/Procedure Detail

### action

    procedure action(
        p_runid in integer,
        p_action in varchar2
    )

### delete_all_profiles

    procedure delete_all_profiles

### delete_profile

    procedure delete_profile(
        p_runid in integer
    )

### profile_off

    procedure profile_off

  Turn off PL/SQL Profiling. This routine should be put into the "after_proc" setting in the gateway/listener: after_proc=webdb.profile_off

### profile_on

    procedure profile_on

  Turn on PL/SQL Profiling. This method will start a run with the PL/SQL Profiler. It will associate a comment to the run of the form: "" - "" eg. "webdb_public" - "/myDad/webdb.home" This routine should be put into the "before_proc" setting in the gateway/listener: before_proc=webdb.profile_on

### show

    procedure show

### unit_action

    procedure unit_action(
        p_runid in integer,
        p_unit in integer,
        p_action in varchar2
    )

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