Multiple SQLPLUS background processes not working properly

rawat_me01 · #1 (**permalink**) 10-28-2008

Hi All,
I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time.
These 25 process creates 25 different files.
When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25 processes one-by-one then all 25 files are created properly with data.

My Doubt is :
1) Is there any restriction on number of SQLPLUS Background processes to run from script?
2) Are they affected by file size as size of files is in around 45K Bytes?

For info i am not using any Global temporary table for creating files.

Thanks

jim mcnamara · #2 (**permalink**) 10-28-2008

Do you make each call with a

Code:

nohup command & 
..............
..............
wait

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
\n not working properly	Jive Spector	Shell Programming and Scripting	1	10-21-2008 07:04 PM
FC card not working properly	Mike1234	HP-UX	4	07-16-2008 12:42 AM
Cron - Not working properly	risshanth	HP-UX	23	10-31-2007 06:34 AM
y is this not working properly?	C\|[anti-trust]	High Level Programming	3	05-18-2005 01:55 PM
Keyboard not working properly...	timresh	UNIX for Dummies Questions & Answers	2	02-25-2005 07:28 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by