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?
Oracle process continue even after the jobs are stopped
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: