Sponsored Content
Top Forums Shell Programming and Scripting Multiple SQLPLUS background processes not working properly Post 302251780 by rawat_me01 on Tuesday 28th of October 2008 03:09:29 AM
Old 10-28-2008
Multiple SQLPLUS background processes not working properly

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
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Background processes

How do you capture the return code from a background process? I am dumping data to a fifo and then processing it in a c program. I need to know that the sql finished successfully to ensure no missing data. Thanks. ex. sqlplus user/password < get_data.sql > data_fifo.txt & bin/process_data... (2 Replies)
Discussion started by: korndog
2 Replies

2. Shell Programming and Scripting

Running two processes in background

hi there, here's what i need in my korn-shell: ... begin korn-shell script ... nohup process_A.ksh ; nohup process_B.ksh & ... "other stuff" ... end lorn-shell script in plain english i want process A and process B to run in the background so that the script can continue doing... (6 Replies)
Discussion started by: jacob_gs
6 Replies

3. Linux

Question about background processes

Hi! First of all, let me warn you I'm quite new to the world of LINUX and Operating Systems understanding, so that's why I pose these newbie and stupid qustions... Anyway, I'm trying to build my own simple shell in C and I'm getting some problems in implementing the background process ('&')... (10 Replies)
Discussion started by: neimaD
10 Replies

4. UNIX for Dummies Questions & Answers

Disadvantage of background processes

Hi, Inorder to improve the performance, I am trying to execute my command as a background process.. For eg: To zip large numbers of files present in a directory instead of using a single process, i do follow the below method: gunzip -c > / &... (3 Replies)
Discussion started by: unni.raj
3 Replies

5. Shell Programming and Scripting

Background Processes

Ok guys so I have my first dummy shell almost done except for one tiny part: I do not know how to run a process in the background, from the code! I already know how to do that in a normal shell: $ program & However, no clue when it comes to how to program that thing. :eek: A very... (2 Replies)
Discussion started by: Across
2 Replies

6. UNIX for Dummies Questions & Answers

Query on Running Multiple processes in background

HI All , Pardon me for asking some very basic questions, I would be grateful if someone can help. I am trying to execute a shell script which runs multiple processes in background. It includes various operations like copying , DB operations etc etc. Now problem is that the complete script... (6 Replies)
Discussion started by: gpta_varun
6 Replies

7. Shell Programming and Scripting

Can't get shell parameters to pass properly to sqlplus

Gurus, The issue I'm having is that my Shell won't accept SQL parameters properly...... Here's they way I'm running it.... applmgr@ga006hds => sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR' The process just hangs not submitting the SQL job... ... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies

8. Shell Programming and Scripting

Need help on background processes

Hi, I have a schell script parent.ksh from which I am calling three background processes a.ksh,b.ksh and c.ksh. Once these three processes completes the next step in parent.ksh should execute. How to achieve this? Please help me.... Thanks... (1 Reply)
Discussion started by: ravinunna
1 Replies

9. Programming

How to properly connect these three processes using pipes?

I'm trying to properly connect three processes in order to allow inter-process communication between them. I have one process, scanner, which takes the parent's STDIN and then processes the words within the stream. If a word length is odd, it sends it to one process, if it is even, it sends it... (7 Replies)
Discussion started by: thomascirca
7 Replies

10. UNIX for Dummies Questions & Answers

Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .

I installed Oracle sqlplus on My Ubuntu 14.04 64bit version as per the instructions on: help.ubuntu page (Unable to post the URL as i'm new user here). I'm totally new to SQL and now i'm learning queries in my college. I installed 64bit version of sqplus and run it executing the command:... (14 Replies)
Discussion started by: arjunmayilvagan
14 Replies
nice(1) 						      General Commands Manual							   nice(1)

NAME
nice - run a command at nondefault priority SYNOPSIS
command [command_args] command [command_args] DESCRIPTION
The command executes command at a nondefault CPU scheduling priority. (The name is derived from being "nice" to other system users by run- ning large programs at lower priority.) Arguments The command-line arguments are as follows: priority_change The difference between the system nice value (relative priority) of the current (or parent) process and the actual system nice value at which command is to run. An unsigned value increases the system nice value for command, causing it to run at lower priority. A negative value requires superuser privileges, and assigns a lower system nice value (higher priority) to command. If the current process is not privileged, the value is silently treated as if it were 0. If the value of priority_change would result in a system nice value outside the range 0 through 39, the correspond- ing limit value of 0 or 39 is used instead. Note that a positive priority_change (lower priority) has a single option character before the numeric value; a neg- ative (higher priority) priority_change has two: the option character followed by the minus sign If is not speci- fied, it defaults to command A program, HP-UX command, user shell script, etc. to be executed at the nondefault priority. command can be run as a foreground or background process. If command is run as a background process, any nice priority_change made by the shell executes all background pro- cesses via is in addition to that specified in the command line. command_args Any arguments recognized by command. Process Priorities All processes have an associated system nice value which is used to compute the instantaneous-priority of the process when it is scheduled to run. Normally, all processes inherit the system nice value of their parent process when they are spawned. The shell etc.) can create a child process with a different priority from the current shell process by spawning the child process via the command. If the prior- ity_change value is unsigned (positive), the child process is nicer (lower in priority) relative to the parent. If the priority_change value is negative, the child process runs at a higher priority with a greater share of available system resources. To spawn a higher pri- ority child process, the parent process must be owned by a user who has the appropriate privileges. At boot-up, the system starts the process at a system nice value of 20 (system default). On most systems, all processes (down to the login shells) inherit this priority. Starting from their individual login shell processes, users can alter the system nice value of descendent processes to as much as 39, or, with appropriate privileges, as little as 0. A system nice value of 0 establishes an extremely high prior- ity, whereas a value of 39 indicates a very low priority. Ordinary users can only increase the system nice value of any child process relative to the current process; i.e., priority_change must be a positive (unsigned) value, resulting in a lower priority. To start a child process at a lower system nice value (higher priority) than the current process, the user must have the appropriate privileges, regardless of the relative nice-priority value desired. For example, using the command from a login shell whose current nice value is 20 spawns a subshell with a system nice value of 30. Attempting to use from the new shell to spawn another subshell whose system nice value would be 28, is rejected (unless the user has appropriate privileges), even though the resulting system nice value would be less than the priority of the original login shell process. The system nice value for current processes is listed under the column produced by the command (see ps(1)). Background Processes Foreground processes are run at same system nice value as the parent shell. Background processes spawned by run at the equivalent of a by default. If a background process is started via from any priority_change specified in the command is added to default Thus the command runs at a system nice value of 36 if executed from EXTERNAL INFLUENCES
Environment Variables determines the language in which messages are displayed. If is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty vari- able. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See environ(5). International Code Set Support Single- and multi-byte character code sets are supported. RETURN VALUE
returns the value returned by command. EXAMPLES
The following examples assume the current process is running with a system nice value of 20 and is executed from the Korn shell (see ksh(1)). Run a program named in the current directory at the default priority_change of 10 (system nice value of 30): Run the same program in the background using a system nice value of 36 (priority_change=12 plus 4 for the Korn shell): As a user with appropriate privileges, run as a foreground process with a system nice value of 6: WARNINGS
The C shell, has a built-in command with different syntax. See csh(1) for details. SEE ALSO
csh(1), ksh(1), nohup(1), sh-posix(1), sh(1), renice(1M), nice(2). STANDARDS CONFORMANCE
nice(1)
All times are GMT -4. The time now is 03:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy