DICTIONARY_SCHEMA

The DICTIONARY_SCHEMA contains views and tables for obtaining information about SQL objects and their related details within the system.

The views and tables in DICTIONARY_SCHEMA can be retrieved from the open phase.

Execute DictionarySchema.sql as follows to use the views.

For standalone

% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/standalone/DictionarySchema.sql

For cluster

% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/cluster/DictionarySchema.sql

Information is retrieved as follows based on the names of the views or tables.

ALL-family view
- The view name begins with ALL_.
- Information about objects accessible to the current user
DBA-family view
- The view name begins with DBA_.
- Information about all objects owned by the current user with DBA privileges (ACCESS CONTROL ON DATABASE)
USER-family view
- The view name begins with USER_.
- Information about objects owned by the current user

ALL_family Views

It retrieves information about objects accessible to the current user.

ALL_ALL_TABLES

ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
OBJECT_ID_TYPE	VARCHAR(32)	reserved Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED
TABLE_TYPE_OWNER	VARCHAR(128)	reserved If an object table, owner of the type from which the table is created
TABLE_TYPE	VARCHAR(128)	reserved If an object table, type of the table
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)

ALL_ARGUMENTS

ALL_ARGUMENTS lists all arguments of functions, procedures.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of function, procedures or package
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures
PACKAGE_NAME	VARCHAR(128)	Package Name of function, procedures
OBJECT_ID	NUMBER	ID of a function, procedures
SUBPROGRAM_ID	NUMBER	ID of procedures in package
ARGUMENT_NAME	VARCHAR(128)	Name of argument or attribute name of record type argument
POSITION	NUMBER	Position of argument or position of attribute in record type
SEQUENCE	NUMBER	Sequential order of argument and its attributes
DATA_LEVEL	NUMBER	Nesting depth of the argument for composite types
DATA_TYPE	VARCHAR(128)	Data type of the argument
DEFAULTED	VARCHAR(1)	Whether or not the argument is defaulted
DEFAULT_VALUE	VARCHAR(1)	Reserved for future use
DEFAULT_LENGTH	VARCHAR(1)	Reserved for future use
IN_OUT	VARCHAR(32)	Direction of the argument (IN, OUT, IN/OUT)
DATA_LENGTH	NUMBER	Length of the column(in bytes)
DATA_PRECISION	NUMBER	Length in decimal digits(NUMBER) or binary digits(FLOAT)
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
RADIX	NUMBER	Argument radix for a number
CHARACTER_SET_NAME	VARCHAR(128)	Character set name for the argument
TYPE_OWNER	VARCHAR(128)	Owner of the type of the argument
TYPE_NAME	VARCHAR(128)	Name of the type of the argument
TYPE_SUBNAME	VARCHAR(128)	Name of the type of the argument declared in package
TYPE_LINK	VARCHAR(128)	Name of the type of the argument declared in a remote package
PLS_TYPE	VARCHAR(128)	Name of the type of the argument at PSM
CHAR_LENGTH	NUMBER	Character limit for string datatypes
CHAR_USED	VARCHAR(1)	Whether the byte limit(B) or char limit(C) is official for the string
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

ALL_CATALOG

ALL_CATALOG displays the tables, views, synonyms, and sequences accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_SCHEMA	VARCHAR(128)	Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_NAME	VARCHAR(128)	Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_TYPE	VARCHAR(32)	Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED

ALL_CLUSTER_TABLES

ALL_CLUSTER_TABLES describes all cluster tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_PLACEMENT	VARCHAR(32)	Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP)
SHARD_COUNT	NUMBER	Shard count of the table (if cloned table, the value is null)
SHARD_KEY_COUNT	NUMBER	Shard key column count of the table (if cloned table, the value is null)
HAS_GSI	VARCHAR(3)	Indicate whether the table has global secondary index: (YES) or (NO)
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

ALL_COL_COMMENTS

ALL_COL_COMMENTS displays comments on the columns of the tables and views accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
COMMENTS	VARCHAR(1024)	Comment on the column

ALL_COL_PRIVS

ALL_COL_PRIVS describes the object grants, for which the current user is the object owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_MADE describes the column object grants for which the current user is the object owner or grantor.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_COL_PRIVS_RECD

ALL_COL_PRIVS_RECD describes the column object grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_CONSTRAINTS

ALL_CONSTRAINTS describes constraint definitions on tables accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
CONSTRAINT_TYPE	VARCHAR(1)	Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity )
TABLE_OWNER	VARCHAR(128)	Owner of the table (or view) associated with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table (or view) associated with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table (or view) associated with the constraint definition
SEARCH_CONDITION	LONG VARCHAR	Text of search condition for a check constraint
R_OWNER	VARCHAR(128)	Owner of the unique constraint definition for the referenced table
R_SCHEMA	VARCHAR(128)	Schema of the unique constraint definition for the referenced table
R_CONSTRAINT_NAME	VARCHAR(128)	Name of the unique constraint definition for the referenced table
DELETE_RULE	VARCHAR(32)	Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
UPDATE_RULE	VARCHAR(32)	Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
STATUS	VARCHAR(32)	Enforcement status of the constraint: the value in ( ENABLED, DISABLE )
DEFERRABLE	VARCHAR(32)	Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE)
DEFERRED	VARCHAR(32)	Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE)
VALIDATED	VARCHAR(32)	Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED )
GENERATED	VARCHAR(32)	Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME)
BAD	VARCHAR(32)	reserved Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL)
RELY	VARCHAR(32)	reserved When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL)
LAST_CHANGE	TIMESTAMP(6) WITHOUT TIME ZONE	When the constraint was last enabled or disabled
INDEX_OWNER	VARCHAR(128)	Owner of the index associated with the key constraint
INDEX_SCHEMA	VARCHAR(128)	Schema of the index associated with the key constraint
INDEX_NAME	VARCHAR(128)	Name of the index associated with the key constraint
INVALID	VARCHAR(32)	Indicates whether the constraint is invalid (INVALID) or not (NULL)
VIEW_RELATED	VARCHAR(32)	Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL)
DROPPED	VARCHAR(3)	Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the constraint definition

ALL_CONS_COLUMNS

ALL_CONS_COLUMNS describes columns that are accessible to the current user and that are specified in constraints.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
TABLE_OWNER	VARCHAR(128)	Owner of the table with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table with the constraint definition
COLUMN_NAME	VARCHAR(128)	Name of the column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER	Original position of the column or attribute in the definition of the object

ALL_DB_PRIVS

ALL_DB_PRIVS describes the database grants, for which the current user is the grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PRIVILEGE	VARCHAR(32)	Privilege on the database
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_DB_PRIVS_MADE

ALL_DB_PRIVS_MADE describes the database grants for which the current user is the grantor.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the database
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_DB_PRIVS_RECD

ALL_DB_PRIVS_RECD describes the database grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the database
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_DEPENDENCIES

ALL_DEPENDENCIES describes dependencies between objects accessible to the current user

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of object
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_OWNER	VARCHAR(128)	Owner of the referenced object
REFERENCED_SCHEMA_NAME	VARCHAR(128)	Schema Name of the referenced object
REFERENCED_TYPE	VARCHAR(32)	Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_LINK_NAME	VARCHAR(128)	Name of the link to the parent object
REFERENCED_NAME	VARCHAR(128)	Name of the referenced object
DEPENDENCY_TYPE	VARCHAR(32)	Indicates whether the dependency is a REF dependency (REF) or not (HARD)

ALL_GLOBAL_SECONDARY_INDEXES

ALL_GLOBAL_SECONDARY_INDEXES describes the global secondary indexes on the tables accessible to the current user.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the global secondary indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the global secondary index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	Indicates whether or not changes to the global secondary index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the global secondary index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the global secondary index
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)

ALL_GSI_PLACE

ALL_GSI_PLACE describes node placement of all global secondary indexes on the tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the global secondary indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
GROUP_ID	NUMBER	Group identifier of the node where the global secondary index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the global secondary index placed
MEMBER_ID	NUMBER	Member identifier of the node where the global secondary index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the global secondary index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)
BLOCKS	NUMBER	Number of used blocks of the node where the global secondary index placed

ALL_HISTOGRAM_BALANCE

ALL_HISTOGRAM_BALANCE describes each height-balanced histogram bucket accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of height-balanced histogram
BUCKET_ACCU_HEIGHT	NUMBER	Accumulated height of the height-balanced histogram bucket
BUCKET_VALUE	VARCHAR(128)	Bucket value

ALL_HISTOGRAM_FREQUENCY

ALL_HISTOGRAM_FREQUENCY describes each frequency histogram bucket accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of frequency histogram
BUCKET_HEIGHT	NUMBER	Bucket height of the frequency histogram bucket
SAMPLE_COUNT	NUMBER	Sample count of frequency histogram
BUCKET_VALUE	VARCHAR(128)	Bucket value

ALL_INDEXES

ALL_INDEXES describes the indexes on the tables accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
INDEX_TYPE	VARCHAR(32)	Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN )
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
TABLE_TYPE	VARCHAR(32)	Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE )
UNIQUENESS	VARCHAR(32)	Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE)
COMPRESSION	VARCHAR(32)	reserved Indicates whether index compression is enabled (ENABLED) or not (DISABLED)
PREFIX_LENGTH	NUMBER	reserved Number of columns in the prefix of the compression key
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
PCT_THRESHOLD	NUMBER	reserved Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER	reserved Column ID of the last column to be included in index-organized table primary key (non-overflow) index
FREELISTS	NUMBER	reserved Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to this segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	Indicates whether or not changes to the index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the index
ANAL_BLOCKS	NUMBER	Number of used blocks in the index when most recently analyzed
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index
BLEVEL	NUMBER	B-Tree level (depth of the index from its root block to its leaf blocks)
LEAF_BLOCKS	NUMBER	Number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	Number of distinct indexed values.
AVG_LEAF_BLOCKS_PER_KEY	NUMBER	reserved Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer
AVG_DATA_BLOCKS_PER_KEY	NUMBER	reserved Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer
CLUSTERING_FACTOR	NUMBER	Indicates the amount of order of the rows in the table based on the values of the index
STATUS	VARCHAR(32)	Indicates whether a nonpartitioned index is VALID or DISABLE
NUM_ROWS	NUMBER	reserved Number of rows in the index
SAMPLE_SIZE	NUMBER	Size of the sample used to analyze the index
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this index was most recently analyzed
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the index, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the indexes to be scanned, or DEFAULT
PARTITIONED	VARCHAR(3)	reserved Indicates whether the index is partitioned (YES) or not (NO)
TEMPORARY	VARCHAR(1)	Indicates whether the index is on a temporary table (Y) or not (N)
GENERATED	VARCHAR(1)	Indicates whether the name of the index is system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for index blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for index blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for index blocks
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
PCT_DIRECT_ACCESS	NUMBER	reserved For a secondary index on an index-organized table, the percentage of rows with VALID guess
ITYP_OWNER	VARCHAR(128)	reserved For a domain index, the owner of the indextype
ITYP_NAME	VARCHAR(128)	reserved For a domain index, the name of the indextype
PARAMETERS	VARCHAR(1024)	reserved For a domain index, the parameter string
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)
DOMIDX_STATUS	VARCHAR(32)	reserved Status of a domain index
DOMIDX_OPSTATUS	VARCHAR(32)	reserved Status of the operation on a domain index
FUNCIDX_STATUS	VARCHAR(32)	reserved Status of a function-based index
JOIN_INDEX	VARCHAR(3)	reserved Indicates whether the index is a join index (YES) or not (NO)
IOT_REDUNDANT_PKEY_ELIM	VARCHAR(3)	reserved Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO)
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
VISIBILITY	VARCHAR(3)	reserved Indicates whether the index is VISIBLE or INVISIBLE to the optimizer
DOMIDX_MANAGEMENT	VARCHAR(32)	reserved If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the index segment has been created (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index

ALL_IND_COLUMNS

ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.

Column information
Column name	Data type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table or cluster
TABLE_SCHEMA	VARCHAR(128)	Schema of the table or cluster
TABLE_NAME	VARCHAR(128)	Name of the table or cluster
COLUMN_NAME	VARCHAR(128)	Column name or attribute of the object type column
COLUMN_POSITION	NUMBER	Position of the column or attribute within the index
COLUMN_LENGTH	NUMBER	Indexed length of the column
CHAR_LENGTH	NUMBER	Maximum codepoint length of the column
DESCEND	VARCHAR(32)	Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC)
NULL_ORDER	VARCHAR(32)	Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST)

ALL_IND_PLACE

ALL_IND_PLACE describes node placement of the indexes on the tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
GROUP_ID	NUMBER	Group identifier of the node where the index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the index placed
MEMBER_ID	NUMBER	Member identifier of the node where the index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
DISTINCT_KEYS	NUMBER	(deprecated)
SAMPLE_SIZE	NUMBER	(deprecated)
BLOCKS	NUMBER	Number of used blocks of the node where the index placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	(deprecated)

ALL_LIBRARIES

ALL_LIBRARIES describes the libraries accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of Library
LIBRARY_SCHEMA	VARCHAR(128)	Schema Name of Library
LIBRARY_NAME	VARCHAR(128)	Name of Library
FILE_SPEC	LONG VARCHAR	Operating system file specification associated with the library
DYNAMIC	VARCHAR(1)	Indicates whether the library is dynamically loadable (Y) or not (N)
STATUS	VARCHAR(32)	Status of the library : the value in ( VALID, INVALID, N/A )
AGENT	VARCHAR(128)	Agent of the library
LEAF_FILENAME	VARCHAR(4000)	Leaf filename of the library
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates
COMMENTS	VARCHAR(1024)	Comment on the library

ALL_LIBRARY_PRIVS

ALL_LIBRARY_PRIVS describes the library grants, for which the current user is the library owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_LIBRARY_PRIVS_MADE

ALL_LIBRARY_PRIVS_MADE describes the library grants for which the current user is the library owner or grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_LIBRARY_PRIVS_RECD

ALL_LIBRARY_PRIVS_RECD describes the library grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_NONSCHEMA_COMMENTS

ALL_NONSCHEMA_COMMENTS displays comments on all non-schema objects (database, authorizations, schemas, tablespaces) accessible to the current user.

Column information
Column name	Data type	Description
OBJECT_NAME	VARCHAR(128)	Name of the non-schema object
OBJECT_TYPE	VARCHAR(32)	Type of the non-schema object: DATABASE, AUTHORIZATION, SCHEMA, TABLESPACE
COMMENTS	VARCHAR(1024)	Comments of the non-schema object

ALL_OBJECTS

ALL_OBJECTS describes all objects accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
SCHEMA_NAME	VARCHAR(128)	Schema of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
SUBOBJECT_NAME	VARCHAR(128)	Name of the subobject (for example, partition)
OBJECT_ID	NUMBER	Dictionary object number of the object
DATA_OBJECT_ID	NUMBER	Dictionary object number of the segment that contains the object
OBJECT_TYPE	VARCHAR(32)	Type of the object (such as TABLE, INDEX)
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the creation of the object
LAST_DDL_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the last modification of the object resulting from a DDL statement
TIMESTAMP	VARCHAR(32)	Timestamp for the specification of the object (character data)
STATUS	VARCHAR(32)	Status of the object: the value in ( VALID, INVALID, N/A )
TEMPORARY	VARCHAR(1)	Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N)
GENERATED	VARCHAR(1)	reserved Indicates whether the name of this object was system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)
NAMESPACE	NUMBER	Namespace for the object
EDITION_NAME	VARCHAR(128)	reserved Name of the edition in which the object is actual
DROPPED	VARCHAR(3)	Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO)

ALL_PACKAGE_PRIVS

ALL_PACKAGE_PRIVS describes the package grants, for which the current user is the package owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_PACKAGE_PRIVS_MADE

ALL_PACKAGE_PRIVS_MADE describes the package grants for which the current user is the package owner or grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_PACKAGE_PRIVS_RECD

ALL_PACKAGE_PRIVS_RECD describes the package grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_PROCEDURES

ALL_PROCEDURES lists all function, procedures or package

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of function, procedures or package
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures or package
PROCEDURE_NAME	VARCHAR(128)	Name when a procedures in package
OBJECT_ID	NUMBER	ID of a function, procedures or package
SUBPROGRAM_ID	NUMBER	ID of procedures in package
OVERLOAD	VARCHAR(32)	ID of overloading procedure in package
OBJECT_TYPE	VARCHAR(32)	Type of function, procedures or package
AGGREGATE	VARCHAR(3)	Indicate whether the procedure is an aggreage function(YES) or not(NO)
PIPELINED	VARCHAR(3)	Indicate whether the procedure is a pipelined table function(YES) or not(NO)
IMPLTYPEOWNER	VARCHAR(128)	Name of the owner of the implementation type, if any
IMPLTYPENAME	VARCHAR(128)	Name of the implementation type, if any
PARALLEL	VARCHAR(3)	Indicates whether the procedure or function is parallel-enabled (YES) or not (NO)
INTERFACE	VARCHAR(3)	YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO
DETERMINISTIC	VARCHAR(3)	YES, if the procedure/function is declared to be deterministic; otherwise NO
AUTHID	VARCHAR(32)	Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker)

ALL_PROC_PRIVS

ALL_PROC_PRIVS describes the procedure grants, for which the current user is the procedure owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_PROC_PRIVS_MADE

ALL_PROC_PRIVS_MADE describes the procedure grants for which the current user is the procedure owner or grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_PROC_PRIVS_RECD

ALL_PROC_PRIVS_RECD describes the procedure grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SCHEMAS

Identify the schemata in a catalog that are owned by given user or accessible to given user or role.

Column information
Column name	Data type	Description
SCHEMA_OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Created time of the schema
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Last modified time of the schema
COMMENTS	VARCHAR(1024)	Comments of the schema

ALL_SCHEMA_PATH

ALL_SCHEMA_PATH describes the schema search order of the current user and PUBLIC, for naming resolution of unqualified SQL schema objects.

Column information
Column name	Data type	Description
AUTH_NAME	VARCHAR(128)	Name of the authorization
SCHEMA_NAME	VARCHAR(128)	Name of the schema
SEARCH_ORDER	NUMBER	Schema search order of the authorization

ALL_SCHEMA_PRIVS

ALL_SCHEMA_PRIVS describes the schema grants, for which the current user is the schema owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SCHEMA_PRIVS_MADE

ALL_SCHEMA_PRIVS_MADE describes the schema grants, for which the current user is the grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SCHEMA_PRIVS_RECD

ALL_SCHEMA_PRIVS_RECD describes the schema grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SEQUENCES

ALL_SEQUENCES describes all sequences accessible to the current user.

Column information
Column name	Data type	Description
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Sequence name
MIN_VALUE	NUMBER	Minimum value of the sequence
MAX_VALUE	NUMBER	Maximum value of the sequence
INCREMENT_BY	NUMBER	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR(1)	Indicates whether the sequence wraps around on reaching the limit (Y) or not (N)
ORDER_FLAG	VARCHAR(1)	Indicates whether sequence numbers are generated in order (Y) or not (N)
CACHE_SIZE	NUMBER	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache.
COMMENTS	VARCHAR(1024)	Comments of the sequence

ALL_SEQ_PRIVS

ALL_SEQ_PRIVS describes the sequence grants, for which the current user is the sequence owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SEQ_PRIVS_MADE

ALL_SEQ_PRIVS_MADE describes the sequence grants for which the current user is the sequence owner or grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SEQ_PRIVS_RECD

ALL_SEQ_PRIVS_RECD describes the sequence grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_SHARD_KEY_COLUMNS

ALL_SHARD_KEY_COLUMNS describes shard key columns of all shareded tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Column name of the shard key
COLUMN_POSITION	NUMBER	Position of the column within the shard key

ALL_SOURCE

ALL_SOURCE describes the text source of the stored objects accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of object
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER
LINE	NUMBER	Line number of this line of source
TEXT	LONG VARCHAR	Text source of the strored object
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

ALL_STAT_COLUMN_GROUP

ALL_STAT_COLUMN_GROUP describes each column group statistics accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
STAT_NAME	VARCHAR(128)	Statistics name
COLUMN_GROUPS	VARCHAR(1024)	Column names of the column group statistics
NUM_DISTINCT	NUMBER	Number of distinct values in the column group statistics
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column group statistics
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column group statistics was most recently analyzed

ALL_SYNONYMS

ALL_SYNONYMS describes all synonyms.

Column information
Column name	Data type	Description
SYNONYM_OWNER	VARCHAR(128)	Owner of the synonym
SYNONYM_SCHEMA	VARCHAR(128)	Schema of the synonym
SYNONYM_NAME	VARCHAR(128)	Synonym name
OBJECT_SCHEMA_NAME	VARCHAR(128)	Object schema name
OBJECT_NAME	VARCHAR(128)	Object name
DB_LINK	VARCHAR(128)	Reserved for future use

ALL_TABLES

ALL_TABLES describes the relational tables accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	reserved If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)
RESULT_CACHE	VARCHAR(32)	reserved Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL )

ALL_TAB_COLS

ALL_TAB_COLS describes the columns(including hidden columns) of the tables, views, and clusters accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	reserved Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HIDDEN_COLUMN	VARCHAR(3)	Indicates whether the column is a hidden column (YES) or not (NO)
VIRTUAL_COLUMN	VARCHAR(3)	reserved Indicates whether the column is a virtual column (YES) or not (NO)
SEGMENT_COLUMN_ID	NUMBER	Sequence number of the column in the segment
INTERNAL_COLUMN_ID	NUMBER	Internal sequence number of the column
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
QUALIFIED_COL_NAME	VARCHAR(4000)	Qualified column name
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

ALL_TAB_COLUMNS

ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

ALL_TAB_COMMENTS

ALL_TAB_COMMENTS displays comments on the tables and views accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
TABLE_TYPE	VARCHAR(32)	Type of the object
COMMENTS	VARCHAR(1024)	Comment on the object

ALL_TAB_IDENTITY_COLS

ALL_TAB_IDENTITY_COLS describes all table identity columns.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the identity column
GENERATION_TYPE	VARCHAR(32)	Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT
IDENTITY_OPTIONS	VARCHAR(1024)	Options for the identity column sequence generator

ALL_TAB_PLACE

ALL_TAB_PLACE describes node placement of all cluster tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
GROUP_ID	NUMBER	Group identifier of the node where the table placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the table placed
MEMBER_ID	NUMBER	Member identifier of the node where the table placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the table placed
MEMBER_POSITION	NUMBER	Member position of the node where the table placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
IS_UPDATE_MASTER	BOOLEAN	whether the cluster member is update master or not
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
SCN	VARCHAR(64)	table scn of the node where the table placed
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks of the node where the table placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed

ALL_TAB_SHARDS

ALL_TAB_SHARDS describes shard information of sharded tables accessible to the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_NAME	VARCHAR(128)	Shard name
SHARD_NUMBER	NUMBER	Shard number
SHARD_DEFINITION	LONG VARCHAR	Shard definition (if hash sharded, the value is null)
GROUP_ID	NUMBER	Group identifier where the shard placed
GROUP_NAME	VARCHAR(128)	Group Name where the shard placed
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

ALL_TAB_PRIVS

ALL_TAB_PRIVS describes the object grants, for which the current user is the object owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner or grantor.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

ALL_TAB_PRIVS_RECD

ALL_TAB_PRIVS_RECD describes object grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

ALL_TBS_PRIVS

ALL_TBS_PRIVS describes the tablespace grants, for which the current user is the grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
PRIVILEGE	VARCHAR(32)	Privilege on the tablespace
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_TBS_PRIVS_MADE

ALL_TBS_PRIVS_MADE describes the tablespace grants for which the current user is the grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
PRIVILEGE	VARCHAR(32)	Privilege on the tablespace
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_TBS_PRIVS_RECD

ALL_TBS_PRIVS_RECD describes the tablespace grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
PRIVILEGE	VARCHAR(32)	Privilege on the tablespace
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

ALL_TRIGGERS

ALL_TRIGGERS describes the triggers on tables accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	Schema Name of the trigger
TRIGGER_NAME	VARCHAR(128)	Name of the trigger
TRIGGER_TYPE	VARCHAR(16)	When the trigger fires: the value in ( BEFORE STATEMENT, BEFORE EACH ROW, AFTER STATEMENT, AFTER EACH ROW, INSTEAD OF, COMPOUND )
TRIGGERING_EVENT	VARCHAR(32)	DML, DDL, or database event that fires the trigger
TABLE_OWNER	VARCHAR(128)	Owner of the table on which the trigger is defined
TABLE_SCHEMA	VARCHAR(128)	Schema Name of the table on which the trigger is defined
BASE_OBJECT_TYPE	VARCHAR(16)	Base object on which the trigger is defined: the value in ( TABLE, VIEW, SCHEMA, DATABASE )
TABLE_NAME	VARCHAR(128)	If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW then this column indicates the table or view name on which the trigger is defined
COLUMN_NAME	VARCHAR(4000)	Name of the nested table column (if a nested table trigger), else NULL
REFERENCING_NAMES	VARCHAR(1024)	Names used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSE	LONG VARCHAR	Must evaluate to TRUE for TRIGGER_BODY to execute
STATUS	VARCHAR(8)	Indicates whether the trigger is enabled (ENABLED) or disabled (DISABLED); a disabled trigger will not fire
DESCRIPTION	LONG VARCHAR	Trigger description; useful for re-creating a trigger creation statement
ACTION_TYPE	VARCHAR(16)	Action type of the trigger body: the value in ( CALL, PSM BLOCK )
TRIGGER_BODY	LONG VARCHAR	Statements executed by the trigger when it fires
CROSSEDITION	VARCHAR(3)	Type of crossedition trigger: the value in ( FORWARD, REVERSE, NO )
BEFORE_STATEMENT	VARCHAR(3)	Indicates whether the trigger has a BEFORE STATEMENT section (YES) or not (NO)
BEFORE_ROW	VARCHAR(3)	Indicates whether the trigger has a BEFORE EACH ROW section (YES) or not (NO)
AFTER_ROW	VARCHAR(3)	Indicates whether the trigger has an AFTER EACH ROW section (YES) or not (NO)
AFTER_STATEMENT	VARCHAR(3)	Indicates whether the trigger has an AFTER STATEMENT section (YES) or not (NO)
INSTEAD_OF_ROW	VARCHAR(3)	Indicates whether the trigger has an INSTEAD OF section (YES) or not (NO)
FIRE_ONCE	VARCHAR(3)	Indicates whether the trigger will fire only for user processes making changes (YES) or whether the trigger will also fire for Replication Apply or SQL Apply processes (NO)
APPLY_SERVER_ONLY	VARCHAR(3)	Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process (YES) or not (NO). If set to YES, then the setting of FIRE_ONCE does not matter
COMMENTS	VARCHAR(1024)	Comment on the trigger

ALL_USERS

ALL_USERS lists all users of the database visible to the current user.

Column information
Column name	Data type	Description
USERNAME	VARCHAR(128)	Name of the user
USER_ID	NUMBER	ID number of the user
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	User creation timestamp

ALL_VIEWS

ALL_VIEWS describes the views accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the view
VIEW_SCHEMA	VARCHAR(128)	Schema of the view
VIEW_NAME	VARCHAR(128)	Name of the view
TEXT_LENGTH	NUMBER	Length of the view text
TEXT	LONG VARCHAR	View text
TYPE_TEXT_LENGTH	NUMBER	reserved Length of the type clause of the typed view
TYPE_TEXT	VARCHAR(4000)	reserved Type clause of the typed view
OID_TEXT_LENGTH	NUMBER	reserved Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR(4000)	reserved WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR(128)	reserved Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR(32)	reserved Type of the view if the view is a typed view
SUPERVIEW_NAME	VARCHAR(128)	reserved Name of the superview
EDITIONING_VIEW	VARCHAR(1)	reserved Reserved for future use
READ_ONLY	VARCHAR(1)	Indicates whether the view is read-only (Y) or not (N)

DBA_family Views

The current user has DBA privileges (ACCESS CONTROL ON DATABASE), and the user can retrieve information about all objects.

DBA_ALL_TABLES

DBA_ALL_TABLES describes all object tables and relational tables in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	reserved If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
OBJECT_ID_TYPE	VARCHAR(32)	reserved Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED
TABLE_TYPE_OWNER	VARCHAR(128)	reserved If an object table, owner of the type from which the table is created
TABLE_TYPE	VARCHAR(128)	reserved If an object table, type of the table
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)

DBA_ARGUMENTS

