load_data_diagnosis_log_compression

Description

load_data_diagnosis_log_compression specifies the compression algorithm used for diagnostic logs.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  The sys tenant and user tenants can modify this parameter.

Attributes

Considerations

This parameter specifies whether to compress diagnostic log files and the compression algorithm to use.

Examples

Set the compression algorithm for diagnostic logs to ZSTD.

obclient> ALTER SYSTEM SET load_data_diagnosis_log_compression = 'ZSTD';

References

• For information about how to set the maximum size of a single diagnostic log file, see load_data_diagnosis_log_max_size.
• For information about how to enable error diagnostics during the import of an external table from a URL, see LOAD DATA (MySQL-compatible mode) and LOAD DATA (Oracle-compatible mode).