Home » RDBMS Server » Performance Tuning » Running queries parallely
Running queries parallely [message #274834] Wed, 17 October 2007 06:36 Go to next message
Messages: 9
Registered: May 2007
Junior Member
Hi All,
I want to run some queries parallely and then make a union.i am using
dbms_job.submit(job 'procedure1;') for that.Can i not use the sql statement for example dbms_job.submit(job 'sql1;')
in place of procedure1.This makes my job easy. Pls help.
Re: Running queries parallely [message #274847 is a reply to message #274834] Wed, 17 October 2007 07:04 Go to previous message
Michel Cadot
Messages: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can... but of course your SQL can't return any value (as well as your procedure).

Previous Topic: autotrace
Next Topic: Stats Gathering on Whole Schema
Goto Forum:

Current Time: Tue Oct 25 09:23:37 CDT 2016

Total time taken to generate the page: 0.20442 seconds