DBA_ARGUMENTS lists all arguments of functions, procedures.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of function, procedures or package
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures
PACKAGE_NAME	VARCHAR(128)	Package Name of function, procedures
OBJECT_ID	NUMBER	ID of a function, procedures
SUBPROGRAM_ID	NUMBER	ID of procedures in package
ARGUMENT_NAME	VARCHAR(128)	Name of argument or attribute name of record type argument
POSITION	NUMBER	Position of argument or position of attribute in record type
SEQUENCE	NUMBER	Sequential order of argument and its attributes
DATA_LEVEL	NUMBER	Nesting depth of the argument for composite types
DATA_TYPE	VARCHAR(128)	Data type of the argument
DEFAULTED	VARCHAR(1)	Whether or not the argument is defaulted
DEFAULT_VALUE	VARCHAR(1)	Reserved for future use
DEFAULT_LENGTH	VARCHAR(1)	Reserved for future use
IN_OUT	VARCHAR(32)	Direction of the argument (IN, OUT, IN/OUT)
DATA_LENGTH	NUMBER	Length of the column(in bytes)
DATA_PRECISION	NUMBER	Length in decimal digits(NUMBER) or binary digits(FLOAT)
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
RADIX	NUMBER	Argument radix for a number
CHARACTER_SET_NAME	VARCHAR(128)	Character set name for the argument
TYPE_OWNER	VARCHAR(128)	Owner of the type of the argument
TYPE_NAME	VARCHAR(128)	Name of the type of the argument
TYPE_SUBNAME	VARCHAR(128)	Name of the type of the argument declared in package
TYPE_LINK	VARCHAR(128)	Name of the type of the argument declared in a remote package
PLS_TYPE	VARCHAR(128)	Name of the type of the argument at PSM
CHAR_LENGTH	NUMBER	Character limit for string datatypes
CHAR_USED	VARCHAR(1)	Whether the byte limit(B) or char limit(C) is official for the string
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

DBA_CATALOG

DBA_CATALOG lists all tables, views, synonyms, and sequences in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_SCHEMA	VARCHAR(128)	Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_NAME	VARCHAR(128)	Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_TYPE	VARCHAR(32)	Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED

DBA_CLUSTER

DBA_CLUSTER describes all cluster members in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
GROUP_ID	NUMBER	Group identifier of the cluster member
GROUP_NAME	VARCHAR(128)	Group name of the cluster member
MEMBER_ID	NUMBER	Member identifier of the cluster member
MEMBER_NAME	VARCHAR(128)	Member name of the cluster member
MEMBER_HOST	VARCHAR(256)	Host name or IP address of the cluster member
MEMBER_PORT	NUMBER	Port number of the cluster member
MEMBER_POSITION	NUMBER	Member position number of the cluster member

DBA_CLUSTER_COMMENTS

DBA_CLUSTER_COMMENTS displays comments on the cluster objects in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OBJECT_NAME	VARCHAR(128)	Name of the cluster object
OBJECT_TYPE	VARCHAR(32)	Type of the cluster object: CLUSTER GROUP, CLUSTER MEMBER
COMMENTS	VARCHAR(1024)	Comment on the cluster object

DBA_CLUSTER_TABLES

DBA_CLUSTER_TABLES describes all cluster tables in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_PLACEMENT	VARCHAR(32)	Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP)
SHARD_COUNT	NUMBER	Shard count of the table (if cloned table, the value is null)
SHARD_KEY_COUNT	NUMBER	Shard key column count of the table (if cloned table, the value is null)
HAS_GSI	VARCHAR(3)	Indicate whether the table has global secondary index: (YES) or (NO)
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

DBA_COL_COMMENTS

DBA_COL_COMMENTS displays comments on the columns of all tables and views in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
COMMENTS	VARCHAR(1024)	Comment on the column

DBA_COL_PRIVS

DBA_COL_PRIVS describes all column object grants in the database.

Column information
Column name	Data type	Description
GRANTOR	CHARACTER VARYING(128)	Name of the user who performed the grant
GRANTEE	CHARACTER VARYING(128)	Name of the user or role to whom access was granted
OWNER	CHARACTER VARYING(128)	Owner of the object
TABLE_SCHEMA	CHARACTER VARYING(128)	Schema of the object
TABLE_NAME	CHARACTER VARYING(128)	Name of the object
COLUMN_NAME	CHARACTER VARYING(128)	Name of the column
PRIVILEGE	CHARACTER VARYING(32)	Privilege on the column
GRANTABLE	CHARACTER VARYING(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_CONSTRAINTS

DBA_CONSTRAINTS describes all constraint definitions on all tables in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
CONSTRAINT_TYPE	VARCHAR(1)	Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity )
TABLE_OWNER	VARCHAR(128)	Owner of the table (or view) associated with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table (or view) associated with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table (or view) associated with the constraint definition
SEARCH_CONDITION	LONG VARCHAR	Text of search condition for a check constraint
R_OWNER	VARCHAR(128)	Owner of the unique constraint definition for the referenced table
R_SCHEMA	VARCHAR(128)	Schema of the unique constraint definition for the referenced table
R_CONSTRAINT_NAME	VARCHAR(128)	Name of the unique constraint definition for the referenced table
DELETE_RULE	VARCHAR(32)	Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
UPDATE_RULE	VARCHAR(32)	Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
STATUS	VARCHAR(32)	Enforcement status of the constraint: the value in ( ENABLED, DISABLE )
DEFERRABLE	VARCHAR(32)	Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE)
DEFERRED	VARCHAR(32)	Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE)
VALIDATED	VARCHAR(32)	Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED )
GENERATED	VARCHAR(32)	Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME)
BAD	VARCHAR(32)	reserved Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL)
RELY	VARCHAR(32)	reserved When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL)
LAST_CHANGE	TIMESTAMP(6) WITHOUT TIME ZONE	When the constraint was last enabled or disabled
INDEX_OWNER	VARCHAR(128)	Owner of the index associated with the key constraint
INDEX_SCHEMA	VARCHAR(128)	Schema of the index associated with the key constraint
INDEX_NAME	VARCHAR(128)	Name of the index associated with the key constraint
INVALID	VARCHAR(32)	Indicates whether the constraint is invalid (INVALID) or not (NULL)
VIEW_RELATED	VARCHAR(32)	reserved Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL)
DROPPED	VARCHAR(3)	Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the constraint definition

DBA_CONS_COLUMNS

DBA_CONS_COLUMNS describes all columns in the database that are specified in constraints.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
TABLE_OWNER	VARCHAR(128)	Owner of the table with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table with the constraint definition
COLUMN_NAME	VARCHAR(128)	Name of the column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER	Original position of the column or attribute in the definition of the object

DBA_DB_PRIVS

DBA_DB_PRIVS describes all database grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PRIVILEGE	VARCHAR(32)	Privilege on the database
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_DEPENDENCIES

DBA_DEPENDENCIES describes all dependencies between objects in the database

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of object
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_OWNER	VARCHAR(128)	Owner of the referenced object
REFERENCED_SCHEMA_NAME	VARCHAR(128)	Schema Name of the referenced object
REFERENCED_TYPE	VARCHAR(32)	Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_LINK_NAME	VARCHAR(128)	Name of the link to the parent object
REFERENCED_NAME	VARCHAR(128)	Name of the referenced object
DEPENDENCY_TYPE	VARCHAR(32)	Indicates whether the dependency is a REF dependency (REF) or not (HARD)

DBA_EXTENTS

DBA_EXTENTS describes the extents comprising the segments in all tablespaces in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the segment associated with the extent
SEGMENT_SCHEMA	VARCHAR(128)	Schema of the segment associated with the extent
SEGMENT_NAME	VARCHAR(128)	Name of the segment associated with the extent
PARTITION_NAME	VARCHAR(128)	reserved Object Partition Name (Set to NULL for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(32)	Type of the segment: TABLE, INDEX
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the extent
EXTENT_ID	NUMBER	reserved Extent number in the segment
FILE_ID	NUMBER	reserved File identifier number of the file containing the extent
BLOCK_ID	NUMBER	reserved Starting block number of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in Oracle blocks
RELATIVE_FNO	NUMBER	reserved Relative file number of the first extent block

DBA_GLOBAL_SECONDARY_INDEXES

DBA_GLOBAL_SECONDARY_INDEXES describes all global secondary indexes in the database.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the global secondary indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the global secondary index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	Indicates whether or not changes to the global secondary index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the global secondary index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the global secondary index
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)

DBA_GSI_PLACE

DBA_GSI_PLACE describes node placement of all global secondary indexes in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the global secondary indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
GROUP_ID	NUMBER	Group identifier of the node where the global secondary index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the global secondary index placed
MEMBER_ID	NUMBER	Member identifier of the node where the global secondary index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the global secondary index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)
BLOCKS	NUMBER	Number of used blocks of the node where the global secondary index placed

DBA_HISTOGRAM_BALANCE

DBA_HISTOGRAM_BALANCE describes each height-balanced histogram bucket.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of height-balanced histogram
BUCKET_ACCU_HEIGHT	NUMBER	Accumulated height of the height-balanced histogram bucket
BUCKET_VALUE	VARCHAR(128)	Bucket value

DBA_HISTOGRAM_FREQUENCY

DBA_HISTOGRAM_FREQUENCY describes each frequency histogram bucket.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of frequency histogram
BUCKET_HEIGHT	NUMBER	Bucket height of the frequency histogram bucket
SAMPLE_COUNT	NUMBER	Sample count of frequency histogram
BUCKET_VALUE	VARCHAR(128)	Bucket value

DBA_INDEXES

DBA_INDEXES describes all indexes in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
INDEX_TYPE	VARCHAR(32)	Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN )
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
TABLE_TYPE	VARCHAR(32)	Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE )
UNIQUENESS	VARCHAR(32)	Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE)
COMPRESSION	VARCHAR(32)	reserved Indicates whether index compression is enabled (ENABLED) or not (DISABLED)
PREFIX_LENGTH	NUMBER	reserved Number of columns in the prefix of the compression key
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
PCT_THRESHOLD	NUMBER	reserved Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER	reserved Column ID of the last column to be included in index-organized table primary key (non-overflow) index
FREELISTS	NUMBER	reserved Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to this segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	Indicates whether or not changes to the index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the index
ANAL_BLOCKS	NUMBER	Number of used blocks in the index when most recently analyzed
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index
BLEVEL	NUMBER	B-Tree level (depth of the index from its root block to its leaf blocks)
LEAF_BLOCKS	NUMBER	Number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	Number of distinct indexed values.
AVG_LEAF_BLOCKS_PER_KEY	NUMBER	reserved Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer
AVG_DATA_BLOCKS_PER_KEY	NUMBER	reserved Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer
CLUSTERING_FACTOR	NUMBER	Indicates the amount of order of the rows in the table based on the values of the index
STATUS	VARCHAR(32)	Indicates whether a nonpartitioned index is VALID or DISABLE
NUM_ROWS	NUMBER	reserved Number of rows in the index
SAMPLE_SIZE	NUMBER	Size of the sample used to analyze the index
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this index was most recently analyzed
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the index, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the indexes to be scanned, or DEFAULT
PARTITIONED	VARCHAR(3)	reserved Indicates whether the index is partitioned (YES) or not (NO)
TEMPORARY	VARCHAR(1)	Indicates whether the index is on a temporary table (Y) or not (N)
GENERATED	VARCHAR(1)	Indicates whether the name of the index is system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for index blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for index blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for index blocks
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
PCT_DIRECT_ACCESS	NUMBER	reserved For a secondary index on an index-organized table, the percentage of rows with VALID guess
ITYP_OWNER	VARCHAR(128)	reserved For a domain index, the owner of the indextype
ITYP_NAME	VARCHAR(128)	reserved For a domain index, the name of the indextype
PARAMETERS	VARCHAR(1024)	reserved For a domain index, the parameter string
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)
DOMIDX_STATUS	VARCHAR(32)	reserved Status of a domain index
DOMIDX_OPSTATUS	VARCHAR(32)	reserved Status of the operation on a domain index
FUNCIDX_STATUS	VARCHAR(32)	reserved Status of a function-based index
JOIN_INDEX	VARCHAR(3)	reserved Indicates whether the index is a join index (YES) or not (NO)
IOT_REDUNDANT_PKEY_ELIM	VARCHAR(3)	reserved Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO)
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
VISIBILITY	VARCHAR(3)	reserved Indicates whether the index is VISIBLE or INVISIBLE to the optimizer
DOMIDX_MANAGEMENT	VARCHAR(32)	reserved If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the index segment has been created (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index

DBA_IND_COLUMNS

DBA_IND_COLUMNS describes the columns of all the indexes on all tables and clusters in the database.

Column information
Column name	Data type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table or cluster
TABLE_SCHEMA	VARCHAR(128)	Schema of the table or cluster
TABLE_NAME	VARCHAR(128)	Name of the table or cluster
COLUMN_NAME	VARCHAR(128)	Column name or attribute of the object type column
COLUMN_POSITION	NUMBER	Position of the column or attribute within the index
COLUMN_LENGTH	NUMBER	Indexed length of the column
CHAR_LENGTH	NUMBER	reserved Maximum codepoint length of the column
DESCEND	VARCHAR(32)	Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC)
NULL_ORDER	VARCHAR(32)	Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST)

DBA_IND_PLACE

DBA_IND_PLACE describes node placement of all indexes in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the index
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
GROUP_ID	NUMBER	Group identifier of the node where the index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the index placed
MEMBER_ID	NUMBER	Member identifier of the node where the index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
DISTINCT_KEYS	NUMBER	(deprecated)
SAMPLE_SIZE	NUMBER	(deprecated)
BLOCKS	NUMBER	Number of used blocks of the node where the index placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	(deprecated)

DBA_LIBRARIES

DBA_LIBRARIES describes all libraries in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of Library
LIBRARY_SCHEMA	VARCHAR(128)	Schema Name of Library
LIBRARY_NAME	VARCHAR(128)	Name of Library
FILE_SPEC	LONG VARCHAR	Operating system file specification associated with the library
DYNAMIC	VARCHAR(1)	Indicates whether the library is dynamically loadable (Y) or not (N)
STATUS	VARCHAR(32)	Status of the library : the value in ( VALID, INVALID, N/A )
AGENT	VARCHAR(128)	Agent of the library
LEAF_FILENAME	VARCHAR(4000)	Leaf filename of the library
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates
COMMENTS	VARCHAR(1024)	Comment on the library

DBA_LIBRARY_PRIVS

DBA_LIBRARY_PRIVS describes all library grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_NONSCHEMA_COMMENTS

DBA_NONSCHEMA_COMMENTS displays comments on all non-schema objects (database, authorizations, schemas, tablespaces).

Column information
Column name	Data type	Description
OBJECT_NAME	VARCHAR(128)	Name of the non-schema object
OBJECT_TYPE	VARCHAR(32)	Type of the non-schema object: DATABASE, PROFILE, AUTHORIZATION, SCHEMA, TABLESPACE
COMMENTS	VARCHAR(1024)	Comments of the non-schema object

DBA_OBJECTS

DBA_OBJECTS describes all objects in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
SCHEMA_NAME	VARCHAR(128)	Schema of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
SUBOBJECT_NAME	VARCHAR(128)	Name of the subobject (for example, partition)
OBJECT_ID	NUMBER	Dictionary object number of the object
DATA_OBJECT_ID	NUMBER	Dictionary object number of the segment that contains the object
OBJECT_TYPE	VARCHAR(32)	Type of the object (such as TABLE, INDEX)
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the creation of the object
LAST_DDL_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the last modification of the object resulting from a DDL statement
TIMESTAMP	VARCHAR(32)	Timestamp for the specification of the object (character data)
STATUS	VARCHAR(32)	Status of the object: the value in ( VALID, INVALID, N/A )
TEMPORARY	VARCHAR(1)	Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N)
GENERATED	VARCHAR(1)	Indicates whether the name of this object was system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)
NAMESPACE	NUMBER	Namespace for the object
EDITION_NAME	VARCHAR(128)	reserved Name of the edition in which the object is actual
DROPPED	VARCHAR(3)	Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO)

DBA_PACKAGE_PRIVS

DBA_PACKAGE_PRIVS describes all packages grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure, function or package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure, function or package
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure, function or package
PRIVILEGE	VARCHAR(32)	Privilege on the procedure, function or package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_PROCEDURES

DBA_PROCEDURES lists all function, procedures or package

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of function, procedures or package
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures or package
PROCEDURE_NAME	VARCHAR(128)	Name when a procedures in package
OBJECT_ID	NUMBER	ID of a function, procedures or package
SUBPROGRAM_ID	NUMBER	ID of procedures in package
OVERLOAD	VARCHAR(32)	ID of overloading procedure in package
OBJECT_TYPE	VARCHAR(32)	Type of function, procedures or package
AGGREGATE	VARCHAR(3)	Indicate whether the procedure is an aggreage function(YES) or not(NO)
PIPELINED	VARCHAR(3)	Indicate whether the procedure is a pipelined table function(YES) or not(NO)
IMPLTYPEOWNER	VARCHAR(128)	Name of the owner of the implementation type, if any
IMPLTYPENAME	VARCHAR(128)	Name of the implementation type, if any
PARALLEL	VARCHAR(3)	Indicates whether the procedure or function is parallel-enabled (YES) or not (NO)
INTERFACE	VARCHAR(3)	YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO
DETERMINISTIC	VARCHAR(3)	YES, if the procedure/function is declared to be deterministic; otherwise NO
AUTHID	VARCHAR(32)	Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker)

DBA_PROC_PRIVS

DBA_PROC_PRIVS describes the procedure grants, for which the current user is the procedure owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure, function or package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure, function or package
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure, function or package
PRIVILEGE	VARCHAR(32)	Privilege on the procedure, function or package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_PROFILES

DBA_PROFILES displays all profiles and their limits.

Column information
Column name	Data type	Description
PROFILE_NAME	VARCHAR(128)	Profile name
RESOURCE_NAME	VARCHAR(128)	Resource name
RESOURCE_TYPE	VARCHAR(32)	Indicates whether the resource profile is a KERNEL or a PASSWORD parameter
LIMIT_VALUE	LONG VARCHAR	Limit placed on this resource for this profile
COMMON	VARCHAR(3)	Indicates whether a given profile is common. (YES or NO)

DBA_RECYCLEBIN

DBA_RECYCLEBIN describes all recycle bins in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
SCHEMA_NAME	VARCHAR(128)	Schema name of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
ORIGINAL_NAME	VARCHAR(128)	Original name of the object
OPERATION	VARCHAR(4)	Operation carried out on the object
OBJECT_TYPE	VARCHAR(32)	Type of the object
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the object
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Created time of the object
DROPPED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Dropped time of the object
DROP_SCN	VARCHAR(128)	System change number (SCN) of the transaction which moved the object to the recycle bin
DROP_GCN	NUMBER	Global change number (GCN) of the transaction which moved the object to the recycle bin
DROP_DCN	NUMBER	Domain change number (DCN) of the transaction which moved the object to the recycle bin
DROP_LCN	NUMBER	Local change number (LCN) of the transaction which moved the object to the recycle bin
CAN_UNDROP	VARCHAR(3)	Indicates whether the object can be undropped (YES) or not (NO)
CAN_PURGE	VARCHAR(3)	Indicates whether the object can be purged (YES) or not (NO)
BASE_OBJECT	NUMBER	Object number of the base object
PURGE_OBJECT	NUMBER	Object number for the object which gets purged

DBA_ROLES

DBA_ROLES describes all roles in the database.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
ROLE_ID	NUMBER	ID number of the role
PASSWORD_REQUIRED	VARCHAR(8)	This column is deprecated in favor of the AUTHENTICATION_TYPE column
AUTHENTICATION_TYPE	VARCHAR(4)	Indicates the authentication mechanism for the role
COMMON	VARCHAR(3)	Indicates whether a given role is common. (YES or NO)
IS_BUILTIN	VARCHAR(1)	Denotes whether the role was created, and is maintained, by GOLDILOCKS.
INHERITED	VARCHAR(3)	Indicates whether the role was inherited from another container (YES) or not (NO)
IMPLICIT	VARCHAR(3)	Indicates whether the role is a common role created by an implicit application (YES) or not (NO)
EXTERNAL_NAME	VARCHAR(4000)	For a global role, the external name refers to the DN of a group from a directory service that is mapped to the global role. This is not applicable to a local role.

DBA_ROLE_PRIVS

DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role receiving the grant
GRANTED_ROLE	VARCHAR(128)	Granted role name
ADMIN_OPTION	VARCHAR(3)	Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)
DELEGATE_OPTION	VARCHAR(3)	Indicates whether the grant was with the DELEGATE OPTION (YES) or not (NO)
DEFAULT_ROLE	VARCHAR(3)	Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)
COMMON	VARCHAR(3)	Indicates how the grant was made. (YES or NO)
INHERITED	VARCHAR(3)	Indicates whether the role grant was inherited from another container (YES) or not (NO)

DBA_SCHEMAS

Identify the schemata in the database.

Column information
Column name	Data type	Description
SCHEMA_OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Created time of the schema
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Last modified time of the schema
COMMENTS	VARCHAR(1024)	Comments of the schema

DBA_SCHEMA_PATH

DBA_SCHEMA_PATH describes the schema search order of all authorizations in the database.

Column information
Column name	Data type	Description
AUTH_NAME	VARCHAR(128)	Name of the authorization
SCHEMA_NAME	VARCHAR(128)	Name of the schema
SEARCH_ORDER	NUMBER	Schema search order of the authorization

DBA_SCHEMA_PRIVS

DBA_SCHEMA_PRIVS describes all schema grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_SEQUENCES

DBA_SEQUENCES describes all sequences in the database.

Column information
Column name	Data type	Description
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Sequence name
MIN_VALUE	NUMBER	Minimum value of the sequence
MAX_VALUE	NUMBER	Maximum value of the sequence
INCREMENT_BY	NUMBER	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR(1)	Indicates whether the sequence wraps around on reaching the limit (Y) or not (N)
ORDER_FLAG	VARCHAR(1)	reserved Indicates whether sequence numbers are generated in order (Y) or not (N)
CACHE_SIZE	NUMBER	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache.
COMMENTS	VARCHAR(1024)	Comments of the sequence

DBA_SEQ_PRIVS

DBA_SEQ_PRIVS describes all sequence grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_SHARD_KEY_COLUMNS

DBA_SHARD_KEY_COLUMNS describes shard key columns of all shareded tables in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Column name of the shard key
COLUMN_POSITION	NUMBER	Position of the column within the shard key

DBA_SOURCE

DBA_SOURCE describes the text source of the stored objects accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of object
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER
LINE	NUMBER	Line number of this line of source
TEXT	LONG VARCHAR	Text source of the strored object
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

DBA_STAT_COLUMN_GROUP

DBA_STAT_COLUMN_GROUP describes each column group statistics.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
STAT_NAME	VARCHAR(128)	Statistics name
COLUMN_GROUPS	VARCHAR(1024)	Column names of the column group statistics
NUM_DISTINCT	NUMBER	Number of distinct values in the column group statistics
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column group statistics
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column group statistics was most recently analyzed

DBA_STAT_SYSTEM

DBA_STAT_SYSTEM describes analyzed system statistics.

Column information
Column name	Data type	Description
CPU_OPS	NATIVE_BIGINT	OPS(operations per second) of CPU
NETWORK_IOPS	NATIVE_BIGINT	IOPS(I/O operations per second) of Cluster NETWORK
NETWORK_BUFSIZE	NATIVE_BIGINT	buffer size of Cluster NETWORK when analyzed
BUFFER_MISS_PERCENT	NATIVE_BIGINT	disk buffer miss percent
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed

DBA_SYS_PRIVS

DBA_SYS_PRIVS describes all system (database, tablespace, schema) privileges in the database.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the grantee
PRIVILEGE	VARCHAR(256)	System(database, tablespace, schema) privilege
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
ADMIN_OPTION	VARCHAR(3)	equal to GRANTABLE column

DBA_SYNONYMS

DBA_SYNONYMS describes all synonyms in the database.

Column information
Column name	Data type	Description
SYNONYM_OWNER	VARCHAR(128)	Owner of the synonym
SYNONYM_SCHEMA	VARCHAR(128)	Schema of the synonym
SYNONYM_NAME	VARCHAR(128)	Synonym name
OBJECT_SCHEMA_NAME	VARCHAR(128)	Object schema name
OBJECT_NAME	VARCHAR(128)	Object name
DB_LINK	VARCHAR(128)	Reserved for future use

DBA_TABLES

DBA_TABLES describes all relational tables in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	reserved If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)
RESULT_CACHE	VARCHAR(32)	reserved Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL )

DBA_TABLESPACES

DBA_TABLESPACES describes all tablespaces in the database.

Column information
Column name	Data type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
BLOCK_SIZE	NUMBER	Tablespace block size
INITIAL_EXTENT	NUMBER	reserved Default initial extent size (in bytes)
NEXT_EXTENT	NUMBER	reserved Default incremental extent size (in bytes)
MIN_EXTENTS	NUMBER	reserved Default minimum number of extents
MAX_EXTENTS	NUMBER	reserved Default maximum number of extents
MAX_SIZE	NUMBER	reserved Default maximum size of segments
PCT_INCREASE	NUMBER	reserved Default percent increase for extent size
MIN_EXTLEN	NUMBER	reserved Minimum extent size for this tablespace (in bytes)
STATUS	VARCHAR(32)	Tablespace status: the value in ( ONLINE, OFFLINE, READ ONLY )
CONTENTS	VARCHAR(32)	Tablespace contents: the value in ( SYSTEM, DATA, TEMPORARY, UNDO )
LOGGING	VARCHAR(32)	Default logging attribute: LOGGING, NOLOGGING
FORCE_LOGGING	VARCHAR(3)	reserved Indicates whether the tablespace is under force logging mode (YES) or not (NO)
EXTENT_MANAGEMENT	VARCHAR(32)	reserved Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL)
ALLOCATION_TYPE	VARCHAR(32)	reserved Type of extent allocation in effect for the tablespace: the value in ( SYSTEM, UNIFORM, USER )
PLUGGED_IN	VARCHAR(3)	reserved Indicates whether the tablespace is plugged in (YES) or not (NO)
SEGMENT_SPACE_MANAGEMENT	VARCHAR(32)	reserved Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
DEF_TAB_COMPRESSION	VARCHAR(32)	reserved Indicates whether default table compression is enabled (ENABLED) or not (DISABLED)
RETENTION	VARCHAR(32)	reserved Undo tablespace retention: the value in ( GUARANTEE, NOGUARANTEE, NOT APPLY )
BIGFILE	VARCHAR(3)	reserved Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)
PREDICATE_EVALUATION	VARCHAR(32)	reserved Indicates whether predicates are evaluated by host (HOST) or by storage (STORAGE)
ENCRYPTED	VARCHAR(3)	reserved Indicates whether the tablespace is encrypted (YES) or not (NO)
COMPRESS_FOR	VARCHAR(32)	reserved Indicates whether the tablespace is encrypted (YES) or not (NO)

DBA_TAB_COLS

DBA_TAB_COLS describes the columns (including hidden columns) of all tables, views, and clusters in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HIDDEN_COLUMN	VARCHAR(3)	Indicates whether the column is a hidden column (YES) or not (NO)
VIRTUAL_COLUMN	VARCHAR(3)	reserved Indicates whether the column is a virtual column (YES) or not (NO)
SEGMENT_COLUMN_ID	NUMBER	Sequence number of the column in the segment
INTERNAL_COLUMN_ID	NUMBER	Internal sequence number of the column
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
QUALIFIED_COL_NAME	VARCHAR(4000)	Qualified column name
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

DBA_TAB_COLUMNS

DBA_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

DBA_TAB_COMMENTS

DBA_TAB_COMMENTS displays comments on all tables and views in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
TABLE_TYPE	VARCHAR(32)	Type of the object
COMMENTS	VARCHAR(1024)	Comment on the object

DBA_TAB_IDENTITY_COLS

DBA_TAB_IDENTITY_COLS describes all table identity columns.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the identity column
GENERATION_TYPE	VARCHAR(32)	Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT
IDENTITY_OPTIONS	VARCHAR(1024)	Options for the identity column sequence generator

DBA_TAB_PLACE

DBA_TAB_PLACE describes node placement of all cluster tables in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
GROUP_ID	NUMBER	Group identifier of the node where the table placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the table placed
MEMBER_ID	NUMBER	Member identifier of the node where the table placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the table placed
MEMBER_POSITION	NUMBER	Member position of the node where the table placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
IS_UPDATE_MASTER	BOOLEAN	whether the cluster member is update master or not
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
SCN	VARCHAR(64)	table scn of the node where the table placed
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks of the node where the table placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed

