Pauses While Sessions View Updates

[UMG Developer]

If I have a Sessions window open, and I have it set to auto refresh, it appears that every time it refreshes that everything in PL/SQL Developer freezes. (Going through menus, or working in other editor windows.)

It would be nice if it didn't freeze up while background tasks were running.

 

[Marco Kalter]

I cannot immediately reproduce this. Can you let me know your Session Mode preference?

 

[UMG Developer]

I am in "Multi Session" mode.

 

[UMG Developer]

I think I found the actual cause... In the bottom section have the "Statistics" tab selected, and then when the window updates everything in PL/SQL Developer pauses for a second or two. (Or at least it does for me.)

 

[Marco Kalter]

How long does this query take for you?

select names.name, stats.statistic#, stats.value
  from v$sesstat stats, v$statname names
 where stats.sid = (select sid
                      from v$session
                     where audsid = userenv('sessionid'))
   and names.Statistic# = stats.Statistic#
 order by stats.statistic#

 

[UMG Developer]

How long does this query take for you?

Normally about 0.875 seconds according to the status bar.

 

[Marco Kalter]

It takes 0.07 seconds here. This may indeed cause some delays.

 

[UMG Developer]

For now I guess I can take the statistics out of my view, but do you think it is something that can be resolved in an update?

 

[Marco Kalter]

A PL/SQL Developer update cannot improve the performance of your v$sesstat and v$statname views.

 

[UMG Developer]

But it could run the query in a separate thread that didn't block the UI from updating. (When I execute a normal query that takes 10 minutes to run, it doesn't block me from editing in a different SQL window when it is running, why does this query?)

 

[Marco Kalter]

I have added this to the list of enhancement requests.