Yocoya.com - DBMS_PROFILER companion for Oracle Application Express

Oracle DBMS_PROFILER extension

function	SHARED mode	LOCAL mode
This application is built upon Oracle's DBMS_PROFILER tables and, thanks to Oracle Application Express, provides you with a more intuitive user interface for interpreting the output of the PL/SQL profiler. Besides the standard tables, new supporting objects are installed which allow a performance comparison between different version of the PL/SQL source code. The application can be installed either in local or in shared mode, depending on the space requirements or privacy considerations. The following table summarizes the main differences between these two modes:
privacy		X
single workspace installation	X
advanced support functions	see note 1	X
migration of existing data		X

note 1: if an additional instance of the application (without supporting objects) is installed in a different workspace, the schema user associated with that workspace will be able to execute the advanced support functions.

The application requires the installation of the optional package DBMS_PROFILER (whose installation script is located in the folder $ORACLE_HOME/RDBMS/admin/profload.sql). If the profiler tables are already present, they will be automatically renamed and it will be possible to migrate their data, otherwise the application will install all the supporting objects automatically.

Installation instructions for SHARED mode

create PROFI user by executing the script create_profi.sql
create a workspace associated with PROFI schema or execute script create_profi_wks.sql
import the application into the newly created workspace.
install both the application and the supporting objects.
optionally, install other copies of the application without supporting objects into the workspaces of users who wish to use the advanced support functions.

Installation instructions for LOCAL mode

import the application into the desired workspace.
install both the application and the supporting objects.

software download

PL/SQL profiler companion for Oracle Application Express 3.1 (beta version)

please accept the terms of use prior to download the software

further information

scarica la presentazione effettuata all'Oracle Open World 2008 sull'estensione al DBMS_PROFILER per Apex

requirements

Oracle Application Express ver. 3.1.0 or better
Oracle Database Server ver. 9.2.0 or better or Oracle XE

I agree

Usage of the software downloaded from this page implies accepting the following terms of use:

The software is provided on a "as is" basis, without any implicit warranty of usability in your software environment.
Yocoya.com does not provide technical support or any warranties for these programs.
In no event shall Yocoya.com be liable for malfunctioning, delays, data loss or security risks deriving from the use of this software.