Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Run only 3 sqlplus session at a time
Top Forums UNIX for Advanced & Expert Users Run only 3 sqlplus session at a time Post 303010847 by ATWC on Monday 8th of January 2018 10:47:29 AM
Old 01-08-2018
Run only 3 sqlplus session at a time
Below code runs n number of session at a time when called. I want to restrict it to run only for 3 sqlplus at a time. Is there a way to do the same.
Code:
for name in `cat abc.txt`
do
(sqlplus -s  usert/password@host <<-EOF>> error.txt
			SET LINESIZE 1000
			select '$name', TO_CHAR(current_timestamp(0),'DD-Mon-YYYY HH24:MI:SS') as start_time from dual;
			EXEC proc('$name');
			select '$name' ,TO_CHAR(current_timestamp(0),'DD-Mon-YYYY HH24:MI:SS') as end_time from dual;
			EOF
 ) &
done
wait

run the below part only if all the loops in the for has completed!
echo "Complete"

 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

setting session time

Please lemme know how & where to set the session time for ftp connection in Wu-ftp . Regards Gambhi. (5 Replies)
Discussion started by: gambhi_s
5 Replies

2. UNIX for Dummies Questions & Answers

Session time out

Hi, We have a generic login id :- ship1 . There can be any number of sessions for this login ID. I'm working on a way to log off idle sessions ( not logins) . I searched the forum and found TMOUT. Is it at login level or session level ? ( looks like it is at login level) But I added it to... (2 Replies)
Discussion started by: newtoxinu
2 Replies

3. Shell Programming and Scripting

sqlplus session being able to see unix variables session within a script

Hi there. How do I make the DB connection see the parameter variables passed to the unix script ? The code snippet below isn't working properly. sqlplus << EOF user1@db1/pass1 BEGIN PACKAGE1.perform_updates($1,$2,$3); END; EOF Thanks in advance, Abrahao. (2 Replies)
Discussion started by: 435 Gavea
2 Replies

4. Shell Programming and Scripting

Is it possible..when ftp session disconnect and it can automatic run again?

Hi, Is is possible when ftp script disconnect by remote server and it can restart to tranfer (such as restart in 10 mins, etc)? Please help!!!! (1 Reply)
Discussion started by: happyv
1 Replies

5. UNIX for Dummies Questions & Answers

how to run who am i from remote session

I just moved from AIX 4 to AIX 5.3. the command `who am i` is essential to our logon scripts; but it does not work anymore, it says the process is not attached to a terminal. Is it possible to run this command remotely? It works for remote root sessions. If it is not is there another way to... (2 Replies)
Discussion started by: raidzero
2 Replies

6. UNIX for Advanced & Expert Users

Xserver connect and run CDE session from Windows PC

Hope someone can help. I have 5 Unix Tru64 ver 4.0/5.1B, boxes and I'm trying to connect and run CDE session from my PC. I have tried using Reflections, and Xming with no luck. Can someone tell me what exactly needs to be running on the Tru64 boxes in order for this to work. Along with what or how... (4 Replies)
Discussion started by: Troberts50
4 Replies

7. Shell Programming and Scripting

how to run a command as soon as user exits from session

I need to write a script, where I have to get names of files that are to be deleted from a user and have to delete those files when he exits session. How to set a particular command to be run as soon as user exits from a session? Can somebody help? I have to write a script on linux system.... (3 Replies)
Discussion started by: yashashri
3 Replies

8. Shell Programming and Scripting

How to run scripts within a telnet session?

I want to connect to a remote host using telnet there is no username/password verification just telnet remotehost then I need to input some commands for initialization and then I need to repeat the following commands: cmd argument argument is read from a local file, in this... (1 Reply)
Discussion started by: esolve
1 Replies

9. Shell Programming and Scripting

Need to track what Commands run in a login session

Hi I need to track what commands run in login session in solaris whether it is root or any normal users in bash shell. My actual requirement is that when a user (nomal/root) login into the system, whatever commands he run, it should log into file on specified path . I don't require command... (4 Replies)
Discussion started by: hb00
4 Replies

LEARN ABOUT REDHAT

ssl_session_get_time

SSL_SESSION_get_time(3) 					      OpenSSL						   SSL_SESSION_get_time(3)

NAME

       SSL_SESSION_get_time, SSL_SESSION_set_time, SSL_SESSION_get_timeout, SSL_SESSION_get_timeout - retrieve and manipulate session time and
       timeout settings

SYNOPSIS

	#include <openssl/ssl.h>

	long SSL_SESSION_get_time(SSL_SESSION *s);
	long SSL_SESSION_set_time(SSL_SESSION *s, long tm);
	long SSL_SESSION_get_timeout(SSL_SESSION *s);
	long SSL_SESSION_set_timeout(SSL_SESSION *s, long tm);

	long SSL_get_time(SSL_SESSION *s);
	long SSL_set_time(SSL_SESSION *s, long tm);
	long SSL_get_timeout(SSL_SESSION *s);
	long SSL_set_timeout(SSL_SESSION *s, long tm);

DESCRIPTION

       SSL_SESSION_get_time() returns the time at which the session s was established. The time is given in seconds since the Epoch and therefore
       compatible to the time delivered by the time() call.

       SSL_SESSION_set_time() replaces the creation time of the session s with the chosen value tm.

       SSL_SESSION_get_timeout() returns the timeout value set for session s in seconds.

       SSL_SESSION_set_timeout() sets the timeout value for session s in seconds to tm.

       The SSL_get_time(), SSL_set_time(), SSL_get_timeout(), and SSL_set_timeout() functions are synonyms for the SSL_SESSION_*() counterparts.

NOTES

       Sessions are expired by examining the creation time and the timeout value.  Both are set at creation time of the session to the actual time
       and the default timeout value at creation, respectively, as set by SSL_CTX_set_timeout(3).  Using these functions it is possible to extend
       or shorten the lifetime of the session.

RETURN VALUES

       SSL_SESSION_get_time() and SSL_SESSION_get_timeout() return the currently valid values.

       SSL_SESSION_set_time() and SSL_SESSION_set_timeout() return 1 on success.

       If any of the function is passed the NULL pointer for the session s, 0 is returned.

SEE ALSO

       ssl(3), SSL_CTX_set_timeout(3), SSL_get_default_timeout(3)

0.9.7a								    2001-08-17						   SSL_SESSION_get_time(3)
All times are GMT -4. The time now is 07:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy