Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Procedures in Parallel

Status
Not open for further replies.
asth01

asth01

Programmer
Joined
Jan 18, 2004
Messages
36
Location
US
Hi,

Is there a way to run multiple procedures from inside a main procedure so that these procedures run in parallel?

I mean can I tell Oracle to run 10 procedures in parallel?

Actually, I have a data loading requirement of loading 10 tables in parallel and I was thinking if I can write 10 procedures to load data and these procedures would run in parallel.

Thanks in advance.
 
Sort by date Sort by votes
Hi,
Try DBMS_JOB and schedule them.

Thanks,
DOUBLEH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question Question
Data encryption in Oracle 19c
Replies
0
Views
544
rk68
rk68
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
annie1975
  • Locked
  • Question Question
sql script in an cron job script failing
Replies
3
Views
671
carp
carp
Livia8
  • Locked
  • Question Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC
Replies
5
Views
802
Livia8
Livia8
Andrzejek
  • Locked
  • Question Question
Insert multiple records
Replies
9
Views
2K
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top