Parallel execution for spooling file in shell script

[Kishore Nandagopal]

Dear Team,

I have shell script in that i have invoking sqlplus for spooling sql queries will be place..if i execute the shell script , the spooling file will be generated one by one. which means test1,test2,test3... . if test1 completed then only test2 starts spooling..it takes more time to consume for execution. i just need paralle execution for spooling file. if you know kindly respond ASAP.

thanks in advance.

Generate_Report ()
{

sqlplus -s <<-EOF
${PBDW_USERID}/${PBDW_PWD}@${PBDW_SID}

@T_test1.sql ${START_DATE} ${END_DATE};
@T_test2.sql ${START_DATE} ${END_DATE};
@T_test3.sql ${START_DATE} ${END_DATE};
@T_test4.sql ${START_DATE} ${END_DATE};
@T_test5.sql ${START_DATE} ${END_DATE};
@T_test6.sql ${START_DATE} ${END_DATE};


EOF

}

 

[johnherman]

You will need to generate separate instances of SQL Plus. Six in your example.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity