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.
Can be set for the PUBLIC group only. DBA authority required.
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 fail with SQLSTATE 54W05 (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.