Home » SQL & PL/SQL » SQL & PL/SQL » How to Call Multiple Session through Shell scripting (oracle 9i)
How to Call Multiple Session through Shell scripting [message #336489] Sun, 27 July 2008 19:55 Go to next message
victory_nag
Messages: 36
Registered: June 2008
Location: CA
Member
I have a scenario where I call multiple inserts on a single table.
There are 3 packages where in each package a Bulk Insert is written on the same table. All these packages have to be called simultaneously.
For this I have to create a shell script which call multiple sessions to execute these packages at once.
Suppose the packages be PkgA, PkgB , PkgC.
All these packages have to be called at once using Shell script.
Can you help me how to call multiple sessions using shell script.

Thanks.
Re: How to Call Multiple Session through Shell scripting [message #336490 is a reply to message #336489] Sun, 27 July 2008 20:27 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

Since you refuse to follow Posting Guidelines, You're On Your Own (YOYO)!

[Updated on: Sun, 27 July 2008 20:30] by Moderator

Report message to a moderator

Re: How to Call Multiple Session through Shell scripting [message #336493 is a reply to message #336490] Sun, 27 July 2008 20:51 Go to previous messageGo to next message
victory_nag
Messages: 36
Registered: June 2008
Location: CA
Member
Dear member can you help me where I went wrong in posting this topic so that it will greatly help me in my future posts. I read through the Posting guidelines but could not understand where I went wrong.
Thanks.
Re: How to Call Multiple Session through Shell scripting [message #336494 is a reply to message #336489] Sun, 27 July 2008 20:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Which part of the following do you NOT understand?

Some of the most important instructions are:

Quote:

Provide all relevant information about your problem, including Oracle software version (4 decimal places) and operating system version.

Format your code and make sure that lines do not exceed 80 characters. Use the "Preview Message" button to check it.



You request assistance for a "script" which is Operating System dependent & yet you withhold the requested & direct information!


Re: How to Call Multiple Session through Shell scripting [message #336495 is a reply to message #336494] Sun, 27 July 2008 21:07 Go to previous messageGo to next message
victory_nag
Messages: 36
Registered: June 2008
Location: CA
Member
I am sorry.
Oracle 10G and K-shell script.
Right now I did not start my coding process.
I am right now collecting valuable inputs from senior members like you. If you can give me a sample script that would be a great start for me.
Re: How to Call Multiple Session through Shell scripting [message #336496 is a reply to message #336489] Sun, 27 July 2008 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
echo "Direction are - including Oracle software version (4 decimal places)"
echo "my answer is - Oracle 10G"
echo " I can not count to 4!"
echo "Since where is K-shell an Operating System?"


You're On Your Own (YOYO)!
Re: How to Call Multiple Session through Shell scripting [message #336541 is a reply to message #336496] Mon, 28 July 2008 01:45 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
I don't know about linux or unix but
In windows make three copies of your script for PkgA,PkgB and PkgC.Schedule these script to run at same time.

But my questions are:-

What if the packages not run simultaneously??
What will happen if executed one after the another??

Regards,
Rajat Ratewal



Re: How to Call Multiple Session through Shell scripting [message #336556 is a reply to message #336541] Mon, 28 July 2008 02:29 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You could execute them all with DBMS_SCHEDULER.

Ross Leishman
Previous Topic: Returns character data from numeric data
Next Topic: which is better Bulk Insert/Update or Merge Command
Goto Forum:
  


Current Time: Thu Dec 08 08:24:38 CST 2016

Total time taken to generate the page: 0.12604 seconds