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 the privileges of OceanBase Database, see Privilege types in MySQL 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 test_seq1 sequence 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 test_seq1 sequence 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 mode)
• ALTER SYSTEM FLUSH SEQUENCE CACHE (Oracle mode)