Test window: Profiler/Trace tab

[jure]

Hello,

when executing Test window code, PL/SQL Developer freezes if you click on Profiler or Trace tab until the code in the Test window is executed. PL/SQL Developer 10.0.5.1710, Windows 7.

Regards,
Jure

Test case: execute the following code in test window and click on one of the tabs.

begin
dbms_lock.sleep(15);
end;

 

[Marco Kalter]

We'll fix it!

 

[uros.r.d]

Same issue and click on Profiler ot Trace hangs up frequently.

Version 11.0.4.1774
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

 

[uros.r.d]

Correction, does not hang up, but it takes aprox. 3min or more to show up the result (cca 20.000 rows in profile tables after first run). Meanwhile it looks like that program has hang up.

 

[uros.r.d]

It seams that PLD pull down all data from db and that takes a lot of time to finish and PLD is not responsive while waiting for data.
It would be better to do procesing ob db and transfer just the result for prifile grid.

I have 2.0MBit connection to db.

 

[uros.r.d]

I count rows in plsql_profiler_data, plsql_profiler_runs, plsql_profiler_units. There is 1 run and aprox 4000 rows in both other tables.
I can send you tables export.

 

[William Robertson]

Correction, does not hang up, but it takes aprox. 3min or more to show up the result (cca 20.000 rows in profile tables after first run). Meanwhile it looks like that program has hang up.

Just to nitpick, "hang" means freeze (i.e. it appears to stop working without returning control to the user). "Hang up" is what you do at the end of a phone call