FLUSH SEQUENCE CACHE

Purpose

This statement is used to clear the sequence cache.

Privilege requirements

To execute this statement, the current user must have the ALTER SYSTEM privilege. For more information about OceanBase Database privileges, see Privilege types in MySQL-compatible mode.

Syntax

ALTER SYSTEM FLUSH SEQUENCE CACHE
    SEQUENCE_NAME = sequence_name
    TENANT = 'tenant_name'
    DATABASES = 'database_name'
    [GLOBAL];

Parameters

Examples

• Clear the cache of the sequence named test_seq1 on the current node in the test database of the mysql001 tenant.

  obclient> ALTER SYSTEM FLUSH SEQUENCE CACHE
      SEQUENCE_NAME = test_seq1
      DATABASES = 'test'
      TENANT = 'mysql001';
  

• Clear the cache of the sequence named test_seq1 on all nodes in the test database of the mysql001 tenant.

  obclient> ALTER SYSTEM FLUSH SEQUENCE CACHE
      SEQUENCE_NAME = test_seq1
      DATABASES = 'test'
      TENANT = 'mysql001'
      GLOBAL;
  

References

• ALTER SYSTEM FLUSH SEQUENCE CACHE (MySQL-compatible mode)
• ALTER SYSTEM FLUSH SEQUENCE CACHE (Oracle-compatible mode)