2
Static Data Dictionary Views

This chapter contains descriptions of data dictionary tables and views. To see the data dictionary views available to you, query the view DICTIONARY.

See Chapter 3, "Dynamic Performance (V$) Views" for descriptions of the V$ views.

In Trusted Oracle Server, each of the dictionary tables and views contains a column that indicates the label of each row in the table or view. Trusted Oracle also provides some additional dictionary tables and views, and some Oracle8 dictionary tables and views contain columns that support compatibility with Trusted Oracle applications.

See your Trusted Oracle documentation for more information about Trusted Oracle dictionary tables and views.

Data Dictionary Views

The following is an alphabetical reference of the data dictionary views accessible to all users of an Oracle Server. Most views can be accessed by any user with the CREATE_SESSION privilege.

The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed.

ALL_ALL_TABLES

This view describes all of the tables (object tables and relational tables) accessible to the user.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
PCT_FREE	NUMBER	Minimum percentage of free space in a bloc
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	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last modification?
NUM_ROWS	NUMBER	The number of rows in the table
BLOCKS	NUMBER	The number of used blocks in the table
EMPTY_BLOCKS	NUMBER	The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	The average available free space in the table
CHAIN_CNT	NUMBER	The number of chained rows in the table
AVG_ROW_LEN	NUMBER	The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	The sample size used in analyzing this table
LAST_ANALYZED	DATE	The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)	If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	Type of the table if the table is a typed table
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)	Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)	Name of the default buffer pool for the appropriate object

ALL_ARGUMENTS

This view lists all of the arguments in the object which are accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
OBJECT_NAME	VARCHAR2(30)		Procedure or function name
OVERLOAD	VARCHAR2(40)		Overload unique identifier
PACKAGE_NAME	VARCHAR2(30)		Package name
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
ARGUMENT_NAME	VARCHAR2(30)		Argument name
POSITION	NUMBER	NOT NULL	Position in argument list, or NULL for function return value
SEQUENCE	NUMBER	NOT NULL	Argument sequence, including all nesting levels
DATA_LEVEL	NUMBER	NOT NULL	Nesting depth of argument for composite types
DATA_TYPE	VARCHAR2(14)		Datatype of the argument
DEFAULT_VALUE	LONG		Default value for the argument
DEFAULT_LENGTH	NUMBER		Length of default value for the argument
IN_OUT	VARCHAR2(9)		Argument direction (IN, OUT, or IN/OUT)
DATA_LENGTH	NUMBER		Length of the column in bytes
DATA_PRECISION	NUMBER		Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER		Digits to right of decimal point in a number
RADIX	NUMBER		Argument radix for a number
CHARACTER_SET_NAME	VARCHAR2(44)		Character set name for the argument
TYPE_OWNER	VARCHAR2(30)		Owner name of the type
TYPE_NAME	VARCHAR2(30)		Name
TYPE_SUBNAME	VARCHAR2(30)		This is valid only in case of package local types; in such cases, the package name is the name and the type name is the subname
TYPE_LINK	VARCHAR2(128)		Database link valid only in case of package local types, in case the package is remote

ALL_CATALOG

This view lists all tables, views, synonyms, and sequences accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object

ALL_CLUSTERS

This view list all clusters accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
PCT_FREE	NUMBER		Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	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	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
AVG_BLOCKS_PER _KEY	NUMBER		Number of blocks in the table divided by number of hash keys
CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B-Tree index or hash
FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the cluster
INSTANCES	VARCHAR2(10)		The number of instances across which the cluster is to be scanned
CACHE	VARCHAR2(5)		Whether the cluster is to be cached in the buffer cache
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

ALL_COL_COMMENTS

This view lists comments on columns of accessible tables and views.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
COMMENTS	VARCHAR2(4000)		Comment on the column

ALL_COL_PRIVS

This view lists grants on columns for which the user or PUBLIC is the grantee.

Column	Datatype	NULL	Description
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
TABLE_SCHEMA	VARCHAR2(30)	NOT NULL	Schema of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privileges was granted with ADMIN OPTION; otherwise NO

ALL_COL_PRIVS_MADE

This view lists grants on columns for which the user is owner or grantor.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_COL_PRIVS_RECD

This view lists grants on columns for which the user or PUBLIC is the grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NUL	Username of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_COLL_TYPES

This view displays the named collection types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
COLL_TYPE	VARCHAR2(30)	NOT NULL	Collection type
UPPER_BOUND	NUMBER		Maximum size of the VARRAY type
ELEM_TYPE_MOD	VARCHAR2(7)		Type modifier of the element
ELEM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the element
ELEM_TYPE_NAME	VARCHAR2(30)		Name of the type of the element
LENGTH	NUMBER		Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE	NUMBER		Scale of the NUMBER or DECIMAL element
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

ALL_CONS_COLUMNS

This view contains information about accessible columns in constraint definitions.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
COLUMN_NAME	VARCHAR2(4000)		Name associated with column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER		Original position of column or attribute in definition

ALL_CONSTRAINTS

This view lists constraint definitions on accessible tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
CONSTRAINT_TYPE	VARCHAR2(1)		Type of constraint definition: C (check constraint on a table), P (primary key), U (unique key), R (referential integrity), or V (with check option, on a view), or O (with read only, on a view)
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
SEARCH_CONDITION	LONG		Text of search condition for table check
R_OWNER	VARCHAR2(30)		Owner of table used in referential constraint
R_CONSTRAINT _NAME	VARCHAR2(30)		Name of unique constraint definition for referenced table
DELETE_RULE	VARCHAR2(9)		Delete rule for a referential constraint: CASCADE / NO ACTION
STATUS	VARCHAR2(8)		Enforcement status of constraint: ENABLED or DISABLED
DEFERRABLE	VARCHAR2(14)		Indicates whether the constraint is deferrable
DEFERRED	VARCHAR2(9)		Indicates whether the constraint was initially deferred
VALIDATED	VARCHAR2(13)		Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED
GENERATED	VARCHAR2(14)		Indicates whether the name system is generated
BAD	VARCHAR2(3)		Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
LAST_CHANGE	DATE		Indicates when the constraint was last enabled or disabled

ALL_DB_LINKS

This view lists database links accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the database link
DB_LINK	VARCHAR2(12)	NOT NULL	Name of the database link
USERNAME	VARCHAR2(30)		Name of user when logging in
HOST	VARCHAR2(200)		Net8 string for connect
CREATED	DATE	NOT NULL	Creation time of the database link

ALL_DEF_AUDIT_OPTS

This view contains default object-auditing options that will be applied when objects are created.

Column	Datatype	Description
ALT	VARCHAR2(3)	Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD	VARCHAR2(3)	Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM	VARCHAR2(3)	Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL	VARCHAR2(3)	Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA	VARCHAR2(3)	Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND	VARCHAR2(3)	Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS	VARCHAR2(3)	Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC	VARCHAR2(3)	Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN	VARCHAR2(3)	Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL	VARCHAR2(3)	Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD	VARCHAR2(3)	Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF	VARCHAR2(3)	Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL
EXE	VARCHAR2(3)	Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

ALL_DEPENDENCIES

This view lists dependencies between objects accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
REFERENCED _OWNER	VARCHAR2(30)		Owner of the parent object
REFERENCED _NAME	VARCHAR2(64)		Type of parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
REFERENCED_TYPE	VARCHAR2(12)		Type of referenced object
REFERENCED_ LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
DEPENDENCY_TYPE	VARCHAR2(4)		Two values: REF when the dependency is a REF dependency; HARD otherwise

ALL_DIRECTORIES

This view contains the description of all directories accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the directory (always SYS)
DIRECTORY_NAME	VARCHAR2(30)	NOT NULL	Name of the directory
DIRECTORY_PATH	VARCHAR2(4000)		Operating system pathname for the directory

ALL_ERRORS

This view lists current errors on all objects accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of object
TYPE	VARCHAR2(12)		Type of object: VIEW, PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY
SEQUENCE	NUMBER	NOT NULL	Sequence number, for ordering
LINE	NUMBER	NOT NULL	Line number at which this error occurs
POSITION	NUMBER	NOT NULL	Position in the line at which this error occurs
TEXT	VARCHAR2(4000)	NOT NULL	Text of the error

ALL_IND_COLUMNS

This view lists columns of the indexes on accessible tables.

Column	Datatype	NULL	Description
INDEX_OWNER	VARCHAR2(30)	NOT NULL	Index owner
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table or cluster owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table or cluster name
COLUMN_NAME	VARCHAR2(4000)		Column name or attribute of object type column
COLUMN_POSITION	NUMBER	NOT NULL	Position of column or attribute within index
COLUMN_LENGTH	NUMBER	NOT NULL	Indexed length of the column

ALL_IND_PARTITIONS

This view describes, for each index partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE that the current user can access.

Column	Datatype	NULL	Description
INDEX_OWNER	VARCHAR2(30)	NOT NULL	Index owner
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the index
STATUS	VARCHAR2(8)		Indicates whether index partition is usable or not
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of process freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
BLEVEL	NUMBER		B-Tree level
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index partition
DISTINCT_KEYS	NUMBER		Number of distinct keys in the index partition
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		Average number of leaf blocks per key
AVG_DATA_BLOCKS _PER_KEY	NUMBER		Average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		Measurement of the amount of (dis)order of the table this index partition is for
NUM_ROWS	NUMBER		Number of rows returned by the ANALYZE command
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)		The actual buffer pool for the partition

ALL_INDEXES

This view contains descriptions of indexes on tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the index
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the index
INDEX_TYPE	VARCHAR2(12)		Type of index
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the indexed object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the indexed object
TABLE_TYPE	CHAR(5)		Type of the indexed object
UNIQUENESS	VARCHAR2(9)		Uniqueness status of the index: UNIQUE or NONUNIQUE
TABLESPACE_NAME	VARCHAR2(30)		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		Percentage increase in extent size
PCT_THRESHOLD	NUMBER		Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER		User column-id for last column to be included in index organized table top index
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
PCT_FREE	NUMBER		Minimum percentage of free space in a block
LOGGING	VARCHAR(2(3)		Logging information
BLEVEL	NUMBER		B-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index
DISTINCT_KEYS	NUMBER		Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS)
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		Average number of leaf blocks in which each distinct value in the index appears. This statistic is rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.
AVG_DATA_BLOCKS _PER_KEY	NUMBER		Average number of data blocks in the table that are pointed to by a distinct value in the index. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns. This statistic is rounded to the nearest integer.
CLUSTERING_FACTOR	NUMBER		Statistic that represents the amount of order of the rows in the table based on the values of the index. If its value is near the number of blocks, then the table is very well ordered. In such a case, the index entries in a single leaf block tend to point to rows in the same data blocks. If its value is near the number of rows, then the table is very randomly ordered. In such a case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.
STATUS	VARCHAR2(8)		State of the index: DIRECT LOAD or VALID
NUM_ROWS	NUMBER		Number of rows in this index
SAMPLE_SIZE	NUMBER		Size of the sample used to analyze this index
LAST_ANALYZED	DATE		Timestamp for when this index was last analyzed
DEGREE	VARCHAR2(40)		Number of threads per instance for scanning the index, NULL if PARTITIONED=NO.
INSTANCES	VARCHAR2(40)		Number of instances across which the indexes to be scanned. NULL if PARTITIONED=NO.
PARTITIONED	VARCHAR2(3)		Indicates whether this index is partitioned. Set to `YES' if it is partitioned
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it places in this object itself?
GENERATED	VARCHAR2(1)		Was the name of this index system generated?
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

ALL_LABELS

This is a Trusted Oracle Server view that lists system labels. For more information, see your Trusted Oracle documentation.

ALL_LIBRARIES

This new data view lists all the libraries that a user can access.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the library
LIBRARY_NAME	VARCHAR2(30)	NOT NULL	Library name
FILE_SPEC	VARCHAR2(2000)		Operating system file specification associated with the library
DYNAMIC	VARCHAR2(1)		Is the library dynamically loadable? (YES or NO)
STATUS	VARCHAR2(7)		Status of the library

ALL_LOBS

This view displays the LOBs contained in tables accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table containing the LOB
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table containing the LOB
COLUMN_NAME	VARCHAR2(4000)		Name of the LOB column or attribute
SEGMENT_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB segment
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB index
CHUNK	NUMBER		Size of the LOB chunk as a unit of allocation/manipulation in bytes
PCTVERSION	NUMBER	NOT NULL	Maximum percentage of the LOB space used for versioning
CACHE	VARCHAR2(3)		Indicates whether the LOB is accessed through the buffer cache
LOGGING	VARCHAR2(3)		Indicates whether the changes to the LOB are logged
IN_ROW	VARCHAR2(3)		Are some of the LOBs stored with the base row?

ALL_METHOD_PARAMS

This view is a description view of method parameters of types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
PARAM_NAME	VARCHAR2(30)	NOT NULL	Name of the parameter
PARAM_NO	NUMBER	NOT NULL	Parameter number or position
PARAM_MODE	VARCHAR2(6)		Mode of the parameter
PARAM_TYPE_MOD	VARCHAR2(7)		Type modifier of the parameter
PARAM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the parameter
PARAM_TYPE_NAME	VARCHAR2(30)		Name of the type of the parameter
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS or NCHAR_CS

ALL_METHOD_RESULTS

This view is a description view of method results of types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
RESULT_TYPE_MOD	VARCHAR2(7)	NOT NULL	Type modifier of the result
RESULT_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the result
RESULT_TYPE_NAME	VARCHAR2(30)		Name of the type of the result
CHARACTER_SET_NAME	VARCHAR2(44		The name of the character set: CHAR_CS or NCHAR_CS

ALL_NESTED_TABLES

This view describes the nested tables in tables accessible to the user.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the nested table
TABLE_NAME	VARCHAR2(30)	Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2(30)	Name of the type of the nested table
PARENT_TABLE _NAME	VARCHAR2(30)	Name of the parent table containing the nested table
PARENT_TABLE _COLUMN	VARCHAR2(4000)	Column name of the parent table that corresponds to the nested table

ALL_OBJECT_TABLES

This view contains descriptions of the object tables accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)		Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)		Name of the index organized table, if any, to which the overflow entry belongs
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		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute
BACKED_UP	VARCHAR2(1)		Has table been backed up since last modification?
NUM_ROWS	NUMBER		The number of rows in the table
BLOCKS	NUMBER		The number of used blocks in the table
EMPTY_BLOCKS	NUMBER		The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER		The average available free space in the table
CHAIN_CNT	NUMBER		The number of chained rows in the table
AVG_ROW_LEN	NUMBER		The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER		The number of blocks on the freelist
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER		The sample size used in analyzing this table
LAST_ANALYZED	DATE		The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)		Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)		If index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	NOT NULL	Type of the table if the table is a typed table
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)		Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)		The default buffer pool to be used for table blocks

ALL_OBJECTS

This view lists objects accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of the object
SUBOBJECT_NAME	VARCHAR2(30)		Name of the sub-object (for example, partition)
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
DATA_OBJECT_ID	NUMBER		Object number of the segment which contains the object
OBJECT_TYPE	VARCHAR2(15)		Type and type body of the object: INDEX PARTITION, TABLE PARTITION, PACKAGE, PACKAGE BODY, TRIGGER
CREATED	DATE	NOT NULL	Timestamp for the creation of the object
LAST_DDL_TIME	DATE	NOT NULL	Timestamp for the last modification of the object resulting from a DDL command (including grants and revokes)
TIMESTAMP	VARCHAR2(20)		Timestamp for the creation of the object (character data)
STATUS	VARCHAR2(7)		Status of the object: VALID, INVALID, or N/A
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it placed in this object itself?
GENERATED	VARCHAR2(1)		Was the name of this object system generated?

ALL_PART_COL_STATISTICS

This view contains column statistics and histogram information for table partitions that the current user can access.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner name
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Table partition name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed

ALL_PART_HISTOGRAMS

This view contains the histogram data (end-points per histogram) for histograms on table partitions that the current user can access.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner name
TABLE_NAME	VARCHAR2(30)	Table name
PARTITION_NAME	VARCHAR2(30)	Table partition name
COLUMN_NAME	VARCHAR2(30)	Column name
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

ALL_PART_INDEXES

This view lists the object level partitioning information for all partitioned indexes that the current user can access.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of this partitioned index
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned index
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: RANGE
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this index
PARTITIONING_KEY _COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
LOCALITY	VARCHAR2(6)		Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT	VARCHAR2(12)		Indicates whether this partitioned index is PREFIXED or NON-PREFIXED
DEF_TABLESPACE _NAME	VARCHAR2(30)		Default TABLESPACE, for LOCAL index, for ADD/SPLIT TABLE partition
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, for LOCAL index, for ADD TABLE partition
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, for LOCAL index, for ADD TABLE partition
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, for LOCAL index, for ADD TABLE partition
DEF_INITIAL_EXTENT	VARCHAR2(40)	NOT NULL	Default INITIAL, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	VARCHAR2(40)	NOT NULL	Default NEXT, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	VARCHAR2(40)	NOT NULL	Default MINEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	VARCHAR2(40)	NOT NULL	Default MAXEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	VARCHAR2(40)	NOT NULL	Default PCTINCREASE, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, for LOCAL index, for ADD TABLE partition
DEF_FREELIST_GROUPS	NUMBER	NOT NULL	Default FREELIST GROUPS, for LOCAL index, for ADD TABLE partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING, for LOCAL index, for ADD TABLE PARTITION
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool for LOCAL index, for ADD TABLE PARTITION

ALL_PART_KEY_COLUMNS

This view describes the partitioning key columns for partitioned objects that the current user access.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Partitioned table or index owner
NAME	VARCHAR2(30)	Partitioned table or index name
OBJECT_TYPE	VARCHAR2(11)	Object type (`TABLE' or `INDEX)
COLUMN_NAME	VARCHAR2(30)	Column name
COLUMN_POSITION	NUMBER	Position of the column within the partitioning key

ALL_PART_TABLES

