Toad World® Forums

PL/SQL Profiler too slow


#1

Hi

I find PL/SQL profiler too slow. Anyone else also has this problem?

I used the SQL Monitor and found out that Profiler is executing the same statement several times (see last 3 code lines below). But even so, it executes the SQL fast enough but take several time displaying the data.
Also It says that the "source code in not available (code has changed) and I am sure that the code didn’t change. any ideas?

The spool portion of SQLMonitor

SELECT SUM(TOTAL_TIME) S FROM PLSQL_PROFILER_DATA WHERE RUNID = 1 AND
UNIT_NUMBER = 11 AND LINE# >= 1 AND LINE# <= 4704----------------------------------
Timestamp: 01:27:05.427

SELECT COUNT(*) C FROM PLSQL_PROFILER_DATA WHERE RUNID = 1 AND UNIT_NUMBER = 11
AND LINE# >= 1 AND LINE# <= 4704----------------------------------
Timestamp: 01:27:05.502

SELECT COUNT(*) C FROM PLSQL_PROFILER_DATA WHERE RUNID = 1 AND UNIT_NUMBER = 11
AND LINE# >= 1 AND LINE# <= 4704 AND TOTAL_OCCUR<>0----------------------------------
Timestamp: 01:27:05.564

SELECT COUNT(*) C FROM PLSQL_PROFILER_DATA WHERE RUNID=1 AND UNIT_NUMBER=11 AND
LINE# >= 1 AND LINE# <= 4704 AND TOTAL_TIME>36000----------------------------------
Timestamp: 01:27:05.630

SELECT COUNT(*) C FROM PLSQL_PROFILER_DATA WHERE RUNID=1 AND UNIT_NUMBER=11 AND
LINE# >= 1 AND LINE# <= 4704 AND TOTAL_TIME>360000----------------------------------
Timestamp: 01:27:05.704

SELECT COUNT(*) C FROM PLSQL_PROFILER_DATA WHERE RUNID=1 AND UNIT_NUMBER=11 AND
LINE# >= 1 AND LINE# <= 4704 AND TOTAL_TIME>3600000----------------------------------
Timestamp: 01:27:05.766

Regards
Filipe
Message was edited by: Fsilva


#2

The same here. See http://sqlnavigator.inside.quest.com/thread.jspa?messageID=29729 3) and 4).

Andres


#3

Thanks Andres for pointing me out

Filipe


#4

Hi all,

All issues related to the Profiler will be looked at in the next version.

Gwen


#5

That means version 7?