| dbms_profiler [message #237608] |
Tue, 15 May 2007 03:30  |
guru_karnam
Messages: 142
Registered: May 2005
|
Senior Member |
|
|
Hi All,
Iam using oracle 10g release 2. Tried to run dbms_profiler package.The steps are
1)profload.sql(it has prvtpbp.plb internally called).
2)proftab.sql
But the file
prvtpbp.plb gives errors.
It gives the error
library created with compilation errors
Package body created with compilation errors
Testing for correct installation
PACKAGE BODY sys.DBMS_PROFILER - missing or invalid
PL/SQL procedure successfully completed.
Please suggest the steps.
Ravi
|
|
|
|
| Re: dbms_profiler [message #237653 is a reply to message #237608] |
Tue, 15 May 2007 07:07  |
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
|
Member |
|
|
Hi Please verify
whether you have run the
1.profload.sql as SYSDBA
2.proftab.sql UNDER THE SCHEMA where you are running your tests.
Note : If you want to have a generic schema to hold this , then You need to grant the profiler related tables under the schema in question to public
GRANT SELECT ON plsql_profiler_runnumber TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON plsql_profiler_data TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON plsql_profiler_units TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON plsql_profiler_runs TO PUBLIC;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