This view lists the object level partitioning information for partitioned tables the current user access.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of this partitioned table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned table
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: `RANGE'
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this table
PARTITIONING_KEY_COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
DEF_TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Default TABLESPACE, used for add partition
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, used for add partition
DEF_PCT_USED	NUMBER	NOT NULL	Default PCTUSED, used for add partition
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, used for add partition
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, used for add partition
DEF_INITIAL_EXTENT	VARCHAR2(40)		Default INITIAL, used for add partition, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	VARCHAR2(40)		Default NEXT, used for add partition, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	VARCHAR2(40)		Default MINEXTENTS, used for add partition, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	VARCHAR2(40)		Default MAXEXTENTS, used for add partition, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	VARCHAR2(40)		Default PCTINCREASE, used for add partition, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, used for add partition
DEF_FREELIST_GROUPS	NUMBER	NOT NULL	Default FREELIST GROUPS, used for add partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING attribute, used for add partition
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool for the given object, used for add partition

ALL_REFRESH

This view lists all the refresh groups that the user can access.

Column	Datatype	NULL	Description
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is subtracted
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N; if Y then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

ALL_REFRESH_CHILDREN

This view lists all the objects in refresh groups, where the user can access the group.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
TYPE	VARCHAR2(30)		Type of the object in the refresh group
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is subtracted
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N; if Y then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

ALL_REFS

This view describes the REF columns and REF attributes in object type columns accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
COLUMN_NAME	VARCHAR2(4000)		Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name.
WITH_ROWID	VARCHAR2(3)		Is the REF value stored with ROWID (YES or NO)?
IS_SCOPED	VARCHAR2(3)		Is the REF column scoped (YES or NO)?
SCOPE_TABLE_OWNER	VARCHAR2(30)		Name of the owner of the scope table, if it exists and is accessible by the user
SCOPE_TABLE_NAME	VARCHAR2(30)		Name of the scope table, if it exists and is accessible by the user

ALL_REGISTERED_SNAPSHOTS

This view lists all registered snapshots.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot
SNAPSHOT_SITE	VARCHAR2(128)	NOT NULL	Global name of the snapshot site.
CAN_USE_LOG	VARCHAR2(3)		YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log
UPDATABLE	VARCHAR2(3)		Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to NO, the snapshot is read only.
REFRESH_METHOD	VARCHAR2(11)		Whether the snapshot uses rowids or primary key for fast refresh
SNAPSHOT_ID	NUMBER(38)		Identifier for the snapshot used by the master for fast refresh
VERSION	VARCHAR2(17)		Version of snapshot
QUERY_TXT	LONG		Original query of which this snapshot is an instantiation

ALL_REPCATLOG

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPCOLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPCOLUMN_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPCONFLICT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPDDL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPGENERATED

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPGROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPGROUPED_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPKEY_COLUMNS

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPOBJECT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPPARAMETER_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPPRIORITY

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPPRIORITY_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPPROP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPRESOLUTION

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPRESOL_STATS_CONTROL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPRESOLUTION_METHOD

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPRESOLUTION_STATISTICS

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

ALL_SEQUENCES

This view lists descriptions of sequences accessible to the user.

Column	Datatype	NULL	Description
SEQUENCE_OWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the sequence
SEQUENCE_NAME	VARCHAR2(30)	NOT NULL	Sequence name
MIN_VALUE	NUMBER		Minimum value of the sequence
MAX_VALUE	NUMBER		Maximum value of the sequence
INCREMENT_BY	NUMBER	NOT NULL	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR2(1)		Does sequence wrap around on reaching limit
ORDER_FLAG	VARCHAR2(1)		Are sequence numbers generated in order
CACHE_SIZE	NUMBER	NOT NULL	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	NOT NULL	Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.

ALL_SNAPSHOT_LOGS

This view lists all snapshot logs.

Column	Datatype	NULL	Description
LOG_OWNER	VARCHAR2(30)	NOT NULL	Owner of the log
MASTER	VARCHAR2(30)	NOT NULL	Name of the master table whose changes are logged
LOG_TABLE	VARCHAR2(30)	NOT NULL	Name of the table where the changes to the master table are recorded
LOG_TRIGGER	VARCHAR2(30)		Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserts rows into the log.
ROWIDS	VARCHAR2(3)		If YES, records ROWID information
PRIMARY_KEY	VARCHAR2(3)		If YES, records primary key information
FILTER_COLUMNS	VARCHAR2(3)		If YES, snapshot log records filter columns
CURRENT_SNAPSHOTS	DATE		One date per snapshot; the date the snapshot of the master was last refreshed
SNAPSHOT_ID	NUMBER(38)		Unique identifier of the snapshot

ALL_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot view
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table
LAST_REFRESH	DATE		The last refresh

ALL_SNAPSHOTS

This view lists all snapshots accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the view used by users and applications for viewing the snapshot
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table the snapshot is stored in. This table may have additional columns.
MASTER_VIEW	VARCHAR2(30)		View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8 and is set to NULL.
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table of which this snapshot is a copy
MASTER_LINK	VARCHAR2(128)		Database link name to the master site
CAN_USE_LOG	VARCHAR2(3)		YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log
UPDATABLE	VARCHAR2(3)		Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to YES, the snapshot is read only.
REFRESH_METHOD	VARCHAR2(11)		Values used to drive a refresh of the snapshot (PRIMARY KEY/ROWID/COMPLEX). If PRIMARY KEY, then the snapshot uses primary keys to drive a fast refresh. If ROWID, then it uses RowIDs to drive a fast refresh. If COMPLEX, then fast refreshes are not allowed and the snapshot can only perform complete refreshes.
LAST_REFRESH	DATE		Date and time at the master site of the last refresh
ERROR	NUMBER		The number of failed automatic refreshes since last successful refresh
FR_OPERATIONS	VARCHAR2(10)		Status of generated fast refresh operations: (REGENERATE, VALID)
CR_OPERATIONS	VARCHAR2(10)		Status of generated complete refresh operations: (REGENERATE, VALID)
TYPE	VARCHAR2(8)		Type of refresh for all automatic refreshes: COMPLETE, FAST, FORCE
NEXT	VARCHAR2(200)		Date function used to compute next refresh dates
START_WITH	DATE		Date function used to compute next refresh dates
REFRESH_GROUP	NUMBER		All snapshots in a given refresh group get refreshed in the same transaction
UPDATE_TRIG	VARCHAR2(30)		Obsolete. It is NULL for Oracle8 snapshots. Formerly, the name of the trigger that fills the UPDATE_LOG
UPDATE_LOG	VARCHAR2(30)		The table that logs changes made to an updatable snapshots
QUERY	LONG		Original query of which this snapshot is an instantiation
MASTER_ROLLBACK _SEG	VARCHAR2(30)		Rollback segment to use at the master site

ALL_SOURCE

This view lists the text source of all stored objects accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER, TYPE, TYPE BODY
LINE	NUMBER	NOT NULL	Line number of this line of source
TEXT	VARCHAR2(4000)		Text source of the stored object

ALL_SYNONYMS

This view lists all synonyms accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the synonym
SYNONYM_NAME	VARCHAR2(30)	NOT NULL	Name of the synonym
TABLE_OWNER	VARCHAR2(30)		Owner of the object referenced by the synonym
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object referenced by the synonym
DB_LINK	VARCHAR2(128)		Name of the database link referenced, if any

ALL_TAB_COL_STATISTICS

This view contains column statistics and histogram information which is in the USER_TAB_COLUMNS view. For more information, see "USER_TAB_COLUMNS" on page 2-161.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column

ALL_TAB_COLUMNS

This view lists the columns of all tables, views, and clusters accessible to the user. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table, view or cluster
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table, view, or cluster name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
DATA_TYPE	VARCHAR2(30)		Datatype of the column
DATA_TYPE_MOD	VARCHAR2(3)		Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR2(30)		Owner of the datatype of the column
DATA_LENGTH	NUMBER	NOT NULL	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 right of decimal point in a number
NULLABLE	VARCHAR2(1)		Specifies whether a column allows NULLs. Value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY.
COLUMN_ID	NUMBER	NOT NULL	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER		Length of default value for the column
DATA_DEFAULT	LONG		Default value for the column
NUM_DISTINCT	NUMBER		These columns remain for backward compatibility with Oracle7. This information is now in the {TAB\|PART}_COL_STATISTICS views. This view now picks up these values from HIST_HEAD$ rather than COL$.
LOW_VALUE	RAW(32)
HIGH_VALUE	RAW(32)
DENSITY	NUMBER
NUM_NULLS	NUMBER		The number of nulls in the column
NUM_BUCKETS	NUMBER		The number of buckets in histogram for the column
LAST_ANALYZED	DATE		The date of the most recent time this column was analyzed
SAMPLE_SIZE			The sample size used in analyzing this column
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS or NCHAR_CS
CHAR_COL_DECL _LENGTH	NUMBER		The length of something

ALL_TAB_COMMENTS

This view lists comments on tables and views accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object
COMMENTS	VARCHAR2(4000)		Comment on the object

ALL_TAB_HISTOGRAMS

This view lists histograms on tables and views accessible to the user.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of table
TABLE_NAME	VARCHAR2(30)	Table name
COLUMN_NAME	VARCHAR2(4000)	Column name or attribute of the object type column
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

ALL_TAB_PARTITIONS

This view describes, for each table partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE that the current user can access.

Column	Datatype	NULL	Description
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the table
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
NUM_ROWS	NUMBER		Number of rows in the partition
BLOCKS	NUMBER		Number of used blocks in the partition
EMPTY_BLOCKS	NUMBER		Number of empty (never used) blocks in the partition
AVG_SPACE	NUMBER		Average available free space in the partition
CHAIN_CNT	NUMBER		Number of chained rows in the partition
AVG_ROW_LEN	NUMBER		Average row length, including row overhead
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)		The actual buffer pool for this partition

ALL_TAB_PRIVS

This view lists the grants on objects for which the user or PUBLIC is the grantee.

Column	Datatype	NULL	Description
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access is granted
TABLE_SCHEMA	VARCHAR2(30)	NOT NULL	Schema of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_TAB_PRIVS_MADE

This view lists the user's grants and grants on the user's objects.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_TAB_PRIVS_RECD

This view lists grants on objects for which the user or PUBLIC is the grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_TABLES

This view contains descriptions of relational tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
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 the secondary extension 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	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated to this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last change
NUM_ROWS	NUMBER	Number of rows in the table
BLOCKS	NUMBER	Number of used data blocks in the table
EMPTY_BLOCKS	NUMBER	Number of empty (never used) data blocks in the table
AVG_SPACE	NUMBER	Average amount of free space, in bytes, in a data block allocated to the table
CHAIN_CNT	NUMBER	Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID
AVG_ROW_LEN	NUMBER	Average length of a row in the table in bytes
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this table
LAST_ANALYZED	DATE	Date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Indicates whether this table is partitioned. Set to YES if it is partitioned
IOT_TYPE	VARCHAR2(12)	If this is an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW. If this is not an index organized table, then IOT_TYPE is NULL
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)	Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)	Name of the default buffer pool for the appropriate object

ALL_TRIGGERS

This view lists trigger information for triggers owned by the user, triggers on tables owned by the user, or all triggers if the user has the CREATE ANY TRIGGER privilege.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the trigger
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TRIGGER_TYPE	VARCHAR2(16)		When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT
TRIGGERING_EVENT	VARCHAR2(26)		Statement that fires the trigger: INSERT, UPDATE, DELETE
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table on which the trigger is defined
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table on which the trigger is defined
REFERENCING_NAME	VARCHAR2(87)		Names used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSE	VARCHAR2(4000)		WHEN clause. Must evaluate to TRUE for TRIGGER_BODY to execute.
STATUS	VARCHAR2(8)		Whether the trigger is enabled: ENABLED or DISABLED
DESCRIPTION	VARCHAR2(4000)		Trigger description. Useful for re-creating a trigger creation statement.
TRIGGER_BODY	LONG		Statement(s) executed by the trigger when it fires

ALL_TRIGGER_COLS

This view displays the usage of columns in triggers owned by user, on tables owned by user, or on all triggers if the user has the CREATE ANY TRIGGER privilege.

Column	Datatype	NULL	Description
TRIGGER_OWNER	VARCHAR2(30)	NOT NULL	Owner of the triggers
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table on which the trigger is defined
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table on which the trigger is defined
COLUMN_NAME	VARCHAR2(4000)		Name of the column used in the trigger
COLUMN_LIST	VARCHAR2(3)		Column specified in UPDATE clause: Y/N
COLUMN_USAGE	VARCHAR2(17)		How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT.

ALL_TYPE_ATTRS

This view displays the attributes of types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
ATTR_NAME	VARCHAR2(30)	NOT NULL	Name of the attribute
ATTR_TYPE_MOD	VARCHAR2(7)		Type modifier of the attribute
ATTR_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the attribute
ATTR_TYPE_NAME	VARCHAR2(30)		Name of the type of the attribute
LENGTH	NUMBER		Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE	NUMBER		Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS or NCHAR_CS

ALL_TYPE_METHODS

This view is a description of methods of types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
METHOD_TYPE	VARCHAR2(6)		Type of the method
PARAMETERS	NUMBER	NOT NULL	Number of parameters to the method
RESULTS	NUMBER	NOT NULL	Number of results returned by the method

ALL_TYPES

This view displays the types accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
TYPE_OID	RAW(16)	NOT NULL	Object identifier (OID) of the type
TYPECODE	VARCHAR2(30)		Typecode of the type
ATTRIBUTES	NUMBER		Number of attributes in the type
METHODS	NUMBER		Number of methods in the type
PREDEFINED	VARCHAR2(3)		Indicates whether the type is a predefined type
INCOMPLETE	VARCHAR2(3)		Indicates whether the type is an incomplete type

ALL_UPDATABLE_COLUMNS

This view contains a description of all columns that are updatable in a join view.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
UPDATABLE	VARCHAR2(3)		Indicates whether the column is updatable
INSERTABLE	VARCHAR2(3)		Indicates whether the column is insertable
DELETABLE	VARCHAR2(3)		Indicates whether the column is deletable

ALL_USERS

This view contains information about all users of the database.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)	NOT NULL	Name of the user
USER_ID	NUMBER	NOT NULL	ID number of the user
CREATED	DATE	NOT NULL	User creation date

ALL_VIEWS

This view lists the text of views accessible to the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the view
VIEW_NAME	VARCHAR2(30)	NOT NULL	Name of the view
TEXT_LENGTH	NUMBER		Length of the view text
TEXT	LONG		View text
TYPE_TEXT_LENGTH	NUMBER		Length of the type clause of the typed view
TYPE_TEXT	VARCHAR2(4000)		Type clause of the typed view
OID_TEXT_LENGTH	NUMBER		Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR2(4000)		WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR2(30)		Type of the view if the view is a typed view

AUDIT_ACTIONS

This view contains descriptions for audit trail action type codes.

Column	Datatype	NULL	Description
ACTION	NUMBER	NOT NULL	Numeric audit trail action type code
NAME	VARCHAR2(27)	NOT NULL	Name of the type of audit trail action

CATALOG

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

CAT

This is a synonym for USER_CATALOG. For more information, see "USER_CATALOG" on page 2-130.

CHAINED_ROWS

This view is the default table for the ANALYZE LIST CHAINED ROWS command.

Column Description

OWNER_NAME

Table owner

TABLE_NAME

Table name

CLUSTER_NAME

Cluster the table is in, if any

HEAD_ROWID

ROWID the chained row is accessed by

TIMESTAMP

Date/time that the ANALYZE command was issued

CLU

This is a synonym for USER_CLUSTERS. For more information, see "USER_CLUSTERS" on page 2-130.

CODE_PIECES

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68 and "USER_OBJECT_SIZE" on page 2-146.

CODE_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68 and "USER_OBJECT_SIZE" on page 2-146.

COL

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

COLS

This is a synonym for USER_TAB_COLUMNS. For more information, see "USER_TAB_COLUMNS" on page 2-161.

COLUMN_PRIVILEGES

This view lists grants on columns for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee.

This view is included for compatibility with Oracle version 6. Use of this view is not recommended.

Column Description

GRANTEE

Name of the user to whom access was granted.

OWNER

Username of the object's owner.

TABLE_NAME

Name of the object.

COLUMN_NAME

Name of the column.

GRANTOR

Name of the user who performed the grant.

INSERT_PRIV

Permission to insert into the column.

UPDATE_PRIV

Permission to update the column.

REFERENCES_PRIV

Permission to reference the column.

CREATED

Timestamp for the grant.

DBA_2PC_NEIGHBORS

This view contains information about incoming and outgoing connections for pending transactions.

Column	Datatype	Description
LOCAL_TRAN_ID	VARCHAR2(22)	Local identifier of a transaction
IN_OUT	VARCHAR2(3)	IN for incoming connections, OUT for outgoing
DATABASE	VARCHAR2(128)	IN: client database name; OUT: outgoing database link
DBUSER_OWNER	VARCHAR2(30)	IN: name of local user; OUT: owner of database link
INTERFACE	VARCHAR2(1)	"C" for request commit, otherwise "N" for prepare or request readonly commit
DBID	VARCHAR2(16)	The database ID at the other end of the connection
SESS#	NUMBER	Session number of the connection at this database
BRANCH	VARCHAR2(128)	Transaction branch ID of the connection at this database

DBA_2PC_PENDING

This view contains information about distributed transactions awaiting recovery.

Column	Datatype	NULL	Description
LOCAL_TRAN_ID	VARCHAR2(22)	NOT NULL	String of form: n.n.n; n is a number
GLOBAL_TRAN_ID	VARCHAR2(169)		Globally unique transaction ID
STATE	VARCHAR2(16)	NOT NULL	Collecting, prepared, committed, forced commit, or forced rollback
MIXED	VARCHAR2(3)		YES = part of the transaction committed and part rolled back
ADVICE	VARCHAR2(1)		C for commit, R for rollback, else NULL
TRAN_COMMENT	VARCHAR2(2000)		Text for commit work comment text
FAIL_TIME	DATE	NOT NULL	Value of SYSDATE when the row was inserted (tx or system recovery)
FORCE_TIME	DATE		Time of manual force decision (null if not forced locally)
RETRY_TIME	DATE	NOT NULL	Time automatic recovery (RECO) last tried to recover the transaction
OS_USER	VARCHAR2(2000)		Time automatic recovery (RECO) last tried to recover the transaction
OS_TERMINAL	VARCHAR2(2000)		Time automatic recovery (RECO) last tried to recover the transaction
HOST	VARCHAR2(2000)		Name of the host machine for the end-user
DB_USER	VARCHAR2(30)		Name of the host machine for the end-user
COMMIT#	VARCHAR2(16)		Name of the host machine for the end-user

DBA_ALL_TABLES

This view displays descriptions of all tables (object tables and relational tables) in the database.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
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	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last modification?
NUM_ROWS	NUMBER	The number of rows in the table
BLOCKS	NUMBER	The number of used blocks in the table
EMPTY_BLOCKS	NUMBER	The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	The average available free space in the table
CHAIN_CNT	NUMBER	The number of chained rows in the table
AVG_ROW_LEN	NUMBER	The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST _BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	The sample size used in analyzing this table
LAST_ANALYZED	DATE	The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)	If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	Type of the table if the table is a typed table
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)	Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)	The default buffer pool to be used for table blocks

DBA_AUDIT_EXISTS

This view lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier of the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry
OWNER	VARCHAR2(30)		Intended creator of the non-existent object
OBJ_NAME	VARCHAR2(128)		Name of the object affected by the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_OWNER	VARCHAR2(30)		Owner of the object named in the NEW_NAME column
NEW_NAME	VARCHAR2(128)		New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	VARCHAR2(16)		Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	VARCHAR2(40)		System privileges granted or revoked by a GRANT or REVOKE statement
GRANTEE	VARCHAR2(30)		Name of grantee specified in a GRANT or REVOKE statement
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run
RETURNCODE	NUMBER	NOT NULL	Oracle Server message code generated by the action. Some useful values: zero: the action succeeded 2004: security violation

DBA_AUDIT_OBJECT

This view contains audit trail records for all objects in the system.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier of the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of the object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of the object affected by the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_OWNER	VARCHAR2(30)		Owner of the object named in the NEW_NAME column
NEW_NAME	VARCHAR2(128)		New name of an object after a RENAME or the name of the underlying object
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)
COMMENT_TEXT	VARCHAR2(4000		Text comment on the audit trail
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run
RETURNCODE	NUMBER	NOT NULL	Oracle Server message code generated by the action. Some useful values: zero: the action succeeded 2004: security violation
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
OBJECT_LABEL	MLSLABEL		Label associated with the object being audited. Applies to Trusted Oracle Server only.
SESSION_LABEL	MLSLABEL		Label associated with the session. Applies to Trusted Oracle Server only.

DBA_AUDIT_SESSION

This view lists all audit trail records concerning CONNECT and DISCONNECT.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier of the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
LOGOFF_TIME	DATE		Timestamp for user log off
LOGOFF_LREAD	NUMBER		Logical reads for the session
LOGOFF_PREAD	NUMBER		Physical reads for the session
LOGOFF_LWRITE	NUMBER		Logical writes for the session
LOGOFF_DLOCK	VARCHAR2(40)		Deadlocks detected during the session
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
RETURNCODE	NUMBER	NOT NULL	Oracle Server message code generated by the action. Some useful values: zero: the action succeeded 2004: security violation
SESSION_LABEL	MLSLABEL		Label associated with the session. Applies to Trusted Oracle Server only.

DBA_AUDIT_STATEMENT

This view lists audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier of the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of the object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of object affected by the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_NAME	VARCHAR2(128)		New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	VARCHAR2(16)		Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	VARCHAR2(40)		System privileges granted or revoked by a GRANT or REVOKE statement
ADMIN_OPTION	VARCHAR2(1)		Signifies the role or system privilege was granted with ADMIN option
GRANTEE	VARCHAR2(30)		Name of grantee specified in a GRANT or REVOKE statement
AUDIT_OPTION	VARCHAR2(40)		Auditing option set with the AUDIT statement
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)
COMMENT_TEXT	VARCHAR2(4000)		Text comment on the audit trail, inserted by the application
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run
RETURNCODE	NUMBER	NOT NULL	Oracle Server message code generated by the action. Some useful values: zero: the action succeeded 2004: security violation
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
SESSION_LABEL	MLSLABEL		Label associated with the session. Applies to Trusted Oracle Server only.

DBA_AUDIT_TRAIL

This view lists all audit trail entries.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier of the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of the object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of the object affected by the action
ACTION	NUMBER	NOT NULL	Numeric type code corresponding to the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in the ACTION column
NEW_OWNER	VARCHAR2(30)		Owner of the object named in the NEW_NAME column
NEW_NAME	VARCHAR2(128)		New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	VARCHAR2(16)		Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	VARCHAR2(40)		System privileges granted or revoked by a GRANT or REVOKE statement
ADMIN_OPTION	VARCHAR2(1)		Signifies the role or system privilege was granted with ADMIN option
GRANTEE	VARCHAR2(30)		Name of grantee specified in a GRANT or REVOKE statement
AUDIT_OPTION	VARCHAR2(40)		Auditing option set with the AUDIT statement
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)
LOGOFF_TIME	DATE		Timestamp for user log off
LOGOFF_LREAD	NUMBER		Logical reads for the session
LOGOFF_PREAD	NUMBER		Physical reads for the session
LOGOFF_LWRITE	NUMBER		Logical writes for the session
LOGOFF_DLOCK	VARCHAR2(40)		Deadlocks detected during the session
COMMENT_TEXT	VARCHAR2(4000)		Text comment on the audit trail entry, providing more information about the statement audited
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run
RETURNCODE	NUMBER	NOT NULL	Oracle Server message code generated by the action. Some useful values: zero: the action succeeded 2004: security violation
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
OBJECT_LABEL	MLSLABEL		Label associated with the object being audited. Applies to Trusted Oracle Server only.
SESSION_LABEL	MLSLABEL		Label associated with the session. Applies to Trusted Oracle Server only.

DBA_BLOCKERS

This view lists all sessions that have someone waiting on a lock they hold that are not themselves waiting on a lock.

Column	Datatype	NULL	Description
HOLDING_SESSION	NUMBER		Session holding a lock

DBA_CATALOG

This view lists all database tables, views, synonyms, and sequences.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object

DBA_CLU_COLUMNS

This view lists mappings of table columns to cluster columns.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Cluster name
CLU_COLUMN_NAME	VARCHAR2(30)	NOT NULL	Key column in the cluster
TABLE_NAME	VARCHAR2(30)	NOT NULL	Clustered table name
TAB_COLUMN_NAME	VARCHAR2(4000)		Key column or attribute of the object type column

DBA_CLUSTERS

This view contains description of all clusters in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
PCT_FREE	NUMBER		Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	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	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
AVG_BLOCKS_PER_KEY	NUMBER		Average number of blocks containing rows with a given cluster key
CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B-Tree index or hash
FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

DBA_COL_COMMENTS

This view lists comments on columns of all tables and views.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
COMMENTS	VARCHAR2(4000)		Comment on the object

DBA_COL_PRIVS

This view lists all grants on columns in the database.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Column privilege
GRANTABLE	VARCHAR2(3)		Privilege is Grantable

DBA_COLL_TYPES

This view displays all named collection types in the database such as VARRAYs, nested tables, object tables, and so on.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
COLL_TYPE	VARCHAR2(30)	NOT NULL	Collection type
UPPER_BOUND	NUMBER		Maximum size of the VARRAY type
ELEM_TYPE_MOD	VARCHAR2(7)		Type modifier of the element
ELEM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the element
ELEM_TYPE_NAME	VARCHAR2(30)		Name of the type of the element
LENGTH	NUMBER		Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE	NUMBER		Scale of the NUMBER or DECIMAL element
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

DBA_CONSTRAINTS

This view contains constraint definitions on all tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with constraint definition
CONSTRAINT_TYPE	VARCHAR2(1)		Type of constraint definition: C (check constraint on a table) P (primary key) U (unique key) R (referential integrity) V (with check option on a view) O (with read only, on a view)
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
SEARCH_CONDITION	LONG		Text of search condition for table check
R_OWNER	VARCHAR2(30)		Owner of table used in referential constraint
R_CONSTRAINT_NAME	VARCHAR2(30)		Owner of table used in referential constraint
DELETE_RULE	VARCHAR2(9)		The delete rule for a referential constraint
STATUS	VARCHAR2(8)		Enforcement status of constraint: ENABLED or DISABLED
DEFERRABLE	VARCHAR2(14)		Indicates whether the constraint is deferrable
DEFERRED	VARCHAR2(9)		Indicates whether the constraint was initially deferred
GENERATED	VARCHAR2(14)		Indicates whether the name system is generated
LAST_CHANGE	DATE		Indicates when the constraint was last enabled or disabled
BAD	VARCHAR2(3)		Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
VALIDATED	VARCHAR2(13)		Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED

DBA_CONS_COLUMNS

This view contains information about accessible columns in constraint definitions.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
COLUMN_NAME	VARCHAR2(4000)		Name associated with column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER		Original position of column or attribute in definition

DBA_DATA_FILES

This view contains information about database files.

Column	Datatype	NULL	Description
FILE_NAME	VARCHAR2(513)		Name of the database file
FILE_ID	NUMBER	NOT NULL	ID of the database file
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace to which the file belongs
BYTES	NUMBER		Size of the file in bytes
BLOCKS	NUMBER	NOT NULL	Size of the file in Oracle blocks
STATUS	VARCHAR2(9)		File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)
RELATIVE_FNO	NUMBER		Relative file number
AUTOEXTENSIBLE	VARCHAR2(3)		Autoextensible indicator
MAXBYTES	NUMBER		Maximum file size in bytes
MAXBLOCKS	NUMBER		Maximum file size in blocks
INCREMENT_BY	NUMBER		Autoextension increment

DBA_DB_LINKS

This view lists all database links in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the database link
DB_LINK	VARCHAR2(128)	NOT NULL	Name of the database link
USERNAME	VARCHAR2(3)		Name of user to log in as
HOST	VARCHAR2(2000)		Connect string
CREATED	DATE	NOT NULL	Creation time of the database link

DBA_DDL_LOCKS

This view lists all DDL locks held in the database and all outstanding requests for a DDL lock.

Column	Datatype	Description
SESSION_ID	NUMBER	Session identifier
OWNER	VARCHAR2(30)	Owner of the lock
NAME	VARCHAR2(30)	Name of the lock
TYPE	VARCHAR2(40)	Lock type: CURSOR, TABLE/PROCEDURE/TYPE, BODY, TRIGGER, INDEX, CLUSTER
MODE_HELD	VARCHAR2(9)	Lock mode: NONE, NULL, SHARE, EXCLUSIVE
MODE_REQUESTED	VARCHAR2(9)	Lock request type: NONE, NULL, SHARE, EXCLUSIVE

DBA_DEPENDENCIES

This view lists dependencies to and from objects.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(3)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of the object
REFERENCED_OWNER	VARCHAR2(30)		Owner of referenced object (remote owner if remote object)
REFERENCED_NAME	VARCHAR2(64)		Name of referenced object
REFERENCED_TYPE	VARCHAR2(12)		Type of referenced object
REFERENCED_LINK _NAME	VARCHAR2(128)		Name of dblink if this is a remote object
DEPENDENCY_TYPE	VARCHAR2(4)		Two values: REF when the dependency is a REF dependency; HARD otherwise

DBA_DIRECTORIES

This view provides information on all directory objects in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the directory (always SYS)
DIRECTORY_NAME	VARCHAR2(30)	NOT NULL	Name of the directory
DIRECTORY_PATH	VARCHAR2(4000)		Operating system pathname for the directory

DBA_DML_LOCKS

This view lists all DML locks held in the database and all outstanding requests for a DML lock.

Column	Datatype	NULL	Description
SESSION_ID	NUMBER		Session holding or acquiring the lock
OWNER	VARCHAR2(30)	NOT NULL	Owner of the lock
NAME	VARCHAR2(30)	NOT NULL	Name of the lock
MODE_HELD	VARCHAR2(13)		Lock mode: see Table 2-1
MODE_REQUESTED	VARCHAR2(13)		Lock request type: see Table 2-1
LAST_CONVERT	NUMBER		The last convert
BLOCKING_OTHERS	VARCHAR2(40)		Blocking others

Table 2-1 describes DML lock mode values that are valid for the MODE_HELD column.

Table 2-1 Lock Modes for the DBA_DML_LOCKS View

Lock Mode	Description
ROWS-S (SS)	Row share
ROW-X (SX)	Row exclusive
SHARE (S)	Share
S/ROW-X (SSX)	Exclusive
NONE	MODE_HELD: Lock requested, not yet obtained MODE_REQUESTED: Lock identifier obtained, lock not held or requested

DBA_ERRORS

This view lists current errors on all stored objects in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	The owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of object: VIEW, PROCEDURE, FUNCTION, PACKAGE, TYPE, TYPE BODY, PACKAGE BODY, or TRIGGER
SEQUENCE	NUMBER	NOT NULL	Sequence number used for ordering purposes
LINE	NUMBER	NOT NULL	Line number at which this error occurs
POSITION	NUMBER	NOT NULL	Position in the line at which this error occurs
TEXT	VARCHAR2(4000)	NOT NULL	Text of the error

DBA_EXP_FILES

This view contains a description of export files.

Column	Datatype	NULL	Description
EXP_VERSION	NUMBER(3)	NOT NULL	Version number of the export session
EXP_TYPE	VARCHAR2(11)		Type of export file: complete, cumulative, or incremental
FILE_NAME	VARCHAR2(100)	NOT NULL	Name of the export file
USER_NAME	VARCHAR2(30)	NOT NULL	Name of user who executed export
TIMESTAMP	DATE	NOT NULL	Timestamp of the export session

DBA_EXP_OBJECTS

This view lists objects that have been incrementally exported.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of exported object
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of exported object
OBJECT_TYPE	VARCHAR2(12)		Type of exported object
CUMULATIVE	DATE		Timestamp of last cumulative export
INCREMENTAL	DATE	NOT NULL	Timestamp of last incremental export
EXPORT_VERSION	NUMBER(3)	NOT NULL	The ID of the export session

DBA_EXP_VERSION

This view contains the version number of the last export session.

Column	Datatypes	NULL	Description
EXP_VERSION	NUMBER(3)	NOT NULL	Version number of the last export session

DBA_EXTENTS

This view lists the extents comprising all segments in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the segment associated with the extent
SEGMENT_NAME	VARCHAR2(81)		Name of the segment associated with the extent
SEGMENT_TYPE	VARCHAR2(17)		Type of the segment: INDEX PARTITION, TABLE PARTITION
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the extent
EXTENT_ID	NUMBER	NOT NULL	Extent number in the segment
FILE_ID	NUMBER	NOT NULL	Name of the file containing the extent
BLOCK_ID	NUMBER	NOT NULL	Starting block number of the extent
BYTES	NUMBER		Size of the extent in bytes
BLOCKS	NUMBER	NOT NULL	Size of the extent in Oracle blocks
RELATIVE_FNO	NUMBER	NOT NULL	Relative file number of the first extent block
PARTITION_NAME	VARCHAR2(30)		Object Partition Name (Set to NULL for non-partitioned objects).

DBA_FREE_SPACE

This view lists the free extents in all tablespaces.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the extent
FILE_ID	NUMBER	NOT NULL	ID number of the file containing the extent
BLOCK_ID	NUMBER	NOT NULL	Starting block number of the extent
BYTES	NUMBER		Size of the extent in bytes
BLOCKS	NUMBER	NOT NULL	Size of the extent in Oracle blocks
RELATIVE_FNO	NUMBER	NOT NULL	Relative file number of the first extent block

DBA_FREE_SPACE_COALESCED

This view contains statistics on coalesced space in tablespaces.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of tablespace
TOTAL_EXTENTS	NUMBER		Total number of free extents in tablespace
EXTENTS_COALESCED	NUMBER		Total number of coalesced free extents in tablespace
PERCENT_EXTENTS _COALESCED	NUMBER		Percentage of coalesced free extents in tablespace
TOTAL_BYTES	NUMBER		Total number of free bytes in tablespace
BYTES_COALESCED	NUMBER		Total number of coalesced free bytes in tablespace
TOTAL_BLOCKS	NUMBER		Total number of free Oracle blocks in tablespace
BLOCKS_COALESCED	NUMBER		Total number of coalesced free Oracle blocks in tablespace
PERCENT_BLOCKS _COALESCED	NUMBER		Percentage of coalesced free Oracle blocks in tablespace

DBA_INDEXES

This view contains descriptions for all indexes in the database. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the index
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the index
INDEX_TYPE	VARCHAR2(12)		Type of index
TABLE_OWNER	VARCHAR2(30)		Owner of the indexed object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the indexed object
TABLE_TYPE	VARCHAR2(11)	NOT NULL	Type of the indexed object
UNIQUENESS	VARCHAR2(9)		Uniqueness status of the index: UNIQUE or NONUNIQUE
TABLESPACE_NAME	VARCHAR2(30)		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 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		Percentage increase in extent size
PCT_THRESHOLD	NUMBER		Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER		User column-id for last column to be included in index organized table top index
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
PCT_FREE	NUMBER		Minimum percentage of free space in a block
LOGGING	VARCHAR2(3)		Logging attribute
BLEVEL	NUMBER		B-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.
LEAF_BLOCKS	NUMBER		The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER		The number of distinct keys in the index
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		The average number of leaf blocks per key
AVG_DATA_BLOCKS _PER_KEY	NUMBER		The average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		A measurement of the amount of (dis)order of the table this index is for
STATUS	VARCHAR2(8)		Whether index is in Direct Load State
NUM_ROWS	NUMBER		Number of rows in this index
SAMPLE_SIZE	NUMBER		Size of the sample used to analyze this index
LAST_ANALYZED	DATE		Timestamp for when this index was last analyzed
DEGREE	VARCHAR2(40)		Number of threads per instance for scanning the index. NULL if PARTITIONED=NO.
INSTANCES	VARCHAR2(40)		Number of instances across which the indexes are to be scanned. NULL if PARTITIONED=NO.
PARTITIONED	VARCHAR2(3)		Indicates whether this index is partitioned. Set to YES if it is partitioned
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
GENERATED	VARCHAR2(1)		Was the name of this index system generated?
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

DBA_IND_COLUMNS

This view contains descriptions of the columns comprising the indexes on all tables and clusters.

Column	Datatype	NULL	Description
INDEX_OWNER	VARCHAR2(30)	NOT NULL	Index owner
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table or cluster owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table or cluster name
COLUMN_NAME	VARCHAR2(4000)		Column name or attribute of the object type column
COLUMN_POSITION	NUMBER	NOT NULL	Position of column or attribute within index
COLUMN_LENGTH	NUMBER	NOT NULL	Indexed length of the column or attribute

DBA_IND_PARTITIONS

This view describes, for each index partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.

Column	Datatype	NULL	Description
INDEX_OWNER	VARCHAR2(30)	NOT NULL	Index owner
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the index
STATUS	VARCHAR2(8)		Indicates whether index partition is usable or not
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of process freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
BLEVEL	NUMBER		B-Tree level
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index partition
DISTINCT_KEYS	NUMBER		Number of distinct keys in the index partition
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		Average number of leaf blocks per key
AVG_DATA_BLOCKS _PER_KEY	NUMBER		Average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		Measurement of the amount of (dis)order of the table this index partition is for
NUM_ROWS	NUMBER		Number of rows in this index partition
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)		The buffer pool for this partition

DBA_JOBS

This view lists all jobs in the database.

Column	Datatype	NULL	Description
JOB	NUMBER	NOT NULL	Identifier of job. Neither import/export nor repeated executions change it.
LOG_USER	VARCHAR2(30)	NOT NULL	USER who was logged in when the job was submitted
PRIV_USER	VARCHAR2(30)	NOT NULL	USER whose default privileges apply to this job
SCHEMA_USER	VARCHAR2(30)	NOT NULL	Default schema used to parse the job. For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
LAST_DATE	DATE		Date that this job last successfully executed
LAST_SEC	VARCHAR2(8)		Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	DATE		Date that this job started executing (usually NULL if not executing)
THIS_SEC	VARCHAR2(8)		Same as THIS_DATE.
NEXT_DATE	DATE	NOT NULL	Date that this job will next be executed
NEXT_SEC	VARCHAR2(8))		Same as NEXT_DATE. The job becomes due for execution at this time.
TOTAL_TIME	NUMBER		Total wall clock time spent by the system on this job, in seconds
BROKEN	VARCHAR2(1)		If Y, no attempt is made to run this job.
INTERVAL	VARCHAR2(200)	NOT NULL	A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES	NUMBER		How many times has this job started and failed since its last success?
WHAT	VARCHAR2(4000)		Body of the anonymous PL/SQL block that this job executes
CURRENT_SESSION _LABEL	MLSLABEL		Trusted Oracle Server label of the current session as seen by the job. Applies to Trusted Oracle Server only.
CLEARANCE_HI	MLSLABEL		Highest level of clearance available to the job. Applies to Trusted Oracle Server only.
CLEARANCE_LO	MLSLABEL		Lowest level of clearance available to the job. Applies to Trusted Oracle Server only.
NLS_ENV	VARCHAR2(4000)		ALTER SESSION parameters describing the NLS environment of the job
MISC_ENV	RAW(32)		Other session parameters that apply to this job

DBA_JOBS_RUNNING

This view lists all jobs in the database that are currently running.

Column	Datatype	Description
SID	NUMBER	Identifier of process that is executing the job. See "V$LOCK" on page 3-51.
JOB	NUMBER	Identifier of job. This job is currently executing.
FAILURES	NUMBER	Number of times this job started and failed since its last success
LAST_DATE	DATE	Date that this job last successfully executed
LAST_SEC	VARCHAR2(8)	Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	DATE	Date that this job started executing
THIS_SEC	VARCHAR2(8)	Same as THIS_DATE. This is when the job started executing.

DBA_LIBRARIES

This view lists all the libraries in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the library
LIBRARY_NAME	VARCHAR2(30)	NOT NULL	Library name
FILE_SPEC	VARCHAR2(2000)		Operating system file specification associated with the library
DYNAMIC	VARCHAR2(1)		Is the library dynamically loadable? (YES or NO)
STATUS	VARCHAR2(7)		Status of the library

DBA_LOBS

This view displays the LOBs contained in all tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table containing the LOB
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table containing the LOB
COLUMN_NAME	VARCHAR2(30)		Name of the LOB column or attribute
SEGMENT_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB segment
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB index
CHUNK	NUMBER		Size of the LOB chunk as a unit of allocation/manipulation in bytes
PCTVERSION	NUMBER	NOT NULL	Maximum percentage of the LOB space used for versioning
CACHE	VARCHAR2(3)		Indicates whether the LOB is accessed through the buffer cache
LOGGING	VARCHAR2(3)		Indicates whether the changes to the LOB are logged
IN_ROW	VARCHAR2(3)		Are some of the LOBs stored with the base row?

DBA_LOCKS

This view lists all locks or latches held in the database, and all outstanding requests for a lock or latch.

Column	Datatype	Description
SESSION_ID	NUMBER	Session holding or acquiring the lock
LOCK_TYPE	VARCHAR2(26)	Lock type
MODE HELD	VARCHAR2(40)	Lock mode
MODE REQUESTED	VARCHAR2(40)	Lock mode requested
LOCK_ID1	VARCHAR2(40)	Type-specific lock identifier, part 1
LOCK_ID2	VARCHAR2(40)	Type-specific lock identifier, part 2
LAST_CONVERT	NUMBER	The last convert
BLOCKING_OTHERS	VARCHAR2(40)	Blocking others

DBA_METHOD_PARAMS

This view is a description of method parameters of types in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
PARAM_NAME	VARCHAR2(30)	NOT NULL	Name of the parameter
PARAM_NO	NUMBER	NOT NULL	Parameter number or position
PARAM_MODE	VARCHAR2(6)		Mode of the parameter
PARAM_TYPE_MOD	VARCHAR2(7)		Type modifier of the parameter
PARAM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the parameter
PARAM_TYPE_NAME	VARCHAR2(30)		Name of the type of the parameter
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

DBA_METHOD_RESULTS

This view is a description of method results of all types in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	The method number
RESULT_TYPE_MOD	VARCHAR2(7)		Type modifier of the result
RESULT_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the result
RESULT_TYPE_NAME	VARCHAR2(30)		Name of the type of the result
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS, NCHAR_CS

DBA_NESTED_TABLES

This view displays descriptions of the nested tables contained in all tables.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the nested table
TABLE_NAME	VARCHAR2(30)	Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2(30)	Name of the type of the nested table
PARENT_TABLE_NAME	VARCHAR2(30)	Name of the parent table containing the nested table
PARENT_TABLE_COLUMN	VARCHAR2(4000)	Column name of the parent table that corresponds to the nested table

DBA_OBJECT_SIZE

This view lists the sizes, in bytes, of various PL/SQL objects.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of the object: TABLE, VIEW, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, or PACKAGE BODY
SOURCE_SIZE	NUMBER		Size of the source in bytes
PARSED_SIZE	NUMBER		Size of the parsed form of the object in bytes
CODE_SIZE	NUMBER		Code size in bytes
ERROR_SIZE	NUMBER		Size of error messages in bytes

DBA_OBJECT_TABLES

This view displays descriptions of all object tables in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)		Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)		Name of the index organized table, if any, to which the overflow entry belongs
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		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute
BACKED_UP	VARCHAR2(1)		Has table been backed up since last modification?
NUM_ROWS	NUMBER		The number of rows in the table
BLOCKS	NUMBER		The number of used blocks in the table
EMPTY_BLOCKS	NUMBER		The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER		The average available free space in the table
CHAIN_CNT	NUMBER		The number of chained rows in the table
AVG_ROW_LEN	NUMBER		The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER		The number of blocks on the freelist
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER		The sample size used in analyzing this table
LAST_ANALYZED	DATE		The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)		Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)		If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	NOT NULL	Type of the table if the table is a typed table
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)		Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)		The default buffer pool to be used for table blocks

DBA_OBJECTS

This view lists all objects in the database.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Username of the owner of the object
OBJECT_NAME	VARCHAR2(128)	Name of the object
SUBOBJECT_NAME	VARCHAR2(30)	Name of the sub-object (for example, partition)
OBJECT_ID	NUMBER	Object number of the object
DATA_OBJECT_ID	NUMBER	Object number of the segment which contains the object
OBJECT_TYPE	VARCHAR2(15)	Type and type body of the object: INDEX PARTITION, TABLE PARTITION, PACKAGE, PACKAGE BODY, or TRIGGER
CREATED	DATE	Timestamp for the creation of the object
LAST_DDL_TIME	DATE	Timestamp for the last DDL change (including GRANT and REVOKE) to the object
TIMESTAMP	VARCHAR2(20)	Timestamp for the specification of the object
STATUS	VARCHAR2(7)	Status of the object
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
GENERATED	VARCHAR2(1)	Was the name of this object system generated?

DBA_OBJ_AUDIT_OPTS

This view lists auditing options for all tables and views.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the object
OBJECT_NAME	VARCHAR2(30)	Name of the object
OBJECT_TYPE	VARCHAR2(9)	Type of the object
ALT	VARCHAR2(3)	Auditing ALTER WHENEVER SUCCESSFUL/UNSUCCESSFUL
AUD	VARCHAR2(3)	Auditing AUDIT WHENEVER SUCCESSFUL/UNSUCCESSFUL
COM	VARCHAR2(3)	Auditing COMMENT WHENEVER SUCCESSFUL/UNSUCCESSFUL
DEL	VARCHAR2(3)	Auditing DELETE WHENEVER SUCCESSFUL/UNSUCCESSFUL
GRA	VARCHAR2(3)	Auditing GRANT WHENEVER SUCCESSFUL/UNSUCCESSFUL
IND	VARCHAR2(3)	Auditing INDEX WHENEVER SUCCESSFUL/UNSUCCESSFUL
INS	VARCHAR2(3)	Auditing INSERT WHENEVER SUCCESSFUL/UNSUCCESSFUL
LOC	VARCHAR2(3)	Auditing LOCK WHENEVER SUCCESSFUL/UNSUCCESSFUL
REN	VARCHAR2(3)	Auditing RENAME WHENEVER SUCCESSFUL/UNSUCCESSFUL
SEL	VARCHAR2(3)	Auditing SELECT WHENEVER SUCCESSFUL/UNSUCCESSFUL
UPD	VARCHAR2(3)	Auditing UPDATE WHENEVER SUCCESSFUL/UNSUCCESSFUL
REF	VARCHAR2(3)	Auditing REFERENCE WHENEVER SUCCESSFUL/UNSUCCESSFUL (not used)
EXE	VARCHAR2(3)	Auditing EXE WHENEVER SUCCESSFUL/UNSUCCESSFUL
CRE	VARCHAR2(3)	Auditing CRE WHENEVER SUCCESSFUL/UNSUCCESSFUL
REA	VARCHAR2(3)	Auditing REA WHENEVER SUCCESSFUL/UNSUCCESSFUL
WRI	VARCHAR2(3)	Auditing WRI WHENEVER SUCCESSFUL/UNSUCCESSFUL

DBA_PART_COL_STATISTICS

This view contains column statistics and histogram information for all table partitions.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner name
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Table partition name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed

DBA_PART_HISTOGRAMS

This view contains the histogram data (end-points per histogram) for histograms on all table partitions.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner name
TABLE_NAME	VARCHAR2(30)	Table name
PARTITION_NAME	VARCHAR2(30)	Table partition name
COLUMN_NAME	VARCHAR2(30)	Column name
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

DBA_PART_INDEXES

This view lists the object level partitioning information for all partitioned indexes.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of this partitioned index
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned index
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: RANGE
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this index
PARTITIONING_KEY _COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
LOCALITY	VARCHAR2(6)		Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT	VARCHAR2(12)		Indicates whether this partitioned index is PREFIXED or NON-PREFIXED
DEF_TABLESPACE _NAME	VARCHAR2(30)		Default TABLESPACE, used for LOCAL index, for ADD/SPLIT TABLE PARTITION
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, used for LOCAL index, for ADD TABLE PARTITION
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, used for LOCAL index, for ADD TABLE PARTITION
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, used for LOCAL index, for ADD TABLE PARTITION
DEF_INITIAL_EXTENT	NUMBER		Default INITIAL, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	NUMBER		Default NEXT, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	NUMBER		Default MINEXTENTS, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	NUMBER		Default MAXEXTENTS, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	NUMBER		Default PCTINCREASE, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, used for LOCAL index, for ADD TABLE PARTITION
DEF_FREELIST_GROUPS	NUMBER	NOT NULL	Default FREELISTS, used for LOCAL index, for ADD TABLE PARTITION
DEF_LOGGING	VARCHAR2(7)		Default LOGGING, for LOCAL index, for ADD TABLE PARTITION
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool for the index, for ADD TABLE PARTITION

DBA_PART_KEY_COLUMNS

This view describes the partitioning key columns for all partitioned objects.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Partitioned table or index owner
NAME	VARCHAR2(30)	Partitioned table or index name
OBJECT_TYPE	VARCHAR2(11)	The object type (`TABLE' or `INDEX')
COLUMN_NAME	VARCHAR2(30)	Column name
COLUMN_POSITION	NUMBER	Position of the column within the partitioning key

