allow resource limits

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Static

Display level

Comprehensive

Required role

System Administrator

allow resource limits controls the use of resource limits. When the value is set to 1, the server allocates internal memory for time ranges, resource limits, and internal server alarms. The server also internally assigns applicable ranges and limits to user sessions. The output of showplan and statistics io displays the optimizer's cost estimate for a query. Set allow resource limits to 0 to disable resource limits.