Solved

Parallel updates

Posted on 2003-11-10
2
489 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now