Note
- For OceanBase Database V4.3.x, this parameter was introduced in OceanBase Database V4.3.2.
- For OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.3.
Description
alert_log_level specifies the level of alert logs.
Privilege requirements
Query the parameter
The the
systenant and all user tenants can query this parameter by executing theSHOW PARAMETERSstatement or using theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | INFO |
| Value range | INFO, WARN, and ERROR
NoteThe priority of the log levels is as follows: ERROR > WARN > INFO. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
Alert logs are stored in the alert.log file under the log/alert directory. Alert logs include key INFO, WARN, and ERROR logs generated during system running. For more information, see Alert logs.
Examples
Set the level of alert logs to INFO.
obclient> ALTER SYSTEM SET alert_log_level='INFO';