The solution: optimal job scheduling and database streamlining
The company enlisted Rego Consulting to assist with improving the performance of the business-critical system.
Rego conducted a series of analytics to understand usage levels and job processing times. This enabled it to identify the ideal time to run certain jobs in order to optimize data availability and performance.
Rego technicians also analyzed statistics, tables, and indexes for fragmentation, which had exceeded the recommended 30 percent threshold, so they recommended and ran a shrink operation on the tables to improve performance.
Rego also uncovered an undersized database cache and an excessive number of database sessions lasting several minutes and causing session blocking and high physical I/O. The issues were resolved by scheduling Oracle jobs to run at night, disabling the Oracle cron job, and rebuilding long-running SQL indexes.