Run from waiting mode

Shell Programming and Scripting
1

I have no idea why this job has been put into waiting state by server. Can anyone help me to run this job from waiting state.

ps -elf | grep 'usr_script'
4 S usr_script    3929  3926  0  77   0 -  2976 wait   Oct21 ?        00:00:00 /bin/ksh /application_folder/script/report
0 S usr_script    3935  3929  0  76   0 -  9807 -      Oct21 ?        00:00:00 sqlplus -s
2

Are you sure it's not waiting for I/O ?

3

Yes it is not waiting for I/O. How do we know that particular process is running or in waiting mode?