DATABASE MANAGER

摘要

An apparatus stores a schedule indicating when a job is scheduled to execute. The apparatus receives a request to execute a first job and determines from the schedule that a second job is scheduled to execute during the execution of the first job. The apparatus estimates a first amount of memory to be consumed by the first job and a second amount of memory to be consumed by the second job, and determines whether a sum of the first amount and the second amount exceeds an amount of free memory. The apparatus determines a table that the first job accesses, and determines whether the table is accessed by the second job. The apparatus communicates a message indicating a period of time to wait before executing the first job if the sum exceeds the amount of free memory or if the table is accessed during by the second job.

主权项

1. An apparatus comprising:
a memory operable to store a schedule indicating, for each job of a plurality of jobs, a time when the job is scheduled to execute against a database; and a processor communicatively coupled to the memory and operable to:
receive a request to execute a first job against the database;determine, based on the schedule, that a second job of the plurality of jobs is scheduled to execute during the execution of the first job;estimate a first amount of memory to be consumed by executing the first job and a second amount of memory to be consumed by executing the second job;determine whether a sum of the first amount and the second amount exceeds an amount of free memory;determine a table of the database that the first job accesses during execution;determine whether the table is accessed during execution of the second job;communicate a message indicating a period of time to wait before executing the first job if the sum of the first amount and the second amount exceeds the amount of free memory or if the table is accessed during execution of the second job.