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.
Dig deeper on Oracle database performance problems and tuning
I have a table with 1.5 million records that needs to have a column updated based on a correlated subselect. This update is currently sitting at four...continue reading
A user complains that every time he tries to access a table (select only), it takes more than two hours to get
the results. There are no DML ...continue reading
I have always used TKPROF to do SQL tuning in previous versions of
Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2?continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.