DBA_PART_TABLES

This view lists the object level partitioning information for all the partitioned tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of this partitioned table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned table
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: RANGE
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this table
PARTITIONING_KEY _COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
DEF_TABLESPACE _NAME	VARCHAR2(30)	NOT NULL	Default TABLESPACE, used for ADD partition
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, used for ADD partition
DEF_PCT_USED	NUMBER	NOT NULL	Default PCTUSED, used for ADD partition
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, used for ADD partition
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, used for ADD partition
DEF_INITIAL_EXTENT	VARCHAR2(40)		Default INITIAL, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	VARCHAR2(40)		Default NEXT, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	VARCHAR2(40)		Default MINEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	VARCHAR2(40)		Default MAXEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	VARCHAR2(40)		Default PCTINCREASE, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, used for ADD partition
DEF_FREELIST _GROUPS	NUMBER	NOT NULL	Default FREELIST GROUPS, used for ADD partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING attribute, used for ADD partition
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool for the given object, used for ADD partition

DBA_PRIV_AUDIT_OPTS

This view describes current system privileges being audited across the system and by user.

Column	Datatype	NULL	Description
USER_NAME	VARCHAR2(30)		User name if by user auditing, else NULL for system-wide auditing
PRIVILEGE	VARCHAR2(40)	NOT NULL	Name of the system privilege being audited
SUCCESS	VARCHAR2(10)		Mode for WHENEVER SUCCESSFUL system auditing
FAILURE	VARCHAR2(10)		Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_PROFILES