DBA_TAB_PRIVS

DBA_TAB_PRIVS describes all object grants in the database.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

DBA_TAB_SHARDS

DBA_TAB_SHARDS describes shard information of all sharded tables in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_NAME	VARCHAR(128)	Shard name
SHARD_NUMBER	NUMBER	Shard number
SHARD_DEFINITION	LONG VARCHAR	Shard definition (if hash sharded, the value is null)
GROUP_ID	NUMBER	Group identifier where the shard placed
GROUP_NAME	VARCHAR(128)	Group Name where the shard placed
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

DBA_TBS_PRIVS

DBA_TBS_PRIVS describes all tablespace grants in the database.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
PRIVILEGE	VARCHAR(32)	Privilege on the tablespace
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

DBA_TRIGGERS

DBA_TRIGGERS describes all triggers in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	Schema Name of the trigger
TRIGGER_NAME	VARCHAR(128)	Name of the trigger
TRIGGER_TYPE	VARCHAR(16)	When the trigger fires: the value in ( BEFORE STATEMENT, BEFORE EACH ROW, AFTER STATEMENT, AFTER EACH ROW, INSTEAD OF, COMPOUND )
TRIGGERING_EVENT	VARCHAR(32)	DML, DDL, or database event that fires the trigger
TABLE_OWNER	VARCHAR(128)	Owner of the table on which the trigger is defined
TABLE_SCHEMA	VARCHAR(128)	Schema Name of the table on which the trigger is defined
BASE_OBJECT_TYPE	VARCHAR(16)	Base object on which the trigger is defined: the value in ( TABLE, VIEW, SCHEMA, DATABASE )
TABLE_NAME	VARCHAR(128)	If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW then this column indicates the table or view name on which the trigger is defined
COLUMN_NAME	VARCHAR(4000)	Name of the nested table column (if a nested table trigger), else NULL
REFERENCING_NAMES	VARCHAR(1024)	Names used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSE	LONG VARCHAR	Must evaluate to TRUE for TRIGGER_BODY to execute
STATUS	VARCHAR(8)	Indicates whether the trigger is enabled (ENABLED) or disabled (DISABLED); a disabled trigger will not fire
DESCRIPTION	LONG VARCHAR	Trigger description; useful for re-creating a trigger creation statement
ACTION_TYPE	VARCHAR(16)	Action type of the trigger body: the value in ( CALL, PSM BLOCK )
TRIGGER_BODY	LONG VARCHAR	Statements executed by the trigger when it fires
CROSSEDITION	VARCHAR(3)	Type of crossedition trigger: the value in ( FORWARD, REVERSE, NO )
BEFORE_STATEMENT	VARCHAR(3)	Indicates whether the trigger has a BEFORE STATEMENT section (YES) or not (NO)
BEFORE_ROW	VARCHAR(3)	Indicates whether the trigger has a BEFORE EACH ROW section (YES) or not (NO)
AFTER_ROW	VARCHAR(3)	Indicates whether the trigger has an AFTER EACH ROW section (YES) or not (NO)
AFTER_STATEMENT	VARCHAR(3)	Indicates whether the trigger has an AFTER STATEMENT section (YES) or not (NO)
INSTEAD_OF_ROW	VARCHAR(3)	Indicates whether the trigger has an INSTEAD OF section (YES) or not (NO)
FIRE_ONCE	VARCHAR(3)	Indicates whether the trigger will fire only for user processes making changes (YES) or whether the trigger will also fire for Replication Apply or SQL Apply processes (NO)
APPLY_SERVER_ONLY	VARCHAR(3)	Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process (YES) or not (NO). If set to YES, then the setting of FIRE_ONCE does not matter
COMMENTS	VARCHAR(1024)	Comment on the trigger

DBA_USERS

DBA_USERS describes all users of the database.

Column information
Column name	Data type	Description
USERNAME	VARCHAR(128)	Name of the user
USER_ID	NUMBER	ID number of the user
PASSWORD	VARCHAR(128)	encrypted password
ACCOUNT_STATUS	VARCHAR(32)	Account status: the value in ( OPEN, EXPIRED, EXPIRED(GRACE), LOCKED(TIMED), LOCKED, EXPIRED & LOCKED(TIMED), EXPIRED(GRACE) & LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED )
LOCK_DATE	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp the account was locked if account status was LOCKED
EXPIRY_DATE	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp of expiration of the account
FAILED_LOGIN_ATTEMPTS	NUMBER	Consecutive failed login attempts count
DEFAULT_TABLESPACE	VARCHAR(128)	Default tablespace for data
TEMPORARY_TABLESPACE	VARCHAR(128)	Name of the default tablespace for temporary tables or the name of a tablespace group
INDEX_TABLESPACE	VARCHAR(128)	Default tablespace for index
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	User creation timestamp
PROFIL_NAME	VARCHAR(128)	User resource profile name
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR(128)	reserved Initial resource consumer group for the user
EXTERNAL_NAME	VARCHAR(128)	reserved User external name
PASSWORD_VERSIONS	VARCHAR(32)	reserved Shows the list of versions of the password hashes (verifiers).
EDITIONS_ENABLED	VARCHAR(1)	Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
AUTHENTICATION_TYPE	VARCHAR(32)	reserved Indicates the authentication mechanism for the user.

DBA_VIEWS

DBA_VIEWS describes all views in the database.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the view
VIEW_SCHEMA	VARCHAR(128)	Schema of the view
VIEW_NAME	VARCHAR(128)	Name of the view
TEXT_LENGTH	NUMBER	Length of the view text
TEXT	LONG VARCHAR	View text
TYPE_TEXT_LENGTH	NUMBER	reserved Length of the type clause of the typed view
TYPE_TEXT	VARCHAR(4000)	reserved Type clause of the typed view
OID_TEXT_LENGTH	NUMBER	reserved Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR(4000)	reserved WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR(128)	reserved Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR(32)	reserved Type of the view if the view is a typed view
SUPERVIEW_NAME	VARCHAR(128)	reserved Name of the superview
EDITIONING_VIEW	VARCHAR(1)	Reserved for future use
READ_ONLY	VARCHAR(1)	Indicates whether the view is read-only (Y) or not (N)

USER_family Views

It retrieves information about objects owned by the current user.

USER_ALL_TABLES

USER_ALL_TABLES describes the object tables and relational tables owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	reserved If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
OBJECT_ID_TYPE	VARCHAR(32)	reserved Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED
TABLE_TYPE_OWNER	VARCHAR(128)	reserved If an object table, owner of the type from which the table is created
TABLE_TYPE	VARCHAR(128)	reserved If an object table, type of the table
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)

USER_ARGUMENTS

USER_ARGUMENTS lists all arguments of functions, procedures.

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures
PACKAGE_NAME	VARCHAR(128)	Package Name of function, procedures
OBJECT_ID	NUMBER	ID of a function, procedures
SUBPROGRAM_ID	NUMBER	ID of procedures in package
ARGUMENT_NAME	VARCHAR(128)	Name of argument or attribute name of record type argument
POSITION	NUMBER	Position of argument or position of attribute in record type
SEQUENCE	NUMBER	Sequential order of argument and its attributes
DATA_LEVEL	NUMBER	Nesting depth of the argument for composite types
DATA_TYPE	VARCHAR(128)	Data type of the argument
DEFAULTED	VARCHAR(1)	Whether or not the argument is defaulted
DEFAULT_VALUE	VARCHAR(1)	Reserved for future use
DEFAULT_LENGTH	VARCHAR(1)	Reserved for future use
IN_OUT	VARCHAR(32)	Direction of the argument (IN, OUT, IN/OUT)
DATA_LENGTH	NUMBER	Length of the column(in bytes)
DATA_PRECISION	NUMBER	Length in decimal digits(NUMBER) or binary digits(FLOAT)
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
RADIX	NUMBER	Argument radix for a number
CHARACTER_SET_NAME	VARCHAR(128)	Character set name for the argument
TYPE_OWNER	VARCHAR(128)	Owner of the type of the argument
TYPE_NAME	VARCHAR(128)	Name of the type of the argument
TYPE_SUBNAME	VARCHAR(128)	Name of the type of the argument declared in package
TYPE_LINK	VARCHAR(128)	Name of the type of the argument declared in a remote package
PLS_TYPE	VARCHAR(128)	Name of the type of the argument at PSM
CHAR_LENGTH	NUMBER	Character limit for string datatypes
CHAR_USED	VARCHAR(1)	Whether the byte limit(B) or char limit(C) is official for the string
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

USER_CATALOG

USER_CATALOG lists tables, views, synonyms, and sequences owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_NAME	VARCHAR(128)	Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_TYPE	VARCHAR(32)	Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED

USER_COL_COMMENTS

USER_COL_COMMENTS displays comments on the columns of the tables and views owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
COMMENTS	VARCHAR(1024)	Comment on the column

USER_CLUSTER_TABLES

USER_CLUSTER_TABLES describes all cluster tables owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_PLACEMENT	VARCHAR(32)	Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP)
SHARD_COUNT	NUMBER	Shard count of the table (if cloned table, the value is null)
SHARD_KEY_COUNT	NUMBER	Shard key column count of the table (if cloned table, the value is null)
HAS_GSI	VARCHAR(3)	Indicate whether the table has global secondary index: (YES) or (NO)
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

USER_COL_PRIVS

USER_COL_PRIVS describes the column object grants for which the current user is the object owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_COL_PRIVS_MADE

USER_COL_PRIVS_MADE describes the column object grants for which the current user is the object owner.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_COL_PRIVS_RECD

USER_COL_PRIVS_RECD describes the column object grants for which the current user is the grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the column
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_CONSTRAINTS

USER_CONSTRAINTS describes all constraint definitions on tables owned by the current user.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
CONSTRAINT_TYPE	VARCHAR(1)	Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity )
TABLE_OWNER	VARCHAR(128)	Owner of the table (or view) associated with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table (or view) associated with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table (or view) associated with the constraint definition
SEARCH_CONDITION	LONG VARCHAR	Text of search condition for a check constraint
R_OWNER	VARCHAR(128)	Owner of the unique constraint definition for the referenced table
R_SCHEMA	VARCHAR(128)	Schema of the unique constraint definition for the referenced table
R_CONSTRAINT_NAME	VARCHAR(128)	Name of the unique constraint definition for the referenced table
DELETE_RULE	VARCHAR(32)	Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
UPDATE_RULE	VARCHAR(32)	Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
STATUS	VARCHAR(32)	Enforcement status of the constraint: the value in ( ENABLED, DISABLE )
DEFERRABLE	VARCHAR(32)	Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE)
DEFERRED	VARCHAR(32)	Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE)
VALIDATED	VARCHAR(32)	Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED )
GENERATED	VARCHAR(32)	Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME)
BAD	VARCHAR(32)	reserved Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL)
RELY	VARCHAR(32)	reserved When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL)
LAST_CHANGE	TIMESTAMP(6) WITHOUT TIME ZONE	When the constraint was last enabled or disabled
INDEX_OWNER	VARCHAR(128)	Owner of the index associated with the key constraint
INDEX_SCHEMA	VARCHAR(128)	Schema of the index associated with the key constraint
INDEX_NAME	VARCHAR(128)	Name of the index associated with the key constraint
INVALID	VARCHAR(32)	Indicates whether the constraint is invalid (INVALID) or not (NULL)
VIEW_RELATED	VARCHAR(32)	reserved Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL)
DROPPED	VARCHAR(3)	Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the constraint definition

USER_CONS_COLUMNS

USER_CONS_COLUMNS describes columns that are owned by the current user and that are specified in constraint definitions.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the constraint definition
CONSTRAINT_SCHEMA	VARCHAR(128)	Schema of the constraint definition
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint definition
TABLE_OWNER	VARCHAR(128)	Owner of the table with the constraint definition
TABLE_SCHEMA	VARCHAR(128)	Schema of the table with the constraint definition
TABLE_NAME	VARCHAR(128)	Name of the table with the constraint definition
COLUMN_NAME	VARCHAR(128)	Name of the column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER	Original position of the column or attribute in the definition of the object

USER_DEPENDENCIES

USER_DEPENDENCIES describes dependencies between objects accessible to the current user

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_OWNER	VARCHAR(128)	Owner of the referenced object
REFERENCED_SCHEMA_NAME	VARCHAR(128)	Schema Name of the referenced object
REFERENCED_TYPE	VARCHAR(32)	Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER
REFERENCED_LINK_NAME	VARCHAR(128)	Name of the link to the parent object
REFERENCED_NAME	VARCHAR(128)	Name of the referenced object
DEPENDENCY_TYPE	VARCHAR(32)	Indicates whether the dependency is a REF dependency (REF) or not (HARD)

USER_EXTENTS

USER_EXTENTS describes the extents comprising the segments owned by the current user's objects.

Column information
Column name	Data type	Description
SEGMENT_SCHEMA	VARCHAR(128)	Schema of the segment associated with the extent
SEGMENT_NAME	VARCHAR(128)	Name of the segment associated with the extent
PARTITION_NAME	VARCHAR(128)	reserved Object Partition Name (Set to NULL for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(32)	Type of the segment: TABLE, INDEX
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the extent
EXTENT_ID	NUMBER	reserved Extent number in the segment
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in Oracle blocks

USER_GLOBAL_SECONDARY_INDEXES

USER_GLOBAL_SECONDARY_INDEXES describes the global secondary indexes on the tables owned by the current user.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the global secondary index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	Indicates whether or not changes to the global secondary index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the global secondary index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the global secondary index
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)

USER_GSI_PLACE

USER_GSI_PLACE describes node placement of all global secondary indexes on the tables owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the global secondary indexed object
TABLE_NAME	VARCHAR(128)	Name of the global secondary indexed object
GROUP_ID	NUMBER	Group identifier of the node where the global secondary index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the global secondary index placed
MEMBER_ID	NUMBER	Member identifier of the node where the global secondary index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the global secondary index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO)
BLOCKS	NUMBER	Number of used blocks of the node where the global secondary index placed

USER_HISTOGRAM_BALANCE

USER_HISTOGRAM_BALANCE describes each height-balanced histogram bucket owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of height-balanced histogram
BUCKET_ACCU_HEIGHT	NUMBER	Accumulated height of the height-balanced histogram bucket
BUCKET_VALUE	VARCHAR(128)	Bucket value

USER_HISTOGRAM_FREQUENCY

USER_HISTOGRAM_FREQUENCY describes each frequency histogram bucket owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARACHAR(128)	Column name
BUCKET_NUMBER	NUMBER	Bucket number of frequency histogram
BUCKET_HEIGHT	NUMBER	Bucket height of the frequency histogram bucket
SAMPLE_COUNT	NUMBER	Sample count of frequency histogram
BUCKET_VALUE	VARCHAR(128)	Bucket value

USER_INDEXES

USER_INDEXES describes indexes owned by the current user.

Column information
Column name	Data type	Description
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
INDEX_TYPE	VARCHAR(32)	Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN )
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
TABLE_TYPE	VARCHAR(32)	Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE )
UNIQUENESS	VARCHAR(32)	Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE)
COMPRESSION	VARCHAR(32)	reserved Indicates whether index compression is enabled (ENABLED) or not (DISABLED)
PREFIX_LENGTH	NUMBER	reserved Number of columns in the prefix of the compression key
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the index
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of secondary extents
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
PCT_THRESHOLD	NUMBER	reserved Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER	reserved Column ID of the last column to be included in index-organized table primary key (non-overflow) index
FREELISTS	NUMBER	reserved Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to this segment
PCT_FREE	NUMBER	Minimum percentage of free space in a block
LOGGING	VARCHAR(3)	ndicates whether or not changes to the index are logged: (YES) or (NO)
BLOCKS	NUMBER	Number of used blocks in the index
ANAL_BLOCKS	NUMBER	Number of used blocks in the index when most recently analyzed
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index
BLEVEL	NUMBER	B-Tree level (depth of the index from its root block to its leaf blocks)
LEAF_BLOCKS	NUMBER	Number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	Number of distinct indexed values.
AVG_LEAF_BLOCKS_PER_KEY	NUMBER	reserved Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer
AVG_DATA_BLOCKS_PER_KEY	NUMBER	reserved Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer
CLUSTERING_FACTOR	NUMBER	Indicates the amount of order of the rows in the table based on the values of the index
STATUS	VARCHAR(32)	Indicates whether a nonpartitioned index is VALID or DISABLE
NUM_ROWS	NUMBER	reserved Number of rows in the index
SAMPLE_SIZE	NUMBER	Size of the sample used to analyze the index
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this index was most recently analyzed
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the index, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the indexes to be scanned, or DEFAULT
PARTITIONED	VARCHAR(3)	reserved Indicates whether the index is partitioned (YES) or not (NO)
TEMPORARY	VARCHAR(1)	Indicates whether the index is on a temporary table (Y) or not (N)
GENERATED	VARCHAR(1)	Indicates whether the name of the index is system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for index blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for index blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for index blocks
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
PCT_DIRECT_ACCESS	NUMBER	reserved For a secondary index on an index-organized table, the percentage of rows with VALID guess
ITYP_OWNER	VARCHAR(128)	reserved For a domain index, the owner of the indextype
ITYP_NAME	VARCHAR(128)	reserved For a domain index, the name of the indextype
PARAMETERS	VARCHAR(1024)	reserved For a domain index, the parameter string
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)
DOMIDX_STATUS	VARCHAR(32)	reserved Status of a domain index
DOMIDX_OPSTATUS	VARCHAR(32)	reserved Status of the operation on a domain index
FUNCIDX_STATUS	VARCHAR(32)	reserved Status of a function-based index
JOIN_INDEX	VARCHAR(3)	reserved Indicates whether the index is a join index (YES) or not (NO)
IOT_REDUNDANT_PKEY_ELIM	VARCHAR(3)	reserved Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO)
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
VISIBILITY	VARCHAR(3)	reserved Indicates whether the index is VISIBLE or INVISIBLE to the optimizer
DOMIDX_MANAGEMENT	VARCHAR(32)	reserved If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the index segment has been created (YES) or not (NO)
COMMENTS	VARCHAR(1024)	Comments of the index
EMPTY_BLOCKS	NUMBER	Number of empty blocks in the index

USER_IND_COLUMNS

USER_IND_COLUMNS describes the columns of the indexes owned by the current user and columns of indexes on tables owned by the current user.

Column information
Column name	Data type	Description
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_SCHEMA	VARCHAR(128)	Schema of the table or cluster
TABLE_NAME	VARCHAR(128)	Name of the table or cluster
COLUMN_NAME	VARCHAR(128)	Column name or attribute of the object type column
COLUMN_POSITION	NUMBER	Position of the column or attribute within the index
COLUMN_LENGTH	NUMBER	Indexed length of the column
CHAR_LENGTH	NUMBER	reserved Maximum codepoint length of the column
DESCEND	VARCHAR(32)	Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC)
NULL_ORDER	VARCHAR(32)	Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST)

USER_IND_PLACE

USER_IND_PLACE describes node placement of the indexes owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
INDEX_SCHEMA	VARCHAR(128)	Schema of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_SCHEMA	VARCHAR(128)	Schema of the indexed object
TABLE_NAME	VARCHAR(128)	Name of the indexed object
GROUP_ID	NUMBER	Group identifier of the node where the index placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the index placed
MEMBER_ID	NUMBER	Member identifier of the node where the index placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the index placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
DROPPED	VARCHAR(3)	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO)
DISTINCT_KEYS	NUMBER	(deprecated)
SAMPLE_SIZE	NUMBER	(deprecated)
BLOCKS	NUMBER	Number of used blocks of the node where the index placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	(deprecated)

USER_LIBRARIES

USER_LIBRARIES describes the libraries owned by the current user.

Column information
Column name	Data type	Description
LIBRARY_SCHEMA	VARCHAR(128)	Schema Name of Library
LIBRARY_NAME	VARCHAR(128)	Name of Library
FILE_SPEC	LONG VARCHAR	Operating system file specification associated with the library
DYNAMIC	VARCHAR(1)	Indicates whether the library is dynamically loadable (Y) or not (N)
STATUS	VARCHAR(32)	Status of the library : the value in ( VALID, INVALID, N/A )
AGENT	VARCHAR(128)	Agent of the library
LEAF_FILENAME	VARCHAR(4000)	Leaf filename of the library
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates
COMMENTS	VARCHAR(1024)	Comment on the library

USER_LIBRARY_PRIVS

USER_LIBRARY_PRIVS describes the library grants for which the current user is the library owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_LIBRARY_PRIVS_MADE

USER_LIBRARY_PRIVS_MADE describes the library grants for which the current user is the library owner.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_LIBRARY_PRIVS_RECD

USER_LIBRARY_PRIVS_RECD describes the library grants for which the current user is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	Privilege on the library
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_OBJECTS

USER_OBJECTS describes all objects owned by the current user.

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
SUBOBJECT_NAME	VARCHAR(128)	Name of the subobject (for example, partition)
OBJECT_ID	NUMBER	Dictionary object number of the object
DATA_OBJECT_ID	NUMBER	Dictionary object number of the segment that contains the object
OBJECT_TYPE	VARCHAR(32)	Type of the object (such as TABLE, INDEX)
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the creation of the object
LAST_DDL_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp for the last modification of the object resulting from a DDL statement
TIMESTAMP	VARCHAR(32)	Timestamp for the specification of the object (character data)
STATUS	VARCHAR(32)	reserved Status of the object: the value in ( VALID, INVALID, N/A )
TEMPORARY	VARCHAR(1)	Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N)
GENERATED	VARCHAR(1)	Indicates whether the name of this object was system-generated (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)
NAMESPACE	NUMBER	Namespace for the object
EDITION_NAME	VARCHAR(128)	reserved Name of the edition in which the object is actual
DROPPED	VARCHAR(3)	Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO)

USER_PACKAGE_PRIVS

USER_PACKAGE_PRIVS describes the package grants for which the current user is the package owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_PACKAGE_PRIVS_MADE

USER_PACKAGE_PRIVS_MADE describes the package grants for which the current user is the package owner.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_PACKAGE_PRIVS_RECD

USER_PACKAGE_PRIVS_RECD describes the package grants for which the current user is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the package
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the package
PROCEDURE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Privilege on the package
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_PROCEDURES

USER_PROCEDURES lists of procedures owned by the current user.

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema Name of function, procedures or package
OBJECT_NAME	VARCHAR(128)	Name of function, procedures or package
PROCEDURE_NAME	VARCHAR(128)	Name when a procedures in package
OBJECT_ID	NUMBER	ID of a function, procedures or package
SUBPROGRAM_ID	NUMBER	ID of procedures in package
OVERLOAD	VARCHAR(32)	ID of overloading procedure in package
OBJECT_TYPE	VARCHAR(32)	Type of function, procedures or package
AGGREGATE	VARCHAR(3)	Indicate whether the procedure is an aggreage function(YES) or not(NO)
PIPELINED	VARCHAR(3)	Indicate whether the procedure is a pipelined table function(YES) or not(NO)
IMPLTYPEOWNER	VARCHAR(128)	Name of the owner of the implementation type, if any
IMPLTYPENAME	VARCHAR(128)	Name of the implementation type, if any
PARALLEL	VARCHAR(3)	Indicates whether the procedure or function is parallel-enabled (YES) or not (NO)
INTERFACE	VARCHAR(3)	YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO
DETERMINISTIC	VARCHAR(3)	YES, if the procedure/function is declared to be deterministic; otherwise NO
AUTHID	VARCHAR(32)	Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker)

USER_PROC_PRIVS

USER_PROC_PRIVS describes the procedure grants for which the current user is the procedure owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_PROC_PRIVS_MADE

USER_PROC_PRIVS_MADE describes the procedure grants for which the current user is the procedure owner or grantor.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_PROC_PRIVS_RECD

USER_PROC_PRIVS_RECD describes the procedure grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
PROCEDURE_OWNER	VARCHAR(128)	Owner of the procedure and function
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the procedure and function
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure and function
PRIVILEGE	VARCHAR(32)	Privilege on the procedure and function
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_RECYCLEBIN

USER_RECYCLEBIN describes recycle bins owned by the current user.

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema name of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
ORIGINAL_NAME	VARCHAR(128)	Original name of the object
OPERATION	VARCHAR(4)	Operation carried out on the object
OBJECT_TYPE	VARCHAR(32)	Type of the object
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the object
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Created time of the object
DROPPED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Dropped time of the object
DROP_SCN	VARCHAR(128)	System change number (SCN) of the transaction which moved the object to the recycle bin
DROP_GCN	NUMBER	Global change number (GCN) of the transaction which moved the object to the recycle bin
DROP_DCN	NUMBER	Domain change number (DCN) of the transaction which moved the object to the recycle bin
DROP_LCN	NUMBER	Local change number (LCN) of the transaction which moved the object to the recycle bin
CAN_UNDROP	VARCHAR(3)	Indicates whether the object can be undropped (YES) or not (NO)
CAN_PURGE	VARCHAR(3)	Indicates whether the object can be purged (YES) or not (NO)
BASE_OBJECT	NUMBER	Object number of the base object
PURGE_OBJECT	NUMBER	Object number for the object which gets purged

USER_ROLE_PRIVS

USER_ROLE_PRIVS describes the roles granted to the current user.

Column information
Column name	Data type	Description
USERNAME	VARCHAR(128)	Name of the user, or PUBLIC
GRANTED_ROLE	VARCHAR(128)	Name of the role granted to the user
ADMIN_OPTION	VARCHAR(3)	Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)
DELEGATE_OPTION	VARCHAR(3)	Indicates whether the grant was with the DELEGATE OPTION (YES) or not (NO)
DEFAULT_ROLE	VARCHAR(3)	Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)
OS_GRANTED	VARCHAR(3)	Indicates whether the role was granted by the operating system (YES) or not (NO); occurs if the OS_ROLES initialization parameter is true
COMMON	VARCHAR(3)	Indicates how the grant was made. (YES or NO)
INHERITED	VARCHAR(3)	Indicates whether the role grant was inherited from another container (YES) or not (NO)

USER_SCHEMAS

Identify the schemata in a catalog that are owned by current user.

Column information
Column name	Data type	Description
SCHEMA_OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Created time of the schema
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	Last modified time of the schema
COMMENTS	VARCHAR(1024)	Comments of the schema

USER_SCHEMA_PATH

USER_SCHEMA_PATH describes the schema search order of the current user, for naming resolution of unqualified SQL schema objects.

Column information
Column name	Data type	Description
AUTH_NAME	VARCHAR(128)	Name of the user
SCHEMA_NAME	VARCHAR(128)	Name of the schema
SEARCH_ORDER	NUMBER	Schema search order of the user

USER_SCHEMA_PRIVS

USER_SCHEMA_PRIVS describes the schema grants, for which the current user is the schema owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SCHEMA_PRIVS_MADE

USER_SCHEMA_PRIVS_MADE describes the schema grants for which the current user is the schema owner.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SCHEMA_PRIVS_RECD

USER_SCHEMA_PRIVS_RECD describes the schema grants for which the current user is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
PRIVILEGE	VARCHAR(32)	Privilege on the schema
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SEQUENCES

USER_SEQUENCES describes all sequences owned by the current user.

Column information
Column name	Data type	Description
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Sequence name
MIN_VALUE	NUMBER	Minimum value of the sequence
MAX_VALUE	NUMBER	Maximum value of the sequence
INCREMENT_BY	NUMBER	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR(1)	Indicates whether the sequence wraps around on reaching the limit (Y) or not (N)
ORDER_FLAG	VARCHAR(1)	reserved Indicates whether sequence numbers are generated in order (Y) or not (N)
CACHE_SIZE	NUMBER	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache.
COMMENTS	VARCHAR(1024)	Comments of the sequence

USER_SEQ_PRIVS

USER_SEQ_PRIVS describes the sequence grants for which the current user is the sequence owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SEQ_PRIVS_MADE

USER_SEQ_PRIVS_MADE describes the sequence grants for which the current user is the sequence owner.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SEQ_PRIVS_RECD

USER_SEQ_PRIVS_RECD describes the sequence grants for which the current user is the grantee.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Privilege on the sequence
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

USER_SHARD_KEY_COLUMNS

USER_SHARD_KEY_COLUMNS describes shard key columns of shareded tables owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Column name of the shard key
COLUMN_POSITION	NUMBER	Position of the column within the shard key

USER_SOURCE

