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 !!!