Note
- Starting from OceanBase Database V2.x, the SQL Audit system tables are split by tenant. Therefore, the memory occupied by SQL Audit is at the tenant level. The server-level memory eviction threshold defined by this parameter is no longer applicable and was removed starting from OceanBase Database V4.0.0.
- Starting from OceanBase Database V2.x, you can use the system variable
ob_sql_audit_percentageto specify the percentage of memory occupied by SQL Audit in the current tenant. For more information about the system variableob_sql_audit_percentage, see ob_sql_audit_percentage.
Description
sql_audit_memory_limit specifies the maximum memory that can be occupied by SQL audit data.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Capacity |
| Default value | 3G |
| Value range | [64M, +∞) |
| Effective upon OBServer node restart | No |