USER_SOURCE describes the text source of the stored objects accessible to the current user.

Column information
Column name	Data type	Description
SCHEMA_NAME	VARCHAR(128)	Schema Name of object
NAME	VARCHAR(128)	Name of object
TYPE	VARCHAR(32)	Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER
LINE	NUMBER	Line number of this line of source
TEXT	LONG VARCHAR	Text source of the strored object
ORIGIN_CON_ID	VARCHAR(256)	ID of the container where the data originates

USER_STAT_COLUMN_GROUP

USER_STAT_COLUMN_GROUP describes each column group statistics owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
STAT_NAME	VARCHAR(128)	Statistics name
COLUMN_GROUPS	VARCHAR(1024)	Column names of the column group statistics
NUM_DISTINCT	NUMBER	Number of distinct values in the column group statistics
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column group statistics
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column group statistics was most recently analyzed

USER_SYNONYMS

USER_SYNONYMS describes all synonyms owned by the current user.

Column information
Column name	Data type	Description
SYNONYM_OWNER	VARCHAR(128)	Owner of the synonym
SYNONYM_SCHEMA	VARCHAR(128)	Schema of the synonym
SYNONYM_NAME	VARCHAR(128)	Synonym name
OBJECT_SCHEMA_NAME	VARCHAR(128)	Object schema name
OBJECT_NAME	VARCHAR(128)	Object name
DB_LINK	VARCHAR(128)	Reserved for future use

USER_SYS_PRIVS

USER_SYS_PRIVS describes system (database, tablespace, schema) privileges granted to the current user or PUBLIC.

Column information
Column name	Data type	Description
USERNAME	VARCHAR(128)	Name of the user, or PUBLIC
PRIVILEGE	VARCHAR(256)	System(database, tablespace, schema) privilege
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
ADMIN_OPTION	VARCHAR(3)	equal to GRANTABLE column

USER_TABLES

USER_TABLES describes the relational tables owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR(128)	reserved Name of the cluster
IOT_NAME	VARCHAR(128)	reserved Name of the index-organized table
STATUS	VARCHAR(32)	reserved If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREE	NUMBER	Minimum percentage of free space in a block
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent (in bytes)
NEXT_EXTENT	NUMBER	Size of secondary extents (in bytes)
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	reserved Percentage increase in extent size
FREELISTS	NUMBER	reserved Number of process freelists allocated to the segment
FREELIST_GROUPS	NUMBER	reserved Number of freelist groups allocated to the segment
LOGGING	VARCHAR(3)	Indicates whether or not changes to the table are logged
BACKED_UP	VARCHAR(1)	reserved Indicates whether the table has been backed up since the last modification (Y) or not (N)
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks in the table
ANAL_BLOCKS	NUMBER	Number of used blocks in the table when most recently analyzed
EMPTY_BLOCKS	NUMBER	reserved Number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	reserved Average available free space in the table
CHAIN_CNT	NUMBER	reserved Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid
AVG_ROW_LEN	NUMBER	reserved Average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	NUMBER	reserved Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	reserved Number of blocks on the freelist
DEGREE	VARCHAR(32)	reserved Number of threads per instance for scanning the table, or DEFAULT
INSTANCES	VARCHAR(32)	reserved Number of instances across which the table is to be scanned, or DEFAULT
CACHE	VARCHAR(1)	reserved Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCK	VARCHAR(32)	Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZE	NUMBER	Sample size used in analyzing the table
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed
PARTITIONED	VARCHAR(3)	reserved Indicates whether the table is partitioned (YES) or not (NO)
IOT_TYPE	VARCHAR(32)	reserved If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING.
TEMPORARY	VARCHAR(1)	Indicates whether the table is temporary (Y) or not (N)
SECONDARY	VARCHAR(1)	reserved Indicates whether the table is a secondary object created by cartridge
NESTED	VARCHAR(3)	reserved Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOL	VARCHAR(32)	reserved Buffer pool to be used for table blocks
FLASH_CACHE	VARCHAR(32)	reserved Database Smart Flash Cache hint to be used for table blocks
CELL_FLASH_CACHE	VARCHAR(32)	reserved Cell flash cache hint to be used for table blocks
ROW_MOVEMENT	VARCHAR(32)	reserved If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED)
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES)
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATION	VARCHAR(32)	Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION )
SKIP_CORRUPT	VARCHAR(32)	reserved Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED)
MONITORING	VARCHAR(3)	reserved Indicates whether the table has the MONITORING attribute set (YES) or not (NO)
CLUSTER_OWNER	VARCHAR(128)	reserved Owner of the cluster, if any
DEPENDENCIES	VARCHAR(32)	reserved Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSION	VARCHAR(32)	reserved Indicates whether table compression is enabled (ENABLED) or not (DISABLED)
COMPRESS_FOR	VARCHAR(32)	reserved Default compression for what kind of operations
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
READ_ONLY	VARCHAR(3)	Indicates whether the table IS READ-ONLY (YES) or not (NO)
IS_IMMUTABLE	VARCHAR(3)	Indicates whether the table IS IMMUTABLE (YES) or not (NO)
SEGMENT_CREATED	VARCHAR(3)	Indicates whether the table segment has been created (YES) or not (NO)
RESULT_CACHE	VARCHAR(32)	reserved Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL )

USER_TABLESPACES

USER_TABLESPACES describes the tablespaces accessible to the current user.

Column information
Column name	Data type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
BLOCK_SIZE	NUMBER	Tablespace block size
INITIAL_EXTENT	NUMBER	reserved Default initial extent size (in bytes)
NEXT_EXTENT	NUMBER	reserved Default incremental extent size (in bytes)
MIN_EXTENTS	NUMBER	reserved Default minimum number of extents
MAX_EXTENTS	NUMBER	reserved Default maximum number of extents
MAX_SIZE	NUMBER	reserved Default maximum size of segments
PCT_INCREASE	NUMBER	reserved Default percent increase for extent size
MIN_EXTLEN	NUMBER	reserved Minimum extent size for this tablespace (in bytes)
STATUS	VARCHAR(32)	Tablespace status: the value in ( ONLINE, OFFLINE, READ ONLY )
CONTENTS	VARCHAR(32)	Tablespace contents: the value in ( SYSTEM, DATA, TEMPORARY, UNDO )
LOGGING	VARCHAR(32)	Default logging attribute: LOGGING, NOLOGGING
FORCE_LOGGING	VARCHAR(3)	reserved Indicates whether the tablespace is under force logging mode (YES) or not (NO)
EXTENT_MANAGEMENT	VARCHAR(32)	reserved Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL)
ALLOCATION_TYPE	VARCHAR(32)	reserved Type of extent allocation in effect for the tablespace: the value in ( SYSTEM, UNIFORM, USER )
SEGMENT_SPACE_MANAGEMENT	VARCHAR(32)	reserved Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
DEF_TAB_COMPRESSION	VARCHAR(32)	reserved Indicates whether default table compression is enabled (ENABLED) or not (DISABLED)
RETENTION	VARCHAR(32)	reserved Undo tablespace retention: the value in ( GUARANTEE, NOGUARANTEE, NOT APPLY )
BIGFILE	VARCHAR(3)	reserved Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)
PREDICATE_EVALUATION	VARCHAR(32)	reserved Indicates whether predicates are evaluated by host (HOST) or by storage (STORAGE)
ENCRYPTED	VARCHAR(3)	reserved Indicates whether the tablespace is encrypted (YES) or not (NO)
COMPRESS_FOR	VARCHAR(32)	reserved Indicates whether the tablespace is encrypted (YES) or not (NO)

USER_TAB_COLS

USER_TAB_COLS describes the columns (including hidden columns) of the tables, views, and clusters owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HIDDEN_COLUMN	VARCHAR(3)	Indicates whether the column is a hidden column (YES) or not (NO)
VIRTUAL_COLUMN	VARCHAR(3)	reserved Indicates whether the column is a virtual column (YES) or not (NO)
SEGMENT_COLUMN_ID	NUMBER	Sequence number of the column in the segment
INTERNAL_COLUMN_ID	NUMBER	Internal sequence number of the column
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
QUALIFIED_COL_NAME	VARCHAR(4000)	Qualified column name
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

USER_TAB_COLUMNS

USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	VARCHAR(128)	Datatype of the column
DATA_TYPE_MOD	VARCHAR(3)	reserved Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR(128)	reserved Owner of the datatype of the column
DATA_LENGTH	NUMBER	Length of the column (in bytes)
DATA_PRECISION	NUMBER	Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER	Digits to the right of the decimal point in a number
NULLABLE	VARCHAR(1)	Indicates whether a column allows NULLs.
COLUMN_ID	NUMBER	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER	Length of the default value for the column
DATA_DEFAULT	LONG VARCHAR	Default value for the column
NUM_DISTINCT	NUMBER	Number of distinct values in the column
LOW_VALUE	VARBINARY(32)	Low value in the column
HIGH_VALUE	VARBINARY(32)	High value in the column
DENSITY	NUMBER	reserved If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram.
NUM_NULLS	NUMBER	Number of NULLs in the column
NUM_BUCKETS	NUMBER	reserved Number of buckets in the histogram for the column
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which this column was most recently analyzed
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR(128)	reserved Name of the character set
CHAR_COL_DECL_LENGTH	NUMBER	Declaration length of the character type column
GLOBAL_STATS	VARCHAR(3)	reserved For partitioned tables, indicates whether column statistics were collected for the table
USER_STATS	VARCHAR(3)	reserved Indicates whether statistics were entered directly by the user (YES) or not (NO)
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
CHAR_LENGTH	NUMBER	Displays the length of the column in characters.
CHAR_USED	VARCHAR(1)	Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C)
V80_FMT_IMAGE	VARCHAR(3)	reserved Indicates whether the column data is in release older image format (YES) or not (NO)
DATA_UPGRADED	VARCHAR(3)	reserved Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO)
HISTOGRAM	VARCHAR(32)	reserved Indicates existence/type of histogram
IDENTITY_COLUMN	VARCHAR(3)	Indicates whether this is an identity column (YES) or not (NO)

USER_TAB_COMMENTS

USER_TAB_COMMENTS displays comments on the tables and views owned by the current user.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
TABLE_TYPE	VARCHAR(32)	Type of the object
COMMENTS	VARCHAR(1024)	Comment on the object

USER_TAB_IDENTITY_COLS

USER_TAB_IDENTITY_COLS describes all table identity columns.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the identity column
GENERATION_TYPE	VARCHAR(32)	Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT
IDENTITY_OPTIONS	VARCHAR(1024)	Options for the identity column sequence generator

USER_TAB_PLACE

USER_TAB_PLACE describes node placement of cluster tables owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
GROUP_ID	NUMBER	Group identifier of the node where the table placed
GROUP_NAME	VARCHAR(128)	Group name of the node where the table placed
MEMBER_ID	NUMBER	Member identifier of the node where the table placed
MEMBER_NAME	VARCHAR(128)	Member name of the node where the table placed
MEMBER_POSITION	NUMBER	Member position of the node where the table placed
MEMBER_OFFLINE	BOOLEAN	data of the cluster member is offline or not
IS_UPDATE_MASTER	BOOLEAN	whether the cluster member is update master or not
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)
SCN	VARCHAR(64)	table scn of the node where the table placed
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used blocks of the node where the table placed
LAST_ANALYZED	TIMESTAMP(6) WITHOUT TIME ZONE	Date on which the table was most recently analyzed

USER_TAB_PRIVS

USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner.

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	Name of the user or role to whom access was granted
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

USER_TAB_PRIVS_RECD

USER_TAB_PRIVS_RECD describes the object grants for which the current user is the grantee.

Column information
Column name	Data type	Description
OWNER	VARCHAR(128)	Owner of the object
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who performed the grant
PRIVILEGE	VARCHAR(32)	Privilege on the object
GRANTABLE	VARCHAR(3)	Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)
HIERARCHY	VARCHAR(3)	Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

USER_TAB_SHARDS

USER_TAB_SHARDS describes shard information of sharded tables owned by the current user in the cluster system.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
SHARD_STRATEGY	VARCHAR(32)	Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING)
SHARD_NAME	VARCHAR(128)	Shard name
SHARD_NUMBER	NUMBER	Shard number
SHARD_DEFINITION	LONG VARCHAR	Shard definition (if hash sharded, the value is null)
GROUP_ID	NUMBER	Group identifier where the shard placed
GROUP_NAME	VARCHAR(128)	Group Name where the shard placed
DROPPED	VARCHAR(3)	Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO)

USER_TRIGGERS

USER_TRIGGERS describes the triggers owned by the current user.

Column information
Column name	Data type	Description
TRIGGER_SCHEMA	VARCHAR(128)	Schema Name of the trigger
TRIGGER_NAME	VARCHAR(128)	Name of the trigger
TRIGGER_TYPE	VARCHAR(16)	When the trigger fires: the value in ( BEFORE STATEMENT, BEFORE EACH ROW, AFTER STATEMENT, AFTER EACH ROW, INSTEAD OF, COMPOUND )
TRIGGERING_EVENT	VARCHAR(32)	DML, DDL, or database event that fires the trigger
TABLE_OWNER	VARCHAR(128)	Owner of the table on which the trigger is defined
TABLE_SCHEMA	VARCHAR(128)	Schema Name of the table on which the trigger is defined
BASE_OBJECT_TYPE	VARCHAR(16)	Base object on which the trigger is defined: the value in ( TABLE, VIEW, SCHEMA, DATABASE )
TABLE_NAME	VARCHAR(128)	If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW then this column indicates the table or view name on which the trigger is defined
COLUMN_NAME	VARCHAR(4000)	Name of the nested table column (if a nested table trigger), else NULL
REFERENCING_NAMES	VARCHAR(1024)	Names used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSE	LONG VARCHAR	Must evaluate to TRUE for TRIGGER_BODY to execute
STATUS	VARCHAR(8)	Indicates whether the trigger is enabled (ENABLED) or disabled (DISABLED); a disabled trigger will not fire
DESCRIPTION	LONG VARCHAR	Trigger description; useful for re-creating a trigger creation statement
ACTION_TYPE	VARCHAR(16)	Action type of the trigger body: the value in ( CALL, PSM BLOCK )
TRIGGER_BODY	LONG VARCHAR	Statements executed by the trigger when it fires
CROSSEDITION	VARCHAR(3)	Type of crossedition trigger: the value in ( FORWARD, REVERSE, NO )
BEFORE_STATEMENT	VARCHAR(3)	Indicates whether the trigger has a BEFORE STATEMENT section (YES) or not (NO)
BEFORE_ROW	VARCHAR(3)	Indicates whether the trigger has a BEFORE EACH ROW section (YES) or not (NO)
AFTER_ROW	VARCHAR(3)	Indicates whether the trigger has an AFTER EACH ROW section (YES) or not (NO)
AFTER_STATEMENT	VARCHAR(3)	Indicates whether the trigger has an AFTER STATEMENT section (YES) or not (NO)
INSTEAD_OF_ROW	VARCHAR(3)	Indicates whether the trigger has an INSTEAD OF section (YES) or not (NO)
FIRE_ONCE	VARCHAR(3)	Indicates whether the trigger will fire only for user processes making changes (YES) or whether the trigger will also fire for Replication Apply or SQL Apply processes (NO)
APPLY_SERVER_ONLY	VARCHAR(3)	Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process (YES) or not (NO). If set to YES, then the setting of FIRE_ONCE does not matter
COMMENTS	VARCHAR(1024)	Comment on the trigger

USER_USERS

USER_USERS describes the current user.

Column information
Column name	Data type	Description
USERNAME	VARCHAR(128)	Name of the user
USER_ID	NUMBER	ID number of the user
ACCOUNT_STATUS	VARCHAR(32)	Account status: the value in ( OPEN, EXPIRED, EXPIRED(GRACE), LOCKED(TIMED), LOCKED, EXPIRED & LOCKED(TIMED), EXPIRED(GRACE) & LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED )
LOCK_DATE	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp the account was locked if account status was LOCKED
EXPIRY_DATE	TIMESTAMP(6) WITHOUT TIME ZONE	Timestamp of expiration of the account
DEFAULT_TABLESPACE	VARCHAR(128)	Default tablespace for data
TEMPORARY_TABLESPACE	VARCHAR(128)	Name of the default tablespace for temporary tables or the name of a tablespace group
INDEX_TABLESPACE	VARCHAR(128)	Default tablespace for index
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	User creation timestamp
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR(128)	reserved Initial resource consumer group for the user
EXTERNAL_NAME	VARCHAR(128)	reserved User external name

USER_VIEWS

USER_VIEWS describes the views owned by the current user.

Column information
Column name	Data type	Description
VIEW_SCHEMA	VARCHAR(128)	Schema of the view
VIEW_NAME	VARCHAR(128)	Name of the view
TEXT_LENGTH	NUMBER	Length of the view text
TEXT	LONG VARCHAR	View text
TYPE_TEXT_LENGTH	NUMBER	reserved Length of the type clause of the typed view
TYPE_TEXT	VARCHAR(4000)	reserved Type clause of the typed view
OID_TEXT_LENGTH	NUMBER	reserved Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR(4000)	reserved WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR(128)	reserved Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR(32)	reserved Type of the view if the view is a typed view
SUPERVIEW_NAME	VARCHAR(128)	reserved Name of the superview
EDITIONING_VIEW	VARCHAR(1)	Reserved for future use
READ_ONLY	VARCHAR(1)	Indicates whether the view is read-only (Y) or not (N)

Other Views

There are other views or tables which are none of All-family, DBA-family or USER-family.

AUDIT_POLICIES

AUDIT_POLICIES contains one row for each audit policy.

Column information
Column name	Data type	Description
POLICY_NAME	VARCHAR(128)	audit policy name
ENABLED	VARCHAR(3)	indicates whether the audit policy is enabled (YES) or not (NO)
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the audit policy
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the audit policy
COMMENTS	VARCHAR(1024)	comments of the audit policy

AUDIT_POLICY_OPTIONS

AUDIT_POLICY_OPTIONS describes all audit policies created in the database.

Column information
Column name	Data type	Description
POLICY_NAME	VARCHAR(128)	audit policy name
AUDIT_OPTION	VARCHAR(32)	auditing option defined in the audit policy
AUDIT_OPTION_TYPE	VARCHAR(32)	The values of AUDIT_OPTION_TYPE_NAME in ( 'DATABASE PRIVILEGE', 'SYSTEM ACTION', 'OBJECT ACTION' )
OBJECT_SCHEMA	VARCHAR(128)	schema name, for an object-specific auditing option
OBJECT_NAME	VARCHAR(128)	object name, for an object-specific auditing option
OBJECT_TYPE	VARCHAR(32)	object type name, for an object-specific auditing option
DROPPED	VARCHAR(3)	Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO)

AUDIT_POLICY_ENABLED

AUDIT_POLICY_ENABLE describes all the audit policies that are enable in the database.

Column information
Column name	Data type	Description
POLICY_NAME	VARCHAR(128)	audit policy name
ENABLED_OPT	VARCHAR(32)	enable option of the audit policy, the possible values are BY, EXCEPT
USER_NAME	VARCHAR(128)	user name for whom the audit policy is enable
WHEN_SUCCESS	VARCHAR(3)	indicates whether the audit policy is enable for auditing successful events or not
WHEN_FAILURE	VARCHAR(3)	indicates whether the audit policy is enable for auditing unsuccessful events or not

AUDIT_TRAIL

AUDIT_TRAIL displays audit records from the audit trail.

Column information
Column name	Data type	Description
MEMBER_NAME	VARCHAR(128)	cluster member name
SESSION_ID	NUMBER	session identifier
SESSION_SERIAL	NUMBER	session serial number
LOGON_USERNAME	VARCHAR(128)	logon user name of the user whose actions were audited
CURRENT_USERNAME	VARCHAR(128)	effective user for the statement execution
SERVER_PROCESS	NUMBER	server process identifier for the session
CLIENT_PROGRAM_NAME	VARCHAR(128)	client program used for session
CLIENT_USERNAME	VARCHAR(128)	client operating system user name for the session
CLIENT_PROCESS	NUMBER	client process identifier for the session
CLIENT_HOST	VARCHAR(128)	client host ip address for the session
CLIENT_PORT	NUMBER	client port number for the session
CLIENT_TERMINAL	VARCHAR(128)	client terminal name for the session
TRANSACTION_ID	NUMBER	transaction identifier
SCN	VARCHAR(128)	system change number (SCN) string of the query at the time of the event
GCN	NUMBER	global change number (GCN) of the query at the time of the event
DCN	NUMBER	domain change number (DCN) of the query at the time of the event
LCN	NUMBER	local change number (LCN) of the query at the time of the event
STMT_NO	NUMBER	numeric number for each statement run in a session
SQL_TEXT	LONG VARCHAR	SQL associated with the event
SQL_BINDS	LONG VARCHAR	list of bind variables, if any, associated with SQL_TEXT
RETURN_CODE	NUMBER	error code generated by the action, zero if the action succeeded
ERROR_MESSAGE	VARCHAR(1024)	error message generated by the action, null if the action succeeded
ENTRY_ID	NUMBER	audit trail entry identifier in the session
EVENT_TIMESTAMP	TIMESTAMP(6) WITHOUT TIME ZONE	timestamp of the creation of the audit trail entry in local time zone
POLICY_NAME	VARCHAR(128)	audit policy name that caused the current audit record
PRIVILEGE_USED	VARCHAR(32)	database privilege used to execute the action
ACTION_NAME	VARCHAR(32)	action name executed by the user
OBJECT_TYPE	VARCHAR(32)	object type of object affected by the action
OBJECT_SCHEMA	VARCHAR(128)	schema name of object affected by the action
OBJECT_NAME	VARCHAR(128)	object name of object affected by the action

DATABASE_PROPERTIES

DATABASE_PROPERTIES lists permanent database properties.

Column information
Column name	Data type	Description
PROPERTY_NAME	VARCHAR(128)	Property name
PROPERTY_VALUE	VARCHAR(4000)	Property value
DESCRIPTION	VARCHAR(4000)	Property description

DBC_TABLE_TYPE_INFO

Identify the ODBC/JDBC table types available in this database.

Column information
Column name	Data type	Description
DBC_TABLE_TYPE_ID	NUMBER	number identifier of the table type in ODBC/JDBC
DBC_TABLE_TYPE	VARCHAR(128)	name of the table type in ODBC/JDBC
IS_SUPPORTED	BOOLEAN	is supported feature
COMMENTS	VARCHAR(1024)	comments of the table type

DICTIONARY

DICTIONARY contains descriptions of data dictionary tables and views.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COMMENTS	VARCHAR(1024)	Text comment on the object

DICT_COLUMNS

DICT_COLUMNS contains descriptions of columns in data dictionary tables and views.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object that contains the column
TABLE_NAME	VARCHAR(128)	Name of the object that contains the column
COLUMN_NAME	VARCHAR(128)	Name of the column
COMMENTS	VARCHAR(1024)	Text comment on the column

DUAL

DUAL returns one row and one column.

Column information
Column name	Data type	Description
DUMMY	VARCHAR(1)	Dummy column

GLOBAL_DUAL

GLOBAL_DUAL returns one row and one column in cluster environment.

Column information
Column name	Data type	Description
DUMMY	VARCHAR(1)	Dummy column

IMPLEMENTATION_INFO

IMPLEMENTATION_INFO contains information about various aspects that are left implementation-defined.

Column information
Column name	Data type	Description
IMPLEMENTATION_INFO_ID	NUMBER	identifier of the implementation item
IMPLEMENTATION_INFO_NAME	VARCHAR(1024)	descriptive name of the implementation item
INTEGER_VALUE	NUMBER	Value of the implementation item, or null if the value is contained in the column CHARACTER_VALUE
CHARACTER_VALUE	VARCHAR(1024)	Value of the implementation item, or null if the value is contained in the column INTEGER_VALUE
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the implementation item

IMPLEMENTATION_INFO_BASE

The IMPLEMENTATION_INFO_BASE table has one row for each implementation information item.

Column information
Column name	Data type	Description
ID	VARCHAR(32)	identifier string of the implementation item
SUB_ID	VARCHAR(32)	identifier string of the implementation item
NAME	VARCHAR(1024)	descriptive name of the implementation item
SUB_NAME	VARCHAR(1024)	descriptive name of the implementation item
IS_SUPPORTED	BOOLEAN	TRUE if the implementation item is supported, FALSE if not
INTEGER_VALUE	NUMBER	Value of the implementation item, or null if the value is contained in the column CHARACTER_VALUE
CHARACTER_VALUE	VARCHAR(1024)	Value of the implementation item, or null if the value is contained in the column INTEGER_VALUE
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the implementation item

JDBC_CLIENT_PROPS

JDBC_CLIENT_PROPS is the set of jdbc client properties.

Column information
Column name	Data type	Description
NAME	VARCHAR(128)	property name
MAX_LEN	NATIVE_INTEGER	max length of a value
DEFAULT_VALUE	VARCHAR(128)	default value
DESCRIPTION	VARCHAR(256)	descrption on that property

PRODUCT

PRODUCT is about the product name, version for ODBC, JDBC interface.

Column information
Column name	Data type	Description
NAME	VARCHAR(32)	the product name
VERSION	VARCHAR(128)	product full version information
PRODUCT_VERSION	NUMBER	product version
MAJOR_VERSION	NUMBER	major version
MINOR_VERSION	NUMBER	minor version
PATCH_VERSION	NUMBER	patch version

ROLE_COL_PRIVS

ROLE_COL_PRIVS describes column privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
PRIVILEGE	VARCHAR(32)	Column privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_DB_PRIVS

ROLE_DB_PRIVS describes database privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PRIVILEGE	VARCHAR(32)	Database privilege granted to the role
GRANT_OPTION	VARCHAR(3)	Indicates whether the grant was with the GRANT option (YES) or not (NO)

ROLE_LIBRARY_PRIVS

ROLE_LIBRARY_PRIVS describes library privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
LIBRARY_OWNER	VARCHAR(128)	Owner of the library
LIBRARY_SCHEMA	VARCHAR(128)	Schema of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
PRIVILEGE	VARCHAR(32)	library privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_PACKAGE_PRIVS

ROLE_PACKAGE_PRIVS describes package privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PACKAGE_OWNER	VARCHAR(128)	Owner of the package
PACKAGE_SCHEMA	VARCHAR(128)	Schema of the package
PACKAGE_NAME	VARCHAR(128)	Name of the package
PRIVILEGE	VARCHAR(32)	Package privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_PROC_PRIVS

ROLE_PROC_PRIVS describes routine privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PROCEDURE_OWNER	VARCHAR(128)	Owner of the routine
PROCEDURE_SCHEMA	VARCHAR(128)	Schema of the routine
PROCEDURE_NAME	VARCHAR(128)	Name of the routine
PRIVILEGE	VARCHAR(32)	Routine privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_ROLE_PRIVS

ROLE_ROLE_PRIVS describes the roles granted to other roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
GRANTED_ROLE	VARCHAR(128)	Role that was granted
ADMIN_OPTION	VARCHAR(3)	Signifies that the role was granted with ADMIN option
COMMON	VARCHAR(3)	Indicates how the grant was made. (YES or NO)
INHERITED	VARCHAR(3)	Indicates whether the role grant was inherited from another container (YES) or not (NO)

ROLE_SCHEMA_PRIVS

ROLE_SCHEMA_PRIVS describes schema privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PRIVILEGE	VARCHAR(32)	Schema privilege granted to the role
SCHEMA_OWNER	VARCHAR(128)	Owner of the schema
SCHEMA_NAME	VARCHAR(128)	Name of the schema
GRANT_OPTION	VARCHAR(3)	Indicates whether the grant was with the GRANT option (YES) or not (NO)

ROLE_SEQ_PRIVS

ROLE_SEQ_PRIVS describes sequence privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	Schema of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
PRIVILEGE	VARCHAR(32)	Sequence privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_SYS_PRIVS

ROLE_SYS_PRIVS describes all system(database, tablespace, schema) privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PRIVILEGE	VARCHAR(256)	all system(database, tablespace, schema) privilege granted to the role
GRANT_OPTION	VARCHAR(3)	Indicates whether the grant was with the GRANT option (YES) or not (NO)
COMMON	VARCHAR(3)	Indicates how the grant was made. (YES or NO)
INHERITED	VARCHAR(3)	Indicates whether the role grant was inherited from another container (YES) or not (NO)

ROLE_TAB_PRIVS

