"One Moment... " window behaviour

[Rob van Rijen]

Hi,

If you do a sort on the query results with large amounts of records, the "One Moment..." window will appear. This window is on top and can not be moved to the backgroud. Some sorts can take a long time. This blocks access to all other programs. Can this behaviour be influenced?

Thanks,

Rob

 

[Marco Kalter]

It cannot be influenced, but we'll look into it.

 

[D.]

Has this been "looked into" ?

It's still an issue, as I see it in v6.

Also, it seems to block the ability to open another instance of PLSQL Developer application too. So you can't even open a new application session to do any other DB work while the "One Moment..." window is active.

D.

 

[Marco Kalter]

Unfortunately we have not been able to reproduce this.

 

[D.]

Marco,

I can reproduce this every time using a simple query that returns maybe 100000 records. On our system, this query returns 100000+ records - you should be able to tweak it suit your env :-

SELECT *
FROM   all_objects a
      ,(SELECT owner
       FROM   all_objects b
       WHERE  ROWNUM < 12)

Here's how I can reproduce the behaviour :-

• After the results are all fetched, click a column header to sort the data.
• The "One Moment..." window appears with the progress bar along the bottom counting up as usual.
• While the progress bar is counting up, switching to another application (Alt-TAB) hides the "One Moment" window as you would expect and switching back brings it to the fore again.
• However, when progress bar has finished (counted up to far right) the progress window stays active for some time after that in the foreground. Switching to another application during this period (Alt-TAB) does not hide the "One Moment..." window. Nor can you open another instance of PLSQL Developer during this time.

System Specs:

• Windows 2000
  
• 5.00.2195
• Service Pack 4

[*]Pentium P4 2.4GHz CPU
[*]1Gb RAM[/list]Hope this helps with your investigation,
D.

 

[Marco Kalter]

That does indeed reproduce it. We'll check out what is going on when the progress bar has completed.

 

[D.]

Marco,

This doesn't seem to be fixed in v7.1.4 .

Did you ever get to the bottom of it ?

D.

 

[Marco Kalter]

This is on the list to be fixed for 8.0.