Problem with Job Scheduling
I am a new member in the group and I am facing very strange problem. I have created one package which has 9 procs and in one of the proc there is a query like this.
INSERT /* +apppend */ INTO pdb_extract.staging_smb_data
FROM pdb_extract.staging_smb_dhs_data ssdd
WHERE NOT EXISTS
FROM pdb_extract.staging_dhs_excluded_subjectid sdes
When I run this query directly on sql prompt it is executed with in 4 min.
But when we schedule this job , the process is stopped at this query and when I try to see the long operations it shows it will take more than 2000 hours to complete. I am also attaching the execution plan of the query when it is taking 2000 hours.
Please help me out !!!
Can you post the init.ora parameter job_queue_processes and also the code that is used to run the dbms_job..
Did you include a commit after running the dbms_job ?
you are scheduling through dbms_job?
exec dbms_job.run() ?
I'm stmontgo and I approve of this message
Click Here to Expand Forum to Full Width