ROLE_TAB_PRIVS describes table privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_SCHEMA	VARCHAR(128)	Schema of the table
TABLE_NAME	VARCHAR(128)	Name of the table
PRIVILEGE	VARCHAR(32)	Table privilege granted to the role
GRANTABLE	VARCHAR(3)	YES if the role was granted with GRANT OPTION; otherwise NO

ROLE_TBS_PRIVS

ROLE_TBS_PRIVS describes tablespace privileges granted to roles. Information is provided only about roles to which the user has access.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role
PRIVILEGE	VARCHAR(32)	Tablespace privilege granted to the role
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
GRANT_OPTION	VARCHAR(3)	Indicates whether the grant was with the GRANT option (YES) or not (NO)

SESSION_PRIVS

SESSION_PRIVS describes the privileges that are currently available to the user.

Column information
Column name	Data type	Description
PRIVILEGE	VARCHAR(256)	Name of the privilege

SESSION_ROLES

SESSION_ROLES describes the roles currently enabled for the current session.

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	Name of the role

SUPPLEMENTAL_LOG_TABLE_INFO

SUPPLEMENTAL_LOG_TABLE_INFO describes table-level supplemental logging status.

Column information
Column name	Data type	Description
TABLE_SCHEMA	VARCHAR(128)	Schema of the object
TABLE_NAME	VARCHAR(128)	Name of the object
SUPPLEMENTAL_LOG_DATA_PK	VARCHAR(32)	Status of table-level PRIMARY KEY COLUMNS supplemental logging: IMPLICIT, EXPLICIT, NO
DROPPED	VARCHAR(3)	Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO)

Aliased Synonym

It is a public synonym that refers to the view or table in DICTIONARY_SCHEMA.

COLS

COLS is a public synonym for USER_TAB_COLUMNS.

DICT

DICT is a public synonym for DICTIONARY.

IND

IND is a public synonym for USER_INDEXES.

OBJ

OBJ is a public synonym for USER_OBJECTS.

SEQ

SEQ is a public synonym for USER_SEQUENCES.

TABS

TABS is a public synonym for USER_TABLES.

RECYCLEBIN

RECYCLEBIN is a public synonym for USER_RECYCLEBIN.

INFORMATION_SCHEMA

The views in the INFORMATION_SCHEMA schema provide the same information as those defined in the SQL standard.

Execute InformationSchema.sql as follows to use the views.

For standalone

% gsql sys gliese --as sysdba --import  $GOLDILOCKS_HOME/admin/standalone/InformationSchema.sql

For cluster

% gsql sys gliese --as sysdba --import  $GOLDILOCKS_HOME/admin/cluster/InformationSchema.sql

The views and tables in INFORMATION_SCHEMA can be retrieved from the OPEN phase.
Objects stored in the recycle bin can not be retrieved in the views of INFORMATION_SCHEMA.

ADMINISTRABLE_ROLE_AUTHORIZATIONS

Identify role authorizations for which the current user or role has WITH ADMIN OPTION

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	grantee name
ROLE_NAME	VARCHAR(128)	role name
IS_GRANTABLE	BOOLEAN	is grantable or not

APPLICABLE_ROLES

Identify the applicable roles for current SQL-session

Column information
Column name	Data type	Description
GRANTEE	VARCHAR(128)	grantee name
ROLE_NAME	VARCHAR(128)	role name
IS_GRANTABLE	BOOLEAN	is grantable or not

CHECK_CONSTRAINTS

Identify the check constraints defined in this catalog that are owned by a given user or role.

Column information
Column name	Data type	Description
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the constraint
CONSTRAINT_OWNER	VARCHAR(128)	authorization name who owns the constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the constraint being described
CONSTRAINT_TABLE	VARCHAR(128)	table name of the constraint being described
CONSTRAINT_NAME	VARCHAR(128)	constraint name
CHECK_CLAUSE	LONG VARCHAR	search condition of CHECK constraint, null for NOT NULL constraint

COLUMNS

Identify the columns of tables defined in this catalog that are accessible to given user or role.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the column
TABLE_OWNER	VARCHAR(128)	owner name of the column
TABLE_SCHEMA	VARCHAR(128)	schema name of the column
TABLE_NAME	VARCHAR(128)	table name of the column
COLUMN_NAME	VARCHAR(128)	column name
ORDINAL_POSITION	NUMBER	the ordinal position (> 0) of the column in the table
COLUMN_DEFAULT	LONG VARCHAR	the default for the column
IS_NULLABLE	BOOLEAN	is nullable of the column
DATA_TYPE	VARCHAR(128)	the standard name of the data type
CHARACTER_MAXIMUM_LENGTH	NUMBER	the maximum length in characters
CHARACTER_OCTET_LENGTH	NUMBER	the maximum length in octets
NUMERIC_PRECISION	NUMBER	the numeric precision of the numerical Data type
NUMERIC_PRECISION_RADIX	NUMBER	the radix ( 2 or 10 ) of the precision of the numerical data type
NUMERIC_SCALE	NUMBER	the numeric scale of the exact numerical data type
DATETIME_PRECISION	NUMBER	for a datetime or interval type, the value is the fractional seconds precision
INTERVAL_TYPE	VARCHAR(32)	for a interval type, the value is in ( YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, YEAR TO MONTH, DAY TO HOUR, DAY TO MINUTE, DAY TO SECOND, HOUR TO MINUTE, HOUR TO SECOND, MINUTE TO SECOND )
INTERVAL_PRECISION	NUMBER	for a interval type, the value is the leading precision
CHARACTER_SET_CATALOG	VARCHAR(128)	catalog name of the character set if it is a character string type
CHARACTER_SET_SCHEMA	VARCHAR(128)	schema name of the character set if it is a character string type
CHARACTER_SET_NAME	VARCHAR(128)	character set name of the character set if it is a character string type
COLLATION_CATALOG	VARCHAR(128)	catalog name of the applicable collation if it is a character string type
COLLATION_SCHEMA	VARCHAR(128)	schema name of the applicable collation if it is a character string type
COLLATION_NAME	VARCHAR(128)	collation name of the applicable collation if it is a character string type
DOMAIN_CATALOG	VARCHAR(128)	catalog name of the domain used by the column being described
DOMAIN_SCHEMA	VARCHAR(128)	schema name of the domain used by the column being described
DOMAIN_NAME	VARCHAR(128)	domain name of the domain used by the column being described
UDT_CATALOG	VARCHAR(128)	catalog name of the user-defined type of the data type being described
UDT_SCHEMA	VARCHAR(128)	schema name of the user-defined type of the data type being described
UDT_NAME	VARCHAR(128)	user-defined type name of the user-defined type of the data type being described
SCOPE_CATALOG	VARCHAR(128)	catalog name of the referenceable table if DATA_TYPE is REF
SCOPE_SCHEMA	VARCHAR(128)	schema name of the referenceable table if DATA_TYPE is REF
SCOPE_NAME	VARCHAR(128)	scope name of the referenceable table if DATA_TYPE is REF
MAXIMUM_CARDINALITY	NUMBER	maximum cardinality if DATA_TYPE is ARRAY
DTD_IDENTIFIER	NUMBER	data type descriptor identifier
IS_SELF_REFERENCING	BOOLEAN	is a self-referencing column
IS_IDENTITY	BOOLEAN	is an identity column
IDENTITY_GENERATION	VARCHAR(32)	for an identity column, the value is in ( ALWAYS, BY DEFAULT )
IDENTITY_START	NUMBER	for an identity column, the start value of the identity column
IDENTITY_INCREMENT	NUMBER	for an identity column, the increment of the identity column
IDENTITY_MAXIMUM	NUMBER	for an identity column, the maximum value of the identity column
IDENTITY_MINIMUM	NUMBER	for an identity column, the minimum value of the identity column
IDENTITY_CYCLE	BOOLEAN	for an identity column, the cycle option
IS_GENERATED	BOOLEAN	is a generated column
GENERATION_EXPRESSION	VARCHAR(128)	for a generated column, the text of the generation expression
IS_SYSTEM_VERSION_START	BOOLEAN	is a system-version start column
IS_SYSTEM_VERSION_END	BOOLEAN	is a system-version end column
SYSTEM_VERSION_TIMESTAMP_GENERATION	VARCHAR(32)	for a system-version column, the value is ALWAYS
IS_UPDATABLE	BOOLEAN	is an updatable column
DECLARED_DATA_TYPE	VARCHAR(128)	the data type name that a user declared
DECLARED_NUMERIC_PRECISION	NUMBER	the precision value that a user declared
DECLARED_NUMERIC_SCALE	NUMBER	the scale value that a user declared
COMMENTS	VARCHAR(1024)	comments of the column

COLUMN_PRIVILEGES

Identify the privileges on columns of tables defined in this catalog that are available to or granted by a given user or role.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted column privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the column privilege being described is granted
TABLE_CATALOG	VARCHAR(128)	catalog name of the column on which the privilege being described was granted
TABLE_OWNER	VARCHAR(128)	table owner name of the column on which the privilege being described was granted
TABLE_SCHEMA	VARCHAR(128)	schema name of the column on which the privilege being described was granted
TABLE_NAME	VARCHAR(128)	table name of the column on which the privilege being described was granted
COLUMN_NAME	VARCHAR(128)	column name of the column on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( SELECT, INSERT, UPDATE, REFERENCES )
IS_GRANTABLE	BOOLEAN	is grantable

CONSTRAINT_COLUMN_USAGE

Identify the columns used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the column that participates in the constraint being described
TABLE_OWNER	VARCHAR(128)	owner name of the column that participates in the constraint being described
TABLE_SCHEMA	VARCHAR(128)	schema name of the column that participates in the constraint being described
TABLE_NAME	VARCHAR(128)	table name of the column that participates in the constraint being described
COLUMN_NAME	VARCHAR(128)	column name that participates in the constraint being described
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the constraint
CONSTRAINT_OWNER	VARCHAR(128)	owner name of the constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the constraint
CONSTRAINT_NAME	VARCHAR(128)	constraint name

CONSTRAINT_TABLE_USAGE

Identify the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the table that participates in the constraint being described
TABLE_OWNER	VARCHAR(128)	owner name of the table that participates in the constraint being described
TABLE_SCHEMA	VARCHAR(128)	schema name of the table that participates in the constraint being described
TABLE_NAME	VARCHAR(128)	table name that participates in the constraint being described
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the constraint
CONSTRAINT_OWNER	VARCHAR(128)	owner name of the constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the constraint
CONSTRAINT_NAME	VARCHAR(128)	constraint name

ENABLED_ROLES

Identify the enabled roles for current SQL-session

Column information
Column name	Data type	Description
ROLE_NAME	VARCHAR(128)	role name

INFORMATION_SCHEMA_CATALOG_NAME

Identify the catalog that contains the Information Schema

Column information
Column name	Data type	Description
CATALOG_NAME	VARCHAR(128)	the name of catalog in which this Information Schema resides

KEY_COLUMN_USAGE

Identify the columns defined in this catalog that are constrained as keys and that are accessible by a given user or role.

Column information
Column name	Data type	Description
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the constraint
CONSTRAINT_OWNER	VARCHAR(128)	owner name of the constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the constraint
CONSTRAINT_NAME	VARCHAR(128)	constraint name
TABLE_CATALOG	VARCHAR(128)	catalog name of the column that participates in the constraint being described
TABLE_OWNER	VARCHAR(128)	owner name of the column that participates in the constraint being described
TABLE_SCHEMA	VARCHAR(128)	schema name of the column that participates in the constraint being described
TABLE_NAME	VARCHAR(128)	table name of the column that participates in the constraint being described
COLUMN_NAME	VARCHAR(128)	column name that participates in the constraint being described
ORDINAL_POSITION	NUMBER	the ordinal position of the specific column in the constraint being described. If the constraint described is a key of cardinality 1 (one), then the value of ORDINAL_POSITION is always 1 (one).
POSITION_IN_UNIQUE_CONSTRAINT	NUMBER	If the constraint being described is a foreign key constraint, then the value of POSITION_IN_UNIQUE_CONSTRAINT is the ordinal position of the referenced column corresponding to the referencing column being described, in the corresponding unique key constraint.

MODULES

Identify the SQL-server modules in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
DEFAULT_CHARACTER_SET_CATALOG	VARCHAR(128)	default character set catalog name of the SQL-server module
DEFAULT_CHARACTER_SET_SCHEMA	VARCHAR(128)	default character set schema name of the SQL-server module
DEFAULT_CHARACTER_SET	VARCHAR(128)	default character set name of the SQL-server module
DEFAULT_SCHEMA_CATALOG	VARCHAR(128)	catalog name of default schema of SQL-server module
DEFAULT_SCHEMA_NAME	VARCHAR(128)	default schema name of the SQL-server module
MODULE_DEFINITION	LONG VARCHAR	definition of the SQL-server module
MODULE_AUTHORIZATION	VARCHAR(32)	authorization of the SQL-server module(DEFINER/INVOKER)
SQL_PATH	VARCHAR(1024)	described SQL PATH when the SQL-server module is defined
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	creation time of the SQL-server module
LAST_ALTERED	TIMESTAMP(6) WITHOUT TIME ZONE	most lately altered time of the SQL-server module
COMMENTS	VARCHAR(1024)	comment on the SQL-server module

MODULE_BODY

Identify the SQL-server module bodies in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module'
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
MODULE_DEFINITION	LONG VARCHAR	definition of the SQL-server module body
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	creation time of the SQL-server module body
LAST_ALTERED	TIMESTAMP(6) WITHOUT TIME ZONE	most lately altered time of the SQL-server module body

MODULE_BODY_MODULE_USAGE

Identify the SQL-server modules owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
REF_MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module of contained in definition text of the SQL-server module body
REF_MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module of contained in definition text of the SQL-server module body
REF_MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module of contained in definition text of the SQL-server module body
REF_MODULE_NAME	VARCHAR(128)	SQL-server module name of contained in definition text of the SQL-server module body

MODULE_BODY_ROUTINE_USAGE

Identify the SQL-invoked routines owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
ROUTINE_CATALOG	VARCHAR(128)	catalog name of the SQL-invoked routine of contained in definition text of the SQL-server module body
ROUTINE_OWNER	VARCHAR(128)	owner name of the SQL-invoked routine of contained in definition text of the SQL-server module body
ROUTINE_SCHEMA	VARCHAR(128)	schema name of the SQL-invoked routine of contained in definition text of the SQL-server module body
ROUTINE_NAME	VARCHAR(128)	SQL-invoked routine name of contained in definition text of the SQL-server module body

MODULE_BODY_SEQUENCE_USAGE

Identify the sequences owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
SEQUENCE_CATALOG	VARCHAR(128)	catalog name of the sequence of contained in definition text of the SQL-server module body
SEQUENCE_OWNER	VARCHAR(128)	owner name of the sequence of contained in definition text of the SQL-server module body
SEQUENCE_SCHEMA	VARCHAR(128)	schema name of the sequence of contained in definition text of the SQL-server module body
SEQUENCE_NAME	VARCHAR(128)	sequence name of contained in definition text of the SQL-server module body

MODULE_BODY_TABLE_USAGE

Identify the tables owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
TABLE_CATALOG	VARCHAR(128)	catalog name of the table of contained in definition text of the SQL-server module body
TABLE_OWNER	VARCHAR(128)	owner name of the table of contained in definition text of the SQL-server module body
TABLE_SCHEMA	VARCHAR(128)	schema name of the table of contained in definition text of the SQL-server module body
TABLE_NAME	VARCHAR(128)	table name of contained in definition text of the SQL-server module body

MODULE_MODULE_USAGE

Identify the SQL-server modules owned by a given user or role on which SQL-server modules defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
REF_MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module of contained in definition text of the SQL-server module
REF_MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module of contained in definition text of the SQL-server module
REF_MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module of contained in definition text of the SQL-server module
REF_MODULE_NAME	VARCHAR(128)	SQL-server module name of contained in definition text of the SQL-server module

MODULE_PRIVILEGES

Identify the privileges on SQL-server modules defined in this catalog that are available to or granted by a given user or role.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted SQL-server module privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the SQL-server module privilege being described is granted
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module on which the privilege being described was granted
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module on which the privilege being described was granted
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module on which the privilege being described was granted
MODULE_NAME	VARCHAR(128)	name of the SQL-server module on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( EXECUTE )
IS_GRANTABLE	BOOLEAN	is grantable

MODULE_ROUTINE_USAGE

Identify the SQL-invoked routines owned by a given user or role on which SQL-server modules defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
ROUTINE_CATALOG	VARCHAR(128)	catalog name of the SQL-invoked routine of contained in definition text of the SQL-server module
ROUTINE_OWNER	VARCHAR(128)	owner name of the SQL-invoked routine of contained in definition text of the SQL-server module
ROUTINE_SCHEMA	VARCHAR(128)	schema name of the SQL-invoked routine of contained in definition text of the SQL-server module
ROUTINE_NAME	VARCHAR(128)	SQL-invoked routine name of contained in definition text of the SQL-server module

MODULE_SEQUENCE_USAGE

Identify the sequences owned by a given user or role on which SQL-server modules defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
SEQUENCE_CATALOG	VARCHAR(128)	catalog name of the sequence of contained in definition text of the SQL-server module
SEQUENCE_OWNER	VARCHAR(128)	owner name of the sequence of contained in definition text of the SQL-server module
SEQUENCE_SCHEMA	VARCHAR(128)	schema name of the sequence of contained in definition text of the SQL-server module
SEQUENCE_NAME	VARCHAR(128)	sequence name of contained in definition text of the SQL-server module

MODULE_TABLE_USAGE

Identify the tables owned by a given user or role on which SQL-server modules defined in this catalog are dependent.

Column information
Column name	Data type	Description
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module
MODULE_NAME	VARCHAR(128)	name of the SQL-server module
TABLE_CATALOG	VARCHAR(128)	catalog name of the table of contained in definition text of the SQL-server module
TABLE_OWNER	VARCHAR(128)	owner name of the table of contained in definition text of the SQL-server module
TABLE_SCHEMA	VARCHAR(128)	schema name of the table of contained in definition text of the SQL-server module
TABLE_NAME	VARCHAR(128)	table name of contained in definition text of the SQL-server module

PARAMETERS

Identify the SQL parameters of SQL-invoked routines defined in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	catalog name of the specific name of the SQL- invoked routine that contains the SQL parameter being described
SPECIFIC_OWNER	VARCHAR(128)	owner name of the specific name of the SQL- invoked routine that contains the SQL parameter being described
SPECIFIC_SCHEMA	VARCHAR(128)	schema name of the specific name of the SQL- invoked routine that contains the SQL parameter being described
SPECIFIC_NAME	VARCHAR(128)	specific name of the SQL- invoked routine that contains the SQL parameter being described
ORDINAL_POSITION	NUMBER	ordinal position of the SQL- invoked routine that contains the SQL parameter being described
PARAMETER_MODE	VARCHAR(32)	parameter mode of the SQL parameter being described
IS_RESULT	BOOLEAN	the parameter is RESULT parameter of type-preserving function
AS_LOCATOR	BOOLEAN	the parameter is passed as locator
PARAMETER_NAME	VARCHAR(128)	name of the SQL parameter being descaibed
FROM_SQL_SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the from-sql routine for the input parameter being described
FROM_SQL_SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the from-sql routine for the input parameter being described
FROM_SQL_SPECIFIC_NAME	VARCHAR(128)	specific name of the from-sql routine for the input parameter being described
TO_SQL_SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the to-sql routine for the input parameter being described
TO_SQL_SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the to-sql routine for the input parameter being described
TO_SQL_SPECIFIC_NAME	VARCHAR(128)	specific name of the to-sql routine for the input parameter being described
DATA_TYPE	VARCHAR(128)	data type of the SQL parameter being described
CHARACTER_MAXIMUM_LENGTH	NUMBER	maximum length of the SQL parameter being described
CHARACTER_OCTET_LENGTH	NUMBER	maximum length in octets of the SQL parameter being described
CHARACTER_SET_CATALOG	VARCHAR(128)	character set catalog name of the data type of the SQL parameter being described
CHARACTER_SET_SCHEMA	VARCHAR(128)	character set schema name of the data type of the SQL parameter being described
CHARACTER_SET_NAME	VARCHAR(128)	character set name of the data type of the SQL parameter being described
COLLATION_CATALOG	VARCHAR(128)	collation catalog name of the data type of the SQL parameter being described
COLLATION_SCHEMA	VARCHAR(128)	collation schema name of the data type of the SQL parameter being described
COLLATION_NAME	VARCHAR(128)	collation name of the data type of the SQL parameter being described
NUMERIC_PRECISION	NUMBER	precision of the data type of the SQL parameter being described
NUMERIC_PRECISION_RADIX	NUMBER	precision radix of the data type of the SQL parameter being described
NUMERIC_SCALE	NUMBER	scale of the data type of the SQL parameter being described
DATETIME_PRECISION	NUMBER	fractional second precisions of the data type of the SQL parameter being described
INTERVAL_TYPE	VARCHAR(32)	interval qualifier of the data type of the SQL parameter being described
INTERVAL_PRECISION	NUMBER	interval precision of the data type of the SQL parameter being described
UDT_CATALOG	VARCHAR(128)	catalog name of UDT of the data type of the SQL parameter being described
UDT_SCHEMA	VARCHAR(128)	schema name of UDT of the data type of the SQL parameter being described
UDT_NAME	VARCHAR(128)	name of UDT of the data type of the SQL parameter being described
SCOPE_CATALOG	VARCHAR(128)	catalog name of referenceable tables of the data type of the SQL parameter being described
SCOPE_SCHEMA	VARCHAR(128)	schema name of referenceable tables of the data type of the SQL parameter being described
SCOPE_NAME	VARCHAR(128)	name of referenceable tables of the data type of the SQL parameter being described
MAXIMUM_CARDINALITY	NUMBER	maximum cardinality of the data type of the SQL parameter being described
DTD_IDENTIFIER	NUMBER	dtd identifier of the data type of the SQL parameter being described
DECLARED_DATA_TYPE	VARCHAR(128)	declared data type of the SQL parameter being described
DECLARED_NUMERIC_PRECISION	NUMBER	precision of declared data type of the SQL parameter being described
DECLARED_NUMERIC_SCALE	NUMBER	scale of declared data type of the SQL parameter being described
PARAMETER_DEFAULT	LONG VARCHAR	default value of the SQL parameter being described

REFERENTIAL_CONSTRAINTS

Identify the referential constraints defined on tables in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the referential constraint
CONSTRAINT_OWNER	VARCHAR(128)	owner name who owns the referential constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the referential constraint being described
CONSTRAINT_NAME	VARCHAR(128)	referential constraint name
CONSTRAINT_TABLE_NAME	VARCHAR(128)	name of the table to which the referential constraint being described applies
CONSTRAINT_COLUMN_NAME	VARCHAR(128)	column name of the table to which the referential constraint being described applies
ORDINAL_POSITION	NUMBER	the ordinal position of the specific column in the referentail constraint being described.
UNIQUE_CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the unique or primary key constraint applied to the referenced column list being described
UNIQUE_CONSTRAINT_OWNER	VARCHAR(128)	owner name of the unique or primary key constraint applied to the referenced column list being described
UNIQUE_CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the unique or primary key constraint applied to the referenced column list being described
UNIQUE_CONSTRAINT_NAME	VARCHAR(128)	constraint name of the unique or primary key constraint applied to the referenced column list being described
UNIQUE_CONSTRAINT_TABLE_NAME	VARCHAR(128)	table name of the unique or primary key constraint applied to the referenced column list being described
UNIQUE_CONSTRAINT_COLUMN_NAME	VARCHAR(128)	column name of the unique or primary key constraint applied to the referenced column list being described
IS_PRIMARY_KEY	BOOLEAN	whether the constraint applied to the referenced column list being described, is primary key or not
MATCH_OPTION	VARCHAR(32)	the referential constraint that has a match option: the value in ( SIMPLE, PARTIAL, FULL )
UPDATE_RULE	VARCHAR(32)	the referential constraint that has an update rule: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
DELETE_RULE	VARCHAR(32)	the referential constraint that has a delete rule: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT )
IS_DEFERRABLE	BOOLEAN	is a deferrable constraint
INITIALLY_DEFERRED	BOOLEAN	is an initially deferred constraint

ROLE_COLUMN_GRANTS

Identify the privileges on columns defined in this catalog that are available to or granted by the currently enabled roles.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted column privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the column privilege being described is granted
TABLE_CATALOG	VARCHAR(128)	catalog name of the column on which the privilege being described was granted
TABLE_OWNER	VARCHAR(128)	table owner name of the column on which the privilege being described was granted
TABLE_SCHEMA	VARCHAR(128)	schema name of the column on which the privilege being described was granted
TABLE_NAME	VARCHAR(128)	table name of the column on which the privilege being described was granted
COLUMN_NAME	VARCHAR(128)	column name of the column on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( SELECT, INSERT, UPDATE, REFERENCES )
IS_GRANTABLE	BOOLEAN	is grantable

ROLE_MODULE_GRANTS

Identify the privileges on SQL-server modules defined in this catalog that are available to or granted by the currently enabled roles.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted SQL-server module privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the SQL-server module privilege being described is granted
MODULE_CATALOG	VARCHAR(128)	specific catalog name of the SQL-server module on which the privilege being described was granted
MODULE_OWNER	VARCHAR(128)	specific owner name of the SQL-server module on which the privilege being described was granted
MODULE_SCHEMA	VARCHAR(128)	specific schema name of the SQL-server module on which the privilege being described was granted
MODULE_NAME	VARCHAR(128)	specific name of the SQL-server module on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( EXECUTE )
IS_GRANTABLE	BOOLEAN	is grantable

ROLE_ROUTINE_GRANTS

Identify the privileges on SQL-invoked routines defined in this catalog that are available to or granted by the currently enabled roles.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted routine privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the routine privilege being described is granted
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_NAME	VARCHAR(128)	specific name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_CATALOG	VARCHAR(128)	routine catalog name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_OWNER	VARCHAR(128)	routine owner name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_SCHEMA	VARCHAR(128)	routine schema name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_NAME	VARCHAR(128)	routine name of the SQL-invoked routine on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( EXECUTE )
IS_GRANTABLE	BOOLEAN	is grantable

ROLE_TABLE_GRANTS

Identify the privileges on tables defined in this catalog that are available to or granted by the currently enabled roles.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted table privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the table privilege being described is granted
TABLE_CATALOG	VARCHAR(128)	catalog name of the table on which the privilege being described was granted
TABLE_OWNER	VARCHAR(128)	table owner name of the table on which the privilege being described was granted
TABLE_SCHEMA	VARCHAR(128)	schema name of the table on which the privilege being described was granted
TABLE_NAME	VARCHAR(128)	table name on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( CONTROL, SELECT, INSERT, UPDATE, DELETE, REFERENCES, LOCK, INDEX, ALTER )
IS_GRANTABLE	BOOLEAN	is grantable
WITH_HIERARCHY	BOOLEAN	whether the privilege was granted WITH HIERARCHY OPTION or not

ROLE_USAGE_GRANTS

Identify the USAGE privileges on objects defined in this catalog that are available to or granted by the currently enabled roles.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted usage privileges, on the object of the type identified by OBJECT_TYPE
GRANTEE	VARCHAR(128)	authorization identifier of some user or role, or PUBLIC to indicate all users, to whom the usage privilege being described is granted
OBJECT_CATALOG	VARCHAR(128)	catalog name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_OWNER	VARCHAR(128)	owner name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_SCHEMA	VARCHAR(128)	schema name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_NAME	VARCHAR(128)	object name of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_TYPE	VARCHAR(32)	the value is in ( DOMAIN, CHARACTER SET, COLLATION, TRANSLATION, SEQUENCE )
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( USAGE )
IS_GRANTABLE	BOOLEAN	is grantable

ROUTINES

