Patent ID: 7093250

Claim:
A method for scheduling access to processor resources of a database, the method comprising the steps of: initiating one or more database sessions each in response to one or more user logons to the database; initiating a plurality of tasks in response to commands received from the one or more database sessions; classifying each of the plurality of tasks into one of a first set of groups based at least in part on one or more logon account attributes associated with the one of the one or more database sessions that initiated that task; assigning a weight to each group of the first set of groups; classifying each of the plurality of tasks into one of a second set of groups; assigning a weight to each group of the second set of groups; selecting a first task from the plurality of tasks; and limiting the first task's access to processor resources of the database based at least in part on the weight of a group from the first set of groups in which the first task is classified and also based at least in part on the weight of a group from the second set of groups in which the first task is classified.