SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Profiler View Results are empty

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
SQL Profiler View Results are empty
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post SQL Profiler View Results are empty Reply with quote

The PROFILER_DATA table describes summary results, but doesn't store profiler details. The details are stored in PLSQL_PROFILER_DATA usually located in SYS or SYSTEM schema. Please make sure you have access permissions for that table.

: I've created a project and added couple of runs to it.
: I can see these runs in the ORA_MONITOR.PROFILER_DATA table,
: but View Results are empty.

Thu Dec 28, 2006 12:53 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: SQL Profiler View Results are empty Reply with quote

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!

Wed Jan 03, 2007 9:50 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.