Note
ob_sql_audit_percentage is available starting with V1.4.
Description
The ob_sql_audit_percentage variable specifies the maximum percentage of memory for SQL Audit in the current tenant.
Privilege requirements
Query variables
Users in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or view theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) to query the value of a global system variable.Modify variables
Users in the
systenant can directly modify the value of a global system variable.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 3 |
| Value range | [0, 80] |
| Scope | Global |
| Modifiable | Yes. You can modify the value by using the SET statement. |
Examples
Set the maximum percentage of memory allocated to SQL audit for the current user tenant to 3.
obclient> SET GLOBAL ob_sql_audit_percentage =3;