This view displays all profiles and their limits.

Column	Datatype	NULL	Description
PROFILE	VARCHAR2(30)	NOT NULL	Profile name
RESOURCE_NAME	VARCHAR2(32)	NOT NULL	Resource name
RESOURCE_TYPE	VARCHAR2(8)		Indicates whether the resource profile is a KERNEL or a PASSWORD parameter
LIMIT	VARCHAR2(40)		Limit placed on this resource for this profile

DBA_QUEUE_SCHEDULES

This view describes the current schedules for propagating messages.

Column	Datatype	NULL	Description
SCHEMA	VARCHAR2(30)	NOT NULL	Schema name for the source queue
QNAME	VARCHAR2(30)	NOT NULL	Source queue name
DESTINATION	VARCHAR2(128)	NOT NULL	Destination name, currently limited to be a DBLINK name
START_DATE	DATE		Date to start propagation in the default date format
START_TIME	VARCHAR2(8)		Time of day at which to start propagation in HH:MI:SS format
PROPAGATION _WINDOW	NUMBER		Duration in seconds for the propagation window
NEXT_TIME	VARCHAR2(128)		Function to compute the start of the next propagation window
LATENCY	NUMBER		Maximum wait time to propagate a message during the propagation window

DBA_ QUEUE_TABLES

This view describes the names and types of the queues in all of the queue tables created in the database. For more information about this view and Advanced Queuing, see the Oracle8 Application Developer's Guide.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Schema of the queue table
QUEUE_TABLE	VARCHAR2(30)	Name of the queue table
TYPE	VARCHAR2(7)	Type of user data: RAW: raw type OBJECT: user-defined object type VARIANT: variant type (internal use only)
OBJECT_TYPE	VARCHAR2(61)	Object type of the payload when TYPE is OBJECT
SORT_ORDER	VARCHAR2(22)	User specified sort order
RECIPIENTS	VARCHAR2(8)	SINGLE or MULTIPLE recipients
MESSAGE_GROUPING	VARCHAR2(13)	NONE or TRANSACTIONAL
USER_COMMENT	VARCHAR2(50)	Comment supplied by the user

DBA_ QUEUES

This view describes the operational characteristics for every queue in a database. For more information about this view and Advanced Queuing, see the Oracle8 Application Developer's Guide.

Column	Datatypes	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the queue schema
NAME	VARCHAR2(30)	NOT NULL	Name of the queue
QUEUE_TABLE	VARCHAR2(30)	NOT NULL	The name of the queue table where this queue resides
QID	NUMBER	NOT NULL	Unique queue identifier
QUEUE_TYPE	VARCHAR2(15)		Queue type: NORMAL_QUEUE - Normal queue EXCEPTION_QUEUE - Exception queue
MAX_RETRIES	NUMBER		Number of dequeue attempts allowed
RETRY_DELAY	NUMBER		Time lapse in seconds before retry takes place
ENQUEUE_ENABLED	VARCHAR2(7)		YES/NO
DEQUEUE_ENABLED	VARCHAR2(7)		YES/NO
RETENTION	VARCHAR2(40)		Number of seconds message is retained after dequeue FOREVER - messages stay in the queue permanently
USER_COMMENT	VARCHAR2(50)		User comment about the table

DBA_RCHILD

This view lists all the children in any refresh group.

Column	Datatype	NULL	Description
REFGROUP	NUMBER		Internal identifier of refresh group
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
TYPE#	VARCHAR2(30)		Type of the object in the refresh group

DBA_REFRESH

This view lists all the refresh groups.

Column	Datatype	NULL	Description
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N; if Y, then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

DBA_REFRESH_CHILDREN

This view lists all of the objects in refresh groups.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
TYPE	VARCHAR2(30)		Type of the object in the refresh group
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N; if Y, then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

DBA_REFS

This view describes the REF columns and REF attributes in object type columns of all the tables in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
COLUMN_NAME	VARCHAR2 (4000)		Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name.
WITH_ROWID	VARCHAR2(3)		Is the REF value stored with ROWID? (YES or NO)
IS_SCOPED	VARCHAR2(3)		Is the REF column scoped? (YES or NO)
SCOPE_TABLE _OWNER	VARCHAR2(30)		Name of the owner of the scope table, if it exists
SCOPE_TABLE _NAME	VARCHAR2(30)		Name of the scope table, if it exists

DBA_REGISTERED_SNAPSHOT_GROUPS

This view lists all the snapshot repgroups at this site.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot replication group
SNAPSHOT_SITE	VARCHAR2(128)	NOT NULL	Site of the master of the snapshot repgroup
GROUP_COMMENT	VARCHAR2(80)		Description of the snapshot repgroup
VERSION	VARCHAR2(8)		Version of the snapshot repgroup

DBA_REGISTERED_SNAPSHOTS

This view is used to get information about remote snapshots of local tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot
SNAPSHOT_SITE	VARCHAR2(128)	NOT NULL	Global name of the snapshot site
CAN_USE_LOG	VARCHAR2(3)		If set to NO, this snapshot is complex and cannot fast refresh
UPDATABLE	VARCHAR2(3)		If set to NO, the snapshot is read only
REFRESH_METHOD	VARCHAR2(11)		Values used to drive a refresh of the snapshot (PRIMARY KEY/ROWID/COMPLEX). If PRIMARY KEY, then the snapshot uses primary keys to drive a fast refresh. If ROWID, then it uses RowIDs to drive a fast refresh. If COMPLEX, then fast refreshes are not allowed and the snapshot can only perform complete refreshes.
SNAPSHOT_ID	NUMBER(38)		Identifier for the snapshot used by the master for fast refresh
VERSION	VARCHAR2(17)		Version of snapshot
QUERY_TXT	LONG		Query defining the snapshot

DBA_REPCATLOG

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPCOLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPCOLUMN_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPCONFLICT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPDDL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPGENERATED

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPGROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPGROUPED_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPKEY_COLUMNS

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPOBJECT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPPARAMETER_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPPRIORITY

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPPRIORITY_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPPROP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPRESOLUTION

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPRESOLUTION_METHOD

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPRESOL_STATS_CONTROL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DBA_RGROUP

This view lists all refresh groups.

Column	Datatype	NULL	Description
REFGROUP	NUMBER		Internal identifier of refresh group
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N; if Y, then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER	NOT NULL	Identifier of job used to refresh the group automatically
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

DBA_ROLES

This view lists all roles that exist in the database.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Role name
PASSWORD_REQUIRED	VARCHAR2(8)		Indicates if the role requires a password to be enabled

DBA_ROLE_PRIVS

This view lists roles granted to users and roles.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)		Grantee name, user or role receiving the grant
GRANTED_ROLE	VARCHAR2(30)	NOT NULL	Granted role name
ADMIN_OPTION	VARCHAR2(3)		Whether the grant was with the ADMIN option: YES/NO
DEFAULT_ROLE	VARCHAR2(3)		Whether the role is designated as a DEFAULT ROLE for the user: YES/NO

DBA_ROLLBACK_SEGS

This view contains descriptions of rollback segments.

Column	Datatype	NULL	Description
SEGMENT_NAME	VARCHAR2(30)	NOT NULL	Name of the rollback segment
OWNER	VARCHAR2(6)		Owner of the rollback segment
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the rollback segment
SEGMENT_ID	NUMBER	NOT NULL	ID number of the rollback segment
FILE_ID	NUMBER	NOT NULL	ID number of the file containing the segment head
BLOCK_ID	NUMBER	NOT NULL	ID number of the block containing the segment header
INITIAL_EXTENT	NUMBER		Initial extent size in bytes
NEXT_EXTENT	NUMBER		Secondary extent size in bytes
MIN_EXTENTS	NUMBER	NOT NULL	Minimum number of extents
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extent
PCT_INCREASE	NUMBER	NOT NULL	Percent increase for extent size
STATUS	VARCHAR2(16)		Rollback segment status
INSTANCE_NUM	VARCHAR2(40)		Rollback segment owning parallel server instance number
RELATIVE_FNO	NUMBER	NOT NULL	Relative file number of the segment header

DBA_SEGMENTS

This view contains information about storage allocated for all database segments.

Column	Datatype	Description
OWNER	VARCHAR2(30)	Username of the segment owner
SEGMENT_NAME	VARCHAR2(81)	Name, if any, of the segment
PARTITION_NAME	VARCHAR2(30)	Object Partition Name (Set to NULL for non-partitioned objects).
SEGMENT_TYPE	VARCHAR2(17)	Type of segment: INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, or CACHE
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the segment
HEADER_FILE	NUMBER	ID of the file containing the segment header
HEADER_BLOCK	NUMBER	ID of the block containing the segment header
BYTES	NUMBER	Size in bytes, of the segment
BLOCKS	NUMBER	Size, in Oracle blocks, of the segment
EXTENTS	NUMBER	Number of extents allocated to the segment
INITIAL_EXTENT	NUMBER	Size in bytes of the initial extent of the segment
NEXT_EXTENT	NUMBER	Size in bytes of the next extent to be allocated to the segment
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	Percent by which to increase the size of the next extent to be allocated
FREELISTS	NUMBER	Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated to this segment
RELATIVE_FNO	NUMBER	Relative file number of the segment header
BUFFER_POOL	VARCHAR2(7)	Name of the default buffer pool for the appropriate object

DBA_SEQUENCES

This view contains descriptions of all sequences in the database.

Column	Datatype	NULL	Description
SEQUENCE_OWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the sequence
SEQUENCE_NAME	VARCHAR2(30)	NOT NULL	Sequence name
MIN_VALUE	NUMBER		Minimum value of the sequence
MAX_VALUE	NUMBER		Maximum value of the sequence
INCREMENT_BY	NUMBER	NOT NULL	Value by which sequence is incremented
CYCLE_FLAG	VARCHAR2(1)		Does sequence wrap around on reaching limit?
ORDER_FLAG	VARCHAR2(1)		Are sequence numbers generated in order?
CACHE_SIZE	NUMBER	NOT NULL	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	NOT NULL	Last sequence number written to disk

DBA_SNAPSHOT_LOGS

This view lists all snapshot logs in the database.

Column	Datatype	NULL	Description
LOG_OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot log
MASTER	VARCHAR2(30)	NOT NULL	Name of the master table of which the log logs changes
LOG_TABLE	VARCHAR2(30)	NOT NULL	Log table; holds timestamps and changes made to the master table
LOG_TRIGGER	VARCHAR2(30)		Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserts rows into the log
FILTER_COLUMNS	VARCHAR2(3)		If set to YES, the snapshot log records filter column information
ROWIDS	VARCHAR2(3)		If set to YES, the snapshot log records ROWID information
PRIMARY_KEY	VARCHAR2(3)		If set to YES, the snapshot log records primary key information
CURRENT_SNAPSHOTS	DATE		One date per snapshot; the date the snapshot of the master last refreshed
SNAPSHOT_ID	NUMBER(38)		Unique identifier of the snapshot

DBA_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot view
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table
LAST_REFRESH	DATE		The last refresh

DBA_SNAPSHOTS

This view lists all snapshots in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	The view used by users and applications for viewing the snapshot
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table the snapshot is stored in.
MASTER_VIEW	VARCHAR2(30)		View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8 and is set to NULL.
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table of which this snapshot is a copy
MASTER_LINK	VARCHAR2(128)		Database link name to the master site
CAN_USE_LOG	VARCHAR2(3)		If NO, this snapshot is complex and will never use a log
UPDATABLE	VARCHAR2(3)		If NO, the snapshot is read only
LAST_REFRESH	DATE		SYSDATE from the master site at the time of the last refresh
ERROR	NUMBER		The number of failed automatic refreshes since last successful refresh
TYPE	VARCHAR2(8)		The type of refresh (complete, fast, force) for all automatic refreshes
NEXT	VARCHAR2(200)		The date function used to compute next refresh dates
START_WITH	DATE		The date expression for the first automatic refresh time.
REFRESH_GROUP	NUMBER		All snapshots in a given refresh group get refreshed in the same transaction
REFRESH_METHOD	VARCHAR2(11)		Values used to drive a fast refresh of the snapshot
UPDATE_TRIG	VARCHAR2(30)		Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was the name of the trigger that fills the UPDATE_LOG
UPDATE_LOG	VARCHAR2(30)		The table that logs changes made to an updatable snapshots
QUERY	LONG		The original query of which this snapshot is an instantiation
FR_OPERATIONS	VARCHAR2(10)		Status of generated fast refresh operations: (REGENERATE, VALID)
CR_OPERATIONS	VARCHAR2(10)		Status of generated complete refresh operations: (REGENERATE, VALID)
MASTER_ROLLBACK _SEG	VARCHAR2(30)		The rollback segment used at the master site

DBA_SOURCE

This view contains source of all stored objects in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of the object: PROCEDURE, FUNCTION, PACKAGE, TYPE, TYPE BODY, or PACKAGE BODY
LINE	NUMBER	NOT NULL	Line number of this line of source
TEXT	VARCHAR2(4000)		Source text

DBA_STMT_AUDIT_OPTS

This view contains information which describes current system auditing options across the system and by user.

Column	Datatype	NULL	Description
USER_NAME	VARCHAR2(30)		User name if by user auditing, else NULL for system-wide auditing
AUDIT_OPTION	VARCHAR2(40)	NOT NULL	Name of the system auditing option
SUCCESS	VARCHAR2(10)		Mode for WHENEVER SUCCESSFUL system auditing
FAILURE	VARCHAR2(10)		Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_SYNONYMS

This view lists all synonyms in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the synonym
SYNONYM_NAME	VARCHAR2(30)	NOT NULL	Name of the synonym
TABLE_OWNER	VARCHAR2(30)		Owner of the object referenced by the synonym
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object referenced by the synonym
DB_LINK	VARCHAR2(128)		Name of the database link referenced in a remote synonym

DBA_SYS_PRIVS

This view lists system privileges granted to users and roles.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Grantee name, user, or role receiving the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	System privilege
ADMIN_OPTION	VARCHAR2(3)		Grant was with the ADMIN option

DBA_TAB_COL_STATISTICS

This view contains column statistics and histogram information which is in the DBA_TAB_COLUMNS view. For more information, see "DBA_TAB_COLUMNS" on page 2-89.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed

DBA_TAB_COLUMNS

This view contains information which describes columns of all tables, views, and clusters. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table, view, or cluster
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table, view, or cluster name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
DATA_TYPE	VARCHAR2(30)		Datatype of the column
DATA_TYPE_MOD	VARCHAR2(3)		Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR2(30)		Owner of the datatype of the column
DATA_LENGTH	NUMBER	NOT NULL	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 right of decimal point in a number
NULLABLE	VARCHAR2(1)		Does column allow NULL values?
COLUMN_ID	NUMBER	NOT NULL	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER		Length of default value for the column
DATA_DEFAULT	LONG
NUM_DISTINCT	NUMBER		These columns remain for backward compatibility with Oracle7. This information is now in the {TAB\|PART}_COL_STATISTICS views.
LOW_VALUE	RAW(32)
HIGH_VALUE	RAW(32)
DENSITY	NUMBER
NUM_NULLS	NUMBER
NUM_BUCKETS	NUMBER
LAST_ANALYZED	DATE
SAMPLE_SIZE	SAMPLE_SIZE
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS, NCHAR_CS
CHAR_COL_DECL _LENGTH	NUMBER

DBA_TAB_COMMENTS

This view contains comments on all tables and views in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object.
COMMENTS	VARCHAR2(4000)		Comment on the object

DBA_TAB_HISTOGRAMS

This view lists histograms on columns of all tables.

Column	Datatype	Description
ENDPOINT_VALUE	VARCHAR2(30)	Owner of Table
TABLE_NAME	VARCHAR2(30)	Table name
COLUMN_NAME	VARCHAR2(30)	Column name or attribute of the object type column
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

DBA_TAB_PARTITIONS

This view describes, for each table partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.

Column	Datatype	NULL	Description
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the table
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
NUM_ROWS	NUMBER		Number of rows in the partition
BLOCKS	NUMBER		Number of used blocks in the partition
EMPTY_BLOCKS	NUMBER		Number of empty (never used) blocks in the partition
AVG_SPACE	NUMBER		Average available free space in the partition
CHAIN_CNT	NUMBER		Number of chained rows in the partition
AVG_ROW_LEN	NUMBER		Average row length, including row overhead
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)	NOT NULL	The buffer pool for the partition

DBA_TAB_PRIVS

This view lists all grants on objects in the database.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	User to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Table Privilege
GRANTABLE	VARCHAR2(3)		Privilege is grantable

DBA_TABLES

This view contains descriptions of all relational tables in the database. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)		Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)		Name of the index organized table, if any, to which the overflow entry belongs
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		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
LOGGING	VARCHAR2(3)		Whether logging is enabled (YES or NO)
BACKED_UP	VARCHAR2(1)		Has table been backed up since last modification?
NUM_ROWS	NUMBER		Number of rows returned by the ANALYZE command
BLOCKS	NUMBER		The number of used data blocks in the table
EMPTY_BLOCKS	NUMBER		The number of empty (never used) data blocks in the table
AVG_SPACE	NUMBER		The average available free space in the table
CHAIN_CNT	NUMBER		The number of chained rows in the table
AVG_ROW_LEN	NUMBER		The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER		The number of blocks on the freelist
DEGREE	VARCHAR2(10)		Number of query servers used for a full-table scan
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this table
LAST_ANALYZED	DATE		Date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)		Indicates whether this table is partitioned. Set to YES if it is partitioned
IOT_TYPE	VARCHAR2(12)		If this is an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW. If this is not an index organized table, then IOT_TYPE is NULL
TABLE_TYPE_OWNER	VARCHAR2(0)		Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(0)		Type of the table if the table is a typed table
PACKED	VARCHAR2(0)		If the table is a typed table, does it store objects in packed format?
TEMPORARY	VARCHAR2(1)		Whether the table is temporary (Y or N)
NESTED	VARCHAR2(3)		Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

DBA_TABLESPACES

This view contains descriptions of all tablespaces.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
INITIAL_EXTENT	NUMBER		Default initial extent size
NEXT_EXTENT	NUMBER		Default incremental extent size
MIN_EXTENTS	NUMBER	NOT NULL	Default minimum number of extents
MAX_EXTENTS	NUMBER	NOT NULL	Default maximum number of extents
PCT_INCREASE	NUMBER	NOT NULL	Default percent increase for extent size
MIN_EXTLEN	NUMBER		Minimum extent size for the tablespace
STATUS	VARCHAR2(9)		Tablespace status: ONLINE, OFFLINE, or READ ONLY
CONTENTS	VARCHAR2(9)		Tablespace contents: "PERMANENT", or "TEMPORARY"
LOGGING	VARCHAR2(9)		Default logging attribute

DBA_TRIGGERS

This view lists all triggers in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the trigger
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TRIGGER_TYPE	VARCHAR2(16)		When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT
TRIGGERING_EVENT	VARCHAR2(26)		Statement that will fire the trigger: INSERT, UPDATE, and/or DELETE
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table with which this trigger is associated
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
REFERENCING _NAMES	VARCHAR2(87)		Names used for referencing OLD and NEW values within the trigger
WHEN_CLAUSE	VARCHAR2(4000)		WHEN clause must evaluate to true in order for triggering body to execute
STATUS	VARCHAR2(8)		If DISABLED, then trigger will not fire
DESCRIPTION	VARCHAR2(4000)		Trigger description, useful for re-creating trigger creation statement
TRIGGER_BODY	LONG		Action taken by this trigger when it fires

