Toad
After running the PL/SQL Profiler in TOAD, no data is recorded or shown under Profiler Analysis.
To resolve this problem, Grant SELECT, INSERT, UPDATE and DELETE on the following tables under the TOAD schema:
PLSQL_PROFILER_DATA
PLSQL_PROFILER_RUNS
PLSQL_PROFILER_UNITS
Also require Select privilege on Sys.DBA_Source.
Example:
GRANT SELECT, INSERT, UPDATE, DELETE ON PLSQL_PROFILER_DATA TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON PLSQL_PROFILER_RUNS TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON PLSQL_PROFILER_UNITS TO PUBLIC;