SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple running queries at the same time

224071Jan 10 2008 — edited Apr 9 2008

Hi!

I looked around (and RTM) for this but didn't find anything, so I'm asking here.

I have quite a few long running queries (data loading and such things, warehousing stuff), and I need to be able to run multiple queries/statements at the same time. In TOAD I can do this, start a procedure and while it is running I can do SQL statements in another session tab (it supports threaded sessions - it starts queries in their own background thread/session).

When I start a long running procedure or query in SQL Developer I can not do anything until the procedure execution finishes. Is there any way (setting/preference) to enable SQL Developer to be able to run multiple queries at the same time?

I really would like to move away from TOAD, but this is a major showstopper for me.

Thanx for any tips.

Alex

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2008

Added on Jan 10 2008

#sql-developer

16 comments

9,057 views