DBA_TRIGGER_COLS

This view lists column usage in all triggers.

Column	Datatype	NULL	Description
TRIGGER_OWNER	VARCHAR2(30)	NOT NULL	Owner of the trigger
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table on which the trigger is defined
COLUMN_NAME	VARCHAR2(4000)		Name of the column used in trigger definition
COLUMN_LIST	VARCHAR2(3)		Is column specified in UPDATE OF clause?
COLUMN_USAGE	VARCHAR2(17)		Usage of column within trigger body

DBA_TS_QUOTAS

This view lists tablespace quotas for all users.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
USERNAME	VARCHAR2(30)	NOT NULL	User with resource rights on the tablespace
BYTES	NUMBER		Number of bytes charged to the user
MAX_BYTES	NUMBER		User's quota in bytes, or -1 if no limit.
BLOCKS	NUMBER	NOT NULL	Number of Oracle blocks charged to the user
MAX_BLOCKS	NUMBER		User's quota in Oracle blocks, or -1 if no limit.

DBA_TYPE_ATTRS

This view displays the attributes of types in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
ATTR_NAME	VARCHAR2(30)	NOT NULL	Name of the attribute
ATTR_TYPE_MOD	VARCHAR2(7)		Type modifier of the attribute
ATTR_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the attribute
ATTR_TYPE_NAME	VARCHAR2(30)		Name of the type of the attribute
LENGTH	NUMBER		Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE	NUMBER		Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

DBA_TYPE_METHODS

This view is a description of methods of all types in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as the ID number
METHOD_TYPE	VARCHAR2(6)		Type of the method
PARAMETERS	NUMBER	NOT NULL	Number of parameters to the method
RESULTS	NUMBER	NOT NULL	Number of results returned by the method

DBA_TYPES

This view displays all abstract datatypes in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
TYPE_OID	RAW(16)	NOT NULL	Object identifier (OID) of the type
TYPECODE	VARCHAR2(30)		Typecode of the type
ATTRIBUTES	NUMBER		Number of attributes in the type
METHODS	NUMBER		Number of methods in the type
PREDEFINED	VARCHAR2(3)		Indicates whether the type is a predefined type
INCOMPLETE	VARCHAR2(3)		Indicates whether the type is an incomplete type

DBA_UPDATABLE_COLUMNS

This view contains a description of columns that are updatable by the database administrator in a join view. See Oracle8 Concepts for information on updatable join views.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
UPDATABLE	VARCHAR2(3)		Indicates whether the column is updatable
INSERTABLE	VARCHAR2(3)		Indicates whether the column is insertable
DELETABLE	VARCHAR2(3)		Indicates whether the column is deletable

DBA_USERS

This view lists information about all users of the database.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)	NOT NULL	Name of the user
USER_ID	NUMBER	NOT NULL	ID number of the user
PASSWORD	VARCHAR2(30)		Encrypted password
DEFAULT_TABLESPACE	VARCHAR2(30)	NOT NULL	Default tablespace for data
TEMPORARY _TABLESPACE	VARCHAR2(30)	NOT NULL	Default tablespace for temporary table
CREATED	DATE	NOT NULL	User creation date
PROFILE	VARCHAR2(30)	NOT NULL	User resource profile name
ACCOUNT_STATUS	VARCHAR2(30)	NOT NULL	Indicates if the account is locked, expired, or unlocked
LOCK_DATE	DATE		Date the account was locked if account status was locked
EXPIRY_DATE	DATE		Date of expiration of the account
EXTERNAL_NAME	VARCHAR2(4000)		User external name

DBA_VIEWS

This view contains the text of all views in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the view
VIEW_NAME	VARCHAR2(30)	NOT NULL	Name of the view
TEXT_LENGTH	NUMBER		Length of the view text
TEXT	LONG		View text
TYPE_TEXT_LENGTH	NUMBER		Length of the type clause of the typed view
TYPE_TEXT	VARCHAR2(4000)		Type clause of the typed view
OID_TEXT_LENGTH	NUMBER		Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR2(4000)		WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR2(30)		Type of the view if the view is a typed view

DBMS_ALERT_INFO

This view lists registered alerts.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the alert
SID	VARCHAR2(30)	NOT NULL	Session ID of a session waiting for this alert
CHANGED	VARCHAR2(1)		Boolean flag to indicate that an alert has been signaled. Y: Alert signaled N: No alert.
MESSAGE	VARCHAR2(1800)		Optional message passed by signaler

DBMS_LOCK_ALLOCATED

This view lists user-allocated locks.

Column	Datatype	NULL	Description
NAME	VARCHAR2(128)	NOT NULL	Name of the lock
LOCKID	NUMBER(38)		Lock identifier number
EXPIRATION	DATE		Planned lock expiration date (updates whenever the allocation procedure is run)

DEFCALL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFCALLDEST

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFDEFAULTDEST

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFERRCOUNT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFERROR

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFLOB

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFPROPAGATOR

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFSCHEDULE

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFTRAN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEFTRANDEST

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

DEPTREE

This view, created by UTLDTREE.SQL, contains information on the object dependency tree. For user SYS, this view displays shared cursors (and only shared cursors) that depend on the object. For all other users, it displays objects other than shared cursors. Other users can access SYS.DEPTREE for information on shared cursors.

Column	Datatype	Description
NESTED_LEVEL	NUMBER	Nesting level in the dependency tree
TYPE	VARCHAR2(15)	Object type
OWNER	VARCHAR2(30)	Object owner
NAME	VARCHAR2(1002)	Object name
SEQ#	NUMBER	Sequence number in the dependency tree. Used for ordering queries. (See also: "IDEPTREE" on page 2-110.)

DICT

This is a synonym for DICTIONARY. For more information, see "DICTIONARY" on page 2-101.

DICTIONARY

This view contains descriptions of data dictionary tables and views.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)		Name of the object
COMMENTS	VARCHAR2(4000)		Text comment on the object

DICT_COLUMNS

This view contains descriptions of columns in data dictionary tables and views.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(30)	Name of the object that contains the column
COLUMN_NAME	VARCHAR2(30)	Name of the column
COMMENTS	VARCHAR2(4000)	Text comment on the column

ERROR_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68 and "USER_OBJECT_SIZE" on page 2-146.

EXCEPTIONS

This view contains information on violations of integrity constraints. This view is created by the UTLEXCPT.SQL script.

Column	Datatype	Description
ROW_ID	ROWID	Row that caused the violation
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
CONSTRAINT	VARCHAR2(30)	Integrity constraint that was violated

FILE_LOCK

This is a Parallel Server view. This view displays the mapping of PCM locks to datafiles as specified in initialization parameter GC_FILES_TO_LOCKS. For more information on this parameter, see "GC_FILES_TO_LOCK" on page 1-44.

Column	Datatype	NULL	Description
FILE_ID	NUMBER	NOT NULL	Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES)
FILE_NAME	VARCHAR2(513)		The datafile name
TS_NAME	VARCHAR2(30)	NOT NULL	The tablespace name for the datafile
START_LK	NUMBER		The first lock corresponding to the datafile
NLOCKS	NUMBER		The number of PCM locks allocated to the datafile
BLOCKING	NUMBER		The number of blocks protected by a PCM lock on the datafile

For more information on this view, see Oracle8 Parallel Server Concepts and Administration.

FILE_PING

This is a Parallel Server view. This view displays the number of blocks pinged per datafile. You can use this information to determine access usage of existing datafiles for better settings of GC_FILES_TO_LOCKS. For more information on this parameter, see "GC_FILES_TO_LOCK" on page 1-44.

For more information, see Oracle8 Parallel Server Concepts and Administration.

Column	Datatype	NULL	Description
FILE_ID	NUMBER	NOT NULL	Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES)
FILE_NAME	NUMBER		The file name
TS_NAME	VARCHAR2(30)	NOT NULL	Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES)
FREQUENCY	NUMBER		The ping count.
X_2_NULL	NUMBER		Number of lock conversions from Exclusive-to-NULL for all blocks in the file
X_2_NULL_FORCED_WRITE	NUMBER		Number of forced writes that occur for blocks of the specified file due to Exclusive-to-NULL conversions
X_2_NULL_FORCED_STALE	NUMBER		Number of times a block in the file was made STALE due to Exclusive-to-NULL conversions
X_2_S	NUMBER		Number of lock conversions from Exclusive-to-Shared for all blocks in the file
X_2_S_FORCED_WRITE	NUMBER		Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Shared conversions
X_2_SSX	NUMBER		Number of lock conversions from Exclusive-to-Sub Shared Exclusive for all blocks in the file
X_2_SSX_FORCED_WRITE	NUMBER		Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Sub Shared Exclusive conversions
S_2_NULL	NUMBER		Number of lock conversions from Shared-to-NULL for all blocks in the file
S_2_NULL_FORCED_STALE	NUMBER		Number of times a block in the file was made STALE due to Shared-to-NULL conversions
SS_2_NULL	NUMBER		Number of lock conversions from Sub Shared-to-NULL for all blocks in the file
WRB	NUMBER		Number of times the instance received a write single buffer cross instance call for this file
WRB_FORCED_WRITE	NUMBER		Number of blocks written due to write single buffer cross instance calls for this file
RBR	NUMBER		Number of times the instance received a reuse block range cross instance call for this file
RBR_FORCED_WRITE	NUMBER		Number of blocks written due to resuse block range cross instance calls for this file
RBR_FORCED_STALE	NUMBER		Number of times a block in this file was made STALE due to resuse block range cross instance calls
CBR	NUMBER		Number of times the instance received a checkpoint block range cross instance call for this file
CBR_FORCED_WRITE	NUMBER		Number of blocks in this file which were written due to checkpoint cross range cross instance calls
NULL_2_X	NUMBER		Number of lock conversions from NULL-to-Exclusive for all blocks of the specified file
S_2_X	NUMBER		Number of lock conversions from Shared-to-Exclusive for all blocks of the specified file
SSX_2_X	NUMBER		Number of lock conversions from Sub Shared Exclusive-to-Exclusive for all blocks of the specified file
NULL_2_S	NUMBER		Number of lock conversions from NULL-to-Shared for all blocks of the specified file
NULL_2_SS	NUMBER		Number of lock conversions from NULL-to-Sub Shared for all blocks of the specified file

FILEXT$

This view is the equivalent of DBA_DATA_FILES. Oracle recommends you use DBA_DATA_FILES instead of FILEXT$. For more information, see "DBA_DATA_FILES" on page 2-55.

Column	Datatype	NULL	Description
FILE#	NUMBER	NOT NULL	Absolute file number
MAXEXTEND	NUMBER		Maximum file size
INC	NUMBER		Increment amount

GLOBAL_NAME

This view contains one row that displays the global name of the current database.

Column	Datatype	NULL	Description
GLOBAL_NAME	VARCHAR2(4000)		Global name of the database

HS_ALL_CAPS

This view contains information about all of the capabilities (that is, features) associated with non-Oracle (FDS) data stores.

Column	Datatype	Description
CAP_NUMBER	NUMBER	Capability number
CONTEXT	NUMBER	Context in which this capability is applicable
TRANSLATION	VARCHAR2(255)	Valid for functions; contains translation to FDS dialect
ADDITIONAL_INFO	NUMBER	Flag for internal use
FDS_CLASS_NAME	VARCHAR2(30)	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	Name of the FDS instance

HS_ALL_DD

This view contains data dictionary information about non-Oracle (FDS) data stores.

Column	Datatype	Description
DD_TABLE_NAME	VARCHAR2(30)	Data dictionary table name
TRANSLATION_TYPE	CHAR(1)	T = Translation, M = Mimic
TRANSLATION_TEXT	VARCHAR2(4000)	SQL statement containing the mapping
FDS_CLASS_NAME	VARCHAR2(30)	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	Name of the FDS instance
DD_TABLE_DESC	VARCHAR2(255)	Description of the ORACLE data dictionary table

HS_ALL_INITS

This view contains initialization parameter information about non-Oracle (FDS) data stores.

Column	Datatype	Description
INIT_VALUE_NAME	VARCHAR2(64)	Name of the initialization parameter
INIT_VALUE	VARCHAR2(255)	Value of the initialization parameter
INIT_VALUE_TYPE	VARCHAR2(1)	Environment variable (T or F). T= this is an environment variable, F= do not set as an environment variable
FDS_CLASS_NAME	VARCHAR2(30)	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	Name of the FDS instance

HS_BASE_CAPS

This view contains information about base capability (that is, base features) of the non-Oracle (FDS) data store.

Column	Datatype	NULL	Description
CAP_NUMBER	NUMBER	NOT NULL	Capability number
CAP_DESCRIPTION	VARCHAR2(255)		Description of the capability

HS_BASE_DD

This view displays information from the base data dictionary translation table.

Column	Datatype	NULL	Description
DD_TABLE_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
DD_TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the Oracle data dictionary table
DD_TABLE_DESC	VARCHAR2(255)		Description of the Oracle data dictionary table

HS_CLASS_CAPS

This view contains information about the class-specific (driver) capabilities belonging to the non-Oracle (FDS) data store.

Column	Datatype	NULL	Description
CAP_NUMBER	NUMBER	NOT NULL	Capability number
CAP_DESCRIPTION	VARCHAR2(255)		Capability description
CONTEXT	NUMBER		Flag indicating the context in which the capability is enabled
TRANSLATION	VARCHAR2(255)		Valid for functions; contains translation to FDS dialect
ADDITIONAL_INFO	NUMBER		Additional flags for internal use
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_CLASS_DD

This view displays information from the non-Oracle data store (FDS) class-specific data dictionary translations.

Column	Datatype	NULL	Description
DD_TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the Oracle data dictionary table
DD_TABLE_DESC	VARCHAR2(255)		Description of the Oracle data dictionary table
TRANSLATION_TYPE	CHAR(1)	NOT NULL	T = Translation, M = Mimic
TRANSLATION_TEXT	VARCHAR2(4000)		SQL statement containing the mapping
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
DD_TABLE_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_CLASS_INIT

This view displays information about the non-Oracle (FDS) class-specific initialization parameters.

Column	Datatype	NULL	Description
INIT_VALUE_NAME	VARCHAR2(64)	NOT NULL	Name of the initialization parameter
INIT_VALUE	VARCHAR2(255)	NOT NULL	Value of the initialization parameter
INIT_VALUE_TYPE	VARCHAR2(1)	NOT NULL	Environment variable (T or F). T= this is an environment variable, F= do not set as an environment variable
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
FDS_CLASS_INIT_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_EXTERNAL_OBJECT_PRIVILEGES

This view contains information about the privileges on objects that are granted to users.

Column	Datatype	NULL	Description
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of the object. Name is unique for each instance.
PRIVILEGE_NAME	VARCHAR2(30)	NOT NULL	Name of the privilege that was granted
GRANTEE	VARCHAR2(30)	NOT NULL	ID of the user that was granted the privilege
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance

HS_EXTERNAL_OBJECTS

This view contains information about all of the distributed external objects accessible from the Oracle Server.

Column	Datatype	NULL	Description
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance
OWNER	VARCHAR(30)	NOT NULL	Name of the user who created the object
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of the object. Name is unique for each instance.
OBJECT_TYPE	VARCHAR2(13)	NOT NULL	Type of object: FUNCTION, PROCEDURE, PACKAGE, or LIBRARY
OBJECT_TEXT	LONG	NOT NULL	SQL text used to create the object.

HS_EXTERNAL_USER_PRIVILEGES

This view contains information about all of the granted privileges that are not tied to any particular object.

Column	Datatype	NULL	Description
PRIVILEGE_NAME	VARCHAR2(30)	NOT NULL	Name of the privilege that was granted
GRANTEE	VARCHAR2(30)	NOT NULL	ID of the user that was granted the privilege
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS Class
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance

HS_FDS_CLASS

This view contains information about legal non-Oracle (FDS) classes.

Column	Datatype	NULL	Description
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS class (i.e ODBC, DB2)
FDS_CLASS _COMMENTS	VARCHAR2(255)		Text description of the non-Oracle class
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_FDS_INST

This view contains information about non-Oracle (FDS) instances.

Column	Datatype	NULL	Description
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance
FDS_INST_COMMENTS	VARCHAR2(255)		Text description of the non-Oracle instance
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS class
FDS_INST_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_INST_CAPS

This view contains information about instance-specific capabilities (that is, features).

Column	Datatype	NULL	Description
CAP_NUMBER	NUMBER	NOT NULL	Capability number
CAP_DESCRIPTION	VARCHAR2(255)		Capability description
CONTEXT	NUMBER		Context in which this capability is applicable
TRANSLATION	VARCHAR2(255)		Valid for functions; contains translation to FDS dialect
ADDITIONAL_INFO	NUMBER		Additional flags for internal use
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS class (i.e ODBC, DB2)
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_INST_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_INST_DD

This view displays information from the non-Oracle (FDS) instance-specific data dictionary translations.

Column	Datatype	NULL	Description
DD_TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the Oracle data dictionary table
DD_TABLE_DESC	VARCHAR2(255)		Description of the Oracle data dictionary table
TRANSLATION_TYPE	CHAR(1)	NOT NULL	T = Translation, M = Mimic
TRANSLATION_TEXT	VARCHAR2(4000)		SQL statement containing the mapping
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS class (that is, ODBC, DB2)
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance
DD_TABLE_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_INST_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

HS_INST_INIT

This view contains information about the non-Oracle (FDS) instance-specific initialization parameters.

Column	Datatype	NULL	Description
INIT_VALUE_NAME	VARCHAR2(64)	NOT NULL	Name of the initialization parameter
INIT_VALUE	VARCHAR2(255)	NOT NULL	Value of the initialization parameter
INIT_VALUE_TYPE	VARCHAR2(1)	NOT NULL	Environment variable (T or F). T= this is an environment variable, F= do not set as an environment variable
FDS_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS class (for example: ODBC, DB2)
FDS_INST_NAME	VARCHAR2(30)	NOT NULL	Name of the FDS instance
FDS_INST_INIT_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_CLASS_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)
FDS_INST_ID	NUMBER	NOT NULL	Sequence - a counter which is incremented for every row inserted (used internally)

IDEPTREE

This view, created by UTLDTREE.SQL, lists the indented dependency tree. It is a pre-sorted, pretty-print version of DEPTREE.

Column	Datatype	Description
NESTED_LEVEL	NUMBER	Nesting level in the dependency tree
TYPE	VARCHAR2(15)	Object type
OWNER	VARCHAR2(30)	Object owner
NAME	VARCHAR2(1002)	Object name

IND

This is a synonym for USER_INDEXES. For more information, see "USER_ INDEXES" on page 2-137.

INDEX_HISTOGRAM

This view contains information from the ANALYZE INDEX ... VALIDATE STRUCTURE command.

Column	Datatype	NULL	Description
REPEAT_COUNT	NUMBER		Number of times that one or more index keys is repeated in the table
KEYS_WITH_REPEAT _COUNT	NUMBER		Number of index keys that are repeated that many times

INDEX_STATS

This view stores information from the last ANALYZE INDEX ... VALIDATE STRUCTURE command.

Column	Datatype	NULL	Description
HEIGHT	NUMBER		Height of the B-Tree
BLOCKS	NUMBER	NOT NULL	Blocks allocated to the segment
NAME	VARCHAR2(30)	NOT NULL	Name of the index
PARTITION_NAME	VARCHAR2(30)		Name of the partition of the index which was analyzed. If the index is not partitioned, a NULL is returned
LF_ROWS	NUMBER		Number of leaf rows (values in the index)
LF_BLKS	NUMBER		Number of leaf blocks in the B-Tree
LF_ROWS_LEN	NUMBER		Sum of the lengths of all the leaf rows
LF_BLK_LEN	NUMBER		Usable space in a leaf block
BR_ROWS	NUMBER		Number of branch rows in the B-Tree
BR_BLKS	NUMBER		Number of branch blocks in the B-Tree
BR_ROWS_LEN	NUMBER		Sum of the lengths of all the branch blocks in the B-Tree
BR_BLK_LEN	NUMBER		Usable space in a branch block
DEL_LF_ROWS	NUMBER		Number of deleted leaf rows in the index
DEL_LF_ROWS_LEN	NUMBER		Total length of all deleted rows in the index
DISTINCT_KEYS	NUMBER		Number of distinct keys in the index (may include rows that have been deleted)
MOST_REPEATED_KEY	NUMBER		How many times the most repeated key is repeated (may include rows that have been deleted)
BTREE_SPACE	NUMBER		Total space currently allocated in the B-Tree
USED_SPACE	NUMBER		Total space that is currently being used in the B-Tree
PCT_USED	NUMBER		Percent of space allocated in the B-Tree that is being used
ROWS_PER_KEY	NUMBER		Average number of rows per distinct key (this figure is calculated without consideration of deleted rows)
BLKS_GETS_PER _ACCESS	NUMBER		Expected number of consistent mode block reads per row, assuming that a randomly chosen row is accessed using the index. Used to calculate the number of consistent reads that will occur during an index scan.

LOADER_CONSTRAINT_INFO

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

LOADER_FILE_TS

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

LOADER_PART_INFO

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

LOADER_PARAM_INFO

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

LOADER_TAB_INFO

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

LOADER_TRIGGER_INFO

This is a SQL*LOADER view used for direct loads. For more information, see Oracle8 Utilities.

NLS_DATABASE_PARAMETERS

This view lists permanent NLS parameters of the database.

Column	Datatype	NULL	Description
PARAMETER	VARCHAR2(30)	NOT NULL	Parameter name
VALUE	VARCHAR2(30)		Parameter value

NLS_INSTANCE_PARAMETERS

This view lists NLS parameters of the instance.

Column	Datatype	NULL	Description
PARAMETER	VARCHAR2(30)		Parameter name
VALUE	VARCHAR2(30)		Parameter value

NLS_SESSION_PARAMETERS

This view lists NLS parameters of the user session.

Column	Datatype	NULL	Description
PARAMETER	VARCHAR2(30)		Parameter name
VALUE	VARCHAR2(30)		Parameter value

