ALTER SYSTEM 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 classification in Oracle-compatible mode.

Syntax

ALTER SYSTEM FLUSH SEQUENCE CACHE
    SEQUENCE_NAME = sequence_name
    [GLOBAL];

Parameters

Examples

• Clear the cache of the test_seq1 sequence on the current node in the current tenant and schema.

  obclient> ALTER SYSTEM FLUSH SEQUENCE CACHE
      SEQUENCE_NAME = test_seq1;
  

• Clear the cache of the test_seq1 sequence on all nodes in the current tenant and schema.

  obclient> ALTER SYSTEM FLUSH SEQUENCE CACHE
      SEQUENCE_NAME = test_seq1
      GLOBAL;
  

References

• For more information about the syntax for creating a sequence, see CREATE SEQUENCE.