ECHO PID 2

[TC2000]

I try to setup a script which will include over 10 sql command.
For each sql command, it will run in the backend.
e.g. nohup sqlplus uid/pid @fdfdfdfdf &
I will like to echo the Process ID.
Can anyone tell me how???

 

[grega]

Not entirely sure what you mean ... you can get the PID of the current shell using $$.

Greg.

 

[quirkasaurus]

In ksh and sh, the last process id put into background is stored in the environmental variable: $!

In csh, I don't believe that's available except through
some heroic grepping of the ps command.

ps -deaf | fgrep $$ | etc....

 

[kerambit275]

If you just want the the PID's of the sqlplus processes, you could do something like this:

ps -ef | grep sqlplus | grep -v grep | awk '{print $2}'

This will just display the PID's of the sqlplus processes.

 

[CaKiwi]

Or

 ps -ef | grep [s]qlplus | awk '{print $2}'

for reasons explained nicely in thread822-306375 CaKiwi