Hi,
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
(SELECT ssdd.*
FROM pdb_extract.staging_smb_dhs_data ssdd
WHERE NOT EXISTS
(SELECT party_id
FROM pdb_extract.staging_dhs_excluded_subjectid sdes
WHERE
ssdd.party_id_person= sdes.party_id));
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 !!!
Regards
Jaideep