| Help about using DBMS PROFILER! [message #14491] |
Fri, 27 August 2004 12:35 |
andi
Messages: 23
Registered: March 2004
|
Junior Member |
|
|
hi,
i need to use the oracle profiler package for performance measuring and I have some problem.
When I tried to install it, I logged on as SYS and execute the script proftab.sql, every table and sequence were successfully created.?And profload.sql.?Then I got the following message:
SP2-0310: unable to open file "dbmspbp.sql"
SP2-0310: unable to open file "prvtpbp.plb"
Testing for correct installation
DBMS_PROFILER - missing or invalid synonym
PACKAGE sys.DBMS_PROFILER - missing or invalid
PL/SQL procedure successfully completed.
Then when I tried to call DBMS_PROFILER.START_PROFILER('test'), I got the following:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'DBMS_PROFILER.START_PROFILER' must be declared.
What should I do? Seems although I was operating under sys account, the profiler was still not correctly installed, right?
Do I need some special CD installed for Oracle?
Please help me out!
Thanks a lot!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
