Overview
The audit_log_strategy parameter specifies the strategy for writing audit records to files.
Privilege requirements
Query parameters
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify parameters
Both the
systenant and user tenants can use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | ASYNCHRONOUS |
| Value range |
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
You can set multiple write log strategies using audit_log_strategy to balance performance and log integrity. When using asynchronous writes, you can control the buffer size using audit_log_buffer_size.
Configuration example
Set the audit record file writing strategy to asynchronous log writing. When the buffer is full, it will wait synchronously.
obclient> ALTER SYSTEM SET audit_log_strategy='ASYNCHRONOUS';