Tag Archives: Oracle nested loop vs hash join

Why would SAP job runtime suddenly jump well above normal range?

Business was complaining that runtime of a periodic SAP background job was suddenly jumped in production environment. There is no code change and no volume change and other jobs and transactions are running well. They were asking why this happened. I was consulted and looked into the situation. Finding the issue was related to Oracle…

This content is for 1 day, 1 Month, 365 days, and Life-time members only.
Log In Register