Oracle8 Reference Release 8.0 A58242-01 |
Library | Product | Contents | Index

# 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 | NULL | 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.

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 | NULL | 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 | Null | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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 | NULL | 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

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 owns.

#####

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

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index