Enable Resource Limits

Use the allow resource limits configuration parameter to enable resource limits.

A value of 1 enables resource limits; a value of 0 disables them. allow resource limits is static, so you must restart the server to reset the changes.

allow resource limits signals the server to allocate internal memory for time ranges, resource limits, and internal server alarms. It also internally assigns applicable ranges and limits to login sessions.

Setting allow resource limits to 1 also changes the output of showplan and statistics i/o: