Q

Overlap of jobs on server

I created a list of start and stop times using it to reorganize the job schedule and minimize overlaps. I'd hoped for some mild performance increase but was surprised to see 30-35% improvement. Why was this so dramatic?

Welcome, Phillip. I noticed a curious thing the other day. One of my servers, which is crowded with jobs, was running slower than usual. I took a pen and paper and created a list of start and stop times using it to reorganize the schedule and minimize overlaps. I'd hoped for some mild performance increase but was surprised to see 30-35% improvement. Why was this so dramatic? What can I do to eliminate the manual effort of tracking the job schedule on paper?
This is hard to really say for sure without seeing the top wait events during the timeframe in question. However, this was probably due to resource contention especially if any of these jobs update any data. If process 1 has a resource locked that process 2 needs, then process 2 has to wait on process 1 to finish and free the lock. The more processes updating the same table, the more likely this will occur.
This was first published in May 2007

Dig deeper on Oracle database performance problems and tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close