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 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
)