Resource Limits

A resource limit is a set of parameters specified by a system administrator, that prevents queries and transactions from individual logins or applications from monopolizing server resources.

Resource limits are bound to time ranges, which allows the system administrator to define the times during which limits are enforced. When the system administrator modifies a resource limit, all users logged in see the change, including the system administrator

The set of parameters for a resource limit includes the time of day to enforce the limit and the type of action to take. For example, you can prevent huge reports from running during critical times of the day, or kill a session in which a query produces unwanted Cartesian products.