Forums Active Threads
Print Thread
Page 1 of 2 1 2
Pauses While Sessions View Updates
#33520 03/05/09 05:05 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
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.
Re: Pauses While Sessions View Updates
UMG Developer #33529 03/06/09 11:38 AM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
I cannot immediately reproduce this. Can you let me know your Session Mode preference?

Marco Kalter
Allround Automations
Re: Pauses While Sessions View Updates
Marco Kalter #33532 03/06/09 04:40 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
I am in "Multi Session" mode.
Re: Pauses While Sessions View Updates
UMG Developer #33533 03/06/09 06:26 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
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.)
Re: Pauses While Sessions View Updates
UMG Developer #33538 03/09/09 10:59 AM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
How long does this query take for you?

Code
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#

Marco Kalter
Allround Automations
Re: Pauses While Sessions View Updates
Marco Kalter #33540 03/09/09 04:49 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
[quote=Marco Kalter]How long does this query take for you?
[/quote]

Normally about 0.875 seconds according to the status bar.
Re: Pauses While Sessions View Updates
UMG Developer #33546 03/10/09 11:22 AM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
It takes 0.07 seconds here. This may indeed cause some delays.

Marco Kalter
Allround Automations
Re: Pauses While Sessions View Updates
Marco Kalter #33550 03/10/09 05:27 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
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?
Re: Pauses While Sessions View Updates
UMG Developer #33555 03/11/09 10:26 AM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
A PL/SQL Developer update cannot improve the performance of your v$sesstat and v$statname views.

Marco Kalter
Allround Automations
Re: Pauses While Sessions View Updates
Marco Kalter #33561 03/11/09 09:21 PM
Joined: Feb 2009
Posts: 23
U
UMG Developer Offline OP
Member
OP Offline
UMG Developer
Member
U
Joined: Feb 2009
Posts: 23
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?)
Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 15 (0.006s) Memory: 2.5609 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-20 05:31:30 UTC
Valid HTML 5 and Valid CSS