MY_SEQUENCES

MY_SEQUENCES displays the sequence information about the current user. This view exists in both PG_CATALOG and SYS schemas. For details about the columns, see Table 1.

**Table 1** MY_SEQUENCES columns
Name	Type	Description
sequence_owner	name	Owner of a sequence.
sequence_name	name	Name of a sequence.
min_value	int16	Minimum value of a sequence.
max_value	int16	Maximum value of a sequence.
increment_by	int16	Value by which the sequence is incremented.
cycle_flag	character(1)	Specifies whether a sequence is a cycle sequence. The options are as follows: Y: It is a cycle sequence. N: It is not a cycle sequence.
order_flag	character varying(1)	Specifies whether a sequence occurs in a request sequence. This parameter is not supported. Set it to NULL.
cache_size	int16	Size of the sequence disk cache.
last_number	int16	Last value of the sequence allocated in a batch from the GTM at a time.
scale_flag	character varying(1)	Specifies whether a sequence is a scalable sequence. This parameter is not supported. Set it to NULL.
extend_flag	character varying(1)	Specifies whether the value generated by a scalable sequence exceeds the maximum or minimum value of the sequence. Not supported. The value is NULL.
sharded_flag	character varying(1)	Specifies whether a sequence is a shard sequence. Not supported. The value is NULL.
session_flag	character varying(1)	Specifies whether a sequence has a private session. This is not supported. The value is NULL.
keep_value	character varying(1)	Specifies whether to retain the sequence value during replay after a failure. Not supported. The value is NULL.