OBJ

This is a synonym for USER_OBJECTS. For more information, see "USER_OBJECTS" on page 2-145.

PARSED_PIECES

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68 and "USER_OBJECT_SIZE" on page 2-146.

PARSED_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68 and "USER_OBJECT_SIZE" on page 2-146.

PLAN_TABLE

This view is the default table for results of the EXPLAIN PLAN statement. It is created by UTLXPLAN.SQL, and it contains one row for each step in the execution plan.

Column	Datatype	Description
STATEMENT_ID	VARCHAR2(30)	Optional statement identifier specified in the EXPLAIN PLAN statement
TIMESTAMP	DATE	Date and time that the EXPLAIN PLAN statement was issued
REMARKS	VARCHAR2(80)	Place for comments that can be added to the steps of the execution plan
OPERATION	VARCHAR2(30)	Name of the operation performed at this step
OPTIONS	VARCHAR2(30)	Options used for the operation performed at this step
OBJECT_NODE	VARCHAR2(128)	Name of the database link used to reference the object
OBJECT_OWNER	VARCHAR2(30)	Owner of the object
OBJECT_NAME	VARCHAR2(30)	Name of the object
OBJECT_INSTANCE	NUMBER(38)	Numbered position of the object name in the original SQL statement
OBJECT_TYPE	VARCHAR2(30)	Descriptive modifier that further describes the type of object
OPTIMIZER	VARCHAR2(255)	The current mode of the optimizer
SEARCH_COLUMNS	NUMBER	Not currently used
ID	NUMBER(38)	Identification number for this step in the execution plan
PARENT_ID	NUMBER(38)	ID of the next step that operates on the results of this step
POSITION	NUMBER(38)	Order of processing for steps with the same parent ID. For cost-based optimization, the value in the first row of the plan is the statement's execution cost. For rule-based optimization, the value is null in the first row.
COST	NUMBER(38)	The cost of the current operation estimated by the cost-based optimizer (CBO)
CARDINALITY	NUMBER(38)	The number of rows returned by the current operation (estimated by the CBO)
BYTES	NUMBER(38)	The number of bytes returned by the current operation
OTHER_TAG	VARCHAR2(255)	OTHER_TAG, describes the function of the SQL text in the OTHER column. Values for OTHER_TAG are: SERIAL - the SQL is the text of a locally-executed, serial query plan. Currently, SQL is not loaded in OTHER for this case. SERIAL_FROM_REMOTE - the SQL text shown in the OTHER column will be executed at a remote site. PARALLEL_COMBINED_WITH_PARENT - the parent of this operation is a DFO that performs both operations in the parallel execution plan. PARALLEL_COMBINED_WITH_CHILD - the child of this operation is a DFO that performs both operations in the parallel execution plan. PARALLEL_TO_SERIAL - the SQL text shown in the OTHER column is the top-level of the parallel plan. PARALLEL_TO_PARALLEL - the SQL text shown in the OTHER column is executed and output in parallel. PARALLEL_FROM_SERIAL - this operation consumes data from a serial operation and outputs it in parallel.
PARTITION_START	VARCHAR2(255)	The start partition of a range of accessed partitions
PARTITION_STOP	VARCHAR2(255)	The stop partition of a range of accessed partitions
PARTITION_ID	NUMBER(38)	The step that has computed the pair of values of the PARTITION_START and PARTITION_STOP columns
OTHER	LONG	Holds SQL text for remote cursors and parallel query slaves

PRODUCT_COMPONENT_VERSION

This view contains version and status information for component products.

Column	Datatype	Description
PRODUCT	VARCHAR2(64)	Product name
VERSION	VARCHAR2(64)	Version number
STATUS	VARCHAR2(64)	Status of release

PSTUBTBL

This table contains information on stubs generated by the PSTUB utility so that an Oracle Forms 3.0 client can call stored procedures in an Oracle database.

Note: The contents of this table are intended only for use by the PSTUB utility.

Column	Datatype	Description
USERNAME	VARCHAR2(30)	Schema part of the identifier of a stored procedure
DBNAME	VARCHAR2(128)	Database link part of the identifier of a stored procedure
LUN	VARCHAR2(30)	Library unit name part of the identifier of a stored procedure
LUTYPE	VARCHAR2(3)	Type of the stored procedure
LINENO	NUMBER	Line number of the stub
LINE	VARCHAR2(1800)	Text of the stub

PUBLICSYN

This view contains information on public synonyms.

Column	Datatype	Description
SNAME	VARCHAR2(30)	Name of the synonym
CREATOR	VARCHAR2(30)	Owner of the synonym
TNAME	VARCHAR2(30)	Table of which this is a synonym
DATABASE	VARCHAR2(128)	Database in which the table resides
TABTYPE	VARCHAR2(9)	Type of table

PUBLIC_DEPENDENCY

This view lists dependencies to and from objects, by object number.

Column	Datatype	NULL	Description
OBJECT_ID	NUMBER	NOT NULL	Object number
REFERENCED_OBJECT_ID	NUMBER	NOT NULL	Referenced object (the parent object)

RESOURCE_COST

This view lists the cost for each resource.

Column	Datatype	NULL	Description
RESOURCE_NAME	VARCHAR2(32)	NOT NULL	Name of the resource
UNIT_COST	NUMBER	NOT NULL	Cost of the resource

RESOURCE_MAP

This view contains descriptions for resources. It maps the resource name to the resource number.

Column	Datatype	NULL	Description
RESOURCE#	NUMBER	NOT NULL	Numeric resource code
TYPE#	NUMBER	NOT NULL	Name of type
NAME	VARCHAR2(32)	NOT NULL	Name of resource

ROLE_ROLE_PRIVS

This view contains information about roles granted to other roles. (Information is only provided about roles to which the user has access.)

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role
GRANTED_ROLE	VARCHAR2(30)	NOT NULL	Role that was granted
ADMIN_OPTION	VARCHAR2(3)		Signifies that the role was granted with ADMIN option

ROLE_SYS_PRIVS

This view contains information about system privileges granted to roles. Information is provided only about roles to which the user has access.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role
PRIVILEGE	VARCHAR2(40)	NOT NULL	System privilege granted to the role
ADMIN_OPTION	VARCHAR2(3)		Signifies the grant was with the ADMIN option

ROLE_TAB_PRIVS

This view contains information about table privileges granted to roles. Information is provided only about roles to which the user has access.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)		Name of the column, if applicable
PRIVILEGE	VARCHAR2(40)	NOT NULL	Object privilege granted to the role
GRANTABLE	VARCHAR2(3)		YES if the role was granted with ADMIN OPTION; otherwise NO

SEQ

This is a synonym for USER_SEQUENCES. For more information see "USER_SEQUENCES" on page 2-157.

SESSION_PRIVS

This view lists the privileges that are currently available to the user.

Column	Datatype	NULL	Description
PRIVILEGE	VARCHAR2(40)	NOT NULL	Name of the privilege

SESSION_ROLES

This view lists the roles that are currently enabled to the user.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role

SOURCE_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68, and "USER_OBJECT_SIZE" on page 2-146.

STMT_AUDIT_OPTION_MAP

This view contains information about auditing option type codes.

Column	Datatype	NULL	Description
OPTION#	NUMBER	NOT NULL	Numeric auditing option type code
NAME	VARCHAR2(40)	NOT NULL	Name of the auditing option

SYN

This is a synonym for USER_SYNONYMS. For more information, see "USER_SYNONYMS" on page 2-159.

SYNONYMS

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

SYSCATALOG

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

SYSFILES

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

SYSSEGOBJ

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

SYSTEM_PRIVILEGE_MAP

This view contains information about system privilege codes.

Column	Datatype	NULL	Description
PRIVILEGE	NUMBER	NOT NULL	Numeric privilege type code
NAME	VARCHAR2(40)	NOT NULL	Name of the type of privilege

SYS_OBJECTS

This view maps object IDs to object types and segment data block addresses.

Column	Datatype	Description
OBJECT_TYPE	VARCHAR2(15)	Type of the object
OBJECT_TYPE_ID	NUMBER	Type ID of the object
SEGMENT_TYPE_ID	NUMBER	Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE
OBJECT_ID	NUMBER	Object identifier
HEADER_FILE	NUMBER	ID of the file containing the segment header
HEADER_BLOCK	NUMBER	ID of the block containing the segment header
TS_NUMBER	NUMBER	The tablespace number

TAB

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

TABLE_PRIVILEGES

This view contains information on grants on objects for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee. This view is included for compatibility with Oracle version 6. Use of this view is not recommended.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access is granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
SELECT_PRIV	VARCHAR2(1)		Permission to select from the object
INSERT_PRIV	VARCHAR2(1)		Permission to insert into the object
DELETE_PRIV	VARCHAR2(1)		Permission to delete from the object
UPDATE_PRIV	VARCHAR2(1)		Permission to update the object
REFERENCES_PRIV	VARCHAR2(1)		Permission to reference the object
ALTER_PRIV	VARCHAR2(1)		Permission to alter the object
INDEX_PRIV	VARCHAR2(1)		Permission to create or drop an index on the object
CREATED	VARCHAR2(0)		Timestamp for the grant

TABLE_PRIVILEGE_MAP

This view contains information about access privilege codes.

Column	Datatype	NULL	Description
PRIVILEGE	NUMBER	NOT NULL	Numeric privilege (auditing option) type code
NAME	VARCHAR2(40)	NOT NULL	Name of the type of privilege (auditing option)

TABS

This is a synonym for USER_TABLES. For more information, see "USER_TABLES" on page 2-164.

TABQUOTAS

This view is included for compatibility with Oracle version 5. Use of this view is not recommended.

TRUSTED_SERVERS

This view displays whether a server is trusted or untrusted.

Column	Datatype	NULL	Description
TRUST	VARCHAR2(9)		Trustedness of the server listed. Values can be TRUSTED or UNTRUSTED Servers which are not listed in the NAME column have opposite trustedness. See the examples below.
NAME	VARCHAR2(128)		Server name. Can be a specific server name or "ALL" for all servers.

For example:

If all servers are trusted, then TRUSTED_SERVERS returns:

TRUST        NAME 
-------      ------
Trusted      ALL

If none of the servers are trusted, then TRUSTED_SERVERS returns:

TRUST        NAME 
-------      ------
Untrusted      ALL

If all servers are trusted, except DB1, then TRUSTED_SERVERS returns:

TRUST        NAME 
-------      ------
Untrusted     DB1

If all servers are untrusted, except DB1, then TRUSTED_SERVERS returns:

TRUST        NAME 
-------      ------
Trusted      DB1

For more information on this view see Oracle8 Distributed Database Systems.

TS_PITR_CHECK

This view, created by CATPITR.SQL provides information on any dependencies or restrictions which might prevent tablespace point-in-time recovery from proceeding. This view applies only to the tablespace point-in-time recovery feature. For more information, see Oracle8 Backup and Recovery Guide.

Column	Datatype	NULL	Description
OBJ1_OWNER	VARCHAR2(30)	NOT NULL	The owner of the object preventing tablespace point-in-time recovery. See the REASON column for details.
OBJ1_NAME	VARCHAR2(30)	NOT NULL	The name of the object preventing tablespace point-in-time recovery
OBJ1_TYPE	VARCHAR2(15)		The object type for the object preventing tablespace point-in-time recovery
OBJ1_SUBNAME	VARCHAR2(30)		Subordinate to OBJ1_NAME
TS1_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the object preventing tablespace point-in-time recovery
OBJ2_NAME	VARCHAR2(30)		The name of a second object which may be preventing tablespace point-in-time recovery. If NULL, object 1 is the only object preventing recovery
OBJ2_TYPE	VARCHAR2(15)		The object type for the second object (will be NULL if OBJ2_NAME is NULL)
OBJ2_OWNER	VARCHAR2(30)		The owner of the second object (will be NULL if OBJ2_NAME is NULL)
OBJ2_SUBNAME	VARCHAR2(30)		Subordinate to OBJ2_NAME
TS2_NAME	VARCHAR2(30)		Name of the tablespace containing second object which may be preventing tablespace point-in-time recovery (-1 indicates not applicable)
CONSTRAINT_NAME	VARCHAR2(30)		Name of the constraint
REASON	VARCHAR2(78)		Reason why tablespace point-in-time recovery cannot proceed

TS_PITR_OBJECTS_TO_BE_DROPPED

This view lists all objects lost as a result of performing tablespace point-in-time recovery. This view applies only to the tablespace point-in-time recovery feature.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	The owner of the object
NAME	VARCHAR2(30)	NOT NULL	The name of the object that will be lost as a result of undergoing tablespace point-in-time recovery
CREATION_TIME	DATE	NOT NULL	Creation timestamp of the object
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the object

USER_ALL_TABLES

This table contains descriptions of the tables (object tables and relational tables) available to the user.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
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	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last modification?
NUM_ROWS	NUMBER	The number of rows in the table
BLOCKS	NUMBER	The number of used blocks in the table
EMPTY_BLOCKS	NUMBER	The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	The average available free space in the table
CHAIN_CNT	NUMBER	The number of chained rows in the table
AVG_ROW_LEN	NUMBER	The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	The sample size used in analyzing this table
LAST_ANALYZED	DATE	The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)	If index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	Type of the table if the table is a typed table
PACKED	VARCHAR2(1)	If the table is a typed table, does it store objects in packed format?
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)	Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)	The default buffer pool to be used for table blocks

USER_ARGUMENTS

This view lists the arguments in the object which are accessible to the user.

Column	Datatype	NULL	Description
OBJECT_NAME	VARCHAR2(30)		Procedure or function name
PACKAGE_NAME	VARCHAR2(30)		Package name
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
OVERLOAD	VARCHAR2(40)		Overload unique identifier
ARGUMENT_NAME	VARCHAR2(30)		Argument name
POSITION	NUMBER	NOT NULL	Position in argument list, or null for function return value
SEQUENCE	NUMBER	NOT NULL	Argument sequence, including all nesting levels
DATA_LEVEL	NUMBER	NOT NULL	Nesting depth of argument for composite types
DATA_TYPE	VARCHAR2(14)		Datatype of the argument
DEFAULT_VALUE	LONG		Default value for the argument
DEFAULT_LENGTH	NUMBER		Length of default value for the argument
IN_OUT	VARCHAR2(9)		Argument direction (IN, OUT, or IN/OUT)
DATA_LENGTH	NUMBER		Length of the column in bytes
DATA_PRECISION	NUMBER		Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER		Digits to right of decimal point in a number
RADIX	NUMBER		Argument radix for a number
CHARACTER_SET _NAME	VARCHAR2(44)		Character set name for the argument
TYPE_OWNER	VARCHAR2(30)		Owner name of the type
TYPE_NAME	VARCHAR2(30)		Name
TYPE_SUBNAME	VARCHAR2(30)		This is valid only in case of package local types; in such cases, the package name is the name and the type name is the subname
TYPE_LINK	VARCHAR2(128)		Database link valid only in case of package local types, in case the package is remote

USER_AUDIT_OBJECT

This view, created by CATAUDIT.SQL, lists audit trail records for statements concerning objects.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system login username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier for the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of the object affected by the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER	VARCHAR2(30)		Owner of the object named in the NEW_NAME column
NEW_NAME	VARCHAR2(128)		New name of an object renamed by a RENAME statement
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 11 characters, one for each action type, in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE; coded: for none, S for success, F for failure, and B for both)
COMMENT_TEXT	VARCHAR2(4000)		Text Comment on the audit trail entry (inserted by an application program)
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE	NUMBER	NOT NULL	Oracle message code generated by the action (zero if the action succeeded)
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
OBJECT_LABEL	MLSLABEL		Label associated with the object being audited. Applies to Trusted Oracle Server only.
SESSION_LABEL	MLSLABEL		Label associated with the user's session. Applies to Trusted Oracle Server only.

USER_AUDIT_SESSION

This view, created by CATAUDIT.SQL, lists all audit trail records concerning connections and disconnections for the user.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system log on user name of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier for the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in ACTION
LOGOFF_TIME	DATE		Timestamp for user log off
LOGOFF_LREAD	NUMBER		Logical reads for the session
LOGOFF_PREAD	NUMBER		Physical reads for the session
LOGOFF_LWRITE	NUMBER		Logical writes for the session
LOGOFF_DLOCK	VARCHAR2(40)		Deadlocks detected during the session
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
RETURNCODE	NUMBER	NOT NULL	Oracle message code generated by the action (zero if the action succeeded)
SESSION_LABEL	MLSLABEL		Label associated with the user's session. Applies to Trusted Oracle Server only.

USER_AUDIT_STATEMENT

This view, created by CATAUDIT.SQL, lists audit trail entries for the following statements issued by the user: GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system log on username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier for the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of the object affected by the action
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in ACTION
NEW_NAME	VARCHAR2(128)		New name of an object after a RENAME
OBJ_PRIVILEGE	VARCHAR2(16)		Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE	VARCHAR2(40)		System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION	VARCHAR2(1)		Signifies the role or system privilege was granted with ADMIN option
GRANTEE	VARCHAR2(30)		Username of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION	VARCHAR2(40)		Auditing option set with the AUDIT statement
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 11 characters, one for each action type, in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE; coded: for none, S for success, F for failure, and B for both)
COMMENT_TEXT	VARCHAR2(4000)		Text Comment on the audit trail entry (inserted by an application program)
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE	NUMBER	NOT NULL	Oracle message code generated by the action (zero if the action succeeded)
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
SESSION_LABEL	MLSLABEL		Label associated with the user's session. Applies to Trusted Oracle Server only.

USER_AUDIT_TRAIL

This view, created by CATAUDIT.SQL, lists audit trail entries relevant to the user.

Column	Datatype	NULL	Description
OS_USERNAME	VARCHAR2(255)		Operating system log on username of the user whose actions were audited
USERNAME	VARCHAR2(30)		Name (not ID number) of the user whose actions were audited
USERHOST	VARCHAR2(2000)		Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	VARCHAR2(2000)		Identifier for the user's terminal
TIMESTAMP	DATE	NOT NULL	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	VARCHAR2(30)		Creator of object affected by the action
OBJ_NAME	VARCHAR2(128)		Name of object affected by the action
ACTION	NUMBER	NOT NULL	Numeric type code corresponding to the action name
ACTION_NAME	VARCHAR2(27)		Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER	VARCHAR2(30)		Owner of the object named in the NEW_NAME column
NEW_NAME	VARCHAR2(128)		New name of an object renamed by a RENAME statement
OBJ_PRIVILEGE	VARCHAR2(16)		Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE	VARCHAR2(40)		System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION	VARCHAR2(1)		Signifies the role or system privilege was granted with ADMIN option
GRANTEE	VARCHAR2(30)		Username of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION	VARCHAR2(40)		Auditing option set with the AUDIT statement
SES_ACTIONS	VARCHAR2(19)		Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)
LOGOFF_TIME	DATE		Timestamp for user log off
LOGOFF_LREAD	NUMBER		Logical reads for the session
LOGOFF_PREAD	NUMBER		Physical reads for the session
LOGOFF_LWRITE	NUMBER		Logical writes for the session
LOGOFF_DLOCK	VARCHAR2(40)		Deadlocks detected during the session
COMMENT_TEXT	VARCHAR2(4000)		Text Comment on the audit trail entry, providing more information about the statement audited
SESSIONID	NUMBER	NOT NULL	Numeric ID for each Oracle session
ENTRYID	NUMBER	NOT NULL	Numeric ID for each audit trail entry in the session
STATEMENTID	NUMBER	NOT NULL	Numeric ID for each statement run (a statement can cause many actions)
RETURNCODE	NUMBER	NOT NULL	Oracle message code generated by the action (zero if the action succeeded)
PRIV_USED	VARCHAR2(40)		System privilege used to execute the action
OBJECT_LABEL	MLSLABEL		Label associated with the object being audited. Applies to Trusted Oracle Server only.
SESSION_LABEL	MLSLABEL		Label associated with the user's session. Applies to Trusted Oracle Server only.

USER_CATALOG

This view lists tables, views, synonyms, and sequences owned by the user.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object

USER_CLUSTERS

This view contains descriptions of user's own clusters.

Column	Datatype	NULL	Description
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
PCT_FREE	NUMBER		Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	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	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
AVG_BLOCKS_PER_KEY	NUMBER		Number of blocks in the table divided by number of hash keys
CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B-Tree index or hash
FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the cluster
INSTANCES	VARCHAR2(10)		The number of instances across which the cluster is to be scanned
CACHE	VARCHAR2(5)		Whether the cluster is to be cached in the buffer cache
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

USER_CLU_COLUMNS

This view contains a mapping of columns in user's tables to cluster columns.

Column	Datatype	NULL	Description
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Cluster name
CLU_COLUMN_NAME	VARCHAR2(30)	NOT NULL	Key column in the cluster
TABLE_NAME	VARCHAR2(30)	NOT NULL	Clustered table name
TAB_COLUMN_NAME	VARCHAR2(4000)		Key column or attribute of the object type column

USER_COL_COMMENTS

This view lists comments on columns of user's tables and views.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Object name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
COMMENTS	VARCHAR2(4000)		Comment on the column

USER_COL_PRIVS

This view lists grants on columns for which the user is the owner, grantor, or grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

USER_COL_PRIVS_MADE

This view lists all grants on columns of objects owned by the user.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

USER_COL_PRIVS_RECD

This view lists grants on columns for which the user is the grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

USER_COLL_TYPES

This new data dictionary view displays the user's named collection types.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
COLL_TYPE	VARCHAR2(30)	NOT NULL	Collection type
UPPER_BOUND	NUMBER		Maximum size of the VARYING ARRAY type
ELEM_TYPE_MOD	VARCHAR2(7)		Type modifier of the element
ELEM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the element
ELEM_TYPE_NAME	VARCHAR2(30)		Name of the type of the element
LENGTH	NUMBER		Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE	NUMBER		Scale of the NUMBER or DECIMAL element
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS, NCHAR_CS

USER_CONSTRAINTS

