Profiler cant find tables

Toad for Oracle
1

“Profiler tables not found. See Toad help for setting up profiler.”

I am getting this message, but I already ran the "server side objects
installation wizard’

I’m logged into schema ABC and these objects/tables are also in ABC.

PLSQL_PROFILER_DATA

PLSQL_PROFILER_RUNS

PLSQL_PROFILER_UNITS

I can run the following as user ABC with no problem.

exec dbms_profiler.start_profiler (‘Test of raise procedure by Mike’);

exec dbms_profiler.flush_data();

exec mike_test;

exec dbms_profiler.stop_profiler();

select runid, unit_number, line#, total_occur, total_time,

   min_time, max_time

from plsql_profiler_data;

What am I missing?

thanks,

Mike

2

Do you have the TOAD_PROFILER package in ABC schema?

How about the sequence? PLSQL_PROFILER_RUNNUMBER.

I think your best bet is to run the Toad server side object wizard (Database >
Administer), logged in as ABC

3

Thanks Brad,

Yes, TOAD_PROFILER and PLSQL_PROFILER_RUNNUMBER are both installed in ABC.

Also, I have already run the Server Side Objects Wizard.

Maybe TOAD is looking in a different schema for these objects?

regards,

Mike

On Fri, Mar 25, 2011 at 11:00 AM, Brad Boddicker
wrote:

Do you have the TOAD_PROFILER package in ABC schema?

 

How about the sequence?  PLSQL_PROFILER_RUNNUMBER.

 

I think your best bet is to run the Toad server side object wizard (Database
> Administer), logged in as ABC
4

FYI – Michael and I got to the bottom of this off-line. If you’re on 11g and want to use the DBMS profiler, you must uncheck the option Execute/Compile > “Use Hierarchical profiler on Oracle 11g and newer”