Home » SQL & PL/SQL » SQL & PL/SQL » Parallel execution of Queries in a Stored Procedure (Oracle 10g)
Parallel execution of Queries in a Stored Procedure [message #427212] Wed, 21 October 2009 09:51 Go to next message
varshasantosh2004
Messages: 7
Registered: October 2009
Junior Member
Hi,
I have a stored procedure where each query can be executed parallely.
Is there any way in oracle to run the queries parallel, something like multi-threading?

E.g.:
Procedure Pr {
insert into a1 select * from b1;
insert into a2 select * from b2;
insert into a3 select * from b3;
insert into a4 select * from b4;
}
Here all the above queries are toally independent and so can be run parallel. Is there any way I can run these parallely?

Thanks,
San
Re: Parallel execution of Queries in a Stored Procedure [message #427214 is a reply to message #427212] Wed, 21 October 2009 09:55 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This question has been asked many times, please search BEFORE posting.

Also, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
And always post your Oracle version with 4 decimals.

Regards
Michel


Regards
Michel
Previous Topic: Date format
Next Topic: Datawarehouse cleanup
Goto Forum:
  


Current Time: Fri Dec 09 02:09:07 CST 2016

Total time taken to generate the page: 0.06434 seconds