Solved

Parallel updates

Posted on 2003-11-10
2
504 Views
Last Modified: 2012-08-14
How do U invoke calls to stored procedures from unix shell scripts parallely?

ie. executing many stored procedures to query many tables paralelly?

Thanks
0
Comment
Question by:garimellan
2 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 9713296
You may have to run multiple script simultaneously...

each script doing a job !!!
0
 
LVL 6

Accepted Solution

by:
morphman earned 35 total points
ID: 9717314
use dbms_job package to submit multiple jobs from within a single session.

You may need to dynamically set init.ora parameters

JOB_QUEUE_PROCESSES

and

JOB_QUEUE_INTERVAL

But you can do this via an

alter system set job_queue_processes = 10;

command.

Look up the dbms_job in the oracle index for syntax on submitting jobs.

JOB_QUEUE_INTERVAL is measured in seconds.
JOB_QUEUE_PROCESSES - how many  background servers will execute jobs in the job_queue.

You can see submitted jobs from user_jobs view.

You will need to use DBMS_JOB.SUBMIT(parameters) to submit the job.

Good luck.

Also, you can use /*+ append_parallel(table_alias,number_of_parallel_processes) */ oracle hint in sql queries to run inserts in parallel.

selects will run in parallel with the /*+ parallel(table_alias,number_or_processes) */ hint on the select statement.

For inserts you will need to run a
alter session enable parallel dml;

command.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question