dbms_profiler

From: sujee <sujee81_at_gmail.com>
Date: 20 Jun 2005 10:19:16 -0700
Message-ID: <1119287956.257613.68120@z14g2000cwz.googlegroups.com>

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. Received on Mon Jun 20 2005 - 12:19:16 CDT