ob_query_timeout

Description

ob_query_timeout specifies the maximum execution time of an SQL statement.

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants 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.

  • Session level

    sys tenant and all user tenants 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.

• Modify variables

  • Global level

    • The sys tenant can directly modify the value of a global system variable.

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

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

  • Session level

    Both the sys tenant and all user tenants can directly modify the value of session system variables for their own tenant.

Attributes

Examples

Set the maximum execution time of an SQL statement to 10000000 microseconds.

• Session level

  obclient> SET ob_query_timeout =10000000;
  

• Global level

  obclient> SET GLOBAL ob_query_timeout=10000000;