Oracle process continue even after the jobs are stopped

vintipa · Post by **vintipa** » Wed Dec 10, 2008 7:23 am

hi friends,

Even after the jobs are stopped the query executed by the jobs
carry on and utilize CPU resources. Any option in Datastge to ensure all the processes end when jobs are stopped?

chulett · Post by **chulett** » Wed Dec 10, 2008 8:59 am

If by "stopped" you mean using the Stop button while the job is running, yes - that can happen. I only do that when the sql is actively delivering rows, if it is still "building the cursor" then you'll have issues, best to have a DBA kill the Oracle SID in that case.

Sathishkumarins · Post by **Sathishkumarins** » Thu Dec 11, 2008 12:58 am

If you are running a job with high volume of data and when you stop the job may be the oracle might try to commit those rows. So the query might still run. In that case you can't avoid that.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 2:36 am

... short of killing the Oracle session.

chulett · Post by **chulett** » Thu Dec 11, 2008 7:54 am

Yup. While Oracle may not notice you stopping the job, DataStage will notice you killing the Oracle session.