Identify the SQL-invoked routines in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine
ROUTINE_CATALOG	VARCHAR(128)	catalog name of the routine
ROUTINE_OWNER	VARCHAR(128)	owner name of the routine
ROUTINE_SCHEMA	VARCHAR(128)	schema name of the routine
ROUTINE_NAME	VARCHAR(128)	null
ROUTINE_TYPE	VARCHAR(128)	name of the routine
MODULE_CATALOG	VARCHAR(128)	module name of the routine
MODULE_SCHEMA	VARCHAR(128)	schema name of the module in which the routine is defined
MODULE_NAME	VARCHAR(128)	name of the module in which the routine is defined
UDT_CATALOG	VARCHAR(128)	catalog name of the user-defined data type which defined the routine as a method function
UDT_SCHEMA	VARCHAR(128)	schema name of the user-defined data type which defined the routine as a method function
UDT_NAME	VARCHAR(128)	name of the user-defined data type which defined the routine as a method function
DATA_TYPE	VARCHAR(128)	data type the routine returns
CHARACTER_MAXIMUM_LENGTH	NUMBER	maximum character length of data type the routine returns
CHARACTER_OCTET_LENGTH	NUMBER	maximum character length in octets of data type the routine returns
CHARACTER_SET_CATALOG	VARCHAR(128)	character set catalog name of data type the routine returns
CHARACTER_SET_SCHEMA	VARCHAR(128)	character set schema name of data type the routine returns
CHARACTER_SET_NAME	VARCHAR(128)	character set name of data type the routine returns
COLLATION_CATALOG	VARCHAR(128)	collation catalog name of data type the routine returns
COLLATION_SCHEMA	VARCHAR(128)	collation schema name of data type the routine returns
COLLATION_NAME	VARCHAR(128)	collation name of data type the routine returns
NUMERIC_PRECISION	NUMBER	precision of data type the routine returns
NUMERIC_PRECISION_RADIX	NUMBER	precision radix of data type the routine returns
NUMERIC_SCALE	NUMBER	scale of data type the routine returns
DATETIME_PRECISION	NUMBER	fractional seconds precision of data type the routine returns
INTERVAL_TYPE	VARCHAR(32)	interval qualifier for data type the routine returns
INTERVAL_PRECISION	NUMBER	interval leading field precision of data type the routine returns
TYPE_UDT_CATALOG	VARCHAR(128)	catalog name of the user-defined data type, which is the data type the routine returns
TYPE_UDT_SCHEMA	VARCHAR(128)	schema name of the user-defined data type, which is the data type the routine returns
TYPE_UDT_NAME	VARCHAR(128)	name of the user-defined data type, which is the data type the routine returns
SCOPE_CATALOG	VARCHAR(128)	catalog name of referenceable table
SCOPE_SCHEMA	VARCHAR(128)	schema name of referenceable table
SCOPE_NAME	VARCHAR(128)	name of referenceable table
MAXIMUM_CARDINALITY	NUMBER	maximum cardinality of data type the routine returns
DTD_IDENTIFIER	NUMBER	dtd ientifier of data type the routine returns
ROUTINE_BODY	VARCHAR(32)	type of the routine body
ROUTINE_DEFINITION	LONG VARCHAR	catalog name of the routine
EXTERNAL_NAME	VARCHAR(128)	external name of the external routine
EXTERNAL_C_FUNCTION	LONG VARCHAR	external C function prototype of the SQL-invoked routine
EXTERNAL_LANGUAGE	VARCHAR(32)	language of the external routine
LIBRARY_SCHEMA	VARCHAR(128)	library schema name which associated with an operating-system shared library
LIBRARY_NAME	VARCHAR(128)	library name which associated with an operating-system shared library
PARAMETER_STYLE	VARCHAR(32)	SQL parameter passing style of the external routine
IS_DETERMINISTIC	BOOLEAN	the routine is deterministic or not
SQL_DATA_ACCESS	VARCHAR(32)	routine possibly contains SQL or access data
IS_NULL_CALL	BOOLEAN	routine returns NULL if any of parameter values are NULL
SQL_PATH	VARCHAR(1024)	described SQL PATH when the routine is defined
SCHEMA_LEVEL_ROUTINE	BOOLEAN	the routine is schema-level routine
MAX_DYNAMIC_RESULT_SETS	NUMBER	max result set count of the routine
IS_USER_DEFINED_CAST	BOOLEAN	the routine is a function that is a user-defined cast function
IS_IMPLICITLY_INVOCABLE	BOOLEAN	the user-defined cast function is implicitly invocable
SECURITY_TYPE	VARCHAR(32)	security type of the routine(DEFINER/INVOKER)
TO_SQL_SPECIFIC_CATALOG	VARCHAR(128)	catalog name of the to-sql routine of the result type of routine
TO_SQL_SPECIFIC_SCHEMA	VARCHAR(128)	schema name of the to-sql routine of the result type of routine
TO_SQL_SPECIFIC_NAME	VARCHAR(128)	name of the to-sql routine of the result type of routine
AS_LOCATOR	BOOLEAN	return value of the routine is passed as locator
CREATED	TIMESTAMP(6) WITHOUT TIME ZONE	creation time of the routine
LAST_ALTERED	TIMESTAMP(6) WITHOUT TIME ZONE	most lately altered time of the routine
NEW_SAVEPOINT_LEVEL	BOOLEAN	specifiy new savepoint level or not
IS_UDT_DEPENDENT	BOOLEAN	routine is dependent
RESULT_CAST_FROM_DATA_TYPE	VARCHAR(128)	data type which is specificed in result cast clause of the routine definition
RESULT_CAST_AS_LOCATOR	BOOLEAN	locator indication which is specificed in result cast clause of the routine definition
RESULT_CAST_CHAR_MAX_LENGTH	NUMBER	maximum character length of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_CHAR_OCTET_LENGTH	NUMBER	maximum character length in octets of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_CHAR_SET_CATALOG	VARCHAR(128)	character set catalog name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_CHAR_SET_SCHEMA	VARCHAR(128)	character set schema name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_CHARACTER_SET_NAME	VARCHAR(128)	character set name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_COLLATION_CATALOG	VARCHAR(128)	collation catalog name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_COLLATION_SCHEMA	VARCHAR(128)	collation schema name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_COLLATION_NAME	VARCHAR(128)	collation name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_NUMERIC_PRECISION	NUMBER	precision of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_NUMERIC_RADIX	NUMBER	precision radix of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_NUMERIC_SCALE	NUMBER	scale of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_DATETIME_PRECISION	NUMBER	fractional seconds precision of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_INTERVAL_TYPE	VARCHAR(32)	interval qualifier of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_INTERVAL_PRECISION	NUMBER	interval precision of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_TYPE_UDT_CATALOG	VARCHAR(128)	UDT catalog name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_TYPE_UDT_SCHEMA	VARCHAR(128)	UDT schema name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_TYPE_UDT_NAME	VARCHAR(128)	UDT name of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_SCOPE_CATALOG	VARCHAR(128)	catalog name of referenceable table described in result cast clause of the routine definition
RESULT_CAST_SCOPE_SCHEMA	VARCHAR(128)	schema name of referenceable table described in result cast clause of the routine definition
RESULT_CAST_SCOPE_NAME	VARCHAR(128)	name of referenceable table described in result cast clause of the routine definition
RESULT_CAST_MAX_CARDINALITY	NUMBER	maximum cardinality of data type which is specificed in result cast clause of the routine definition
RESULT_CAST_DTD_IDENTIFIER	NUMBER	dtd identifier of data type which is specificed in result cast clause of the routine definition
DECLARED_DATA_TYPE	VARCHAR(128)	declared data type of the routine returns
DECLARED_NUMERIC_PRECISION	NUMBER	declared data type precision of the routine returns
DECLARED_NUMERIC_SCALE	NUMBER	declared data type scale of the routine returns
RESULT_CAST_FROM_DECLARED_DATA_TYPE	VARCHAR(128)	declared data type which is specificed in result cast clause of the routine definition
RESULT_CAST_DECLARED_NUMERIC_PRECISION	NUMBER	declared data type precision which is specificed in result cast clause of the routine definition
RESULT_CAST_DECLARED_NUMERIC_SCALE	NUMBER	declared data type scale which is specificed in result cast clause of the routine definition
COMMENTS	VARCHAR(1024)	comment on the routine

ROUTINE_MODULE_USAGE

Identify the SQL-server modules owned by a given user or role on which SQL routines defined in this catalog are dependent.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module of contained in routine body of the SQL-invoked routine
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module of contained in routine body of the SQL-invoked routine
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module of contained in routine body of the SQL-invoked routine
MODULE_NAME	VARCHAR(128)	SQL-server module name of contained in routine body of the SQL-invoked routine

ROUTINE_PRIVILEGES

Identify the privileges on SQL-invoked routines defined in this catalog that are available to or granted by a given user or role.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted routine privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the routine privilege being described is granted
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the SQL-invoked routine on which the privilege being described was granted
SPECIFIC_NAME	VARCHAR(128)	specific name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_CATALOG	VARCHAR(128)	routine catalog name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_OWNER	VARCHAR(128)	null
ROUTINE_SCHEMA	VARCHAR(128)	routine schema name of the SQL-invoked routine on which the privilege being described was granted
ROUTINE_NAME	VARCHAR(128)	routine name of the SQL-invoked routine on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( EXECUTE )
IS_GRANTABLE	BOOLEAN	is grantable

ROUTINE_ROUTINE_USAGE

Identify each SQL-invoked routine owned by a given user or role on which an SQL routine defined in this catalog is dependent.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine
ROUTINE_CATALOG	VARCHAR(128)	routine catalog name of a routine contained in routine body of the SQL-invoked routine
ROUTINE_OWNER	VARCHAR(128)	routine owner name of a routine contained in routine body of the SQL-invoked routine
ROUTINE_SCHEMA	VARCHAR(128)	routine schema name of a routine contained in routine body of the SQL-invoked routine
ROUTINE_NAME	VARCHAR(128)	routine name of a routine contained in routine body of the SQL-invoked routine

ROUTINE_SEQUENCE_USAGE

Identify each external sequence generator owned by a given user or role on which some SQL routine defined in this catalog is dependent.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine
SEQUENCE_CATALOG	VARCHAR(128)	catalog name of the sequence of contained in routine body of the SQL-invoked routine
SEQUENCE_OWNER	VARCHAR(128)	owner name of the sequence of contained in routine body of the SQL-invoked routine
SEQUENCE_SCHEMA	VARCHAR(128)	schema name of the sequence of contained in routine body of the SQL-invoked routine
SEQUENCE_NAME	VARCHAR(128)	sequence name of contained in routine body of the SQL-invoked routine

ROUTINE_TABLE_USAGE

Identify the tables owned by a given user or role on which SQL routines defined in this catalog are dependent.

Column information
Column name	Data type	Description
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine
TABLE_CATALOG	VARCHAR(128)	catalog name of the table of contained in routine body of the SQL-invoked routine
TABLE_OWNER	VARCHAR(128)	owner name of the table of contained in routine body of the SQL-invoked routine
TABLE_SCHEMA	VARCHAR(128)	schema name of the table of contained in routine body of the SQL-invoked routine
TABLE_NAME	VARCHAR(128)	table name of contained in routine body of the SQL-invoked routine

SCHEMATA

Identify the schemata in a catalog that are owned by given user or accessible to given user or role.

Column information
Column name	Data type	Description
CATALOG_NAME	VARCHAR(128)	catalog name of the schema
SCHEMA_NAME	VARCHAR(128)	schema name
SCHEMA_OWNER	VARCHAR(128)	authorization name who owns the schema
DEFAULT_CHARACTER_SET_CATALOG	VARCHAR(128)	catalog name of the default character set for columns and domains in the schemata
DEFAULT_CHARACTER_SET_SCHEMA	VARCHAR(128)	schema name of the default character set for columns and domains in the schemata
DEFAULT_CHARACTER_SET_NAME	VARCHAR(128)	character set name of the default character set for columns and domains in the schemata
SQL_PATH	VARCHAR(1024)	character representation of schema path specification
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the schema
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the schema
COMMENTS	VARCHAR(1024)	comments of the schema

SEQUENCES

Identify the external sequence generators defined in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
SEQUENCE_CATALOG	VARCHAR(128)	catalog name of the sequence
SEQUENCE_OWNER	VARCHAR(128)	owner name of the sequence
SEQUENCE_SCHEMA	VARCHAR(128)	schema name of the sequence
SEQUENCE_NAME	VARCHAR(128)	sequence name
DATA_TYPE	VARCHAR(128)	the standard name of the data type
NUMERIC_PRECISION	NUMBER	the numeric precision of the numerical data type
NUMERIC_PRECISION_RADIX	NUMBER	the radix ( 2 or 10 ) of the precision of the numerical data type
NUMERIC_SCALE	NUMBER	the numeric scale of the exact numerical data type
START_VALUE	NUMBER	the start value of the sequence generator
MINIMUM_VALUE	NUMBER	the minimum value of the sequence generator
MAXIMUM_VALUE	NUMBER	the maximum value of the sequence generator
INCREMENT	NUMBER	the increment of the sequence generator
CYCLE_OPTION	BOOLEAN	cycle option
CACHE_SIZE	NATIVE_INTEGER	number of sequence numbers to cache
DECLARED_DATA_TYPE	VARCHAR(128)	the data type name that a user declared
DECLARED_NUMERIC_PRECISION	NUMBER	the precision value that a user declared
DECLARED_NUMERIC_SCALE	NUMBER	the scale value that a user declared
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the sequence generator
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the sequence generator
COMMENTS	VARCHAR(1024)	comments of the sequence generator

SQL_FEATURES

List the features and subfeatures of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.

Column information
Column name	Data type	Description
FEATURE_ID	VARCHAR(32)	identifier string of the conformance element
FEATURE_NAME	VARCHAR(1024)	descriptive name of the conformance element
SUB_FEATURE_ID	VARCHAR(32)	identifier string of the subfeature, or a single space if not a subfeature
SUB_FEATURE_NAME	VARCHAR(1024)	descriptive name of the subfeature, or a single space if not a subfeature
IS_SUPPORTED	BOOLEAN	TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not
IS_VERIFIED_BY	VARCHAR(1024)	If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the conformance element

SQL_IMPLEMENTATION_INFO

List the SQL-implementation information items defined in this ISO/IEC 9075 standard and, for each of these, indicate the value supported by the SQL-implementation.

Column information
Column name	Data type	Description
IMPLEMENTATION_INFO_ID	VARCHAR(32)	identifier string of the implementation information item
IMPLEMENTATION_INFO_NAME	VARCHAR(1024)	descriptive name of the implementation information item
INTEGER_VALUE	NATIVE_INTEGER	value of the implementation information item, or null if the value is contained in the column CHARACTER_VALUE
CHARACTER_VALUE	VARCHAR(32)	value of the implementation information item, or null if the value is contained in the column INTEGER_VALUE
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the implementation information item

SQL_PACKAGES

List the packages of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.

Column information
Column name	Data type	Description
ID	VARCHAR(32)	identifier string of the conformance element
NAME	VARCHAR(1024)	descriptive name of the conformance element
IS_SUPPORTED	BOOLEAN	TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not
IS_VERIFIED_BY	VARCHAR(1024)	If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the conformance element

SQL_PARTS

List the parts of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.

Column information
Column name	Data type	Description
ID	VARCHAR(32)	identifier string of the conformance element
NAME	VARCHAR(1024)	descriptive name of the conformance element
IS_SUPPORTED	BOOLEAN	TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not
IS_VERIFIED_BY	VARCHAR(1024)	If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the conformance element

SQL_SIZING

List the sizing items of this ISO/IEC 9075 standard, for each of these, indicate the size supported by the SQL-implementation.

Column information
Column name	Data type	Description
SIZING_ID	NATIVE_INTEGER	identifier of the sizing item
SIZING_NAME	VARCHAR(1024)	descriptive name of the sizing item
SUPPORTED_VALUE	NATIVE_INTEGER	value of the sizing item, or 0 if the size is unlimited or cannot be determined, or null if the features for which the sizing item is applicable are not supported
COMMENTS	VARCHAR(1024)	possibly a comment pertaining to the sizing item

STATISTICS

Provide a list of statistics about a single table and the indexes associated with the table that are accessible to a given user or role.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the table
TABLE_OWNER	VARCHAR(128)	owner name of the table
TABLE_SCHEMA	VARCHAR(128)	schema name of the table
TABLE_NAME	VARCHAR(128)	table name of the table
STAT_TYPE	VARCHAR(32)	statistics type: the value in ( TABLE STAT, INDEX CLUSTERED, INDEX HASHED, INDEX OTHER )
NON_UNIQUE	BOOLEAN	indicates whether the index does not allow duplicate values
INDEX_CATALOG	VARCHAR(128)	catalog name of the index
INDEX_OWNER	VARCHAR(128)	owner name of the index
INDEX_SCHEMA	VARCHAR(128)	schema name of the index
INDEX_NAME	VARCHAR(128)	name of the index
COLUMN_NAME	VARCHAR(128)	column name that participates in the index
ORDINAL_POSITION	NUMBER	ordinal position of the specific column in the index described
IS_ASCENDING_ORDER	BOOLEAN	index key column being described is sorted in ASCENDING(TRUE) or DESCENDING(FALSE) order
IS_NULLS_FIRST	BOOLEAN	the null values of the key column are sorted before(TRUE) or after(FALSE) non-null values
CARDINALITY	NUMBER	if STAT_TYPE is (TABLE TYPE), then this is the number of rows in the table; otherwise, it is the number of unique values in the index
PAGES	NUMBER	if STAT_TYPE is (TABLE TYPE), then this is the number of pages used for the table; otherwise, it is the number of pages used for the current index.
FILTER_CONDITION	VARCHAR(1024)	filter condition, if any.
COMMENTS	VARCHAR(1024)	if STAT_TYPE is (TABLE TYPE), then this is the table comments; otherwise, it is the index comments.

TABLES

Identify the tables defined in this catalog that are accessible to a given user or role

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the table
TABLE_OWNER	VARCHAR(128)	owner name of the table
TABLE_SCHEMA	VARCHAR(128)	schema name of the table
TABLE_NAME	VARCHAR(128)	table name of the table
TABLE_TYPE	VARCHAR(32)	the value is in ( BASE TABLE, VIEW, GLOBAL TEMPORARY, LOCAL TEMPORARY, SYSTEM VERSIONED, FIXED TABLE, DUMP TABLE )
DBC_TABLE_TYPE	VARCHAR(32)	ODBC/JDBC table type: the value is in ( TABLE, VIEW, GLOBAL TEMPORARY, LOCAL TEMPORARY, IMMUTABLE TABLE, SYSTEM TABLE, ALIAS, SYNONYM )
TABLESPACE_NAME	VARCHAR(128)	tablespace name of the table, NULL if view
SYSTEM_VERSION_START_COLUMN_NAME	VARCHAR(128)	if the table is a system-versioned table, then the name of the system-version start column of the table
SYSTEM_VERSION_END_COLUMN_NAME	VARCHAR(128)	if the table is a system-versioned table, then the name of the system-version end column of the table
SYSTEM_VERSION_RETENTION_PERIOD	VARCHAR(32)	if the table is a system-versioned table, then the character representation of the value of the retention period of the table
SELF_REFERENCING_COLUMN_NAME	VARCHAR(128)	if the table is a typed table, then the name of the self-referencing column of the table
REFERENCE_GENERATION	VARCHAR(32)	if the table has a self-referencing column, the value is in ( SYSTEM GENERATED, USER GENERATED, DERIVED )
USER_DEFINED_TYPE_CATALOG	VARCHAR(128)	if the table being described is a table of a structured type, the catalog name of the structured type
USER_DEFINED_TYPE_SCHEMA	VARCHAR(128)	if the table being described is a table of a structured type, the schema name of the structured type
USER_DEFINED_TYPE_NAME	VARCHAR(128)	if the table being described is a table of a structured type, the name of the structured type
IS_INSERTABLE_INTO	BOOLEAN	is an insertable-into table
IS_TYPED	BOOLEAN	is a typed table
COMMIT_ACTION	VARCHAR(32)	if the table is a temporary table, the value is in ( DELETE, PRESERVE )
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the table
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the table
COMMENTS	VARCHAR(1024)	comments of the table

TABLE_CONSTRAINTS

Identify the table constraints defined on tables in this catalog that are accessible to a given user or role

Column information
Column name	Data type	Description
CONSTRAINT_CATALOG	VARCHAR(128)	catalog name of the constraint
CONSTRAINT_OWNER	VARCHAR(128)	authorization name who owns the constraint
CONSTRAINT_SCHEMA	VARCHAR(128)	schema name of the constraint being described
CONSTRAINT_NAME	VARCHAR(128)	constraint name
TABLE_CATALOG	VARCHAR(128)	catalog name of the table to which the table constraint being described applies
TABLE_OWNER	VARCHAR(128)	authorization name who owns the table to to which the table constraint being described applies
TABLE_SCHEMA	VARCHAR(128)	schema name of the table to to which the table constraint being described applies
TABLE_NAME	VARCHAR(128)	table name of the table to to which the table constraint being described applies
CONSTRAINT_TYPE	VARCHAR(32)	the value is in ( PRIMARY KEY, UNIQUE, FOREIGN KEY, NOT NULL, CHECK )
IS_DEFERRABLE	BOOLEAN	is a deferrable constraint
INITIALLY_DEFERRED	BOOLEAN	is an initially deferred constraint
ENFORCED	BOOLEAN	is an enforced constraint
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the constraint
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the constraint
COMMENTS	VARCHAR(1024)	comments of the constraint

TABLE_PRIVILEGES

Identify the privileges on tables defined in this catalog that are available to or granted by a given user or role.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted table privileges
GRANTEE	VARCHAR(128)	authorization name of some user or role, or PUBLIC to indicate all users, to whom the table privilege being described is granted
TABLE_CATALOG	VARCHAR(128)	catalog name of the table on which the privilege being described was granted
TABLE_OWNER	VARCHAR(128)	table owner name of the table on which the privilege being described was granted
TABLE_SCHEMA	VARCHAR(128)	schema name of the table on which the privilege being described was granted
TABLE_NAME	VARCHAR(128)	table name on which the privilege being described was granted
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( CONTROL, SELECT, INSERT, UPDATE, DELETE, REFERENCES, LOCK, INDEX, ALTER )
IS_GRANTABLE	BOOLEAN	is grantable
WITH_HIERARCHY	BOOLEAN	whether the privilege was granted WITH HIERARCHY OPTION or not

TRIGGER_EVENT_ORDER

Identify trigger event order in the list of triggers with the same EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_ORIENTATION, and EVENT_MANIPULATION.

Column information
Column name	Data type	Description
EVENT_OBJECT_OWNER	VARCHAR(128)	owner name of the subject table of the trigger
EVENT_OBJECT_SCHEMA	VARCHAR(128)	schema name of the subject table of the trigger
EVENT_OBJECT_TABLE	VARCHAR(128)	table name of the subject table of the trigger
ACTION_TIMING	VARCHAR(32)	action timing, the value is in ( 'BEFORE', 'AFTER', 'INSTEAD OF' )
ACTION_ORIENTATION	VARCHAR(32)	action orientation, the value is in ( 'ROW', 'STATEMENT' )
EVENT_MANIPULATION	VARCHAR(32)	trigger event, the value is in ( 'INSERT', 'UPDATE', 'DELETE' )
ACTION_ORDER	NATIVE_BIGINT	the ordinal position of the trigger in the list of triggers with the same EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_ORIENTATION, and EVENT_MANIPULATION
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name

TRIGGER_MODULE_USAGE

Identify the SQL-server modules owned by a given user or role on which some trigger defined in this catalog is dependent.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module identified in the trigger
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module identified in the trigger
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module identified in the trigger
MODULE_NAME	VARCHAR(128)	module name of the SQL-server module identified in the trigger

TRIGGER_ROUTINE_USAGE

Identify each SQL-invoked routine owned by a given user or role on which some trigger defined in this catalog is dependent.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of the routine identified in the trigger
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of the routine identified in the trigger
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of the routine identified in the trigger
SPECIFIC_NAME	VARCHAR(128)	specific name of the routine identified in the trigger

TRIGGER_SEQUENCE_USAGE

Identify each external sequence generator owned by a given user or role on which some trigger defined in this catalog is dependent.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
SEQUENCE_CATALOG	VARCHAR(128)	catalog name of the sequence identified in the trigger
SEQUENCE_OWNER	VARCHAR(128)	owner name of the sequence identified in the trigger
SEQUENCE_SCHEMA	VARCHAR(128)	schema name of the sequence identified in the trigger
SEQUENCE_NAME	VARCHAR(128)	sequence name identified in the trigger

TRIGGER_TABLE_USAGE

Identify the tables on which triggers defined in this catalog and owned by a given user or role are dependent.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
TABLE_CATALOG	VARCHAR(128)	catalog name of the table identified in the trigger
TABLE_OWNER	VARCHAR(128)	owner name of the table identified in the trigger
TABLE_SCHEMA	VARCHAR(128)	schema name of the table identified in the trigger
TABLE_NAME	VARCHAR(128)	table name identified in the trigger

TRIGGERED_UPDATE_COLUMNS

Identify the columns in this catalog that are identified by the explicit UPDATE trigger event columns of a trigger defined in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
EVENT_OBJECT_CATALOG	VARCHAR(128)	catalog name of the subject table of the trigger
EVENT_OBJECT_OWNER	VARCHAR(128)	owner name of the subject table of the trigger
EVENT_OBJECT_SCHEMA	VARCHAR(128)	schema name of the subject table of the trigger
EVENT_OBJECT_TABLE	VARCHAR(128)	table name of the subject table of the trigger
EVENT_OBJECT_COLUMN	VARCHAR(128)	column name of the subject table of the trigger

TRIGGERS

Identify the triggers defined on tables in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
TRIGGER_CATALOG	VARCHAR(128)	catalog name of the trigger
TRIGGER_OWNER	VARCHAR(128)	owner name of the trigger
TRIGGER_SCHEMA	VARCHAR(128)	schema name of the trigger
TRIGGER_NAME	VARCHAR(128)	trigger name
EVENT_MANIPULATION	VARCHAR(32)	trigger event, the value is in ( 'INSERT', 'UPDATE', 'INSERT OR UPDATE', 'DELETE', 'INSERT OR DELETE', 'UPDATE OR DELETE', 'INSERT OR UPDATE OR DELETE' )
EVENT_OBJECT_CATALOG	VARCHAR(128)	catalog name of the subject table of the trigger
EVENT_OBJECT_OWNER	VARCHAR(128)	owner name of the subject table of the trigger
EVENT_OBJECT_SCHEMA	VARCHAR(128)	schema name of the subject table of the trigger
EVENT_OBJECT_TABLE	VARCHAR(128)	table name of the subject table of the trigger
ACTION_ORDER	NATIVE_INTEGER	the ordinal position of the trigger in the list of triggers with the same EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_TIMING, and ACTION_ORIENTATION
ACTION_CONDITION	LONG VARCHAR	action condition is a character representation of the <search condition> in the <triggered action> of the trigger
ACTION_STATEMENT	LONG VARCHAR	action statement is a character representation of the <triggered SQL statement> in the <triggered action> of the trigger
ACTION_ORIENTATION	VARCHAR(32)	action orientation, the value is in ( 'ROW', 'STATEMENT' )
ACTION_TIMING	VARCHAR(32)	action timing, the value is in ( 'BEFORE', 'AFTER', 'INSTEAD OF' )
ACTION_REFERENCE_OLD_TABLE	VARCHAR(128)	the <old transition table name> of the trigger
ACTION_REFERENCE_NEW_TABLE	VARCHAR(128)	the <new transition table name> of the trigger
ACTION_REFERENCE_OLD_ROW	VARCHAR(128)	the <old transition variable name> of the trigger
ACTION_REFERENCE_NEW_ROW	VARCHAR(128)	the <new transition variable name> of the trigger
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	created time of the trigger
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last modified time of the trigger
COMMENTS	VARCHAR(1024)	comments of the trigger

USAGE_PRIVILEGES

Identify the USAGE privileges on objects defined in this catalog that are available to or granted by a given user or role.

Column information
Column name	Data type	Description
GRANTOR	VARCHAR(128)	authorization name of the user who granted usage privileges, on the object of the type identified by OBJECT_TYPE
GRANTEE	VARCHAR(128)	authorization identifier of some user or role, or PUBLIC to indicate all users, to whom the usage privilege being described is granted
OBJECT_CATALOG	VARCHAR(128)	catalog name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_OWNER	VARCHAR(128)	owner name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_SCHEMA	VARCHAR(128)	schema name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_NAME	VARCHAR(128)	object name of the type identified by OBJECT_TYPE on which the privilege being described was granted
OBJECT_TYPE	VARCHAR(32)	the value is in ( DOMAIN, CHARACTER SET, COLLATION, TRANSLATION, SEQUENCE )
PRIVILEGE_TYPE	VARCHAR(32)	the value is in ( USAGE )
IS_GRANTABLE	BOOLEAN	is grantable

VIEWS

