Oracle stored procedure job running long time from DS
Posted: Fri Mar 12, 2010 1:20 pm
Hi
We have a job that calls the oracle stored procedure(using stored procedure stage), which is running long time from DS parallel job about 20 hours and we have ran the stored procedure from SQLPLUS, it ran about 2 to 3 hours and we also ran the SP from DataStage server using SQLPLUS, it completed with in 3 hour,
Did anybody came across this kind of problem running long time or can anybody has any ideas, please share.
We have a job that calls the oracle stored procedure(using stored procedure stage), which is running long time from DS parallel job about 20 hours and we have ran the stored procedure from SQLPLUS, it ran about 2 to 3 hours and we also ran the SP from DataStage server using SQLPLUS, it completed with in 3 hour,
Did anybody came across this kind of problem running long time or can anybody has any ideas, please share.