Oracle 5.0, Reference Manual

Page: 510 / 3232

Server System Variables
490
Disables or enables automatic purging of relay log files as soon as they are not needed any more.
The default value is 1 (
ON
).
•
relay_log_space_limit
[490]
Command-Line Format
--relay_log_space_limit=#
Option-File Format
relay_log_space_limit
Option Sets Variable Yes,
relay_log_space_limit
[490]
Variable Name
relay_log_space_limit
Variable Scope Global
Dynamic Variable No
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
0
Range
0 .. 4294967295
Permitted Values
Platform
Bit Size
64
Type
numeric
Default
0
Range
0 .. 18446744073709547520
The maximum amount of space to use for all relay logs.
•
secure_auth
[490]
Command-Line Format
--secure-auth
Option-File Format
secure-auth
Option Sets Variable Yes,
secure_auth
[490]
Variable Name
secure_auth
Variable Scope Global
Dynamic Variable Yes
If this variable is enabled, the server blocks connections by clients that attempt to use accounts that
have passwords stored in the old (pre-4.1) format.
Enable this variable to prevent all use of passwords employing the old format (and hence insecure
communication over the network).
Server startup fails with an error if this variable is enabled and the privilege tables are in pre-4.1
format. See
Section C.5.2.4, “
Client does not support authentication protocol
” .
•
secure_file_priv
[490]
Version Introduced 5.0.38
Command-Line Format
--secure-file-priv=path
Option-File Format
secure-file-priv=path