Alphabetical list of options
198
"Temporary tables used in query processing" on page 824 of the book ASA
User’s Guide.
In general, you should not need to use this option, as the query optimizer
allocates hash sizes for the internal temporary tables based on the data
distribution within the table. The option allows you to override the optimizer
behavior to either increase the maximum hash size it can use beyond 20, or
to restrict it further.
MAX_STATEMENT_COUNT option
A resource governor to limit the maximum number of prepared statements
that a connection can use at once.
Integer
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately. DBA permissions are required to set this option for any
connection.
50
This resource governor allows a DBA to limit the number of prepared
statements per connection a user can use. If an operation would exceed the
limit for a connection, an error is generated, indicating that the governor for
the resource has been exceeded.
If a connection executes a stored procedure, that procedure is executed under
the permissions of the procedure owner. However, the resources used by the
procedure are assigned to the current connection.
You can remove resource limits by setting the option to 0 (zero).
MIN_PASSWORD_LENGTH option
Sets the minimum length for new passwords in the database.
Integer, greater than or equal to zero.
The value is in bytes. For single-byte character sets, this is the same as the
number of characters.
Can be set for the PUBLIC group. Takes effect immediately. DBA
permissions are required to set this option.
0 characters
See also
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
To Next Page
Loading...