Re: dbms_profiler

sujee wrote:
> hi,
> i am creating a tool using java to profiler plsql stored procedures.
> there are two way of installing dbms_packages
> 1. install profload.sql as sys.
> Then creat plsql profiler table(proftab.sql) for each user who want to
> profile its plsql proce.
> 2.install proload.sql and proftab.sql as sys then give permission to
> profiler tables and others to other user.
>
> first installation is ok
> i have problem with second one.
>
> I installed as follows,
> 1.installed proload.sql and protab.sql as sys as sysbda
> 2.
> grant execute on dbms_profiler to public;
> grant select,insert,delete,update on plsql_profiler_runs to public;
> grant select,insert,delete,update on plsql_profiler_units to public;
> grant select,insert,delete,update on plsql_profiler_data to public;
> grant all on plsql_profiler_runnumber to public;
>
> 3.
> create public synonym plsql_profiler_runs for plsql_profiler_runs;
> create public synonym plsql_profiler_units for plsql_profiler_units;
> create public synonym plsql_profiler_data for plsql_profiler_data;
> create public synonym plsql_profiler_runnumber for
> plsql_profiler_runnumber;
>
> after that when i tried to profile i got following error,
> ora-06528 error executing plsql profiler
> ora-06512 at sys.dbms_profiler line 123
> ora-06512 at sys.dbms_profiler line 132
> ora-06512 at testuser.test_profiler//this my proce call profiler
>
> when i tried to access profiler tables from plsql developer it said,
> dynamic performance tables are not accessable. automatic statistics
> disabled for this session.
> you can disable statistics in the performance menu or v$sessstat and
> v$statname tables.
>
>
> i am expecting your answers
> thank you.

Do the separate installs into each schema.

Otherwise your ability to keep things straight between multiple users running multiple profiles is fraught with danger.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)