Home » RDBMS Server » Performance Tuning » dbms_profiler
dbms_profiler [message #237608] Tue, 15 May 2007 03:30 Go to next message
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 Go to previous messageGo to next message
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;

Re: dbms_profiler [message #237654 is a reply to message #237608] Tue, 15 May 2007 07:11 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
Hi Sriram,

I have run as sys only. But prvtpbp.plb gives errors .

Ravi
Re: dbms_profiler [message #237656 is a reply to message #237654] Tue, 15 May 2007 07:21 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Hi ,

How did you run this ?

Using PL/SQL Developer or sqlplus?
Re: dbms_profiler [message #237657 is a reply to message #237656] Tue, 15 May 2007 07:23 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Also after you have run this , please type

SQL>SHOW ERRORS


And list the error
Re: dbms_profiler [message #237901 is a reply to message #237608] Wed, 16 May 2007 01:53 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
I have run through pl/sql developer
Re: dbms_profiler [message #237996 is a reply to message #237901] Wed, 16 May 2007 05:39 Go to previous message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Hi

Please can you run the same through sqlplus with @<path>.

Thanks
Previous Topic: My production statspack report
Next Topic: Statspack Report
Goto Forum:
  


Current Time: Sun Dec 04 06:53:38 CST 2016

Total time taken to generate the page: 0.04720 seconds