This view lists constraint definitions on user's tables.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
CONSTRAINT_TYPE	VARCHAR2(1)		Type of constraint definition: C (check constraint on a table) P (primary key) U (unique key) R (referential integrity) V (with check option on a view)
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
SEARCH_CONDITION	LONG		Text of search condition for table check
R_OWNER	VARCHAR2(30)		Owner of table used in referential constraint
R_CONSTRAINT_NAME	VARCHAR2(30)		Name of unique constraint definition for referenced table
DELETE_RULE	VARCHAR2(9)		The delete rule for a referential constraint: CASCADE, NO ACTION
STATUS	VARCHAR2(8)		Enforcement status of constraint: ENABLED or DISABLED
DEFERRABLE	VARCHAR2(14)		Indicates whether the constraint is deferrable
DEFERRED	VARCHAR2(9)		Indicates whether the constraint was initially deferred
GENERATED	VARCHAR2(14)		Indicates whether the name system is generated
LAST_CHANGE	VARCHAR2(3)		Indicates when the constraint was last enabled or disabled
VALIDATED	DATE		Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED

USER_CONS_COLUMNS

This view contains information about columns in constraint definitions owned by the user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
COLUMN_NAME	VARCHAR2(4000)		Name associated with column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER		Original position of column or attribute in definition

USER_DB_LINKS

This view contains information on database links owned by the user.

Column	Datatype	NULL	Description
DB_LINK	VARCHAR2(128)	NOT NULL	Name of the database link
USERNAME	VARCHAR2(30)		Name of user to log in as
PASSWORD	VARCHAR2(30)		Password for login
HOST	VARCHAR2(2000)		Net8 string for connect
CREATED	DATE	NOT NULL	Creation time of the database link

USER_DEPENDENCIES

This view lists dependencies to and from a user's objects.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY
REFERENCED_OWNER	VARCHAR2(64)		Owner of the parent object
REFERENCED_NAME	VARCHAR2(30)		Name of the parent object
REFERENCED_TYPE	VARCHAR2(12)		Type of the parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY
REFERENCED_LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
SCHEMAID	NUMBER		The schema ID
DEPENDENCY_TYPE	VARCHAR2(4)		Two values: REF when the dependency is a REF dependency; HARD otherwise

USER_ERRORS

This view lists current errors on all a user's stored objects.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY
SEQUENCE	NUMBER	NOT NULL	Sequence number, for ordering
LINE	NUMBER	NOT NULL	Line number at which this error occurs
POSITION	NUMBER	NOT NULL	Position in the line at which this error occurs
TEXT	VARCHAR2(4000)	NOT NULL	Text of the error

USER_EXTENTS

This view lists extents of the segments belonging to a user's objects.

Column	Datatype	NULL	Description
SEGMENT_NAME	VARCHAR2(81)		Name of the segment associated with the extent
SEGMENT_TYPE	VARCHAR2(17)		Type of the segment: INDEX PARTITION, TABLE PARTITION
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the extent
PARTITION_NAME	VARCHAR2(30)		Object Partition Name (Set to NULL for non-partitioned objects).
EXTENT_ID	NUMBER	NOT NULL	Extent number in the segment
BYTES	NUMBER		Size of the extent in bytes
BLOCKS	NUMBER	NOT NULL	Size of the extent in Oracle blocks

USER_FREE_SPACE

This view lists the free extents in tablespaces accessible to the user.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the extent
FILE_ID	NUMBER	NOT NULL	ID number of the file containing the extent
BLOCK_ID	NUMBER	NOT NULL	Starting block number of the extent
BYTES	NUMBER		Size of the extent in bytes
BLOCKS	NUMBER	NOT NULL	Size of the extent in Oracle blocks
RELATIVE_FNO	NUMBER	NOT NULL	Relative file number of the first extent block

USER_ INDEXES

This view contains descriptions of the user's own indexes. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.

Column	Datatype	NULL	Description
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the index
INDEX_TYPE	VARCHAR2(12)		Type of index
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the indexed object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the indexed object
TABLE_TYPE	VARCHAR2(11)		Type of the indexed object
UNIQUENESS	VARCHAR2(9)		Uniqueness status of the index: UNIQUE or NONUNIQUE
TABLESPACE_NAME	VARCHAR2(30)		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 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		Percentage increase in extent size
PCT_THRESHOLD	NUMBER		Threshold percentage of block space allowed per index entry
INCLUDE_COLUMN	NUMBER		User column-id for last column to be included in index organized table top index
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
PCT_FREE	NUMBER		Minimum percentage of free space in a block
LOGGING	VARCHAR2(3)		Logging attribute
BLEVEL	NUMBER		B-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index.
DISTINCT_KEYS	NUMBER		Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table USER_TABLES.NUM_ROWS.
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		Average number of leaf blocks in which each distinct value in the index appears. This statistic is rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.
AVG_DATA_BLOCKS _PER_KEY	NUMBER		Average number of data blocks in the table that are pointed to by a distinct value in the index. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed column(s). This statistic is rounded to the nearest integer.
CLUSTERING_FACTOR	NUMBER		This statistic represents the amount of order of the rows in the table based on the values of the index. If its value is near the number of blocks, then the table is well ordered. In such a case, the index entries in a single leaf block tend to point to rows in the same data blocks. If its value is near the number of rows, then the table is randomly ordered. In such a case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.
STATUS	VARCHAR2(8)		State of the index: DIRECT LOAD or VALID
NUM_ROWS	NUMBER		Number of rows in this index
SAMPLE_SIZE	NUMBER		Size of the sample used to analyze this index
LAST_ANALYZED	DATE		Timestamp for when this index was last analyzed
DEGREE	VARCHAR2(40)		Number of threads per instance for scanning the index. NULL if PARTITIONED=NO.
INSTANCES	VARCHAR2(40)		The number of instances across which the partitioned index is to be scanned
PARTITIONED	VARCHAR2(3)		Indicates whether this index is partitioned. Set to YES if it is partitioned
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
GENERATED	VARCHAR2(1)		Was the name of this index system generated?
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

USER_IND_COLUMNS

This view lists columns of the user's indexes or on user's tables.

Column	Datatype	NULL	Description
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table or cluster name
COLUMN_NAME	VARCHAR2(4000)		Column name or attribute of the object type column
COLUMN_POSITION	NUMBER	NOT NULL	Position of column or attribute within index
COLUMN_LENGTH	NUMBER	NOT NULL	Indexed length of the column or attribute

USER_IND_PARTITIONS

This view describes, for each index partition that the current user owns, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.

Column	Datatype	NULL	Description
INDEX_NAME	VARCHAR2(30)	NOT NULL	Index name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the index
STATUS	VARCHAR2(8)		Indicates whether index partition is usable or not
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of process freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
BLEVEL	NUMBER		B-Tree level
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index partition
DISTINCT_KEYS	NUMBER		Number of distinct keys in the index partition
AVG_LEAF_BLOCKS _PER_KEY	NUMBER		Average number of leaf blocks per key
AVG_DATA_BLOCKS _PER_KEY	NUMBER		Average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		Measurement of the amount of (dis)order of the table this index partition is for
NUM_ROWS	NUMBER		Number of rows in this index partition
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)		The buffer pool for the partition

USER_JOBS

This view lists all jobs owned by the user. For more information, see the Oracle8 Administrator's Guide.

Column	Datatype	NULL	Description
JOB	NUMBER	NOT NULL	Identifier of job. Neither import/export nor repeated executions change it.
LOG_USER	VARCHAR2(30)	NOT NULL	USER who was logged in when the job was submitted
PRIV_USER	VARCHAR2(30)	NOT NULL	USER whose default privileges apply to this job
SCHEMA_USER	VARCHAR2(30)	NOT NULL	Default schema used to parse the job For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
LAST_DATE	DATE		Date this job last successfully executed
LAST_SEC	VARCHAR2(8)		Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	DATE		Date that this job started executing (usually null if not executing)
THIS_SEC	VARCHAR2(8)		Same as THIS_DATE.
NEXT_DATE	DATE	NOT NULL	Date that this job will next be executed
NEXT_SEC	VARCHAR2(8)		Same as NEXT_DATE. The job becomes due for execution at this time.
TOTAL_TIME	NUMBER		Total wall clock time spent by the system on this job, in seconds
BROKEN	VARCHAR2(1)		If Y, no attempt is being made to run this job. See DBMS_JOB.BROKEN (JOB).
INTERVAL	VARCHAR2(200)	NOT NULL	A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES	NUMBER		How many times has this job started and failed since its last success?
WHAT	VARCHAR2(4000)		Body of the anonymous PL/SQL block that this job executes
CURRENT_SESSION _LABEL	MLSLABEL		Trusted Oracle Server label of the current session as seen by the job. Applies to Trusted Oracle Server only.
CLEARANCE_HI	MLSLABEL		Highest level of clearance available to the job. Applies to Trusted Oracle Server only.
CLEARANCE_LO	MLSLABEL		Lowest level of clearance available to the job. Applies to Trusted Oracle Server only.
NLS_ENV	VARCHAR2(4000)		ALTER SESSION parameters describing the NLS environment of the job
MISC_ENV	RAW(32)		Other session parameters that apply to this job

USER_LIBRARIES

This view lists all the libraries that a user owns.

Column	Datatype	NULL	Description
LIBRARY_NAME	VARCHAR2(30)	NOT NULL	Library name
FILE_SPEC	VARCHAR2(2000)		File specification associated with the library
DYNAMIC	VARCHAR2(1)		Is the library dynamically loadable? (YES or NO)
STATUS	VARCHAR2(7)		Status of the library

USER_LOBS

This view displays the user's LOBs contained in the user's tables. It is only for internal LOBs, so BLOBs, CLOBs, and NCLOBs are OK. External LOBs (i.e.,BFILES) are not.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table containing the LOB
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB column or attribute
SEGMENT_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB segment
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB index
CHUNK	NUMBER		Size of the LOB chunk as a unit of allocation/manipulation in bytes
PCTVERSION	NUMBER	NOT NULL	Maximum percentage of the LOB space used for versioning
CACHE	VARCHAR2(3)		Indicates whether the LOB is accessed through the buffer cache
LOGGING	VARCHAR2(3)		Indicates whether the changes to the LOB are logged
IN_ROW	VARCHAR2(3)		Are some of the LOBs stored with the base row?

USER_METHOD_PARAMS

This view is a description of method parameters of the user's types.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
PARAM_NAME	VARCHAR2(30)	NOT NULL	Name of the parameter
PARAM_NO	NUMBER	NOT NULL	Parameter number or position
PARAM_MODE	VARCHAR2(6)		Mode of the parameter
PARAM_TYPE_MOD	VARCHAR2(7)		Type modifier of the parameter
PARAM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the parameter
PARAM_TYPE_NAME	VARCHAR2(30)		Name of the type of the parameter
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

USER_METHOD_RESULTS

This view is a description of method results of the user's types.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER	NOT NULL	Method number for distinguishing overloaded method (not to be used as ID number)
RESULT_TYPE_MOD	VARCHAR2(7)		Type modifier of the result
RESULT_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the result
RESULT_TYPE_NAME	VARCHAR2(30)		Name of the type of the result
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS

USER_NESTED_TABLES

This view describes the nested tables contained in the user's own tables.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(30)	Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2(30)	Name of the type of the nested table
PARENT_TABLE_NAME	VARCHAR2(30)	Name of the parent table containing the nested table
PARENT_TABLE_COLUMN	VARCHAR2(4000)	Column name of the parent table that corresponds to the nested table

USER_OBJECT_TABLES

This view contains descriptions of the object tables available to the user.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)		Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)		Name of the index organized table, if any, to which the overflow entry belongs
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		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute
BACKED_UP	VARCHAR2(1)		Has table been backed up since last modification?
NUM_ROWS	NUMBER		The number of rows in the table
BLOCKS	NUMBER		The number of used blocks in the table
EMPTY_BLOCKS	NUMBER		The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER		The average available free space in the table
CHAIN_CNT	NUMBER		The number of chained rows in the table
AVG_ROW_LEN	NUMBER		The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER		The number of blocks on the freelist
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER		The sample size used in analyzing this table
LAST_ANALYZED	DATE		The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)		Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)		If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	NOT NULL	Type of the table if the table is a typed table
PACKED	VARCHAR2(1)		If the table is a typed table, does it store objects in packed format?
TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)		Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)		The default buffer pool to be used for table blocks

USER_OBJECTS

This view lists objects owned by the user.

Column	Datatype	Description
OBJECT_NAME	VARCHAR2(128)	Name of the object
SUBOBJECT_NAME	VARCHAR2(30)	Name of the sub-object (for example, partition)
OBJECT_ID	NUMBER	Object number of the object
DATA_OBJECT_ID	NUMBER	Object number of the segment which contains the object
OBJECT_TYPE	VARCHAR2(15)	Type and type body of the object: INDEX PARTITION, TABLE PARTITION, PACKAGE, PACKAGE BODY, or TRIGGER
CREATED	DATE	Timestamp for the creation of the object
LAST_DDL_TIME	DATE	Timestamp of the last DDL command applied to the object (including grants and revokes)
TIMESTAMP	VARCHAR2(19)	Timestamp for the creation of the object (character data)
STATUS	VARCHAR2(7)	Status of the object: VALID, INVALID
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
GENERATED	VARCHAR2(1)	Was the name of this object system generated?

USER_OBJECT_SIZE

This view lists the PL/SQL objects owned by the user.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of the object: PROCEDURE, PACKAGE, or PACKAGE BODY
SOURCE_SIZE	NUMBER		Size of source code in bytes
PARSED_SIZE	NUMBER		Size of parsed code in bytes
CODE_SIZE	NUMBER		Size of compiled code in bytes
ERROR_SIZE	NUMBER		Size of error messages in bytes

USER_OBJ_AUDIT_OPTS

This view, created by CATAUDIT.SQL, lists auditing options for the user's tables and views.

Column	Datatype	Description
OBJECT_NAME	VARCHAR2(30)	Name of the object
OBJECT_TYPE	VARCHAR2(9)	Type of the object: TABLE or VIEW
ALT	VARCHAR2(3)	Auditing ALTER WHENEVER SUCCESSFUL/UNSUCCESSFUL
AUD	VARCHAR2(3)	Auditing AUDIT WHENEVER SUCCESSFUL/UNSUCCESSFUL
COM	VARCHAR2(3)	Auditing COMMENT WHENEVER SUCCESSFUL/UNSUCCESSFUL
DEL	VARCHAR2(3)	Auditing DELETE WHENEVER SUCCESSFUL/UNSUCCESSFUL
GRA	VARCHAR2(3)	Auditing GRANT WHENEVER SUCCESSFUL/UNSUCCESSFUL
IND	VARCHAR2(3)	Auditing INDEX WHENEVER SUCCESSFUL/UNSUCCESSFUL
INS	VARCHAR2(3)	Auditing INSERT WHENEVER SUCCESSFUL/UNSUCCESSFUL
LOC	VARCHAR2(3)	Auditing LOCK WHENEVER SUCCESSFUL/UNSUCCESSFUL
REN	VARCHAR2(3)	Auditing RENAME WHENEVER SUCCESSFUL/ UNSUCCESSFUL
SEL	VARCHAR2(3)	Auditing SELECT WHENEVER SUCCESSFUL/UNSUCCESSFUL
UPD	VARCHAR2(3)	Auditing UPDATE WHENEVER SUCCESSFUL/UNSUCCESSFUL
REF	VARCHAR2(3)	Auditing REFERENCES WHENEVER SUCCESSFUL/UNSUCCESSFUL
EXE	VARCHAR2(3)	Auditing EXECUTE WHENEVER SUCCESSFUL/UNSUCCESSFUL
CRE	VARCHAR2(3)	Auditing CREATE WHENEVER SUCCESSFUL/UNSUCCESSFUL
REA	VARCHAR2(3)	Auditing READ WHENEVER SUCCESSFUL/UNSUCCESSFUL
WRI	VARCHAR2(3)	Auditing WRITE WHENEVER SUCCESSFUL/UNSUCCESSFUL

USER_PART_COL_STATISTICS

This view contains column statistics and histogram information for table partitions that the current user owns.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Table partition name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed

U SER_PART_HISTOGRAMS

This view contains the histogram data (end-points per histogram) for histograms on table partitions that the current user can access.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(30)	Table name
PARTITION_NAME	VARCHAR2(30)	Table partition name
COLUMN_NAME	VARCHAR2(30)	Column name
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

USER_PART_KEY_COLUMNS

This view describes the partitioning key columns for partitioned objects that the current user owns.