Identify the viewed tables defined in this catalog that are accessible to a given user or role.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the viewed table
TABLE_OWNER	VARCHAR(128)	owner name of the viewed table
TABLE_SCHEMA	VARCHAR(128)	schema name of the viewed table
TABLE_NAME	VARCHAR(128)	view name of the viewed table
VIEW_DEFINITION	LONG VARCHAR	the character representation of the user-specified query expression contained in the corresponding view descriptor
CHECK_OPTION	VARCHAR(32)	the value is in ( CASCADED, LOCAL, NONE )
IS_UPDATABLE	BOOLEAN	is an updatable view
INSERTABLE_INTO	BOOLEAN	is an insertable view
IS_TRIGGER_UPDATABLE	BOOLEAN	whether an update INSTEAD OF trigger is defined on the view or not
IS_TRIGGER_DELETABLE	BOOLEAN	whether a delete INSTEAD OF trigger is defined on the view or not
IS_TRIGGER_INSERTABLE_INTO	BOOLEAN	whether an insert INSTEAD OF trigger is defined on the view or not
IS_COMPILED	BOOLEAN	whether the view is compiled or not
IS_AFFECTED	BOOLEAN	whether the view is affected by modification of underlying object or not
COMMENTS	VARCHAR(1024)	comments of the view

VIEW_MODULE_USAGE

Identify the SQL-server modules owned by a given user or role on which views defined in this catalog are dependent.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the viewed table
TABLE_OWNER	VARCHAR(128)	owner name of the viewed table
TABLE_SCHEMA	VARCHAR(128)	schema name of the viewed table
TABLE_NAME	VARCHAR(128)	view name of the viewed table
MODULE_CATALOG	VARCHAR(128)	catalog name of the SQL-server module of contained in definition text of the view
MODULE_OWNER	VARCHAR(128)	owner name of the SQL-server module of contained in definition text of the view
MODULE_SCHEMA	VARCHAR(128)	schema name of the SQL-server module of contained in definition text of the view'
MODULE_NAME	VARCHAR(128)	SQL-server module name of contained in definition text of the view

VIEW_ROUTINE_USAGE

Identify each routine owned by a given user or role on which a view defined in this catalog is dependent.

Column information
Column name	Data type	Description
TABLE_CATALOG	VARCHAR(128)	catalog name of the viewed table
TABLE_OWNER	VARCHAR(128)	owner name of the viewed table
TABLE_SCHEMA	VARCHAR(128)	schema name of the viewed table
TABLE_NAME	VARCHAR(128)	view name of the viewed table
SPECIFIC_CATALOG	VARCHAR(128)	specific catalog name of a routine contained in the query expression of the view being described
SPECIFIC_OWNER	VARCHAR(128)	specific owner name of a routine contained in the query expression of the view being described
SPECIFIC_SCHEMA	VARCHAR(128)	specific schema name of a routine contained in the query expression of the view being described
SPECIFIC_NAME	VARCHAR(128)	specific name of a routine contained in the query expression of the view being described

VIEW_TABLE_USAGE

Identify the tables on which viewed tables defined in this catalog and owned by a given user or role are dependent.

Column information
Column name	Data type	Description
VIEW_CATALOG	VARCHAR(128)	catalog name of the viewed table
VIEW_OWNER	VARCHAR(128)	owner name of the viewed table
VIEW_SCHEMA	VARCHAR(128)	schema name of the viewed table
VIEW_NAME	VARCHAR(128)	view name of the viewed table
TABLE_CATALOG	VARCHAR(128)	catalog name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described
TABLE_OWNER	VARCHAR(128)	owner name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described
TABLE_SCHEMA	VARCHAR(128)	schema name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described
TABLE_NAME	VARCHAR(128)	table name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described

PERFORMANCE_VIEW_SCHEMA

The PERFORMANCE_VIEW_SCHEMA schema consists of views that can retrieve the current state of the system.

Execute PerformanceViewSchema.sql as follows to use the views.

For standalone

% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/standalone/PerformanceViewSchema.sql

For cluster

% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/cluster/PerformanceViewSchema.sql

The retrievable information of PERFORMANCE_VIEW_SCHEMA views varies depending on the startup phase (nomount, mount, open).
The following query displays the startup phase in which each view can be retrieved.

gSQL> select table_name, startup_phase from v$tables order by 1;

TABLE_NAME                 STARTUP_PHASE
-------------------------- -------------
V$AGABLE_INFO              OPEN         
V$ALLOCATOR                NO_MOUNT     
V$ARCHIVELOG               MOUNT        
V$AUDITABLE_DB_PRIVILEGES  NO_MOUNT     
V$AUDITABLE_SYSTEM_ACTIONS NO_MOUNT     
V$BACKUP                   MOUNT        
V$BALANCER                 OPEN         
V$BCH                      MOUNT        
V$BUFFER_STAT              MOUNT        
V$COLUMNS                  OPEN         
V$CONTROLFILE              MOUNT        
V$DATAFILE                 MOUNT        
V$DB_CHANGE_TRACKING       MOUNT        
V$DB_FILE                  MOUNT        
V$DB_PROPERTY              OPEN         
V$DISPATCHER               OPEN         
V$ERROR_CODE               NO_MOUNT     
V$INCREMENTAL_BACKUP       MOUNT        
V$INSTANCE                 NO_MOUNT     
V$KEYWORDS                 NO_MOUNT     

TABLE_NAME            STARTUP_PHASE
--------------------- -------------
V$LATCH               NO_MOUNT     
V$LICENSE             OPEN         
V$LOCKED_OBJECT       OPEN         
V$LOCK_WAIT           OPEN         
V$LOGFILE             MOUNT        
V$OPEN_CURSOR         NO_MOUNT     
V$PLAN_HISTORY        OPEN         
V$PLAN_HISTORY_LATEST OPEN         
V$PROCESS_MEM_STAT    NO_MOUNT     
V$PROCESS_SQL_STAT    NO_MOUNT     
V$PROCESS_STAT        NO_MOUNT     
V$PROPERTY            NO_MOUNT     
V$PROPERTY_ALIAS      NO_MOUNT     
V$PSM_RESERVED_WORDS  NO_MOUNT     
V$QUEUE               OPEN         
V$RELATION            OPEN         
V$RESERVED_WORDS      NO_MOUNT     
V$SEQUENCE            OPEN         
V$SESSION             NO_MOUNT     
V$SESSION_AUDIT       OPEN         

TABLE_NAME             STARTUP_PHASE
---------------------- -------------
V$SESSION_CONNECT_INFO NO_MOUNT     
V$SESSION_EVENT        OPEN         
V$SESSION_MEM_STAT     NO_MOUNT     
V$SESSION_MEM_USAGE    NO_MOUNT     
V$SESSION_SQL_STAT     NO_MOUNT     
V$SESSION_STAT         NO_MOUNT     
V$SESSION_WAIT         OPEN         
V$SHARED_MODE          OPEN         
V$SHARED_SERVER        OPEN         
V$SHM_SEGMENT          NO_MOUNT     
V$SPROPERTY            NO_MOUNT     
V$SQLFN_METADATA       NO_MOUNT     
V$SQL_CACHE            NO_MOUNT     
V$SQL_COMMAND          NO_MOUNT     
V$SQL_HISTORY          NO_MOUNT     
V$STATEMENT            NO_MOUNT     
V$SYSTEM_EVENT         OPEN         
V$SYSTEM_MEM_STAT      NO_MOUNT     
V$SYSTEM_SQL_STAT      NO_MOUNT     
V$SYSTEM_STAT          NO_MOUNT     

TABLE_NAME              STARTUP_PHASE
----------------------- -------------
V$TABLES                NO_MOUNT     
V$TABLESPACE            MOUNT        
V$TABLESPACE_STAT       OPEN         
V$TCL_LOGFILE           MOUNT        
V$TRANSACTION           OPEN         
V$UNDO_SEGMENT          OPEN         
V$WAIT_EVENT_CLASS_NAME OPEN         
V$WAIT_EVENT_NAME       OPEN         
V$XA_TRANSACTION        OPEN         

69 rows selected.

GV$ Global View

Cluster provides GV$ views corresponding to most V$ views. While a V$ view retrieves information from the currently connected cluster member, a GV$ view generally retrieves information from all active cluster members.

A general GV$ view includes all columns of its corresponding V$ view and additionally provides an ORIGIN_MEMBER_NAME column that indicates the cluster member that provided each row.

However, the following GV$ views, which provide cluster-wide common information or metadata, or whose views themselves represent information for the entire cluster, do not provide the ORIGIN_MEMBER_NAME column and have the same column structure as the corresponding V$ views.

GV$CLUSTER_MEMBER
GV$ERROR_CODE
GV$KEYWORDS
GV$PSM_RESERVED_WORDS
GV$RESERVED_WORDS
GV$SQLFN_METADATA
GV$TABLES

The column configuration of each GV$ view can be checked using the \DESC GV$view_name command.

It is available only on a cluster.

For example, the V$TRANSACTION information displays transaction information from the currently connected server as follows.

gSQL> SELECT TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME FROM V$TRANSACTION;

TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME                
-------- ---------- -------------- --------------------------
40501296         48 1098.1.26      2017-04-07 17:14:01.912637

On the other hand, the GV$TRANSACTION information displays transaction information from all servers as follows.

gSQL> SELECT ORIGIN_MEMBER_NAME, TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME FROM GV$TRANSACTION;

ORIGIN_MEMBER_NAME TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME                
------------------ -------- ---------- -------------- --------------------------
G1N1               40501296         48 1098.1.26      2017-04-07 17:14:01.912637
G2N2               40304688         48 1098.0.888     2017-04-07 17:14:55.134015
G2N1               42205232         48 1098.0.888     2017-04-07 17:14:55.135996
G1N2               40435760         48 1098.1.889     2017-04-07 17:14:01.910138

In the example above, the ORIGIN_MEMBER_NAME information indicates that the transaction information were obtained from the cluster members corresponding to G1N1, G2N1, G1N2, G2N2 each.

Information about a specific remote server can be retrieved by using a condition on the ORIGIN_MEMBER_NAME column as follows.

gSQL> 
SELECT ORIGIN_MEMBER_NAME, TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME 
  FROM GV$TRANSACTION 
WHERE ORIGIN_MEMBER_NAME IN ( 'G2N1', 'G3N2' );

ORIGIN_MEMBER_NAME TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME                
------------------ -------- ---------- -------------- --------------------------
G3N2               32178224         48 1099.0.888     2017-04-07 17:33:10.934752
G2N1               42270768         48 1099.0.888     2017-04-07 17:31:14.726007

2 rows selected.

V$AGABLE_INFO

The V$AGABLE_INFO displays the system agable information.

Column information
Column name	Data type	Description
SCN	VARCHAR(32)	system scn
AGABLE_SCN	VARCHAR(32)	system agable scn
AGABLE_SCN_GAP	VARCHAR(32)	gap between system scn and agable scn
OLDEST_SESSION_ID	NUMBER	identifier of session blocking aging

V$ALLOCATOR

The V$ALLOCATOR shows descriptions of all memory allocators.

Column information
Column name	Data type	Description
ID	NUMBER	allocator identifier
TYPE	VARCHAR(8)	allocator type: the value in ( REGION, DYNAMIC, ARRAY )
MINIMUM_FRAGMENT_SIZE	NUMBER	minimum size of free block
DESC	VARCHAR(64)	description of memory allocator

V$ARCHIVELOG

The V$ARCHIVELOG displays information of log archiving.

Column information
Column name	Data type	Description
ARCHIVELOG_MODE	VARCHAR(32)	database log mode: the value in ( NOARCHIVELOG, ARCHIVELOG )
LAST_ARCHIVED_LOG	NUMBER	sequence number of last archived log file
ARCHIVELOG_DIR	VARCHAR(1024)	archive destination path
ARCHIVELOG_FILE_PREFIX	VARCHAR(128)	file prefix name of the archived log

V$AUDITABLE_DB_PRIVILEGES

The V$AUDITABLE_DB_PRIVILEGES displays auditable database privileges.

Column information
Column name	Data type	Description
PRIVILEGE_ID	NUMBER	database privilege identifier
PRIVILEGE_NAME	VARCHAR(128)	database privilege name

V$AUDITABLE_SYSTEM_ACTIONS

The V$AUDITABLE_SYSTEM_ACTIONS displays auditable system actions.

Column information
Column name	Data type	Description
ACTION_ID	NUMBER	auditable system action identifier
ACTION_NAME	VARCHAR(128)	auditable system action name

V$BACKUP

The V$BACKUP displays information of backup.

Column information
Column name	Data type	Description
TBS_NAME	VARCHAR(128)	tablespace name
BACKUP_STATUS	VARCHAR(16)	indicates whether the tablespace begin backup ( ACTIVE ) or not ( INACTIVE )
BACKUP_LSN	NUMBER	the last checkpoint lsn of tablespace when backup started

V$BALANCER

The V$BALANCER displays information of balancer.

Column information
Column name	Data type	Description
PROCESS_ID	NUMBER	balancer process identifier
CUR_CONNECTIONS	NUMBER	current number of connections
CONNECTIONS	NUMBER	total number of connections
CONNECTIONS_HIGHWATER	NUMBER	highest number of connections
MAX_CONNECTIONS	NUMBER	maximum connections
STATUS	VARCHAR(16)	status

V$BCH

The V$BCH displays information of database buffer control header array.

Column information
Column name	Data type	Description
BCH_SEQ	NUMBER	bch sequence
TABLESPACE_ID	NUMBER	tablespace identifier of the page cached in the frame of bch
PAGE_ID	NUMBER	page identifier of the page cached in the frame of bch
LOGICAL_ADDRESS	VARCHAR(18)	logical address of the frame of bch
DIRTY	BOOLEAN	dirty state of the page cached in the frame of bch
PGAE_TYPE	VARCHAR(20)	page type of the page cached in the frame of bch
FIRST_DIRTY_LSN	NUMBER	first dirty lsn of the page cached in the frame of bch
RECOVERY_LSN	NUMBER	recovery lsn of the page cached in the frame of bch
LAST_FLUSHED_LSN	NUMBER	last flushed lsn of the page cached in the frame of bch
FIXED_COUNT	NUMBER	fixed count of the page cached in the frame of bch
TOUCHED_COUNT	NUMBER	touched count of the page cached in the frame of bch
RECENT_TOUCH_COUNT_INCREASED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	timestamp that touch count of the page cached in the frame of bch increased most recently
BCH_LIST_TYPE	VARCHAR(16)	list type to which the bch belongs
BCH_STATE	VARCHAR(16)	bch state

V$BUFFER_STAT

The V$BUFFER_STAT displays database buffer statistics.

Column information
Column name	Data type	Description
BUFFER_POOL_SIZE	NUMBER	total buffer frame size ( page count )
HASH_BUCKET_COUNT	NUMBER	buffer hash bucket count
LRU_LIST_COUNT	NUMBER	buffer lru list count
HOT_REGION_PERCENTAGE	NUMBER	percentage of lru hot region
HOT_REGION_CRITERIA	NUMBER	touch count criteria of lru hot region
CHECKPOINT_LIST_COUNT	NUMBER	buffer checkpoint list count
FLUSH_LIST_COUNT	NUMBER	buffer flush list count
FREE_LIST_COUNT	NUMBER	buffer free list count
FREE_BUFFER_WAIT	NUMBER	total number of waiting for free list
READ_COMPLETE_WAIT	NUMBER	total number of waiting for read page complete
BUFFER_LOOKUPS	NUMBER	total number of lookups in the buffer for requested pages
BUFFER_HIT	NUMBER	total number of hits in the buffer for requested pages
BUFFER_MISS	NUMBER	total number of misses in the buffer for requested pages
TOTAL_WRITES	NUMBER	total number of physical writes
TOTAL_READS	NUMBER	total number of physical reads
FLUSH_PER_SECOND	NUMBER	total number of disk writes per one second
READ_PER_SECOND	NUMBER	total number of disk reads per one second
AVERAGE_WRITE_LATENCY	NUMBER	average latency of disk writes
AVERAGE_READ_LATENCY	NUMBER	average latency of disk reads

V$CLUSTER_COMMAND

The V$CLUSTER_COMMAND lists statistics information of each cluster command.

It is available only on a cluster.

Column information
Column name	Data type	Description
COMMAND	VARCHAR(128)	command name
SEND_COUNT	NUMBER	send count
ELAPSED_TIME	NUMBER	average elapsed time for command requests
RECEIVE_COUNT	NUMBER	receive count

V$CLUSTER_CONNECTION

The V$CLUSTER_CONNECTION displays a list of all cluster connections.

It is available only on a cluster.

Column information
Column name	Data type	Description
DISPATCHER_ID	NUMBER	dispatcher identifier
IS_SENDER	BOOLEAN	indicates whether the connection is owned by the sender (TRUE) or not (FALSE)
LOCAL_PORT	NUMBER	port number of connected local socket
PEER_MEMBER_POS	NUMBER	member position of connected peer
PEER_ADDR	VARCHAR(1024)	ip address of connected peer socket
PEER_PORT	NUMBER	port number of connected peer socket

V$CLUSTER_DISPATCHER

The V$CLUSTER_DISPATCHER displays cluster dispatcher information.

It is available only on a cluster.

Column information
Column name	Data type	Description
DISPATCHER_ID	NUMBER	dispatcher identifier
TYPE	VARCHAR(64)	dispatcher type: the value in ( commit, heartbeat, lockable, lockless, sync, urgent )
RX_BYTES	NUMBER	total amount of data that has received through the dispatcher
TX_BYTES	NUMBER	total amount of data that has transmitted through the dispatcher
RX_JOBS	NUMBER	the total number of jobs received
TX_JOBS	NUMBER	the total number of jobs transmitted

V$CLUSTER_LOCATION

The V$CLUSTER_LOCATION displays cluster location information.

It is available only on a cluster.

Column information
Column name	Data type	Description
MEMBER_NAME	VARCHAR(128)	member name
HOST	VARCHAR(256)	host name or IP address of a member
PORT	NUMBER	host port of a member

V$CLUSTER_MEMBER

The V$CLUSTER_MEMBER displays cluster member information.

It is available only on a cluster.

Column information
Column name	Data type	Description
MEMBER_ID	NUMBER	member identifier
MEMBER_POSITION	NUMBER	member position
STATUS	VARCHAR(64)	status of the member: the value in ( ACTIVE, INACTIVE )
IS_GLOBAL_COORD	BOOLEAN	indicates whether a member is global coordnator (TRUE) or not (FALSE)
IS_GROUP_COORD	BOOLEAN	indicates whether a member is group coordnator (TRUE) or not (FALSE)

V$CLUSTER_QUEUE

The V$CLUSTER_QUEUE displays a list of all cluster queues.

It is available only on a cluster.

Column information
Column name	Data type	Description
NAME	VARCHAR(128)	the name of the queue
QUEUED	NUMBER	the number of items currently enqueued
QUEUE_SIZE	NUMBER	size of queue
TOTAL_QUEUED	NUMBER	total number of enqueued items

V$CLUSTER_SERVER

The V$CLUSTER_SERVER displays a list of all cluster servers.

It is available only on a cluster.

Column information
Column name	Data type	Description
NAME	VARCHAR(128)	name of the cluster server
OS_PROC_ID	NUMBER	process identifier of the cluster server in the operating system
PROCESSED_JOBS	NUMBER	total number of jobs processed
STATUS	VARCHAR(16)	status of cluster server: the value in( NONE, WAIT, SUSPEND, RUN )
DRIVER_SESSION_ID	NUMBER	identifier of the session that orginated the job
DRIVER_MEMBER_POS	NUMBER	member position from which the job orginated
WAIT_EVENT_ID	NUMBER	identifier of the wait event (valid only if STATUS is SUSPEND)

V$COLUMNS

The V$COLUMNS has one row for each column of all the performance views (views beginning with V$).

Use \desc as follows to retrieve the column information of a performance view in the nomount or mount phase, during which V$COLUMNS is not available.

gSQL> \desc V$INSTANCE

COLUMN_NAME     TYPE                           IS_NULLABLE
--------------- ------------------------------ -----------
RELEASE_VERSION VARCHAR(64)          FALSE      
STARTUP_TIME    TIMESTAMP(6) WITHOUT TIME ZONE FALSE      
INSTANCE_STATUS VARCHAR(16)          FALSE

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	owner name who owns the performance view
TABLE_SCHEMA	VARCHAR(128)	schema name of the performance view
TABLE_NAME	VARCHAR(128)	name of the performance view
COLUMN_NAME	VARCHAR(128)	column name
ORDINAL_POSITION	NUMBER	the ordinal position (> 0) of the column in the performance view
DATA_TYPE	VARCHAR(128)	the data type name that a user declared
DATA_PRECISION	NUMBER	the precision value that a user declared
DATA_SCALE	NUMBER	the scale value that a user declared
COMMENTS	VARCHAR(1024)	comments of the column

V$CONTROLFILE

This view displays information about GOLDILOCKS control files.

Column information
Column name	Data type	Description
STATUS	VARCHAR(16)	control file status ( VALID, CORRUPTED )
CONTROLFILE_NAME	VARCHAR(1152)	control file name ( absolute path )
LAST_CHECKPOINT_LSN	NATIVE_BIGINT	the last checkpoint lsn
ON_DISK_LSN	NATIVE_BIGINT	the minimum lsn of the most recent log that must be contained in the logfile to complete recovery
IS_PRIMARY	BOLLEAN	indicates whether the control file is primary

V$DATAFILE

The V$DATAFILE displays information of all datafiles.

Column information
Column name	Data type	Description
TBS_NAME	VARCHAR(128)	tablespace name
DATAFILE_NAME	VARCHAR(1024)	datafile name ( absolute path )
CHECKPOINT_LSN	NUMBER	LSN at last checkpoint ( null if temporary tablespace )
CREATION_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	timestamp of the datafile creation
FILE_SIZE	NUMBER	datafile size ( in bytes )
LOADED_CHECKPOINT_LSN	NUMBER	checkpoint LSN of the datafile loaded in memory
CORRUPT_PAGE_COUNT	NUMBER	number of corrupt pages in the datafile

V$DB_CHANGE_TRACKING

The V$DB_CHANGE_TRACKING displays information of database change tracking.

Column information
Column name	Data type	Description
TABLESPACE_ID	NUMBER	tablespage identifier
DATAFILE_ID	NUMBER	datafile identifier
CHANGE_TRACKING_STATE	VARCHAR(32)	state of datafile change tracking

V$DB_FILE

The V$DB_FILE displays a list of all files using in database.

Column information
Column name	Data type	Description
FILE_NAME	VARCHAR(1024)	file name
FILE_TYPE	VARCHAR(16)	file type

V$DB_PROPERTY

The V$DB_PROPERTY displays a list of permanent property.

Column information
Column name	Data type	Description
PROPERTY_NAME	VARCHAR(128)	name of the property
DESCRIPTION	VARCHAR(2048)	description of the property
DATA_TYPE	VARCHAR(32)	data type of the property
VALUE_UNIT	VARCHAR(32)	unit of the property value: the value in ( NONE, BYTE, MS(milisec) )
PROPERTY_VALUE	VARCHAR(2048)	property value for the session. otherwise, the instance-wide value
MIN_VALUE	NUMBER	minimum value for property. null if type is varchar
MAX_VALUE	NUMBER	maximum value for property. null if type is varchar
SES_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SESSION or not: the value in ( TRUE, FALSE )
SYS_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SYSTEM and when the change takes effect: the value in ( NONE, FALSE, IMMEDIATE, DEFERRED )
IS_MODIFIABLE	VARCHAR(32)	property can be changed or not: the value in ( TRUE, FALSE )
IS_DEPRECATED	VARCHAR(32)	whether a property is deprecated or not: the value in (TRUE, FALSE)
IS_GLOBAL	VARCHAR(32)	whether a property scope is global or not: the value in (TRUE, FALSE)

V$DISPATCHER

The V$DISPATCHER displays information of dispatchers.

Column information
Column name	Data type	Description
PROCESS_ID	NUMBER	dispatcher process identifier
RESPONSE_JOB_COUNT	NUMBER	response job count
ACCEPT	NUMBER	indicates whether this dispatcher is accepting new connections
START_TIME	NUMBER	process start time
CUR_CONNECTIONS	NUMBER	current number of connections
CONNECTIONS	NUMBER	total number of connections
CONNECTIONS_HIGHWATER	NUMBER	highest number of connections
MAX_CONNECTIONS	NUMBER	maximum connections
RECV_STATUS	VARCHAR(16)	receive status
RECV_BYTES	NUMBER	total bytes of received
RECV_UNITS	NUMBER	total units of received
RECV_IDLE	NUMBER	total idle time of receive (1/100 second)
RECV_BUSY	NUMBER	total busy time of receive (1/100 second)
SEND_STATUS	VARCHAR(16)	send status
SEND_BYTES	NUMBER	total bytes of sent
SEND_UNITS	NUMBER	total units of sent
SEND_IDLE	NUMBER	total idle time of send (1/100 second)
SEND_BUSY	NUMBER	total busy time of send (1/100 second)

V$ERROR_CODE

The V$ERROR_CODE displays a list of all GOLDILOCKS error codes.

Column information
Column name	Data type	Description
ERROR_CODE	NUMBER	GOLDILOCKS error code
SQL_STATE	VARCHAR(32)	standard SQLSTATE code
ERROR_MESSAGE	VARCHAR(1024)	error message

V$GLOBAL_TRANSACTION

The V$GLOBAL_TRANSACTION displays information on the currently active global transactions.

Column information
Column name	Data type	Description
GLOBAL_TRANS_ID	VARCHAR(1024)	global transaction identifier
LOCAL_TRANS_ID	NUMBER	local transaction identifier
GLOBAL_TRANS_STATE	VARCHAR(32)	state of the global transaction: the value in ( NOTR, ACTIVE, IDLE, PREPARED, ROLLBACK_ONLY, HEURISTIC_COMPLETED )
ASSO_STATE	VARCHAR(32)	associate state of the global transaction: the value in ( NOT_ASSOCIATED, ASSOCIATED, ASSOCIATION_SUSPENDED )
START_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	global transaction start time
IS_REPREPARABLE	BOOLEAN	indicates whether the global transaction is repreparable

V$INCREMENTAL_BACKUP

The V$INCREMENTAL_BACKUP displays information about control files and datafiles in backup sets from the control file.

Column information
Column name	Data type	Description
BACKUP_NAME	VARCHAR(1024)	backup file name ( absolute path )
BACKUP_SCOPE	VARCHAR(128)	incremental backup scope: the value in ( database, tablespace, control )
INCREMENTAL_LEVEL	NUMBER	incremental backup level: the value in ( 0, 1, 2, 3, 4 )
INCREMENTAL_TYPE	VARCHAR(32)	incremental backup type: the value in ( DIFFERENTIAL, CUMULATIVE )
LSN	NUMBER	all changes up to checkpoint LSN are included in this backup
BEGIN_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	incremental backup beginning time
COMPLETION_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	incremental backup completion time

V$INSTANCE

This view displays the state of the current instance.

Column information
Column name	Data type	Description
RELEASE_VERSION	VARCHAR(64)	release version
STARTUP_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	time when the instance was started
INSTANCE_STATUS	VARCHAR(16)	status of the instance: the value in ( STARTED, MOUNTED, OPEN )

V$JOURNALING

The V$JOURNALING displays journaling information.

It is available only on a cluster.

Column information
Column name	Data type	Description
TABLE_NAME	VARCHAR(128)	table name
SHARD_ID	NUMBER	shard identifier
RECORD_COUNT	NUMBER	journaled record count
TOTAL_SIZE	NUMBER	total size of journaled records (byte)

V$KEYWORDS

The V$KEYWORDS displays a list of all SQL keywords.

Column information
Column name	Data type	Description
KEYWORD_NAME	VARCHAR(128)	name of keyword
KEYWORD_LENGTH	NUMBER	length of the keyword
IS_RESERVED	BOOLEAN	indicates whether the keyword cannot be used as an identifier (TRUE) or whether the keyword is not reserved (FALSE)

V$LATCH

The V$LATCH shows latch information.

Column information
Column name	Data type	Description
LATCH_DESCRIPTION	VARCHAR(64)	latch description
REF_COUNT	NUMBER	reference count
SPIN_LOCK	VARCHAR(3)	indicates whether the spin lock is locked ( YES ) or not ( NO )
WAIT_COUNT	NUMBER	wait count
CURRENT_MODE	VARCHAR(32)	current latch mode: the value in ( INITIAL, SHARED, EXCLUSIVE )

V$LICENSE

The V$LICENSE displays information of current license.

