ob_log_level

Description

ob_log_level specifies the log level of the current session. If you do not specify the log level, the system log level is used.

Privilege requirements

• Query variables

  • Global level

    You can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to view the value of a global system variable in the sys tenant and all user tenants.

  • Session level

    You can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to view the value of a session system variable in the sys tenant and all user tenants.

• Modify variables

  • Global level

    • In the sys tenant, you can directly modify the value of a global system variable.

    • In a MySQL user tenant, you must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.

    • In an Oracle user tenant, you must have the ALTER SYSTEM privilege to modify the value of a global system variable.

  • Session level

    You can directly modify the value of a session system variable in the sys tenant and all user tenants.

Attributes

Usage notes

If ob_log_level is set to disabled, the system global log level is used, which is specified by the syslog_level parameter.

Examples

Set the log level of the current session to INFO.

• Session level

  obclient> SET ob_log_level ='INFO';
  

• Global level

  obclient> SET GLOBAL ob_log_level ='INFO';
  

References

For more information about system logs, see Overview of logs.