Column	Datatype	Description
NAME	VARCHAR2(30)	Partitioned table or index name
OBJECT_TYPE	VARCHAR2(11)	The object type (`TABLE' or `INDEX')
COLUMN_NAME	VARCHAR2(30)	Column name
COLUMN_POSITION	NUMBER	Position of the column within the partitioning key

USER_PART_INDEXES

This view lists the object level partitioning information for all partitioned indexes that the user owns.

Column	Datatype	NULL	Description
INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned index
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: RANGE
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this index
PARTITIONING_KEY _COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
LOCALITY	VARCHAR2(6)		Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT	VARCHAR2(12)		Indicates whether this partitioned index is PREFIXED or NON-PREFIXED
DEF_TABLESPACE _NAME	VARCHAR2(30)		Default TABLESPACE, for LOCAL index, for ADD/SPLIT TABLE partition
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, for LOCAL index, for ADD TABLE partition
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, for LOCAL index, for ADD TABLE partition
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, for LOCAL index, for ADD TABLE partition
DEF_INITIAL_EXTENT	VARCHAR2(40)		Default INITIAL, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	VARCHAR2(40)		Default NEXT, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	VARCHAR2(40)		Default MINEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	VARCHAR2(40)		Default MAXEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	VARCHAR2(40)		Default PCTINCREASE, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, for LOCAL index, for ADD TABLE partition
DEF_FREELIST_GROUPS	NUMBER	NOT NULL	Default FREELISTS, for LOCAL index, for ADD TABLE partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING, for LOCAL index, for ADD TABLE PARTITION
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool, for LOCAL index, for ADD TABLE PARTITION

USER_PART_TABLES

This view describes the object level partitioning information for partitioned tables that the current user owns.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of this partitioned table
PARTITIONING_TYPE	VARCHAR2(7)		Partitioning algorithm: RANGE
PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this table
PARTITIONING_KEY_COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
DEF_TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Default TABLESPACE, used for ADD partition
DEF_PCT_FREE	NUMBER	NOT NULL	Default PCTFREE, used for ADD partition
DEF_PCT_USED	NUMBER	NOT NULL	Default PCTUSED, used for ADD partition
DEF_INI_TRANS	NUMBER	NOT NULL	Default INITRANS, used for ADD partition
DEF_MAX_TRANS	NUMBER	NOT NULL	Default MAXTRANS, used for ADD partition
DEF_INITIAL_EXTENT	VARCHAR2(40)		Default INITIAL, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_NEXT_EXTENT	VARCHAR2(40)		Default NEXT, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_MIN_EXTENTS	VARCHAR2(40)		Default MINEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_MAX_EXTENTS	VARCHAR2(40)		Default MAXEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_PCT_INCREASE	VARCHAR2(40)		Default PCTINCREASE, used for ADD partition, `DEFAULT' if attribute was not specified
DEF_FREELISTS	NUMBER	NOT NULL	Default FREELISTS, used for ADD partition
DEF_FREELIST_GROUPS	NUMBER	NOT NULL	Default FREELIST GROUPS, used for ADD partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING attribute, used for ADD PARTITION
DEF_BUFFER_POOL	VARCHAR2(7)		The default buffer pool for the given object

USER_PASSWORD_LIMITS

This view describes the password profile parameters that are assigned to the user.

Column	Datatype	NULL	Description
RESOURCE_NAME	VARCHAR2(32)	NOT NULL	Name of the password resource
LIMIT	VARCHAR2(40)		Value of the resource limit

USER_QUEUE_TABLES

This view describes only the queues in the queue tables created in the user `s schema. For more information about this view and Advanced Queuing, see the Oracle8 Application Developer's Guide.

Column	Datatype	Description
QUEUE_TABLE	VARCHAR2(30)	Name of the queue table
TYPE	VARCHAR2(7)	Type of payload: RAW: raw type OBJECT: user-defined object type VARIANT: variant type (internal use only)
OBJECT_TYPE	VARCHAR2(61)	Object type of the payload when TYPE is OBJECT
SORT_ORDER	VARCHAR2(22)	User specified sort order
RECIPIENTS	VARCHAR2(8)	SINGLE or MULTIPLE recipients
MESSAGE_GROUPING	VARCHAR2(13)	NONE or TRANSACTIONAL
USER_COMMENT	VARCHAR2(50)	Comment supplied by the user

USER_QUEUES

This view describes the operational characteristics for every queue in the user's schema. For more information about this view and Advanced Queuing, see the Oracle8 Application Developer's Guide.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the queue
QUEUE_TABLE	VARCHAR2(30)	NOT NULL	The name of the queue table where this queue resides
QID	NUMBER	NOT NULL	Unique queue identifier
QUEUE_TYPE	VARCHAR2(15)		Queue type: NORMAL_QUEUE - Normal queue EXCEPTION_QUEUE - Exception queue
MAX_RETRIES	NUMBER		Number of dequeue attempts allowed
RETRY_DELAY	NUMBER		Time lapse in seconds before retry takes place
ENQUEUE_ENABLED	VARCHAR2(7)		YES/NO
DEQUEUE_ENABLED	VARCHAR2(7)		YES/NO
RETENTION	VARCHAR2(40)		Number of seconds message is retained after dequeue. FOREVER - messages stay in the queue permanently
USER_COMMENT	VARCHAR2(50)		Comment supplied by the user

USER_REFRESH

This view lists all the refresh groups.

Column	Datatype	NULL	Description
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED _RPC	VARCHAR2(1)		Y or N, if Y then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

USER_REFRESH_CHILDREN

This view lists all the objects in refresh groups, where the user owns the refresh group.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
TYPE	VARCHAR2(30)		Type of the object in the refresh group
ROWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the refresh group
RNAME	VARCHAR2(30)	NOT NULL	Name of the refresh group
REFGROUP	NUMBER		Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		Y or N; if Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED_RPC	VARCHAR2(1)		Y or N, if Y then push changes from snapshot to master before refresh
REFRESH_AFTER _ERRORS	VARCHAR2(1)		If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER		Identifier of job used to refresh the group automatically
NEXT_DATE	DATE		Date that this job will next be refreshed automatically, if not broken
INTERVAL	VARCHAR2(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2(1)		Y or N; Y means the job is broken and will never be run
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap.

USER_REFS

This view describes the REF columns and REF attributes in the object type columns of the user's tables.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
COLUMN_NAME	VARCHAR2(4000)		Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name.
WITH_ROWID	VARCHAR2(3)		Is the REF value stored with ROWID? (YES or NO)
IS_SCOPED	VARCHAR2(3)		Is the REF column scoped? (YES or NO)
SCOPE_TABLE_OWNER	VARCHAR2(30)		Name of the owner of the scope table, if it exists and is accessible by the user
SCOPE_TABLE_NAME	VARCHAR2(30)		Name of the scope table, if it exists and is accessible by the user

USER_REPCATLOG

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPCOLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPCOLUMN_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPCONFLICT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPDDL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPGENERATED

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPGROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPGROUPED_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPKEY_COLUMNS

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPOBJECT

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPPARAMETER_COLUMN

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPPRIORITY

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPPRIORITY_GROUP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPPROP

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPRESOLUTION

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPRESOL_STATS_CONTROL

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPRESOLUTION_METHOD

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPRESOLUTION_STATISTICS

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8 Replication.

USER_RESOURCE_LIMITS

This view displays the resource limits for the current user.

Column	Datatype	NULL	Description
RESOURCE_NAME	VARCHAR2(32)	NOT NULL	Name of the resource
LIMIT	VARCHAR2(40)		Limit placed on this resource

USER_ROLE_PRIVS

This view lists roles granted to the user.

Column	Datatype	Description
USERNAME	VARCHAR2(30)	Name of the user, or PUBLIC
GRANTED_ROLE	VARCHAR2(30)	Name of the role granted to the user
ADMIN_OPTION	VARCHAR2(3)	Granted with ADMIN option: YES/NO
DEFAULT_ROLE	VARCHAR2(3)	Role is designated as the user's default role: YES/NO
OS_GRANTED	VARCHAR2(3)	Granted by the operating system: Y/N (occurs if configuration parameter OS_ROLES = TRUE)

USER_SEGMENTS

This view lists information about storage allocation for database segments belonging to a user's objects.

Column	Datatype	Description
SEGMENT_NAME	VARCHAR2(81)	Name of the segment, if any
PARTITION_NAME	VARCHAR2(30)	Object Partition Name (Set to NULL for non-partitioned objects).
SEGMENT_TYPE	VARCHAR2(17)	Type of segment: INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the segment
BYTES	NUMBER	Size of the segment in bytes
BLOCKS	NUMBER	Size of the segment in Oracle blocks
EXTENTS	NUMBER	Number of extents allocated to the segment
INITIAL_EXTENT	NUMBER	Size of the initial extent in Oracle blocks
NEXT_EXTENT	NUMBER	Size of the next extent to be allocated in Oracle blocks
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	Percent by which to increase the size of the next extent to be allocated
FREELISTS	NUMBER	Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated to this segment
BUFFER_POOL	VARCHAR2(7)	Name of the default buffer pool for the appropriate object

USER_SEQUENCES

This view lists descriptions of the user's sequences.

Column	Datatype	NULL	Description
SEQUENCE_NAME	VARCHAR2(30)	NOT NULL	SEQUENCE name
MIN_VALUE	NUMBER		Minimum value of the sequence
MAX_VALUE	NUMBER		Maximum value of the sequence
INCREMENT_BY	NUMBER	NOT NULL	Value by which the sequence is incremented
CYCLE_FLAG	VARCHAR2(1)		Does sequence wraparound on reaching limit
ORDER_FLAG	VARCHAR2(1)		Are sequence numbers generated in order
CACHE_SIZE	NUMBER	NOT NULL	Number of sequence numbers to cache
LAST_NUMBER	NUMBER	NOT NULL	Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was actually used. This value is not continuously updated during database operation. It is intended for use after a warm start or import.

USER_SNAPSHOTS

This view lists snapshots that the user can view.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the view used by users and applications for viewing the snapshot
TABLE_NAME	VARCHAR2(30)	NOT NULL	The table name
MASTER_VIEW	VARCHAR2(30)		View of the master table, owned by the snapshot owner, used for refreshes. this is obsolete in Oracle8 and is NULL.
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table of which this snapshot is a copy
MASTER_LINK	VARCHAR2(128)		Database link name to the master site
CAN_USE_LOG	VARCHAR2(3)		YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log
UPDATABLE	VARCHAR2(3)		If YES, then snapshot is updatable snapshot. If NO, then is a read-only snapshot.
LAST_REFRESH	DATE		Date and time at the master site of the last refresh
ERROR	NUMBER		The number of failed automatic refreshes since last successful refresh
TYPE	VARCHAR2(8)		Type of refresh for all automatic refreshes: COMPLETE, FAST, FORCE
NEXT	VARCHAR2(200)		Date function used to compute next refresh dates
START_WITH	DATE		Date function used to compute next refresh dates
REFRESH_GROUP	NUMBER		All snapshots in a given refresh group get refreshed in the same transaction
REFRESH_METHOD	VARCHAR2(11)		Values used to drive a fast refresh of the snapshot
FR_OPERATIONS	VARCHAR2(10)		Status of generated fast refresh operations: (REGENERATE, VALID)
CR_OPERATIONS	VARCHAR2(10)		Status of generated complete refresh operations: (REGENERATE, VALID)
UPDATE_TRIG	VARCHAR2(30)		Obsolete. It is NULL for Oracle8 snapshots.
UPDATE_LOG	VARCHAR2(30)		The table that logs changes made to an updatable snapshots
QUERY	LONG		Original query of which this snapshot is an instantiation
MASTER_ROLLBACK_SEG	VARCHAR2(30		Rollback segment used at the main site.

USER_SNAPSHOT_LOGS

This view lists all snapshot logs owned by the user.

Column	Datatype	NULL	Description
LOG_OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot log
MASTER	VARCHAR2(30)	NOT NULL	Name of the master table for which the log records changes
LOG_TABLE	VARCHAR2(30)	NOT NULL	Log table that holds the ROWIDs and timestamps of rows that changed in the master table
LOG_TRIGGER	VARCHAR2(30)		Obsolete. It is NULL for Oracle8 snapshots.
ROWIDS	VARCHAR2(3)		If YES, the snapshot log records rowid information
PRIMARY_KEY	VARCHAR2(3)		If YES, the snapshot log records primary_key information
FILTER_COLUMNS	VARCHAR2(3)		If YES, the snapshot log records filter column information
CURRENT_SNAPSHOTS	DATE		Date and time when the snapshot of the master was last refreshed
SNAPSHOT_ID	NUMBER(38)		Unique snapshot identifier.

USER_SOURCE

This view contains text source of all stored objects belonging to the user.

Column	Datatype	NULL	Description
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, TYPE, TYPE BODY, or PACKAGE BODY
LINE	NUMBER	NOT NULL	Line number of this line of source
TEXT	VARCHAR2(4000)		Text source of the stored object

USER_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the snapshot
NAME	VARCHAR2(30)	NOT NULL	Name of the snapshot view
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table
LAST_REFRESH	DATE		The last refresh

USER_SYNONYMS

This view lists the user's private synonyms.

Column	Datatype	NULL	Description
SYNONYM_NAME	VARCHAR2(30)	NOT NULL	Name of the synonym
TABLE_OWNER	VARCHAR2(30)		Owner of the object referenced by the synonym
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object referenced by the synonym
DB_LINK	VARCHAR2(128)		Database link referenced in a remote synonym

USER_SYS_PRIVS

This view lists system privileges granted to the user.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)		Name of the user, or PUBLIC
PRIVILEGE	VARCHAR2(40)	NOT NULL	System privilege granted to the user
ADMIN_OPTION	VARCHAR2(3)		Signifies the privilege was granted with ADMIN option

USER_TAB_COL_STATISTICS

This view contains column statistics and histogram information which is in the USER_TAB_COLUMNS view. For more information, see "USER_TAB_COLUMNS" on page 2-161.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
NUM_DISTINCT	NUMBER		Number of distinct values in the column
LOW_VALUE	RAW(32)		Low value in the column
HIGH_VALUE	RAW(32)		High value in the column
DENSITY	NUMBER		Density of the column
NUM_NULLS	NUMBER		Number of nulls in the column
NUM_BUCKETS	NUMBER		Number of buckets in histogram for the column
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
LAST_ANALYZED	DATE		Date of the most recent time this column was analyzed

USER_TAB_COLUMNS

This view contains information about columns of user's tables, views, and clusters. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table, view, or cluster name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
DATA_LENGTH	NUMBER	NOT NULL	Maximum length of the column in bytes
DATA_TYPE	VARCHAR2(30)		Datatype of the column
DATA_TYPE_MOD	VARCHAR2(3)		Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR2(30)		Owner of the datatype of the column
DATA_PRECISION	NUMBER		Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
DATA_SCALE	NUMBER		Digits to right of decimal point in a number
NULLABLE	VARCHAR2(1)		Does column allow NULLs? Value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY.
COLUMN_ID	NUMBER	NOT NULL	Sequence number of the column as created
DEFAULT_LENGTH	NUMBER		Length of default value for the column
DATA_DEFAULT	LONG		Default value for the column
NUM_DISTINCT	NUMBER		These columns remain for backward compatibility with Oracle7. This information is now in the {TAB\|PART}_COL_STATISTICS views. This view now picks up these values from HIST_HEAD$ rather than COL$.
LOW_VALUE HIGH_VALUE	RAW(32)
DENSITY	NUMBER
NUM_NULLS	NUMBER		The number of NULLs in the column
NUM_BUCKETS	NUMBER		The number of buckets in histogram for the column
LAST_ANALYZED	DATE		The date of the most recent time this column was analyzed
SAMPLE_SIZE	NUMBER		The sample size used in analyzing this column
PACKED	VARCHAR2(1)		Does column store values in packed format?
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS, NCHAR_CS
CHAR_COL_DECL _LENGTH	NUMBER		The declared length for CHAR, VARCHAR, VARCHAR2, NCAR, and NVARCHAR2 datatypes; NULL for all other datatypes

USER_TAB_COMMENTS

This view contains comments on the tables and views owned by the user.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object: TABLE (indicating the value for object tables and regular tables) or VIEW
COMMENTS	VARCHAR2(4000)		Comment on the object

USER_TAB_HISTOGRAMS

This view lists histograms on columns of user's tables.

Column	Datatype	Description
TABLE_NAME	VARCHAR2(30)	Table name
COLUMN_NAME	VARCHAR2(4000)	Column name or attribute of the object type column
BUCKET_NUMBER	NUMBER	Bucket number
ENDPOINT_VALUE	NUMBER	Normalized endpoint values for this bucket

USER_TAB_PARTITIONS

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
PARTITION_NAME	VARCHAR2(30)		Partition name
HIGH_VALUE	LONG		Partition bound value expression
HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the table
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)		Logging attribute of partition
NUM_ROWS	NUMBER		Number of rows in the partition
BLOCKS	NUMBER		Number of used blocks in the partition
EMPTY_BLOCKS	NUMBER		Number of empty (never used) blocks in the partition
AVG_SPACE	NUMBER		Average available free space in the partition
CHAIN_CNT	NUMBER		Number of chained rows in the partition
AVG_ROW_LEN	NUMBER		Average row length, including row overhead
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
LAST_ANALYZED	DATE		Date of the most recent time this partition was analyzed
BUFFER_POOL	VARCHAR2(7)		Actual buffer pool of the given object

USER_TAB_PRIVS

This view contains information on grants on objects for which the user is the owner, grantor, or grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privileges was granted with ADMIN OPTION; otherwise NO

USER_TAB_PRIVS_MADE

This view contains information about all grants on objects owned by the user.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

USER_TAB_PRIVS_RECD

This view contains information about grants on objects for which the user is the grantee.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

USER_TABLES

This view contains a description of the user's own relational tables. To gather statistics for this view, use the SQL command ANALYZE.

Column	Datatype	NULL	Description
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)		Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)		Name of the index organized table, if any, to which the overflow entry belongs
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		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
LOGGING	VARCHAR2(3)		Logging attribute
BACKED_UP	VARCHAR2(1)		Has table been backed up since last modification
NUM_ROWS	NUMBER		Number of rows returned by the ANALYZE command
BLOCKS	NUMBER		Number of used data blocks in the table
EMPTY_BLOCKS	NUMBER		Number of empty (never used) data blocks in the table
AVG_SPACE	NUMBER		Average amount of free space (in bytes) in a data block allocated to the table
CHAIN_CNT	NUMBER		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		Average length of a row in the table in bytes
AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
NUM_FREELIST _BLOCKS	NUMBER		The number of blocks on the freelist
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)		Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER		Sample size used in analyzing this table
LAST_ANALYZED	DATE		Date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)		Indicates whether this table is partitioned. Set to `YES' if it is partitioned
IOT_TYPE	VARCHAR2(12)		If this is an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW. If this is not an index organized table, IOT_TYPE is NULL
TABLE_TYPE_OWNER	VARCHAR2(0)		Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(0)		Type of the table if the table is a typed table
PACKED	VARCHAR2(0)		If the table is a typed table, does it store objects in packed format?
TEMPORARY	VARCHAR2(1)		Can the current session see only the data that it places in this object itself?
NESTED	VARCHAR2(3)		Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object

USER_TABLESPACES

This view contains descriptions of accessible tablespaces.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
INITIAL_EXTENT	NUMBER		Default initial extent size
NEXT_EXTENT	NUMBER		Default incremental extent size
MIN_EXTENTS	NUMBER	NOT NULL	Default minimum number of extents
MAX_EXTENTS	NUMBER	NOT NULL	Default maximum number of extents
PCT_INCREASE	NUMBER	NOT NULL	Default percent increase for extent size
MIN_EXTLEN	NUMBER		Minimum extent size for the tablespace
STATUS	VARCHAR2(9)		Tablespace status: ONLINE, OFFLINE, or INVALID (tablespace has been dropped)
CONTENTS	VARCHAR2(9)		Tablespace contents: "PERMANENT", or "TEMPORARY"
LOGGING	VARCHAR2(9)		Default logging attribute

USER_TRIGGERS

This view contains descriptions of the user's triggers.

Column	Datatype	NULL	Description
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TRIGGER_TYPE	VARCHAR2(16)		When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT
TRIGGERING_EVENT	VARCHAR2(26)		Statement that fires the trigger: INSERT, UPDATE, DELETE
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table on which the trigger is defined
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table on which the trigger is defined
REFERENCING_NAMES	VARCHAR2(87)		Names used for referencing to OLD and NEW values within the trigger
WHEN_CLAUSE	VARCHAR2(4000)		WHEN clause. Must evaluate to TRUE for TRIGGER_BODY to execute.
STATUS	VARCHAR2(8)		Whether the trigger is enabled: ENABLED or DISABLED
DESCRIPTION	VARCHAR2(4000)		Trigger description. Useful for re-creating a trigger creation statement.
TRIGGER_BODY	LONG		Statement(s) executed by the trigger when it fires

USER_TRIGGER_COLS

This view displays the usage of columns in triggers owned by the user or on one of the user's tables.

Column	Datatype	NULL	Description
TRIGGER_OWNER	VARCHAR2(30)	NOT NULL	Owner of the trigger
TRIGGER_NAME	VARCHAR2(30)	NOT NULL	Name of the trigger
TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table on which the trigger is defined
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table on which the trigger is defined
COLUMN_NAME	VARCHAR2(4000)		Name of the column used in the trigger
COLUMN_LIST	VARCHAR2(3)		Column specified in UPDATE clause: Y/N
COLUMN_USAGE	VARCHAR2(17)		How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT.

USER_TS_QUOTAS

This view contains information about tablespace quotas for the user.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
BYTES	NUMBER		Number of bytes charged to the user
MAX_BYTES	NUMBER		User's quota in bytes, or -1 for UNLIMITED
BLOCKS	NUMBER	NOT NULL	Number of Oracle blocks charged to the user
MAX_BLOCKS	NUMBER		User's quota in Oracle blocks, or -1 or UNLIMITED

USER_TYPES

This view displays the user's types in a table.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
TYPE_OID	RAW(16)	NOT NULL	Object identifier (OID) of the type
TYPECODE	VARCHAR2(30)		Typecode of the type
ATTRIBUTES	NUMBER		Number of attributes (if any) in the type
METHODS	NUMBER		Number of methods (if any) in the type
PREDEFINED	VARCHAR2(3)		Indicates whether the type is a predefined type
INCOMPLETE	VARCHAR2(3)		Indicates whether the type is an incomplete type

USER_TYPE_ATTRS

This view displays the attributes of the user's types.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
ATTR_NAME	VARCHAR2(30)	NOT NULL	Name of the attribute
ATTR_TYPE_MOD	VARCHAR2(7)		Type modifier of the attribute
ATTR_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the attribute
ATTR_TYPE_NAME	VARCHAR2(30)		Name of the type of the attribute
LENGTH	NUMBER		Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE	NUMBER		Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET_NAME	VARCHAR2(44)		The name of the character set: CHAR_CS, NCHAR_CS

USER_TYPE_METHODS

This view is a description of the user's methods types.

Column	Datatype	NULL	Description
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
METHOD_NAME	VARCHAR2(30)	NOT NULL	Name of the method
METHOD_NO	NUMBER		Method number for distinguishing overloaded method (not to be used as ID number)
METHOD_TYPE	VARCHAR2(6)		Type of the method
PARAMETERS	NUMBER	NOT NULL	Number of parameters to the method
RESULTS	NUMBER	NOT NULL	Number of results returned by the method

USER_UPDATABLE_COLUMNS

This view contains a description of columns that are updatable to the user in a join view.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
UPDATABLE	VARCHAR2(3)		Indicates whether the column is updatable
INSERTABLE	VARCHAR2(3)		Indicates whether the column is insertable
DELETABLE	VARCHAR2(3)		Indicates whether the column is deletable

USER_USERS

This view contains information about the current user.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)	NOT NULL	Name of the user
USER_ID	NUMBER	NOT NULL	ID number of the user
ACCOUNT_STATUS	VARCHAR2(32)	NOT NULL	Indicates if the account is locked, expired, or unlocked
LOCK_DATE	DATE		Date the account was locked if account status is locked
EXPIRY_DATE	DATE		Date of expiration of the account if account status is expired
DEFAULT_TABLESPACE	VARCHAR2(30)	NOT NULL	Default tablespace for data
TEMPORARY_TABLESPACE	VARCHAR2(30)	NOT NULL	Default tablespace for temporary tables
CREATED	DATE	NOT NULL	User creation date
EXTERNAL_NAME	VARCHAR2(4000)		User external name

USER_VIEWS

This view contains the text of views owned by the user.

Column	Datatype	NULL	Description
VIEW_NAME	VARCHAR2(30)	NOT NULL	Name of the view
TEXT_LENGTH	NUMBER		Length of the view text
TEXT	LONG		View text
TYPE_TEXT_LENGTH	NUMBER		Length of the type clause of the typed view
TYPE_TEXT	VARCHAR2(4000)		Type clause of the typed view
OID_TEXT_LENGTH	NUMBER		Length of the WITH OID clause of the typed view
OID_TEXT	VARCHAR2(4000)		WITH OID clause of the typed view
VIEW_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the view if the view is a typed view
VIEW_TYPE	VARCHAR2(30)		Type of the view if the view is a typed view

Column	Description
OWNER_NAME	Table owner
TABLE_NAME	Table name
CLUSTER_NAME	Cluster the table is in, if any
HEAD_ROWID	ROWID the chained row is accessed by
TIMESTAMP	Date/time that the ANALYZE command was issued

2Static Data Dictionary Views

Data Dictionary Views

ALL_ALL_TABLES

ALL_ARGUMENTS

ALL_CATALOG

ALL_CLUSTERS

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_COLL_TYPES

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_DB_LINKS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_DIRECTORIES

ALL_ERRORS

ALL_IND_COLUMNS

ALL_IND_PARTITIONS

ALL_INDEXES

ALL_LABELS

ALL_LIBRARIES

ALL_LOBS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_NESTED_TABLES

ALL_OBJECT_TABLES

ALL_OBJECTS

ALL_PART_COL_STATISTICS

ALL_PART_HISTOGRAMS

ALL_PART_INDEXES

ALL_PART_KEY_COLUMNS

ALL_PART_TABLES

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REFS

ALL_REGISTERED_SNAPSHOTS

ALL_REPCATLOG

ALL_REPCOLUMN

ALL_REPCOLUMN_GROUP

ALL_REPCONFLICT

ALL_REPDDL

ALL_REPGENERATED

ALL_REPGROUP

ALL_REPGROUPED_COLUMN

ALL_REPKEY_COLUMNS

ALL_REPOBJECT

ALL_REPPARAMETER_COLUMN

ALL_REPPRIORITY

ALL_REPPRIORITY_GROUP

ALL_REPPROP

ALL_REPRESOLUTION

ALL_REPRESOL_STATS_CONTROL

ALL_REPRESOLUTION_METHOD

ALL_REPRESOLUTION_STATISTICS

ALL_REPSITES

ALL_SEQUENCES

ALL_SNAPSHOT_LOGS

ALL_SNAPSHOT_REFRESH_TIMES

ALL_SNAPSHOTS

ALL_SOURCE

ALL_SYNONYMS

ALL_TAB_COL_STATISTICS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TAB_HISTOGRAMS

ALL_TAB_PARTITIONS

ALL_TAB_PRIVS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

ALL_TABLES

ALL_TRIGGERS

ALL_TRIGGER_COLS

ALL_TYPE_ATTRS

ALL_TYPE_METHODS

ALL_TYPES

ALL_UPDATABLE_COLUMNS

ALL_USERS

ALL_VIEWS

2
Static Data Dictionary Views