My Oracle Support Banner

Where to Find Files PROFREP.SQL and PROFSUM.SQL to Create the DBMS_PROFILER Package? (Doc ID 1076588.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Aug-2012***

Goal

Need to create the following tables in the oracle database for DBMS_PROFILER:

PLSQL_PROFILER_GRAND_TOTAL
PLSQL_PROFILER_UNITS_CROSS_RUN
PLSQL_PROFILER_LINES_CROSS_RUN
PLSQL_PROFILER_NOTEXEC_LINES

Per the documentation, the SQL scripts for the setup of DBMS_PROFILER is found within the PROFREP.SQL and PROFSUM.SQL scripts located in the $ORACLE_HOME/PLSQL/DEMO directory.

Searching the $ORACLE_HOME/plsql/demo directory and these files can not be found.


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.