I have an ETL process which runs more than 2 hrs 20 min if executed between 5 am and 7 am.
But what we find surprisingly the same ETL batch process executes in 1 hr. 30 min on a different time other than 5 am to 7 am.
DBA team and Linux team confirmed that there are no other jobs running between 5 am and 7 am.
When I take a specific job to analyze what is going on, which was running fine on the odd timing it took 320 seconds where on regular it took 844 seconds...following is what I got from ASH.
Can someone please guide me what should I look into further...