eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_SEQUENCES

Object Details

Object Name:	USER_SEQUENCES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of the user's own SEQUENCEs

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_NAME	VARCHAR2	(128)	Yes	SEQUENCE name
MIN_VALUE	NUMBER			Minimum value of the sequence
MAX_VALUE	NUMBER			Maximum value of the sequence
INCREMENT_BY	NUMBER		Yes	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR2	(1)		Does sequence wrap around on reaching limit?
ORDER_FLAG	VARCHAR2	(1)		Are sequence numbers generated in order?
CACHE_SIZE	NUMBER		Yes	Number of sequence numbers to cache
LAST_NUMBER	NUMBER		Yes	Last sequence number written to disk
PARTITION_COUNT	NUMBER			Partition Count if sequence is partitioned
SESSION_FLAG	VARCHAR2	(1)		Is this a session sequence?
KEEP_VALUE	VARCHAR2	(1)		Are sequence values kept during replay after failure

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEQUENCE_NAME
,      MIN_VALUE
,      MAX_VALUE
,      INCREMENT_BY
,      CYCLE_FLAG
,      ORDER_FLAG
,      CACHE_SIZE
,      LAST_NUMBER
,      PARTITION_COUNT
,      SESSION_FLAG
,      KEEP_VALUE
FROM SYS.USER_SEQUENCES;

Dependencies

[top of page]

SYS.USER_SEQUENCES references the following:

SYS: OBJ$; SEQ$

SYS.USER_SEQUENCES is referenced by following:

PUBLIC: SEQ; USER_SEQUENCES