Sorry for long delay with replying to your post. I believe the problem is caused by the location of the profiler tables. DB Tools Profiler simply cannot find them in the STUDENT schema. Try creating public synonyms with the same names that point to profiler tables in your schema. Also please take a look what you got in db_tools.err file. Permission-related errors are usually recorded in that file. : I have all three PLSQL Profiler tables in my schema. The schema name is : STUDENT. : Wnen connecting to the database in the Profiler I connect as user STUDENT. : I have verified that I have access to the profiler tables in the STUDENT : schema. : After each run I execute : select count(*) from student.plsql_profiler_runs : and can see that the number of records increased. : plsql_profiler_data and plsql_profiler_units tables are also growing after : each run. : Thanks!
|