Re: DBMS_PROFILER schema setup script - 10g and 11g

From: ddf <oratune_at_msn.com>
Date: Mon, 2 Dec 2013 06:53:49 -0800 (PST)
Message-ID: <54afaed4-6f74-4b95-a9d2-20c6c0497be8_at_googlegroups.com>


On Friday, November 29, 2013 10:59:00 AM UTC-7, raja wrote:
> Hi All,
>
>
>
> I am looking for an oracle 10g script that would create a separate schema (example : perf schema),
>
> install the DBMS_PROFILER packages and its related tables and provide necessary grants to access the schema.
>
>
>
> Please share if anyone has it, even if you have 11g hierarchial profiler schema setup script too, that would be helpfull. Thanks in Advance.
>
>
>
> With Regards,
>
> Raja

DBMS_PROFILER does not install into its own schema on 10g or 11g; if you want that then you need to create a script to create this new user, grant the appropriate privileges, connect as this new user and then run the dbmspbp.sql script to create the DBMS_PROFILER objects. Also you cannot run the 11g hierarchical profiler setup script in 10g. 11g already has those scripts, dbmshpro.sql and dbmshptab.sql, in $ORACLE_HOME/rdbms/admin. Received on Mon Dec 02 2013 - 15:53:49 CET

Original text of this message