Improve company productivity with a Business Account.Sign Up

x
?
Solved

Oracle SQL Developer v3.0.04 - Multiprocessing of SQL Scripts..???

Posted on 2011-09-19
4
Medium Priority
?
624 Views
Last Modified: 2012-05-12
Experts,

Is there some option to turn-on or something else I can do that would allow me to run multiple SQL Queries at the SAME TIME?

For example, when I have a tab open with a query and I hit F9 to process,...the query processes....I want to go to another tab and run another SQL query,... when I try to do this, Oracle SQL Developer says that the database is "Busy" and to wait or try again...

SQL Server does this with ease...that is run multiple queries at the same time in different tabs.....

Can Oracle SQL Developer do this as well? If so, HOW can I set it up to allow this...????

Thanks
0
Comment
Question by:MIKE
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
Jacobfw earned 1000 total points
ID: 36560010
SQL Developer Session Mode
By default, each new window is in its own session. Although this can be handy as a long-running process in one window won't block the others, it can lead to you having a large number of sessions, which might cause problems in some environments, and you won't be able to see uncommitted data or the contents of global temporary tables from a second window, any ALTER SESSION commands will only apply to the window they were issued in, and so on. I therefore prefer to change the setting to "Dual Session" (under "Oracle > Connection > Session Mode"), which gives me two database sessions - one for the browser panel and session monitor, and one for all other windows.

0
 
LVL 36

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 1000 total points
ID: 36560048
One option would be to open multiple, separate SQL Developer sessions (but you likely knew that already).

When you say "SQL Server does this with ease", that makes it sould like you have SQL Server experience and you expect Oracle (and/or Oracle tools) to work like SQL Server (and/or SQL Server tools).  Remember, SQL Server comes from a software tools company (Microsoft) so thay make good or user-friendly software and they also sell a database (SQL Server)  Oracle is primarliy a database company that also makes some software tools.  Oracle's tools are not as user-friendly as Microsoft's.  But remember, Microsoft only has to design tools for one O/S.  Oracle's tools are mainly O/S independent, so they can work on Windows, Linux, UNIX, etc.
0
 
LVL 17

Author Comment

by:MIKE
ID: 36560608
JacobFW:

Regarding : "...  I therefore prefer to change the setting to "Dual Session" (under "Oracle > Connection > Session Mode"), which gives me two database sessions  ..."

I can't locate these menu options.

Again, I'm using the free version of Oracle SQL Developer v3.0.04

My menu options across the top of my program are:
FILE, EDIT, VIEW, NAVIGATE, RUN, VERSIONING, TOOLS, HELP

Any idea where I'd be able to fine the menu that will allow me to change the option to allow multiple sessions...???
0
 
LVL 7

Expert Comment

by:Jacobfw
ID: 36560947
Sorry, I was refering to a much older version.  In version Oracle SQL Developer v3.0.04, you can create two connections to the same database and then execute queries under both at the same time. Two connections
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question