Home » SQL & PL/SQL » SQL & PL/SQL » Parallel execution of Procedure.
Parallel execution of Procedure. [message #401313] Mon, 04 May 2009 01:01 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member


How to perform parallel execution of various Procedures??


regards,
Nataraj
Re: Parallel execution of Procedure. [message #401314 is a reply to message #401313] Mon, 04 May 2009 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on your needs, many ways, and also question already posted, please search.

Regards
Michel
Re: Parallel execution of Procedure. [message #401317 is a reply to message #401314] Mon, 04 May 2009 01:13 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Thanks,

but "parallel execution" key word returns no results in my search .
pls helpp me by giving some reference.

regards,
Nataraj


[Updated on: Mon, 04 May 2009 01:15]

Report message to a moderator

Re: Parallel execution of Procedure. [message #401321 is a reply to message #401317] Mon, 04 May 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems that "Search" feature is currently broken.
So I can't more search than you.

But as I said "it depends on your needd", so explain them in details.

Regards
Michel


Re: Parallel execution of Procedure. [message #401329 is a reply to message #401321] Mon, 04 May 2009 02:01 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

In a package I have 14 procedures as below.
13 driving procedures and one common procedure.

All the 13 driving procedures will call the only common procedure for the calculations and storing data in the report tables.

I want to parallelise the calls for all the 13 procedures.

1. Is this possible?

2. Can one common procedure serve all of those?

regards,
Nataraj.
Re: Parallel execution of Procedure. [message #401337 is a reply to message #401329] Mon, 04 May 2009 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Yes, for instance use dbms_job
2. Yes

Regards
Michel
Re: Parallel execution of Procedure. [message #401348 is a reply to message #401337] Mon, 04 May 2009 03:07 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Thanks, Miche.
Can you pls share me some of the good reference for dbms_job, if any?

common procedure is used to perform the calculations and inserting the calculated data in the report tables.

while executing the procedures parallelly, do the report table encounters the table lock issues.

regards,
Nataraj.

[Updated on: Mon, 04 May 2009 03:11]

Report message to a moderator

Re: Parallel execution of Procedure. [message #401351 is a reply to message #401348] Mon, 04 May 2009 03:20 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Oracle documentation is quite generous with information concerning dbms_job Smile
Re: Parallel execution of Procedure. [message #401352 is a reply to message #401348] Mon, 04 May 2009 03:20 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AskTom, Execute procedures concurently in a procedure

Regards
Michel
Previous Topic: SQL Expression
Next Topic: How to show all the data in a one row
Goto Forum:
  


Current Time: Mon Dec 05 07:11:23 CST 2016

Total time taken to generate the page: 0.09653 seconds