cursor_sharing

Description

cursor_sharing specifies whether to parameterize SQL statements.

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

Examples

Parameterize SQL statements.

• Global level

  obclient> SET GLOBAL cursor_sharing ='FORCE';
  

• Session level

  obclient> SET cursor_sharing ='FORCE';