Column information
Column name	Data type	Description
LICENSE_TYPE	VARCHAR(8)	license type
START_DATE	DATE	start date of the license
EXPIRE_DATE	DATE	expire date of the license

V$LOGFILE

The V$LOGFILE displays information of all redo log members.

Column information
Column name	Data type	Description
GROUP_ID	NUMBER	redo log group identifier
FILE_NAME	VARCHAR(1024)	name of the log member
GROUP_STATE	VARCHAR(32)	state of the log group: the value in ( UNUSED, ACTIVE, CURRENT, INACTIVE )
FILE_SEQ	NUMBER	file sequence number of the log member
FILE_SIZE	NUMBER	file size of the log member ( in bytes )

V$LOCK_WAIT

This view lists the locks currently held and outstanding requests for a lock.

Column information
Column name	Data type	Description
GRANT_TRANS_ID	NUMBER	transaction identifier that holds the lock
REQUEST_TRANS_ID	NUMBER	transaction identifier that requests the lock

V$LOCKED_OBJECT

This view shows locked object information.

Column information
Column name	Data type	Description
LOCK_SLOT_ID	NUMBER	lock slot identifier
TABLE_OWNER	VARCHAR(128)	owner name who owns the locked table
TABLE_SCHEMA	VARCHAR(128)	schema of the locked table
TABLE_NAME	VARCHAR(128)	locked table name
LOCK_MODE	VARCHAR(8)	granted lock mode (IS, IX, S, X, SIX)

V$OPEN_CURSOR

The view lists display cursor status information for each current session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	ID of the session
USER_NAME	VARCHAR(128)	NAME of the user
CURSOR_NAME	VARCHAR(128)	NAME of the cursor
PSM_CURSOR_ID	NUMBER	ID of the PSM cursor
SQL_TEXT	LONG VARCHAR	SQL text for the cursor
IS_PSM_CURSOR	BOOLEAN	is PSM cursor
IS_OPEN	BOOLEAN	is open
OPEN_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	cursor open time
LAST_EXEC_TIME	NATIVE_BIGINT	last execution time(us)
IS_SENSITIVE	BOOLEAN	is sensitive
IS_SCROLLABLE	BOOLEAN	is scrollable
IS_HOLDABLE	BOOLEAN	is holdable
IS_UPDATABLE	BOOLEAN	is updatable

V$PLAN_HISTORY

The V$PLAN_HISTORY displays information of SQL plans.

Column information
Column name	Data type	Description
DRIVER_MEMBER_POS	NUMBER	driver member position
DRIVER_SESSION_ID	NUMBER	driver session identifier
SESSION_ID	NUMBER	session identifier
STMT_ID	NUMBER	statement identifier in a session
CL_STMT_ID	NUMBER	cluster statement identifier in a session
DRIVER_CL_STMT_ID	NUMBER	driver cluster statement identifier in a session
PLAN_HISTORY_POS	NUMBER	plan history position
PLAN_HISTORY_ID	NUMBER	plan history identifier
SQL_TEXT	LONG VARCHAR	SQL text for the statement
PLAN_TEXT	LONG VARCHAR	plan text for the statement
LAST_EXEC_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	statement last execution time

V$PLAN_HISTORY_LATEST

The V$PLAN_HISTORY_LATEST displays information of the latest SQL plan.

Column information
Column name	Data type	Description
DRIVER_MEMBER_POS	NUMBER	driver member position
DRIVER_SESSION_ID	NUMBER	driver session identifier
SESSION_ID	NUMBER	session identifier
STMT_ID	NUMBER	statement identifier in a session
CL_STMT_ID	NUMBER	cluster statement identifier in a session
DRIVER_CL_STMT_ID	NUMBER	driver cluster statement identifier in a session
PLAN_HISTORY_POS	NUMBER	plan history position
PLAN_HISTORY_ID	NUMBER	plan history identifier
SQL_TEXT	LONG VARCHAR	SQL text for the statement
PLAN_TEXT	LONG VARCHAR	plan text for the statement
LAST_EXEC_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	statement last execution time

V$PROCESS_STAT

The V$PROCESS_STAT displays goldilocks process statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
PROC_ID	NUMBER	goldilocks process identifier
STAT_VALUE	NUMBER	statistic value

V$PROCESS_MEM_STAT

The V$PROCESS_MEM_STAT displays goldilocks process memory statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
PROC_ID	NUMBER	goldilocks process identifier
STAT_VALUE	NUMBER	statistic value

V$PROCESS_SQL_STAT

The V$PROCESS_SQL_STAT displays goldilocks process SQL statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
PROC_ID	NUMBER	goldilocks process identifier
STAT_VALUE	NUMBER	statistic value

V$PROPERTY

The V$PROPERTY displays a list of all properties at current session. Otherwise, the instance-wide value.

Column information
Column name	Data type	Description
PROPERTY_NAME	VARCHAR(128)	name of the property
DESCRIPTION	VARCHAR(2048)	description of the property
DATA_TYPE	VARCHAR(32)	data type of the property
STARTUP_PHASE	VARCHAR(32)	modifiable startup-phase: the value IN ( NO MOUNT / MOUNT / OPEN & [BELOW\|ABOVE] )
VALUE_UNIT	VARCHAR(32)	unit of the property value: the value in ( NONE, BYTE, MS(milisec) )
PROPERTY_VALUE	VARCHAR(2048)	property value for the session. otherwise, the instance-wide value
PROPERTY_SOURCE	VARCHAR(32)	source of the current property value: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM )
INIT_VALUE	VARCHAR(2048)	property init value for the session
INIT_SOURCE	VARCHAR(32)	source of the current property INIT_VALUE: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM )
MIN_VALUE	NUMBER	minimum value for property. null if type is varchar
MAX_VALUE	NUMBER	maximum value for property. null if type is varchar
SES_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SESSION or not: the value in ( TRUE, FALSE )
SYS_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SYSTEM and when the change takes effect: the value in ( NONE, FALSE, IMMEDIATE, DEFERRED )
IS_MODIFIABLE	VARCHAR(32)	property can be changed or not: the value in ( TRUE, FALSE )
IS_DEPRECATED	VARCHAR(32)	whether a property is deprecated or not: the value in (TRUE, FALSE)
IS_GLOBAL	VARCHAR(32)	whether a property scope is global or not: the value in (TRUE, FALSE)

V$PROPERTY_ALIAS

The V$PROPERTY_ALIAS displays a list of all properties alias.

Column information
Column name	Data type	Description
PROPERTY_NAME	VARCHAR(128)	original name of the property
PROPERTY_ALIAS	VARCHAR(128)	alias name of the property

V$PSM_RESERVED_WORDS

The V$PSM_RESERVED_WORDS displays a list of all PSM reserved keywords. Reserved words cannot be used in variable name or procedure name.

Column information
Column name	Data type	Description
KEYWORD_NAME	VARCHAR(128)	name of keyword
KEYWORD_LENGTH	NUMBER	length of the keyword

V$QUEUE

The V$QUEUE displays information of queue.

Column information
Column name	Data type	Description
TYPE	NUMBER	queue type ( COMMON or DISPATCHER )
INDEX	NUMBER	index
QUEUED	NUMBER	number of items in the queue
WAIT	NUMBER	total time that all items in this queue have waited (1/100 second)
TOTALQ	VARCHAR(128)	total number of items that have ever been in the queue

V$RELATION

The V$RELATION displays information of all relations

Column information
Column name	Data type	Description
NAME	VARCHAR(128)	name of the relation
TBS_ID	NUMBER	tablespace identifier
PHYSICAL_ID	NUMBER	physical identifier of the relation
TYPE	VARCHAR(128)	type of the relation: values in ( TABLE, BTREE INDEX, GLOBAL SECONDARY INDEX )
USABLE	BOOLEAN	indicates whether the relation is usable or not
ALLOC_PAGE_COUNT	NUMBER	number of pages currently allocated
GLOBAL_SCN	VARCHAR(128)	global scn of the relation: only available for the TABLE type

V$RESERVED_WORDS

The V$RESERVED_WORDS displays a list of all SQL reserved keywords. Reserved words cannot be used in table name or column name.

Column information
Column name	Data type	Description
KEYWORD_NAME	VARCHAR(128)	name of keyword
KEYWORD_LENGTH	NUMBER	length of the keyword

V$SEQUENCE

The V$SEQUENCE displays information of sequences

Column information
Column name	Data type	Description
SEQUENCE_NAME	VARCHAR(128)	sequence name
PHYSICAL_ID	NUMBER	sequence physical identifier
START_WITH	NUMBER	start with value
INCREMENT_BY	NUMBER	increment value
MAXVALUE	NUMBER	maximum value
MINVALUE	NUMBER	minimum value
CACHE_SIZE	NUMBER	cache size
LOCAL_NEXT_VALUE	NUMBER	local next value
LOCAL_CURR_VALUE	NUMBER	local current value
RESTART_VALUE	NUMBER	restart value
CYCLE	BOOLEAN	allow cycle
USE_LAST_VALUE	BOOLEAN	use last value or not
LOCAL_CACHE_COUNT	NUMBER	current local cache count
GLOBAL_NEXT_VALUE	NUMBER	global next cache chunk start value
SYNC_COMPARE_SN	NUMBER	serial number for global sequence synchronization
IS_ONLINE	BOOLEAN	is online
LAST_SYNC_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	last time the sequence was synchronized

V$SESSION

The V$SESSION displays session information for each current session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	session identifier
SERIAL_NO	NUMBER	session serial number
TRANS_ID	NUMBER	transaction identifier ( -1 if inactive transaction )
CONNECTION_TYPE	VARCHAR(32)	connection type: the value in ( DA, TCP )
USER_NAME	VARCHAR(128)	user name
SESSION_STATUS	VARCHAR(32)	status of the session: the value in ( CONNECTED, SIGNALED, SNIPED, DEAD )
SERVER_TYPE	VARCHAR(32)	server type: the value in ( DEDICATED, SHARED )
PROCESS_ID	NUMBER	client process identifier
LOGON_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	logon time
PROGRAM_NAME	VARCHAR(128)	program name
CLIENT_ADDRESS	VARCHAR(1024)	client address ( null if DA )
CLIENT_PORT	NUMBER	client port ( 0 if DA )
FAILOVER_TYPE	VARCHAR(13)	indicates whether and to what extent transparent application failover (TAF) is enabled for the session ( NONE, SESSION )
FAILED_OVER	VARCHAR(3)	indicates whether the session is running in failover mode and failover has occurred (YES) or not (NO)
IS_AUDITED	VARCHAR(3)	indicates whether the session is audited (YES) or not (NO)

V$SESSION_AUDIT

The V$SESSION_AUDIT displays audited session information.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	session identifier
SERIAL_NO	NUMBER	session serial number
POLICY_NAME	VARCHAR(128)	active audit policy name
WHEN_SUCCESS	VARCHAR(3)	indicates whether the audit policy is enable for auditing successful events or not
WHEN_FAILURE	VARCHAR(3)	indicates whether the audit policy is enable for auditing unsuccessful events or not

V$SESSION_CONNECT_INFO

The V$SESSION_CONNECT_INFO displays information about network connections for the current session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	session identifier
SERIAL_NO	NUMBER	session serial number
CLIENT_CHARSET	VARCHAR(40)	client character set

V$SESSION_EVENT

The V$SESSION_EVENT displays information on waits for an event by a session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	ID of the session
WAIT_EVENT_ID	NUMBER	Identifier of the wait event
WAIT_EVENT_NAME	VARCHAR(64)	Name of the wait event
TOTAL_WAITS	NUMBER	Total number of waits for the event
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event
TIME_WAITED	NUMBER	Total amount of time waited for the event (microsecond)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event (microsecond)
MAX_WAIT	NUMBER	Maximum time waited for the event by the session (microsecond)
CLASS_NAME	VARCHAR(64)	Name of the class of the wait event

V$SESSION_STAT

The V$SESSION_STAT displays session statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
SESS_ID	NUMBER	session identifier
STAT_VALUE	NUMBER	statistic value

V$SESSION_MEM_STAT

The V$SESSION_MEM_STAT displays session memory statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
SESS_ID	NUMBER	session identifier
STAT_VALUE	NUMBER	statistic value

V$SESSION_MEM_USAGE

The V$SESSION_MEM_USAGE displays session memory usage for each session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	session identifier
ALLOCATOR_ID	NUMBER	memory allocator identifier
PARENT_ALLOCATOR_ID	NUMBER	parent memory allocator identifier
ALLOCATOR_TYPE	VARCHAR(7)	memory allocator type ( REGION or DYNAMIC )
MEMORY_TYPE	VARCHAR(4)	memory type ( HEAP, SHM )
TOTAL_SIZE	NUMBER	total memory size
USED_SIZE	NUMBER	used memory size

V$SESSION_SQL_STAT

The V$SESSION_SQL_STAT displays session SQL statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
SESS_ID	NUMBER	session identifier
STAT_VALUE	NUMBER	statistic value

V$SESSION_WAIT

The V$SESSION_WAIT displays the current or last wait for each session.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	ID of the session
SEQ_NO	NUMBER	Identifier of the wait event
WAIT_EVENT_ID	NUMBER	Name of the wait event
WAIT_EVENT_NAME	VARCHAR(64)	A number that uniquely identifies the current or last wait (incremented for each wait)
P1TEXT	VARCHAR(64)	Description of the first parameter for the wait event
P1	NUMBER	First wait event parameter (in decimal)
P1HEX	VARCHAR(32)	First wait event parameter (in hex)
P2TEXT	VARCHAR(64)	Description of the second parameter for the wait event
P2	NUMBER	Second wait event parameter (in decimal)
P2HEX	VARCHAR(32)	Second wait event parameter (in hex)
P3TEXT	VARCHAR(64)	Description of the third parameter for the wait event
P3	NUMBER	Third wait event parameter (in decimal)
P3HEX	VARCHAR(32)	Third wait event parameter (in hex)
STATE	VARCHAR(64)	Wait state
WAIT_TIME	NUMBER	If the session is currently waiting, then the value is time waited for the current wait. If the session is not in a wait, then the value is the duration of the last wait (in microseconds)
TIME_SINCE_LAST_WAIT	NUMBER	Time elapsed since the end of the last wait (in microseconds). If the session is currently in a wait, then the value is 0.
CLASS_NAME	VARCHAR(64)	Name of the class of the wait event

V$SHARED_MODE

The V$SHARED_MODE displays information of shared mode.

Column information
Column name	Data type	Description
NAME	VARCHAR(128)	name
VALUE	VARCHAR(128)	value

V$SHARED_SERVER

The V$SHARED_SERVER displays information of shared servers.

Column information
Column name	Data type	Description
PROCESS_ID	NUMBER	shared server process identifier
PROCESSED_JOB_COUNT	NUMBER	processed job count
STATUS	VARCHAR(128)	status
IDLE	NUMBER	total idle time (1/100 second)
BUSY	NUMBER	total busy time (1/100 second)
REQUEST_GROUP_ID	NUMBER	indicates which shared group the shared server belongs to
WAIT_EVENT_ID	NUMBER	identifier of the wait event (valid only if STATUS is SUSPEND)

V$SHM_SEGMENT

The V$SHM_SEGMENT displays a list of all shared memory segments.

Column information
Column name	Data type	Description
SHM_NAME	VARCHAR(32)	shared memory segment name
SHM_ID	NUMBER	shared memory segment identifier
SHM_SIZE	NUMBER	shared memory segment size ( in bytes )
SHM_KEY	NUMBER	shared memory segment key
SHM_SEQ	NUMBER	shared memory segment sequence
SHM_ADDR	VARCHAR(32)	start address of the shared memory segment
LARGE_PAGES	BOOLEAN	indicates whether the shared memory segment use large pages

V$SPROPERTY

The V$SPROPERTY displays a list of Properties. This is store a binary property file.

Column information
Column name	Data type	Description
PROPERTY_NAME	VARCHAR(128)	name of the property
DESCRIPTION	VARCHAR(2048)	description of the property
DATA_TYPE	VARCHAR(32)	data type of the property
STARTUP_PHASE	VARCHAR(32)	modifiable startup-phase: the value IN ( NO MOUNT / MOUNT / OPEN & [BELOW\|ABOVE] )
VALUE_UNIT	VARCHAR(32)	unit of the property value: the value in ( NONE, BYTE, MS(milisec) )
PROPERTY_VALUE	VARCHAR(2048)	property value stored in the binary property file
PROPERTY_SOURCE	VARCHAR(32)	source of the current property value: the value is BINARY_FILE
INIT_VALUE	VARCHAR(2048)	property init value for the system
INIT_SOURCE	VARCHAR(32)	source of the current property INIT_VALUE: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM )
MIN_VALUE	NUMBER	minimum value for property. null if type is varchar
MAX_VALUE	NUMBER	maximum value for property. null if type is varchar
SES_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SESSION or not: the value in ( TRUE, FALSE )
SYS_MODIFIABLE	VARCHAR(32)	property can be changed with ALTER SYSTEM and when the change takes effect: the value in ( NONE, FALSE, IMMEDIATE, DEFERRED )
IS_MODIFIABLE	VARCHAR(32)	property can be changed or not: the value in ( TRUE, FALSE )

V$SQLFN_METADATA

The V$SQLFN_METADATA contains metadata about operators and built-in functions

Column information
Column name	Data type	Description
FUNC_NAME	VARCHAR(128)	name of the built-in function
MINARGS	NUMBER	minimum number of arguments for the function
MAXARGS	NUMBER	maximum number of arguments for the function
IS_AGGREGATE	BOOLEAN	indicates whether the function is an aggregate function (TRUE) or not (FALSE)

V$SQL_CACHE

The V$SQL_CACHE lists statistics of shared SQL plan.

Column information
Column name	Data type	Description
SQL_HANDLE	NUMBER	SQL handle
HASH_VALUE	NUMBER	hash value of the SQL statement
PLAN_SIZE	NUMBER	the total plan size of the SQL statement ( in bytes )
CLOCK_ID	NUMBER	clock identifier
PLAN_AGE	NUMBER	plan age
USER_NAME	VARCHAR(128)	user name
BIND_PARAM_COUNT	NUMBER	count of bind parameters
SQL_TEXT	LONG VARCHAR	SQL full text
PLAN_COUNT	NUMBER	plan count of the SQL statement
PLAN_ID	NUMBER	plan identifier
PLAN_SIZE	NUMBER	the total plan size of the SQL statement ( in bytes )
PLAN_IS_ATOMIC	BOOLEAN	plan is atomic array insert or not
PLAN_TEXT	LONG VARCHAR	plan text for SQL statement

V$SQL_COMMAND

The V$SQL_COMMAND lists attribute information of each SQL command.

Column information
Column name	Data type	Description
COMMAND	VARCHAR(128)	SQL command
FROM_PHASE	VARCHAR(32)	executable from start-up phase
UNTIL_PHASE	VARCHAR(32)	executable until start-up phase
ACCESS_MODE	VARCHAR(32)	database access mode: values in (NONE, READ & WRITE, READ, READ & LOCK)
NEED_FETCH	VARCHAR(32)	the command is a query which has result set and need fetch
IS_DDL	VARCHAR(3)	the command is a DDL(Data Definition Language) or not
CLUSTER_LOCK_MODE	VARCHAR(32)	cluster lock mode: values in (NONE, SERIAL, MANUAL)
AUTO_COMMIT	VARCHAR(3)	the command is auto-commit or not
IS_CACHEABLE	VARCHAR(3)	the command is plan-cacheable or not
AUDIT_ACTION	VARCHAR(128)	auditiable action name for the SQL command

V$SQL_HISTORY

The V$SQL_HISTORY displays information of SQLs.

Column information
Column name	Data type	Description
DRIVER_MEMBER_POS	NUMBER	driver member position
SESSION_ID	NUMBER	session identifier
START_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	statement start time
EXEC_TIME	NUMBER	execution time(us)
PREPARED	BOOLEAN	indicates whether the statement is prepared ( YES ) or not ( NO )
SUCCESS	BOOLEAN	indicates whether the statement is success ( YES ) or not ( NO )
STATUS	CHARACTER VARYING(16)	status of the statement: the value in ( RUNNING, DONE )
SQL_TEXT	CHARACTER VARYING(1024)	first 1024 bytes of the SQL text for the statement

V$STATEMENT

The V$STATEMENT lists all statements.

Column information
Column name	Data type	Description
SESSION_ID	NUMBER	session identifier
STMT_ID	NUMBER	statement identifier in a session
STMT_VIEW_SCN	NUMBER	statement view scn
SQL_TEXT	VARCHAR(1024)	first 1024 bytes of the SQL text for the statement
START_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	statement start time
TOTAL_EXEC_TIME	NATIVE_BIGINT	total execution time(us)
LAST_EXEC_TIME	NATIVE_BIGINT	last execution time(us)
EXECUTIONS	NATIVE_BIGINT	number of executions

V$SYSTEM_EVENT

The V$SYSTEM_EVENT displays information on total waits for an event.

Column information
Column name	Data type	Description
WAIT_EVENT_ID	NUMBER	Identifier of the wait event
WAIT_EVENT_NAME	VARCHAR(64)	Name of the wait event
TOTAL_WAITS	NUMBER	Total number of waits for the event
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event
TIME_WAITED	NUMBER	Total amount of time waited for the event (microsecond)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event (microsecond)
CLASS_NAME	VARCHAR(64)	Name of the class of the wait event

V$SYSTEM_STAT

The V$SYSTEM_STAT displays system statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
STAT_VALUE	NUMBER	statistic value
COMMENTS	VARCHAR(1024)	comments

V$SYSTEM_MEM_STAT

The V$SYSTEM_MEM_STAT displays system memory statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
STAT_VALUE	NUMBER	statistic value
COMMENTS	VARCHAR(1024)	comments

V$SYSTEM_SQL_STAT

The V$SYSTEM_SQL_STAT displays system SQL statistics.

Column information
Column name	Data type	Description
STAT_NAME	VARCHAR(128)	statistic name
STAT_VALUE	NUMBER	statistic value
COMMENTS	VARCHAR(1024)	comments

V$TABLES

The V$TABLES contains the definitions of all the performance views (views beginning with V$).

Column information
Column name	Data type	Description
TABLE_OWNER	VARCHAR(128)	owner name who owns the performance view
TABLE_SCHEMA	VARCHAR(128)	schema name of the performance view
TABLE_NAME	VARCHAR(128)	name of the performance view
STARTUP_PHASE	VARCHAR(32)	visible startup phase of the performance view
CREATED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	available only in OPEN phase created time of the performance view
MODIFIED_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	available only in OPEN phase modified time of the performance view
COMMENTS	VARCHAR(1024)	available only in OPEN phase comments of the performance view

V$TABLESPACE

This view displays tablespace information.

Column information
Column name	Data type	Description
TBS_NAME	VARCHAR(128)	tablespace name
TBS_ID	NUMBER	tablespace identifier
TBS_ATTR	VARCHAR(128)	tablespace attribute: the value in ( device attribute (MEMORY) \| temporary attribute (TEMPORARY, PERSISTENT) \| usage attribute(DICT, UNDO, DATA, TEMPORARY) )
IS_LOGGING	BOOLEAN	indicates whether the tablespace is a logging tablespace ( YES ) or not ( NO )
IS_ONLINE	BOOLEAN	indicates whether the tablespace is ONLINE ( YES ) or OFFLINE ( NO )
OFFLINE_STATE	VARCHAR(32)	indicates whether the tablespace can be taken online normally ( CONSISTENT ) or not ( INCONSISTENT ). null if the tablespace is ONLINE
EXTENT_SIZE	NUMBER	extent size of the tablespace ( in bytes )
PAGE_SIZE	NUMBER	page size of the tablespace ( in bytes )

V$TABLESPACE_STAT

This view displays tablespace statistical information.

Column information
Column name	Data type	Description
TBS_NAME	VARCHAR(128)	tablespace name
TBS_ID	NUMBER	tablespace identifier
TOTAL_EXT_COUNT	NUMBER	total extent count of the tablespace
USED_META_EXT_COUNT	NUMBER	meta extent count currently used on the tablespace
USED_DATA_EXT_COUNT	NUMBER	data extent count currently used on the tablespace
FREE_EXT_COUNT	NUMBER	free extent count of the tablespace
EXTENT_SIZE	NUMBER	extent size of the tablespace ( in bytes )

V$TCL_LOGFILE

The V$TCL_LOGFILE displays information of all TCL(tranaction commit log) members.

Column information
Column name	Data type	Description
GROUP_ID	NUMBER	group identifier of the TCL member
FILE_NAME	VARCHAR(1024)	file path of the TCL member
GROUP_STATE	VARCHAR(32)	state of the TCL group: the value in ( UNUSED, ACTIVE, CURRENT, INACTIVE )
FILE_SEQ	NUMBER	file sequence number of the TCL member
FILE_SIZE	NUMBER	file size of the TCL member ( in bytes )

V$TRANSACTION

The V$TRANSACTION lists the active transactions in the system.

Column information
Column name	Data type	Description
TRANS_ID	NUMBER	transaction identifier
SESSION_ID	NUMBER	session identifier ( null if the global transaction is unassociated )
TRANS_SLOT_ID	NUMBER	transaction slot identifier
PHYSICAL_TRANS_ID	NUMBER	physical transaction identifier
TRANS_STATE	VARCHAR(32)	transaction state: the value in ( ACTIVE, BLOCK, PREPARE, COMMIT, ROLLBACK, IDLE, PRECOMMIT )
IS_XA	BOOLEAN	indicates whether the transaction is xa transaction or not
TRANS_ATTRIBUTE	VARCHAR(32)	transaction attribute: the value in ( READ_ONLY, UPDATABLE, LOCKABLE, UPDATABLE \| LOCKABLE )
ISOLATION_LEVEL	VARCHAR(32)	transaction isolation level: the value in ( READ COMMITTED, SERIALIZABLE )
TRANS_VIEW_SCN	VARCHAR(32)	transaction view scn
TCN	NUMBER	transaction change number
TRANS_SEQ	NUMBER	transaction sequence number
START_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	transaction start time
UNDO_SEGMENT_ID	NUMBER	undo segment identifier

V$UNDO_SEGMENT

The V$UNDO_SEGMENT displays a list of all undo segments.

Column information
Column name	Data type	Description
ID	NUMBER	logical identifier of undo segment
PHYSICAL_ID	NUMBER	physical identifier of undo segment
PAGES	NUMBER	total number of allocated pages
AGABLE_PAGES	NUMBER	total number of agable pages

V$WAIT_EVENT_CLASS_NAME

The V$WAIT_EVENT_CLASS_NAME displays information about Class of wait event.

Column information
Column name	Data type	Description
CLASS_ID	NUMBER	Identifier of the class of the wait event
NAME	VARCHAR(64)	Name of the class of the wait event
DESCRIPTION	VARCHAR(128)	Description of the class of the wait event

V$WAIT_EVENT_NAME

The V$WAIT_EVENT_NAME displays information about wait events.

Column information
Column name	Data type	Description
CLASS_ID	NUMBER	Identifier of the wait event
NAME	VARCHAR(64)	Name of the wait event
DESCRIPTION	VARCHAR(128)	Description of the wait event
PARAMETER1	NUMBER	Description of the first parameter for the wait event
PARAMETER1	NUMBER	Description of the second parameter for the wait event
PARAMETER1	NUMBER	Description of the third parameter for the wait event
CLASS_ID	NUMBER	Identifier of the class of the wait event
CLASS_NAME	VARCHAR(64)	Name of the class of the wait event

V$XA_TRANSACTION

The V$XA_TRANSACTION displays information on the currently active XA transactions.

Column information
Column name	Data type	Description
XA_TRANS_ID	VARCHAR(1024)	XA transaction identifier
LOCAL_TRANS_ID	NUMBER	local transaction identifier
DRIVER_TRANS_ID	NUMBER	driver transaction identifier
DRIVER_MEMBER_POS	NUMBER	driver member position
XA_TRANS_STATE	VARCHAR(32)	state of the XA transaction: the value in ( NOTR, ACTIVE, IDLE, PREPARED, ROLLBACK_ONLY, HEURISTIC_COMPLETED )
ASSO_STATE	VARCHAR(32)	associate state of the XA transaction: the value in ( NOT_ASSOCIATED, ASSOCIATED, ASSOCIATION_SUSPENDED )
START_TIME	TIMESTAMP(6) WITHOUT TIME ZONE	XA transaction start time
IS_REPREPARABLE	BOOLEAN	indicates whether the XA transaction is repreparable