Home » RDBMS Server » Performance Tuning » Running queries parallely
Running queries parallely [message #274834] Wed, 17 October 2007 06:36 Go to next message
vkrmhj
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.

Report message to a moderator

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: 68664
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).

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 25 02:09:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.