|
Checks the amount of temporary file space used by a connection and fails the request if the amount of space requested is greater than the connection's allowable quota.
On, Off
On
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | Yes, with SET ANY SYSTEM OPTION | No | No |
| Allowed to set temporarily? | Yes, with SET ANY SYSTEM OPTION | No | No |
When temp_space_limit_check is set to On (the default), if a connection requests more than its quota of temporary file space, then the request fails and the error SQLSTATE_TEMP_SPACE_LIMIT is returned. When this option is set to Off, the database server does not check the amount of temporary file space used by a connection. If a connection requests more than its quota of temporary space when this option is set to Off, a fatal error can occur.
The temporary file space quota for a connection is the minimum of the following two thresholds:
the maximum amount of temporary file space permitted for each connection as specified by the setting of the max_temp_space option
the maximum potential size of the temporary file divided by the number of connections
This threshold is used only if the temporary file has grown to 80% or more of its maximum size, which is determined by the amount of free space remaining on the device as reported by the operating system. When a connection requests more temporary file space than the quota allows, that connection's current request fails with SQLSTATE '54W05' (SQLSTATE_TEMP_SPACE_LIMIT).
You can specify a hard limit on the amount of temporary file space used by a connection with the max_temp_space option.