Note
- The
SQL_AUDITsystem table has been split by tenant since OceanBase Database V2.x, which means that the memory available for SQL audit data must be limited at the tenant level and the server-level memory limit specified by this parameter is no longer applicable. This parameter has been deprecated since OceanBase Database V4.0.0. - In OceanBase Database 2.x and later, you can use the
ob_sql_audit_percentagesystem variable to specify the maximum percentage of the SQL audit memory to the total memory of the current tenant. For more information about theob_sql_audit_percentagesystem variable, see ob_sql_audit_percentage.
sql_audit_memory_limit specifies the maximum memory available for SQL audit data.
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 3G |
| Value range | [64M, +∞) |
| Effective upon OBServer node restart | No |