Definition of a resource limits group

A resource limits group is a set of resource limits that are implemented collectively, for each user that is assigned to the group, according to a specified schedule. You can create as many resource limits groups as you want, with each group having a different set of resource limits implemented according to different schedules.

There are many permutations available to you for setting up resource limits groups. The most common ways to set up resource limits groups and control resource usage are by:
  • data source
  • user
  • day of the week
  • time of day
For example, a resource limits group can contain one set of limits that is in effect weekdays between 8 AM and 6 PM and another that is in effect on weekends and off-hours. In addition, each resource limits group can have different users assigned allowing them to perform only certain functions on specific database data sources or when running specific queries.