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 Oracle 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(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?

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is enabled or disabled

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction, else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
PCT_FREE	NUMBER	Minimum percentage of free space in a bloc
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent in bytes
NEXT_EXTENT	NUMBER	Size of secondary extents in bytes
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last modification?
NUM_ROWS	NUMBER	The number of rows in the table
BLOCKS	NUMBER	The number of used blocks in the table
EMPTY_BLOCKS	NUMBER	The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	The average available free space in the table
CHAIN_CNT	NUMBER	The number of chained rows in the table
AVG_ROW_LEN	NUMBER	The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	The sample size used in analyzing this table
LAST_ANALYZED	DATE	The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)	If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(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?
OBJECT_ID_TYPE	VARCHAR2(16)	If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
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
ROW_MOVEMENT	VARCHAR2(8)	Whether partitioned row movement is enabled or disabled
GLOBAL_STATS	VARCHAR2(3)	Are the statistics calculated without merging underlying partitions?
USER_STATS	VARCHAR2(3)	Were the statistics entered directly by the user?
DURATION	VARCHAR2(15)	If temporary table, then duration is sys$session or sys$transaction, else NULL
SKIP_CORRUPT	VARCHAR2(8)	Whether skip corrupt blocks is enabled or disabled

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

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_ASSOCIATIONS

This view lists user-defined statistics information.

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(30)

NOT NULL

Owner of the object for which the association is being defined

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Object name for which the association is being defined

COLUMN_NAME

VARCHAR2(30)

Column name in the object for which the association is being defined

OBJECT_TYPE

VARCHAR2(9)

Schema type of the object - column, type, package or function

STATSTYPE_SCHEMA

VARCHAR2(30)

Owner of the statistics type

STATSTYPE_NAME

VARCHAR2(30)

Name of Statistics type which contains the cost, selectivity or stats funcs

DEF_SELECTIVITY

NUMBER

Default Selectivity if any of the object

DEF_CPU_COST

NUMBER

Default CPU cost if any of the object

DEF_IO_COST

NUMBER

Default I/O cost if any of the object

DEF_NET_COST

NUMBER

Default Networking cost if any of the object

Column	Datatype	NULL	Description
OBJECT_OWNER	VARCHAR2(30)	NOT NULL	Owner of the object for which the association is being defined
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Object name for which the association is being defined
COLUMN_NAME	VARCHAR2(30)		Column name in the object for which the association is being defined
OBJECT_TYPE	VARCHAR2(9)		Schema type of the object - column, type, package or function
STATSTYPE_SCHEMA	VARCHAR2(30)		Owner of the statistics type
STATSTYPE_NAME	VARCHAR2(30)		Name of Statistics type which contains the cost, selectivity or stats funcs
DEF_SELECTIVITY	NUMBER		Default Selectivity if any of the object
DEF_CPU_COST	NUMBER		Default CPU cost if any of the object
DEF_IO_COST	NUMBER		Default I/O cost if any of the object
DEF_NET_COST	NUMBER		Default Networking cost if any of the object

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

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

ALL_CLUSTERS

This view list all clusters accessible to the user.

Column Datatype NULL Description

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

Name of the cluster

OWNER

VARCHAR2(30)

NOT NULL

The owner of the cluster

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

The 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

SINGLE_TABLE

VARCHAR2(5)

Y if the cluster is single table; N if not

Column	Datatype	NULL	Description
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
OWNER	VARCHAR2(30)	NOT NULL	The owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	The 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
SINGLE_TABLE	VARCHAR2(5)		Y if the cluster is single table; N if not

ALL_CLUSTER_HASH_EXPRESSIONS

This view list hash functions for all accessible clusters.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Name of the owner of the cluster

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

The name of the cluster

HASH_EXPRESSION

LONG

Text of hash function of cluster

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	The name of the cluster
HASH_EXPRESSION	LONG		Text of hash function of cluster

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

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 were granted with ADMIN OPTION; otherwise NO

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 were 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

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

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

ELEM_STORAGE

VARCHAR2(7)

Storage optimization specification for VARRAY of numeric elements

NULLS_STORED

VARCHAR2(3)

Is null information stored with each VARRAY element?

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
ELEM_STORAGE	VARCHAR2(7)		Storage optimization specification for VARRAY of numeric elements
NULLS_STORED	VARCHAR2(3)		Is null information stored with each VARRAY element?

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

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

Note: If you create a constraint on a user-defined REF column, the system creates the constraint on the exploded columns that make up the REF column and hence column names of the constraint will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.

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.

RELY

VARCHAR2(4)

If set, this flag will be used in the optimizer

LAST_CHANGE

DATE

Indicates when the constraint was last enabled or disabled

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.
RELY	VARCHAR2(4)		If set, this flag will be used in the optimizer
LAST_CHANGE	DATE		Indicates when the constraint was last enabled or disabled

ALL_CONTEXT

This view lists active context information.

Column Datatype NULL Description

NAMESPACE

VARCHAR2(30)

NOT NULL

The name of the context namespace

SCHEMA

VARCHAR2(30)

NOT NULL

The schema name of the designated package which can set attributes using this namespace

PACKAGE

VARCHAR2(30)

NOT NULL

The package name of the designated package which can set attributes using this namespace

Column	Datatype	NULL	Description
NAMESPACE	VARCHAR2(30)	NOT NULL	The name of the context namespace
SCHEMA	VARCHAR2(30)	NOT NULL	The schema name of the designated package which can set attributes using this namespace
PACKAGE	VARCHAR2(30)	NOT NULL	The package name of the designated package which can set attributes using this namespace

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

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

ALL_DEF_AUDIT_OPTS

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

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

ALL_DEPENDENCIES

This view lists dependencies between objects accessible to the user. Dependencies on views created without any database links are also available.

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: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER

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

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: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
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_DIMENSIONS

This view represents dimension objects.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

INVALID

VARCHAR2(1)

'Y' if this dimension is in an invalid state, else 'N'

REVISION

NUMBER

Dimension revision level

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
INVALID	VARCHAR2(1)		'Y' if this dimension is in an invalid state, else 'N'
REVISION	NUMBER		Dimension revision level

ALL_DIM_ATTRIBUTES

This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
LEVEL_NAME	VARCHAR2(30)		Name of the hierarchy level
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Dependent column name
INFERRED	CHAR(1)		Whether inferred

ALL_DIM_CHILD_OF

This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

HIERARCHY_NAME

VARCHAR2(30)

Hierarchy name

POSITION

NUMBER

NOT NULL

Hierarchical position within this hierarchy, position 1 being the most detailed

CHILD_LEVEL_NAME

VARCHAR2(30)

Child side of 1:n relationship

JOIN_KEY_ID

VARCHAR2(40)

If non-null, then the child joins to the parent

PARENT_LEVEL_NAME

VARCHAR2(30)

Parent side of 1:n relationship

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
HIERARCHY_NAME	VARCHAR2(30)		Hierarchy name
POSITION	NUMBER	NOT NULL	Hierarchical position within this hierarchy, position 1 being the most detailed
CHILD_LEVEL_NAME	VARCHAR2(30)		Child side of 1:n relationship
JOIN_KEY_ID	VARCHAR2(40)		If non-null, then the child joins to the parent
PARENT_LEVEL_NAME	VARCHAR2(30)		Parent side of 1:n relationship

ALL_DIM_HIERARCHIES

This view represents a dimension hierarchy.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
HIERARCHY_NAME	VARCHAR2(30)		Hierarchy name

ALL_DIM_JOIN_KEY

This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

DIM_KEY_ID

NUMBER

NOT NULL

Unique within a dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

HIERARCHY_NAME

VARCHAR2(30)

Name of the key column

CHILD_JOIN_COLUMN

VARCHAR2(30)

NOT NULL

Name of the join column

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
DIM_KEY_ID	NUMBER	NOT NULL	Unique within a dimension
LEVEL_NAME	VARCHAR2(30)		Name of the hierarchy level
KEY_POSITION	NUMBER	NOT NULL	Ordinal position of the key column within the level
HIERARCHY_NAME	VARCHAR2(30)		Name of the key column
CHILD_JOIN_COLUMN	VARCHAR2(30)	NOT NULL	Name of the join column

ALL_DIM_LEVELS

This view represents a dimension level. All columns of a dimension level must come from the same relation.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Unique within a dimension

NUM_COLUMNS

NUMBER

Number of columns in the level definition

DETAILOBJ_OWNER

VARCHAR2(30)

NOT NULL

Owner of the detail object that the keys of this level come from

DETAILOBJ_NAME

VARCHAR2(30)

NOT NULL

Name of the table that the keys of this level come from

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
LEVEL_NAME	VARCHAR2(30)		Unique within a dimension
NUM_COLUMNS	NUMBER		Number of columns in the level definition
DETAILOBJ_OWNER	VARCHAR2(30)	NOT NULL	Owner of the detail object that the keys of this level come from
DETAILOBJ_NAME	VARCHAR2(30)	NOT NULL	Name of the table that the keys of this level come from

ALL_DIM_LEVEL_KEY

This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the key column

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
LEVEL_NAME	VARCHAR2(30)		Name of the hierarchy level
KEY_POSITION	NUMBER	NOT NULL	Ordinal position of the key column within the level
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the key column

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

DESCEND

VARCHAR2(4)

Y/N, Y if this column is sorted in descending order

Note: If you create an index on a user-defined REF column, the system creates the index on the exploded columns that make up the REF column and hence column names of the index will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.

ALL_IND_EXPRESSIONS

This view lists functional index expressions 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_EXPRESSION

LONG

Functional index expression defining the column

COLUMN_POSITION

NUMBER

NOT NULL

Position of column or attribute within index

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)

Index owner

INDEX_NAME

VARCHAR2(30)

Index name

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

HIGH_VALUE

LONG

Partition bound value expression

HIGH_VALUE_LENGTH

NUMBER

Length of partition bound value expression

PARTITION_POSITION

NUMBER

Position of the partition within the index

STATUS

VARCHAR2(8)

Indicates whether index partition is usable or not

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace containing the partition

PCT_FREE

NUMBER

Minimum percentage of free 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_EXTENT

NUMBER

Minimum number of extents allowed in the segment

MAX_EXTENT

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

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

ALL_IND_SUBPARTITIONS

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

Column Datatype NULL Description

INDEX_OWNER

VARCHAR2(30)

NOT NULL

The owner of the index

INDEX_NAME

VARCHAR2(30)

NOT NULL

Index name

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_NAME

VARCHAR2(30)

Subpartition name

SUBPARTITION_POSITION

NUMBER

NOT NULL

Position of a subpartition within a partition

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_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

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

COMPRESSION

VARCHAR2(11)

Enabled or disabled

PREFIX_LENGTH

NUMBER

The number of columns in the prefix of the key used for compression

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, VALID or INPROGS (a DDL operation on the domain index is in progress).

DOMIDX_STATUS

VARCHAR

Reflects the status of the domain index. A NULL value means that the specified index is not a domain index. A Value of VALID means that the index is a domain index and the index does not have any errors. If the value of this column is IDXTYP_INVLD it means that the indextype corresponding to this domain index is invalid.

DOMIDX_OPSTATUS

VARCHAR

Reflects the status of an operation that was performed on the domain index. A value of NULL indicates that the specified index is not a domain index. A value of VALID specifies that the index does not have any errors. A value of FAILED indicates that the operation that was performed on the domain index failed with an error.

FUNCIDX_STATUS

VARCHAR

A value of NULL indicates a non function-based index. ENABLED indicates the function-based index is enabled. DISABLED indicates the function-based index is disabled.

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?

SECONDARY

VARCHAR2(1)

Is the index object created as part of icreate for domain indexes?

BUFFER_POOL

VARCHAR2(7)

Name of the default buffer pool for the appropriate object

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

The duration

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

ALL_INDEXTYPES

This view lists all the indextypes.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the indextype

INDEXTYPE_NAME

VARCHAR2(30)

NOT NULL

Name of the indextype

IMPLEMENTATION
_SCHEMA

VARCHAR2(30)

NOT NULL

Name of the schema for indextype implementation

IMPLEMENTATION_NAME

VARCHAR2(30)

NOT NULL

Name of indextype implementation

IMPLEMENTATION_VERSION

NUMBER

NOT NULL

Version of indextype implementation

NUMBER_OF_OPERATORS

NUMBER

Number of operators associated with the indextype

ALL_INDEXTYPE_OPERATORS

This view lists all the operators supported by indextypes.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the indextype

INDEXTYPE_NAME

VARCHAR2(30)

NOT NULL

Name of the indextype

OPERATOR_NAME

VARCHAR2(30)

NOT NULL

Name of the operator for which the indextype is defined

BINDING#

NUMBER

NOT NULL

Binding# associated with the operator

ALL_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

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

INSTANCE

NUMBER

Indicates which instance can execute or is executing the job; the default is 0

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_LOB_PARTITIONS

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

ALL_LOB_SUBPARTITIONS

This view displays partition-level attributes of LOB data subpartitions.

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_MVIEW_AGGREGATES

This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.

Column Datatype Null Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view index

MVIEW_NAME

VARCHAR2(30)

NOT NULL

Materialized view name

POSITION_IN_SELECT

NUMBER

NOT NULL

Position of this measure within the SELECT list

CONTAINER_COLUMN

VARCHAR2(30)

NOT NULL

Name of this column in the container table

AGG_FUNCTION

VARCHAR2(8)

Aggregation function

DISTINCTFLAG

VARCHAR2(1)

Set to Y if DISTINCT aggregation

MEASURE

LONG

Contains the SQL text of the measure, excluding the aggregation function. Equal to * for COUNT(*)

ALL_MVIEW_ANALYSIS

This view represents the materialized views that potentially support query rewrite and that have additional information that is available for analysis by applications. This view excludes any materialized view that references a remote table or that includes a reference to a non-static value such as SYSDATE or USER. It also excludes any materialized view that was created as a snapshot prior to Oracle8.1 and that was never altered to enable query rewrite.

Column Datatype Null Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view

MVIEW_NAME

VARCHAR2(30)

NOT NULL

Materialized view name

MVIEW_TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view table object

CONTAINER_NAME

VARCHAR2(30)

Name of the snapshot that the materialized view data is contained in

LAST_REFRESH_SCN

NUMBER

The System Change Number

LAST_REFRESH_DATE

DATE

SYSDATE of the last refresh

REFRESH_METHOD

VARCHAR2(8)

FORCE, FAST, COMPLETE, or NONE

SUMMARY

VARCHAR2(1)

Y if this materialized view includes a GROUP BY clause or aggregation, else N

FULLREFRESHTIM

NUMBER

Approximate refresh time, in seconds (defined only when summary = Y for full refresh

INCREFRESHTIM

NUMBER

Approximate refresh time, in seconds (defined only when summary = Y for full refresh

CONTAINS_VIEWS

VARCHAR2(1)

Y if this materialized view contains a view in its definition, else N

UNUSABLE

VARCHAR2(1)

Y if this materialized view is in an unusable state (inconsistent data), else N. A materialized view can be in an unusable state if a system failure occurs during a full refresh

RESTRICTED_SYNTAX

VARCHAR2(1)

Y if this materialized view uses restricted materialized view syntax, else N

INC_REFRESHABLE

VARCHAR2(1)

Y if this materialized view can be incrementally refreshed, else N

KNOWN_STALE

VARCHAR2(1)

Y if the data contained in the materialized view is known to be inconsistent with the detail data, else N

INVALID

VARCHAR2(1)

Y if this materialized view is in an invalid state (inconsistent metadata), else N

QUERY_LEN

NUMBER

NOT NULL

The length of the query field

QUERY

LONG

NOT NULL

SELECT expression of the materialized view definition

REVISION

NUMBER

The materialized view metadata revision level

ALL_MVIEW_DETAIL_RELATIONS

This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.

Column Datatype Null Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view

MVIEW_NAME

VARCHAR2(30)

NOT NULL

Materialized view name

DETAILOBJ_OWNER

VARCHAR2(30)

NOT NULL

Detail object owner

DETAILOBJ_NAME

VARCHAR2(30)

NOT NULL

Detail object name, eg, the name of a table or view

DETAILOBJ_TYPE

VARCHAR2(9)

TABLE, VIEW, MATERIALIZED VIEW, or SNAPSHOT

DETAILOBJ_ALIAS

VARCHAR2(30)

Implicit or explicit alias for detail relation

ALL_MVIEW_JOINS

This view represents a join between two columns in the WHERE clause of a materialized view.

Column Datatype Null Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view

MVIEW_NAME

VARCHAR2(30)

NOT NULL

Materialized view name

POSITION_IN_SELECT

NUMBER

NOT NULL

Position of this key within the SELECT list

CONTAINER_COLUMN

VARCHAR2(30)

NOT NULL

The name of the column in the container table

DETAILOBJ_OWNER

VARCHAR2(30)

NOT NULL

Detail object owner

DETAILOBJ_NAME

VARCHAR2(30)

NOT NULL

Detail object name, eg, the name of a table or view

DETAILOBJ_TYPE

VARCHAR2(5)

VIEW or TABLE

DETAILOBJ_ALIAS

VARCHAR2(30)

Implicit or explicit alias for detail relation

DETAILOBJ_COLUMN

VARCHAR2(30)

NOT NULL

Name of the detail relation column

ALL_MVIEW_KEYS

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

STORAGE_SPEC

VARCHAR2(30)

Indication of default or user-specified storage for the varray

RETURN_TYPE

VARCHAR2(20)

Return type of the varray column locator or value

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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?

SECONDARY

VARCHAR2(1)

Is this table object created as part of icreate for domain indexes?

NESTED

VARCHAR2(3)

Is the table a nested table?

BUFFER_POOL

VARCHAR2(7)

The default buffer pool to be used for table blocks

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is enabled or disabled

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

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 of the object (eg, TABLE, INDEX)

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?

SECONDARY

VARCHAR2(1)

Is this a secondary object created as part of create for domain indexes?

ALL_OPANCILLARY

This view lists ancillary information for operators.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of ancillary operator

OPERATOR_NAME

VARCHAR2(30)

NOT NULL

Name of ancillary operator

BINDING#

NUMBER

NOT NULL

Binding number of ancillary operator

PRIMOP_OWNER

VARCHAR2(30)

NOT NULL

Owner of primary operator

PRIMOP_NAME

VARCHAR2(30)

NOT NULL

Name of primary operator

PRIMOP_BIND#

NUMBER

NOT NULL

Binding number of primary operator

ALL_OPARGUMENTS

This view lists argument information for operator bindings.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the operator argument

OPERATOR_NAME

VARCHAR2(30)

NOT NULL

Name of the operator argument

BINDING#

NUMBER

NOT NULL

Binding number of the operator argument

POSITION

NUMBER

NOT NULL

Position of the operator argument

ARGUMENT_TYPE

VARCHAR2(61)

Datatype of the operator argument

ALL_OPBINDINGS

This view lists operator bindings.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the operator

OPERATOR_NAME

VARCHAR2(30)

NOT NULL

Name of the operator

BINDING#

NUMBER

NOT NULL

Binding number of the operator

FUNCTION_NAME

VARCHAR2(92)

Name of the binding function or method as specified by the user

RETURN_SCHEMA

VARCHAR2(30)

Name of the schema of the return type - not null only for ADTs

RETURN_TYPE

VARCHAR2(30)

Name of the return type

IMPLEMENTATION_TYPE_SCHEMA

VARCHAR2(30)

Schema of the implementation type of the indextype

IMPLEMENTATION_TYPE

VARCHAR2(30)

Implementation type of the indextype

ALL_OPERATORS

This view lists operators.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the operator

OPERATOR_NAME

VARCHAR2(30)

NOT NULL

Name of the operator

NUMBER_OF_BINDS

NUMBER

NOT NULL

Number of bindings associated with the operator

ALL_OUTLINE_HINTS

This view lists the set of hints which make up the outlines.

Column Datatype NULL Description

NAME

VARCHAR2(30)

Name of the outline

NODE

NUMBER

I.D. of the query or subquery to which the hint applies. The top-level query is labelled 1. Subqueries are assigned sequentially numbered labels, starting with 2

JOIN_POS

NUMBER

Position of the table in the join order. The JOIN_POS column is 0 for all hints except the access method hints. The access method hints identify a table to which the hint and the join position apply

HINT

VARCHAR2(512)

Text of the hint

ALL_OUTLINES

This view lists information about outlines.

Column Datatype NULL Description

NAME

VARCHAR2(30)

The user-specified or generated name of the stored outline. The name must be of a form that can be expressed in SQL

CATEGORY

VARCHAR2(30)

A user-defined name used to group outlines into collections

USED

VARCHAR2(9)

Flag indicating whether the outline has ever been used

TIMESTAMP

DATE

Timestamp at which the outline was created

VERSION

VARCHAR2(64)

Oracle Version that created the outline

SQL_TEXT

LONG

SQL text of the query-including any hints that were a part of the original statement. If bind variables are included, the variable names are stored as SQL text, not the values that are assigned to the variables

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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.

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_LOBS

This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.

ALL_PART_TABLES

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

ALL_PARTIAL_DROP_TABS

This view describes tables which have partially dropped tables.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

ALL_POLICIES

This view is a list of all policies on all tables and views that the user has access to.

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table or view

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of the table or view

POLICY_NAME

VARCHAR2(30)

NOT NULL

Name of the policy

PF_OWNER

VARCHAR2(30)

NOT NULL

Owner of the policy function

PACKAGE

VARCHAR2(30)

Name of the package containing the policy function

FUNCTION

VARCHAR2(30)

NOT NULL

Name of the policy function

SEL

VARCHAR2(3)

If YES, policy is applied to query on the object

INS

VARCHAR2(3)

If YES, policy is applied to insert on the object

UPD

VARCHAR2(3)

If YES, policy is applied to update on the object

DEL

VARCHAR2(3)

If YES, policy is applied to delete on the object

CHK_OPTION

VARCHAR2(3)

Is check option enforced for this policy?

ENABLE

VARCHAR2(3)

Is this policy enabled?

ALL_QUEUES

This view displays information of the queues the user has enqueue or dequeue privilege on. If the user has any of the Advanced Queuing system privileges, like MANAGE ANY QUEUE, ENQUEUE ANY QUEUE or DEQUEUE ANY QUEUE, then all queues in the database will be displayed.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the queue

NAME

VARCHAR2(30)

NOT NULL

Name of the queue

QUEUE_TABLE

VARCHAR2(30)

NOT NULL

Name of the table the queue data resides in

QID

NUMBER

NOT NULL

Object number of the queue

QUEUE_TYPE

VARCHAR2(15)

Type of the queue

MAX_RETRIES

NUMBER

Maximum number of retries allowed when dequeuing from the queue

RETRY_DELAY

NUMBER

Time interval between retries

ENQUEUE_ENABLED

VARCHAR2(7)

Queue is enabled for enqueue

DEQUEUE_ENABLED

VARCHAR2(7)

Queue is enabled for dequeue

RETENTION

VARCHAR2(40)

Time interval processed messages retained in the queue

USER_COMMENT

VARCHAR2(50)

User specified comment

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_REFRESH_DEPENDENCIES

This view lists the names of the dependent detail or container tables of all the summaries or snapshots in the current schema.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table name, unique within this schema

PARENT_OBJECT_TYPE

CHAR(7)

'SNAPSHOT' or 'SUMMARY'

OLDEST_REFRESH_SCN

NUMBER

The minimum SCN of any summary or snapshot that has TABLE_NAME as a detail table

OLDEST_REFRESH_DATE

DATE

SYSDATE when last refreshed

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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 Oracle8i Replication.

ALL_REPCOLUMN

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

ALL_REPCOLUMN_GROUP

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

ALL_REPCONFLICT

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

ALL_REPDDL

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

ALL_REPGENERATED

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

ALL_REPGENOBJECTS

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

ALL_REPGROUP

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

ALL_REPGROUPED_COLUMN

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

ALL_REPKEY_COLUMNS

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

ALL_REPOBJECT

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

ALL_REPPARAMETER_COLUMN

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

ALL_REPPRIORITY

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

ALL_REPPRIORITY_GROUP

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

ALL_REPPROP

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

ALL_REPRESOLUTION

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

ALL_REPRESOL_STATS_CONTROL

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

ALL_REPRESOLUTION_METHOD

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

ALL_REPRESOLUTION_STATISTICS

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

ALL_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8i 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 Oracle8i Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserted 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 Oracle8i 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 Oracle8i 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

STATUS

VARCHAR2(7)

The status of the contents of the snapshot

REFRESH_MODE

VARCHAR2(8)

This indicates how and when the snapshot will be refreshed

PREBUILT

VARCHAR2(3)

If YES, this snapshot uses a prebuilt table as the base table

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_SUBPART_COL_STATISTICS

This view lists column statistics and histogram information for table subpartitions.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner name

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table name

SUBPARTITION_NAME

VARCHAR2(30)

Table subpartition 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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying subpartitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

ALL_SUBPART_HISTOGRAMS

This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.

SUB

Column Datatype NULL Description

OWNER

VARCHAR2(30)

Owner name

TABLE_NAME

VARCHAR2(30)

Table name

SUBPARTITION_NAME

VARCHAR2(30)

Table subpartition name

COLUMN_NAME

VARCHAR2(30)

Column name

BUCKET_NUMBER

NUMBER

Bucket number

ENDPOINT_VALUE

NUMBER

Normalized endpoint values for this bucket

ALL_SUBPART_KEY_COLUMNS

This view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

The partitioned table or index owner

NAME

VARCHAR2(30)

The partitioned table or index name

OBJECT_TYPE

VARCHAR2(11)

The object type (TABLE or INDEX)

COLUMN_NAME

VARCHAR2(30)

The column name

COLUMN_POSITION

NUMBER

The position of the column within the subpartitioning key

ALL_SUMDELTA

This view lists direct path load entries accessible to the user.

Column Datatype NULL Description

TABLEOBJ#

NUMBER

NOT NULL

Object number of the table

PARTITIONOBJ#

NUMBER

NOT NULL

Object number of table partitions (if the table is partitioned)

DMLOPERATION

VARCHAR2(1)

Type of DML operation applied to the table

SCN

NUMBER

NOT NULL

SCN when the bulk DML occurred

TIMESTAMP

DATE

NOT NULL

Timestamp of log entry

LOWROWID

ROWID

NOT NULL

The start ROWID in the loaded rowid range

HIGHROWID

ROWID

NOT NULL

The end ROWID in the loaded rowid range

ALL_SUMMARIES

This view represents a summary object.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the synonym

SUMMARY_NAME

VARCHAR2(30)

NOT NULL

Name of the synonym

CONTAINER_OWNER

VARCHAR2(30)

NOT NULL

Owner of the container object

CONTAINER_NAME

VARCHAR2(30)

Name of the table or snapshot that the summary data is contained in

CONTAINER_TYPE

VARCHAR2(9)

'TABLE' or 'SNAPSHOT'

LAST_REFRESH_SCN

NUMBER

System Change Number

LAST_REFRESH_DATE

DATE

SYSDATE of last refresh

REFRESH_METHOD

VARCHAR2(11)

'ANY', 'INCREMENTAL', 'FULL', or 'NONE'

FULLREFRESHTIM

NUMBER

The time that it took to fully refresh the summary

INCREFRESHTIM

NUMBER

The time that it took to incrementally refresh the summary

CONTAINS_VIEWS

VARCHAR2(1)

This summary contains views in the FROM clause

UNUSABLE

VARCHAR2(1)

This summary is unusable, the build was deferred

RESTRICTED_SYNTAX

VARCHAR2(1)

Y if this summary uses restricted syntax, else 'N'

INC_REFRESHABLE

VARCHAR2(1)

Y if this summary can be incrementally refreshed, else 'N

KNOWN_STALE

VARCHAR2(1)

Y if the data contained in this summary is known to be inconsistent with the detail data, and 'N' otherwise

QUERY_LEN

NUMBER

NOT NULL

Length of the query field

QUERY

LONG

NOT NULL

SELECT expression of the summary definition

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

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

ALL_TAB_COMMENTS

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

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

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

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

GLOBAL_STATS

VARCHAR2(3)

Global statistics

USER_STATS

VARCHAR2(3)

User statistics

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.

ALL_TAB_SUBPARTITIONS

This view describes, for each table subpartition, its name, name of the table and partition to which it belongs, and its storage attributes. Note that statistics will not be collected on a per-subpartition basis.

ALL_TABLES

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

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 STATEMENT, BEFORE EACH ROW, BEFORE EVENT, AFTER STATEMENT, AFTER EACH ROW, and AFTER EVENT

TRIGGERING_EVENT

VARCHAR2(75)

Events that fire the trigger: INSERT, UPDATE, DELETE, STARTUP, SHUTDOWN, ERROR, LOGON, LOGOFF, CREATE, ALTER, DROP

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table on which the trigger is defined

BASE_OBJECT_TYPE

VARCHAR2(16)

The base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASE

TABLE_NAME

VARCHAR2(30)

If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, this columns indicates the table/view name on which the trigger is defined

COLUMN_NAME

VARCHAR2(30)

Name of the nested table column (if nested table trigger), else null

REFERENCING_NAMES

VARCHAR2(87)

Names used for referencing OLD and NEW column values from within the trigger

WHEN_CLAUSE

VARCHAR2(4000)

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.

ACTION_TYPE

VARCHAR2(11)

The action type of the trigger body: CALL or PL/SQL

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

ATTR_NO

NUMBER

NOT NULL

Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number)

ALL_TYPE_METHODS

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

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_UNUSED_COL_TABS

This view contains a description of all tables containing unused columns.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

The owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

The name of the table

COUNT

NUMBER

The number of unused columns

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_USTATS

This view contains information about the current user.

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(30)

Owner of the table or index for which the statistics have been collected

OBJECT_NAME

VARCHAR2(30)

Name of the table or index for which the statistics have been collected

PROPERTY

VARCHAR2(6)

Property of the object - column or index

COLUMN_NAME

VARCHAR2(30)

Column name, if property is column for which statistics have been collected

STATSTYPE_SCHEMA

VARCHAR2(30)

Schema of statistics type which was used to collect the statistics

STATSTYPE_NAME

VARCHAR2(30)

Name of statistics type which was used to collect statistics

STATISTICS

RAW(2000)

User collected statistics for the object

ALL_VARRAYS

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

Column Datatype NULL Description

OWNER

VARCHAR2(30)

Owner of the table containing the varray

PARENT_TABLE_NAME

VARCHAR2(30)

Name of the containing table

PARENT_TABLE_COLUMN

VARCHAR2(4000)

Name of the varray column or attribute

TYPE_OWNER

VARCHAR2(30)

Owner of the varray type

TYPE_NAME

VARCHAR2(30)

Name of the varray type

LOB_NAME

VARCHAR2(30)

Name of the LOB if the varray is stored in a LOB

STORAGE_SPEC

VARCHAR2(30)

DEFAULT value indicates that the storage was defaulted. USER_SPECIFIED value indicates that the storage was user-specified

RETURN_TYPE

VARCHAR2(20)

Return type of the column

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

CHAINED_ROWS

Stores the output for the ANALYZE command with the CHAINED ROWS option.

Column Description

OWNER_NAME

Table owner

TABLE_NAME

Table name

CLUSTER_NAME

Cluster the table is in, if any

PARTITION_NAME

The name of the partition

SUBPARTITION_NAME

The name of the subpartition

HEAD_ROWID

ROWID the chained row is accessed by

ANALYZE_TIMESTAMP

Date/time that the ANALYZE command was issued

CLU

This is a synonym for USER_CLUSTERS. For more information, see "USER_CLUSTERS".

CODE_PIECES

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".

CODE_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".

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

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.

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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?

SECONDARY

VARCHAR2(1)

Is the index object created as part of icreate for domain indexes?

NESTED

VARCHAR2(3)

Is the table a nested table?

BUFFER_POOL

VARCHAR2(7)

The default buffer pool to be used for table blocks

ROW_MOVEMENT

VARCHAR2(8)

The movement of the row

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

DBA_ANALYZE_OBJECTS

This view lists analyze objects.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

The owner

OBJECT_NAME

VARCHAR2(30)

NOT NULL

The object name

OBJECT_TYPE

VARCHAR2(7)

The object type

DBA_ASSOCIATIONS

This view lists user-defined statistics information.

DBA_AUDIT_EXISTS

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

DBA_AUDIT_OBJECT

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

DBA_AUDIT_SESSION

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

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

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
Also indicates how the user was authenticated. The method can be one of the following:
DATABASE - authentication was done by password
NETWORK - authentication was done by Net8 or the Advanced Security option
PROXY - the client was authenticated by another user. The name of the proxy user follows the method type

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

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.

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

SINGLE_TABLE

VARCHAR2(5)

Y if the cluster is single table; N if not

DBA_CLUSTER_HASH_EXPRESSIONS

This view list hash functions for all clusters.

This view list all clusters accessible to the user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Name of owner of cluster

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

Name of cluster

HASH_EXPRESSION

LONG

Text of hash function of cluster

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

ELEM_STORAGE

VARCHAR2(7)

Storage optimization specification for VARRAY of numeric elements

NULLS_STORED

VARCHAR2(3)

Is null information stored with each VARRAY element?

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)

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.

RELY

VARCHAR2(4)

If set, this flag will be used in the optimizer

LAST_CHANGE

DATE

Indicates when the constraint was last enabled or disabled

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_CONTEXT

This view lists all context namespaces information.

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

USER_BYTES

NUMBER

Corresponding number of bytes

USER_BLOCKS

NUMBER

Number of blocks which can be used by the data

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. Dependencies on views created without any database links are also available.

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: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY.

REFERENCED_OWNER

VARCHAR2(30)

Owner of referenced object (remote owner if remote object)

REFERENCED_NAME

VARCHAR2(64)

Type of parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY

REFERENCED_TYPE

VARCHAR2(12)

Type of referenced object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY.

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_DIMENSIONS

This view represents dimension objects.

DBA_DIM_ATTRIBUTES

This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.

DBA_DIM_CHILD_OF

This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.

DBA_DIM_JOIN_KEY

This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.

DBA_DIM_HIERARCHIES

This view represents a dimension hierarchy.

DBA_DIM_LEVELS

This view represents a dimension level. All columns of a dimension level must come from the same relation.

DBA_DIM_LEVEL_KEY

This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the key column

DBA_DIRECTORIES

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

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, "Lock Modes for the DBA_DML_LOCKS View"

MODE_REQUESTED

VARCHAR2(13)

Lock request type: see Table 2-1, "Lock Modes for the DBA_DML_LOCKS View"

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

COMPRESSION

VARCHAR2(11)

Enabled or disabled

PREFIX_LENGTH

NUMBER

The number of columns in the prefix of the key used for compression

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)

State of the index: DIRECT LOAD, VALID or INPROGS (a DDL operation on the domain index is in progress).

DOMIDX_STATUS

VARCHAR

Reflects the status of the domain index. A NULL value means that the specified index is not a domain index. A Value of VALID means that the index is a domain index and the index does not have any errors. If the value of this column is IDXTYP_INVLD it means that the indextype corresponding to this domain index is invalid.

DOMIDX_OPSTATUS

VARCHAR

Reflects the status of an operation that was performed on the domain index. A value of NULL indicates that the specified index is not a domain index. A value of VALID specifies that the index does not have any errors. A value of FAILED indicates that the operation that was performed on the domain index failed with an error.

FUNCIDX_STATUS

VARCHAR

A value of NULL indicates a non function-based index. ENABLED indicates the function-based index is enabled. DISABLED indicates the function-based index is disabled.

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?

SECONDARY

VARCHAR2(1)

Is the index object created as part of icreate for domain indexes?

BUFFER_POOL

VARCHAR2(7)

Name of the default buffer pool for the appropriate object

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

The duration

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

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

DESCEND

VARCHAR2(4)

Y/N, Y if this column is sorted in descending order

DBA_IND_EXPRESSIONS

This view lists functional index expressions 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_EXPRESSION

LONG

Functional index expression defining the column

COLUMN_POSITION

NUMBER

NOT NULL

Position of column or attribute within index

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

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

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

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

DBA_IND_SUBPARTITIONS

DBA_INDEXTYPES

This view lists all the indextypes.

DBA_INDEXTYPE_OPERATORS

This view lists all the operators supported by indextypes.

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

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

INSTANCE

NUMBER

Indicates which instance can execute or is executing the job; the default is 0

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

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.

INSTANCE

NUMBER

Indicates which instance can execute or is executing the job; the default is 0

DBA_LIBRARIES

This view lists all the libraries in the database.

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_LOB_PARTITIONS

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

DBA_LOB_SUBPARTITIONS

This view displays partition-level attributes of LOB data subpartitions.

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_LOCK_INTERNAL

This view has a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.

Column Datatype NULL Description

SESSION_ID

NUMBER

Session holding or acquiring the lock

LOCK_TYPE

VARCHAR2(56)

Lock type

MODE HELD

VARCHAR2(40)

Lock mode

MODE REQUESTED

VARCHAR2(40)

Lock mode requested

LOCK_ID1

VARCHAR2(1130)

Type-specific lock identifier, part 1

LOCK_ID2

VARCHAR2(40)

Type-specific lock identifier, part 2

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_MVIEW_AGGREGATES

This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.

DBA_MVIEW_ANALYSIS

This view represents the materialized views that potentially support query rewriting and that have additional information that is available for analysis by applications. This view excludes any materialized view that references a remote table or that includes a reference to a non-static value such as SYSDATE or USER. It does show all materialized views upon which Oracle would allow ENABLE QUERY REWRITE, not just those that are actually enabled for query rewrite.

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_JOINS

This view represents a join between two columns in the WHERE clause of a materialized view.

DBA_MVIEW_KEYS

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

STORAGE_SPEC

VARCHAR2(30)

Indication of default or user-specified storage for the varray

RETURN_TYPE

VARCHAR2(20)

Return type of the varray column locator or value

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: "TYPE", "TYPE BODY", "TABLE", "VIEW", "SYNONYM", "SEQUENCE", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "JAVA SOURCE", "JAVA CLASS" or "JAVA RESOURCE"

SOURCE_SIZE

NUMBER

Size of the source in bytes. Must be in memory during compilation, or dynamic recompilation

PARSED_SIZE

NUMBER

Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object

CODE_SIZE

NUMBER

Code size, in bytes. Must be in memory when this object is executing

ERROR_SIZE

NUMBER

Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is enabled or disabled

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

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 of the object (eg, TABLE, INDEX)

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?

SECONDARY

VARCHAR2(1)

Is this a secondary object created as part of icreate for domain indexes

DBA_OBJ_AUDIT_OPTS

This view lists auditing options for all objects owned by a user.

DBA_OPANCILLARY

This view lists ancillary information for operator bindings.

DBA_OPARGUMENTS

This view lists argument information for operator bindings.

DBA_OPBINDINGS

This view lists operator bindings.

DBA_OPERATORS

This view lists operators.

DBA_OUTLINE_HINTS

This view lists the set of hints which make up the outlines.

Column Datatype NULL Description

NAME

VARCHAR2(30)

Name of the outline

OWNER

VARCHAR2(30)

The name of the user who created the outline

NODE

NUMBER

I.D. of the query or subquery to which the hint applies. The top-level query is labelled 1. Subqueries are assigned sequentially numbered labels, starting with 2

JOIN_POS

NUMBER

Position of the table in the join order. The JOIN_POS column is 0 for all hints except the access method hints. The access method hints identify a table to which the hint and the join position apply

HINT

VARCHAR2(512)

Text of the hint

DBA_OUTLINES

This view lists information about outlines.

Column Datatype NULL Description

NAME

VARCHAR2(30)

The user-specified or generated name of the stored outline. The name must be of a form that can be expressed in SQL

OWNER

VARCHAR2(30)

The name of the user who created the outline

CATEGORY

VARCHAR2(30)

A user-defined name used to group outlines into collections

USED

VARCHAR2(9)

Flag indicating whether the outline has ever been used

TIMESTAMP

DATE

Timestamp at which the outline was created

VERSION

VARCHAR2(64)

Oracle Version that created the outline

SQL_TEXT

LONG

SQL text of the query-including any hints that were a part of the original statement. If bind variables are included, the variable names are stored as SQL text, not the values that are assigned to the variables

DBA_PART_COL_STATISTICS

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

DBA_PART_HISTOGRAMS

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

DBA_PART_INDEXES

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

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_LOBS

This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.

DBA_PART_TABLES

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

DBA_PARTIAL_DROP_TABS

This view describes tables which have partially dropped tables.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

DBA_PENDING_TRANSACTIONS

This view gives information about unresolved transactions (either due to failure or if the co-ordinator has not sent a commit/rollback).

Column Datatype NULL Description

FORMATID

NUMBER

The format identifier of the transaction identifier

GLOBALID

RAW(64)

The global part (gtrid) of the transaction identifier

BRANCHID

RAW(64)

The branch qualifier (bqual) of the transaction identifier

DBA_POLICIES

This view lists policies.

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. ANY CLIENT if access by a proxy on behalf of a client is being audited
NULL for system-wide auditing

PROXY_NAME

VARCHAR2(30)

The name of the proxy user which is performing an operation for the client. NULL if the client is performing the operation directly

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

The schema

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(200)

Function to compute the start of the next propagation window

LATENCY

NUMBER

Maximum wait time to propagate a message during the propagation window

SCHEDULE_DISABLED

VARCHAR2(1)

N if enabled; Y if disabled and schedule will not be executed

PROCESS_NAME

VARCHAR2(8)

The name of the process executing the schedule. NULL if not currently executing

SESSION_ID

NUMBER

The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing

INSTANCE

NUMBER

The OPS instance number executing the schedule

LAST_RUN_DATE

DATE

The date on the last successful execution

LAST_RUN_TIME

VARCHAR2(8)

The time of the last successful execution in HH:MI:SS format

CURRENT_START_DATE

DATE

The date at which the current window of this schedule was started

CURRENT_START_TIME

VARCHAR2(8)

The time of day at which the current window of this schedule was started in HH:MI:SS format

NEXT_RUN_DATE

DATE

The date at which the next window of this schedule will be started

NEXT_RUN_TIME

VARCHAR2(8)

The time of day at which the next window of this schedule will be started in HH:MI:SS format

TOTAL_TIME

NUMBER

The total time, in seconds, spent by the system in executing this schedule

TOTAL_NUMBER

NUMBER

The total number of messages propagated in this schedule

TOTAL_BYTES

NUMBER

The total number of bytes propagated in this schedule

MAX_NUMBER

NUMBER

The maximum number of messages propagated in a propagation window

MAX_BYTES

NUMBER

The maximum number of bytes propagated in a propagation window

AVG_NUMBER

NUMBER

The average number of messages propagated in a propagation window

AVG_SIZE

NUMBER

The average size of a propagated message in bytes

AVG_TIME

NUMBER

The average time, in seconds, to propagate a message

FAILURES

NUMBER

The number of times the execution failed. If 16, the schedule will be disabled

LAST_ERROR_DATE

DATE

The date of the last unsuccessful execution

LAST_ERROR_TIME

VARCHAR2(8)

The time of the last unsuccessful execution

LAST_ERROR_MSG

VARCHAR2(4000)

The error number and error message text of the last unsuccessful execution

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 Oracle8i Application Developer's Guide - Fundamentals.

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

COMPATIBLE

VARCHAR2(5)

The lowest release level which this is compatible with (eg, 8.0.4)

PRIMARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the primary owner of the queue table. A value of 0 indicates that there is no primary owner

SECONDARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the secondary owner of the queue table. This instance becomes the owner of the queue table if the primary owner is not alive. A value of 0 indicates that there is no secondary owner

OWNER_INSTANCE

NUMBER

The instance number of the instance which currently owns the queue table

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 Oracle8i Application Developer's Guide - Fundamentals.

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
NON_PERSISTENT_QUEUE - Non-persistent 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.

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

HAS_REFERENTIAL
_CONS

VARCHAR2(3)

Yes or no for a referential constraint

REFERENTIAL_CONS
_NAME

VARCHAR2(30)

The name associated with the referential integrity constraint

DBA_REGISTERED_SNAPSHOT_GROUPS

This view lists all the snapshot repgroups at this site.

Column Datatype NULL Description

NAME

VARCHAR2(30)

Name of the snapshot replication group

SNAPSHOT_SITE

VARCHAR2(128)

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

FNAME

VARCHAR2(30)

Name of the flavor of the snapshot object group

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 Oracle8i Replication.

DBA_REPCAT_REFRESH_TEMPLATES

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

DBA_REPCAT_TEMPLATE_OBJECTS

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

DBA_REPCAT_TEMPLATE_PARMS

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

DBA_REPCAT_TEMPLATE_SITES

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

DBA_REPCAT_USER_AUTHORIZATIONS

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

DBA_REPCAT_USER_PARM_VALUES

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

DBA_REPCOLUMN

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

DBA_REPCOLUMN_GROUP

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

DBA_REPCONFLICT

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

DBA_REPDDL

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

DBA_REPGENERATED

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

DBA_REPGENOBJECTS

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

DBA_REPGROUP

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

DBA_REPGROUPED_COLUMN

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

DBA_REPKEY_COLUMNS

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

DBA_REPOBJECT

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

DBA_REPPARAMETER_COLUMN

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

DBA_REPPRIORITY

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

DBA_REPPRIORITY_GROUP

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

DBA_REPPROP

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

DBA_REPRESOLUTION

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

DBA_REPRESOLUTION_METHOD

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

DBA_REPRESOL_STATS_CONTROL

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

DBA_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8i 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_RSRC_CONSUMER_GROUP_PRIVS

This view lists all resource consumer groups and the users and roles to which they have been granted.

Column Datatype NULL Description

GRANTEE

VARCHAR2(30)

NOT NULL

User or role receiving the grant

GRANTED_GROUP

VARCHAR2(30)

Granted consumer group name

GRANT_OPTION

VARCHAR2(3)

Whether grant was with the GRANT option

INITIAL_GROUP

VARCHAR2(3)

Whether consumer group is designated as the default

DBA_RSRC_CONSUMER_GROUPS

This view lists all resource consumer groups which exist in the database.

Column Datatype NULL Description

CONSUMER_GROUP

VARCHAR2(30)

The consumer group name

CPU_METHOD

VARCHAR2(30)

The CPU resource allocation method for the consumer group

COMMENTS

VARCHAR2(2000)

A text comment on the consumer group

STATUS

VARCHAR2(30)

PENDING if it is part of the pending area, ACTIVE otherwise

MANDATORY

VARCHAR2(3)

Whether the consumer group is mandatory

DBA_RSRC_MANAGER_SYSTEM_PRIVS

This view lists all the users and roles which have been granted system privileges pertaining to the resource manager.

Column Datatype NULL Description

GRANTEE

VARCHAR2(30)

NOT NULL

User or role receiving the grant

PRIVILEGE

VARCHAR2(40)

NOT NULL

The name of the system privilege

ADMIN_OPTION

VARCHAR2(3)

Whether the grant was with the ADMIN option

DBA_RSRC_PLANS

This view lists all resource plans which exist in the database.

Column Datatype NULL Description

PLAN

VARCHAR2(30)

Plan name

NUM_PLAN_DIRECTIVES

NUMBER

The number of plan directives for the plan

CPU_METHOD

VARCHAR2(30)

The CPU resource allocation method for the plan

MAX_ACTIVE_SESS_TARGET
_MTH

VARCHAR2(30)

RESERVED FOR FUTURE USE

PARALLEL_DEGREE_LIMIT
_MTH

VARCHAR2(30)

The parallel degree limit resource allocation method for the plan

COMMENTS

VARCHAR2(2000)

A text comment on the plan

STATUS

VARCHAR2(30)

PENDING if it is part of the pending area, ACTIVE otherwise

MANDATORY

VARCHAR2(3)

Whether the plan is mandatory

DBA_RSRC_PLAN_DIRECTIVES

This view lists all resource plan directives which exist in the database.

DBA_RULESETS

This view lists information about rulesets.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

The user owning the ruleset

RULESET_NAME

VARCHAR2(30)

NOT NULL

The name of the ruleset

RULESET_STORAGE_TABLE

VARCHAR2(61)

The table in which the ruleset is stored (will be schema.table)

BASE_TABLE

VARCHAR2(61)

The table on which the rules are defined (will be schema.table)

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, CACHE, LOBSEGMENT and LOBINDEX

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 Oracle8i. 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_LOG_FILTER_COLS

This view lists all filter columns (excluding PK cols) being logged in the snapshot logs.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the master table being logged

NAME

VARCHAR2(30)

NOT NULL

Name of the master table being logged

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Filter column being logged

DBA_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

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

STATUS

VARCHAR2(7)

The status of the contents of the snapshot

REFRESH_MODE

VARCHAR2(8)

This indicates how and when the snapshot will be refreshed

PREBUILT

VARCHAR2(3)

If YES, this snapshot uses a prebuilt table as the base table

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. ANY CLIENT if access by a proxy on behalf of a client is being audited
NULL for system-wide auditing

PROXY_NAME

VARCHAR2(30)

The name of the proxy user which is performing an operation for the client. NULL if the client is performing the operation directly

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_SUBPART_COL_STATISTICS

This view lists column statistics and histogram information for table subpartitions.

DBA_SUBPART_HISTOGRAMS

This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.

DBA_SUBPART_KEY_COLUMNS

This view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.

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

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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

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.

LOW_VALUE

RAW(32)

HIGH_VALUE

RAW(32)

DENSITY

NUMBER

NUM_NULLS

NUMBER

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

SAMPLE_SIZE

The sample size used in analyzing this column

CHARACTER_SET
_NAME

VARCHAR2(44)

The name of the character set: CHAR_CS, NCHAR_CS

CHAR_COL_DECL
_LENGTH

NUMBER

Declaration length of character type column

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

Average column length in bytes

DBA_TAB_COMMENTS

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

DBA_TAB_HISTOGRAMS

This view lists histograms on columns of all tables.

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

ENDPOINT_NUMBER

NUMBER

Endpoint 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

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

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

GLOBAL_STATS

VARCHAR2(3)

The global statistics

USER_STATS

VARCHAR2(3)

The user statistics

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_TAB_SUBPARTITIONS

DBA_TABLES

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

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

EXTENT_MANAGEMENT

VARCHAR2(10)

Extent management tracking: "DICTIONARY" or "LOCAL"

ALLOCATION_TYPE

VARCHAR2(9)

Type of extent allocation in effect for this tablespace

PLUGGED_IN

VARCHAR2(3)

YES - the tablespace is plugged in; NO - it is not plugged in

DBA_TEMP_FILES

This view contains information about database temp files.

Column Datatype NULL Description

FILE_NAME

VARCHAR2(513)

Name of the database temp file

FILE_ID

NUMBER

ID of the database temp 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

Size of the file in ORACLE blocks

STATUS

CHAR(9)

File status: "AVAILABLE"

RELATIVE_FNO

NUMBER

Tablespace-relative file number

AUTOEXTENSIBLE

VARCHAR2(3)

Autoextensible indicator: "YES" or "NO"

MAXBYTES

NUMBER

maximum size of the file in bytes

MAXBLOCKS

NUMBER

Maximum size of the file in ORACLE blocks

INCREMENT_BY

NUMBER

Default increment for autoextension

USER_BYTES

NUMBER

Size of the useful portion of file in bytes

USER_BLOCKS

NUMBER

Size of the useful portion of file in ORACLE blocks

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 STATEMENT, BEFORE EACH ROW, BEFORE EVENT, AFTER STATEMENT, AFTER EACH ROW, and AFTER EVENT

TRIGGERING_EVENT

VARCHAR2(75)

Events that fire the trigger: INSERT, UPDATE, DELETE, STARTUP, SHUTDOWN, ERROR, LOGON, LOGOFF, CREATE, ALTER, DROP

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table on which the trigger is defined

BASE_OBJECT_TYPE

VARCHAR2(16)

The base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASE

TABLE_NAME

VARCHAR2(30)

If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, this columns indicates the table/view name on which the trigger is defined

COLUMN_NAME

VARCHAR2(30)

Name of the nested table column (if nested table trigger), else null

REFERENCING_NAMES

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.

ACTION_TYPE

VARCHAR2(11)

The action type of the trigger body: CALL or PL/SQL

TRIGGER_BODY

LONG

Statement(s) executed by the 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.

DBA_TYPE_METHODS

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

DBA_TYPES

This view displays all abstract datatypes in the database.

DBA_UNUSED_COL_TABS

This view contains a description of all tables containing unused columns.

DBA_UPDATABLE_COLUMNS

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

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

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

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

INITIAL_RSRC_CONSUMER_GROUP

VARCHAR2(30)

The initial resource consumer group for the user

EXTERNAL_NAME

VARCHAR2(4000)

User external name

DBA_USTATS

This view contains information about the current user.

DBA_VARRAYS

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

DBA_VIEWS

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

DBA_WAITERS

This view shows all the sessions that have someone waiting on a lock they hold, but that are not themselves waiting on a lock.

Column Datatype NULL Description

WAITING_SESSION

NUMBER

The waiting session

HOLDING_SESSION

NUMBER

The holding session

LOCK_TYPE

VARCHAR2(26)

The lock type

MODE_HELD

VARCHAR2(40)

The mode held

MODE_REQUESTED

VARCHAR2(40)

The mode requested

LOCK_ID1

VARCHAR2(40)

Lock ID 1

LOCK_ID2

VARCHAR2(40)

Lock ID 2

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 Oracle8i Replication.

DEFCALLDEST

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

DEFDEFAULTDEST

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

DEFERRCOUNT

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

DEFERROR

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

DEFLOB

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

DEFPROPAGATOR

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

DEFSCHEDULE

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

DEFTRAN

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

DEFTRANDEST

This view is used with Advanced Replication. For more information, see Oracle8i 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".)

DICT

This is a synonym for DICTIONARY. For more information, see "DICTIONARY".

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" and "USER_OBJECT_SIZE".

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_LOCKS".

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 Oracle8i 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_LOCKS".

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

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

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 (eg, 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 (eg, 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 (eg, 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.

IND

This is a synonym for USER_INDEXES. For more information, see "USER_INDEXES".

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

PRE_ROWS

NUMBER

Number of prefix rows (values in the index)

PRE_ROWS_LEN

NUMBER

Sum of lengths of all prefix rows

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

ORPHAN_KEY_TABLE

If there are index entries that point to corrupt rows when you run the DUMP_ORPHAN_KEYS procedure, the orphan key table is populated as a log of the activity and provides index information.

Column Datatype Null Description

SCHEMA_NAME

VARCHAR2(30)

NOT NULL

Schema name

INDEX_NAME

VARCHAR2(30)

NOT NULL

Index name

IPART_NAME

VARCHAR2(30)

NULL

Index partition/subpartition name

INDEX_ID

NUMBER

NOT NULL

Index's object id

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table name

PART_NAME

VARCHAR2(30)

NULL

Table partition/subpartition name

TABLE_ID

NUMBER

NOT NULL

Base table's object id

KEYDATA

UROWID

NOT NULL

Index entry's keydata

KEY

UROWID

NOT NULL

Index entry's key in linear format

DUMP_TIMESTAMP

DATE

NOT NULL

Timestamp

PARSED_PIECES

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".

PARSED_SIZE

This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".

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 execution slaves

DISTRIBUTION

VARCHAR2(30)

The distribution method

PLUGGABLE_SET_CHECK

This view contains pluggable set checks.

Column Datatype NULL Description

OBJ1_OWNER

VARCHAR2(30)

Owner of object

OBJ1_NAME

VARCHAR2(30)

Object 1

OBJ1_SUBNAME

VARCHAR2(30)

SubObject1Name

OBJ1_TYPE

VARCHAR2(15)

Object Type

TS1_NAME

VARCHAR2(30)

Tablespace containing Object 1

OBJ2_NAME

VARCHAR2(30)

Object Name

OBJ2_SUBNAME

VARCHAR2(30)

SubObject2Name

OBJ2_TYPE

VARCHAR2(15)

Object Type

OBJ2_OWNER

VARCHAR2(30)

Object owner of second object

TS2_NAME

VARCHAR2(30)

Tablespace containing Object 1

CONSTRAINT_NAME

VARCHAR2(30)

Name of dependent constraint

REASON

VARCHAR2(79)

Reason for Pluggable check violation

MESG_ID

NUMBER

The message ID

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

PROXY_USERS

This view describes users who can assume the identity of other users.

Column Datatype NULL Description

PROXY

VARCHAR2(30)

NOT NULL

Name of the client whose identity a proxy may assume

CLIENT

VARCHAR2(30)

NOT NULL

Name of a user which assume the identity of a client

ROLE

VARCHAR2(30)

Name of a role that a proxy user may or may not activate while acting as a client

FLAGS

VARCHAR2(35)

Indicates whether or not a proxy can activate all client roles, no client roles, or a specific client role

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)

QUEUE_PRIVILEGES

This view shows all Advanced Queuing object privileges granted to the session.

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

NAME

VARCHAR2(30)

NOT NULL

Name of the object

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

ENQUEUE_PRIVILEGE

NUMBER

Permission to ENQUEUE to the queue

DEQUEUE_PRIVILEGE

NUMBER

Permission to DEQUEUE from the queue

RC

RC_ views are not created by default in the database, they are only available after you create an optional recovery catalog (which contains schemas containing information about backups) for use with Recovery Manager. Please see the Oracle8i Backup and Recovery Guide for details about these views.

REPAIR_TABLE

The REPAIR_TABLE view lists any corruptions found by the CHECK_OBJECT procedure. It also displays information about how the corruptions would be addressed if the
FIX_CORRUPT_BLOCKS procedure is executed. This information is also used by the FIX_CORRUPT_BLOCKS and REFORMAT_CORRUPT_BLOCKS procedures on execution.

Column Datatype NULL Description

OBJECT_ID

NUMBER

NOT NULL

Object number

TABLESPACE_ID

NUMBER

NOT NULL

Tablespace number

RELATIVE_FILE_ID

NUMBER)

NOT NULL

Relative file number

BLOCK_ID

NUMBER

NOT NULL

Block number

CORRUPT_TYPE

NUMBER

NOT NULL

Type of corruption encountered

SCHEMA_NAME

VARCHAR2(30)

NOT NULL

Schema name

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Object name

BASEOBJECT_NAME

VARCHAR2(30)

NULL

Base table name when object is an index

PARTITION_NAME

VARCHAR2(30)

NULL

Partition or subpartition name

CORRUPT_DESCRIPTION

VARCHAR2(200)

NULL

Description of corruption

REPAIR_DESCRIPTION

VARCHAR2(200)

NULL

Description of repair action

MARKED_CORRUPT

VARCHAR2(10)

NOT NULL
Indicates whether the block is marked corrupt: 'TRUE' or 'FALSE'

CHECK_TIMESTAMP

DATE

NOT NULL

Timestamp from check_object procedure

FIX_TIMESTAMP

DATE

NULL

Set if block is modified by fix_corrupt_blocks

REFORMAT_TIMESTAMP

DATE

NULL

Set if block is modified by reformat_corrupt_blocks

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

SESSION_CONTEXT

This view lists set attributes information for the current session.

Column Datatype NULL Description

NAMESPACE

VARCHAR2(30)

The namespace that the active attribute is in

ATTRIBUTE

VARCHAR2(30)

The name of the active attribute

VALUE

VARCHAR2(64)

The value of the active attribute

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", and "USER_OBJECT_SIZE".

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

PROPERTY

NUMBER

NOT NULL

SYN

This is a synonym for USER_SYNONYMS. For more information, see "USER_SYNONYMS".

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

PROPERTY

NUMBER

NOT NULL

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

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 Oracle8i 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 Oracle8i 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

UNI_PLUGGABLE_SET_CHECK

This view contains pluggable check information.

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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?

SECONDARY

VARCHAR2(1)

Is the index object created as part of icreate for domain indexes?

NESTED

VARCHAR2(3)

Is the table a nested table?

BUFFER_POOL

VARCHAR2(7)

The default buffer pool to be used for table blocks

ROW_MOVEMENT

VARCHAR2(8)

The movement of the row

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

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_ASSOCIATIONS

This view lists user-defined statistics information

USER_AUDIT_OBJECT

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

USER_AUDIT_SESSION

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

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

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
Also indicates how the user was authenticated. The method can be one of the following:
DATABASE - authentication was done by password
NETWORK - authentication was done by Net8 or the Advanced Security option
PROXY - the client was authenticated by another user. The name of the proxy user follows the method type

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

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

SINGLE_TABLE

VARCHAR2(5)

Y if the cluster is single table; N if not

USER_CLUSTER_HASH_EXPRESSIONS

This view list hash functions for the users' hash clusters.

This view list all clusters accessible to the user.

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.

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

ELEM_STORAGE

VARCHAR2(7)

Storage optimization specification for VARRAY of numeric elements

NULLS_STORED

VARCHAR2(3)

Is null information stored with each VARRAY element?

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)
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)

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

DATE3

Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED

RELY

VARCHAR2(4)

If set, this flag will be used in optimizer

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. Dependencies on views created without any database links are also available.

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)

Type of the parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY

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_DIMENSIONS

This view represents dimension objects.

USER_DIM_ATTRIBUTES

This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Dependent column name

INFERRED

CHAR(1)

Whether this attribute is inferred from a JOIN KEY specification

USER_DIM_CHILD_OF

This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.

USER_DIM_JOIN_KEY

This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.

USER_DIM_HIERARCHIES

This view represents a dimension hierarchy.

USER_DIM_LEVELS

This view represents a dimension level. All columns of a dimension level must come from the same relation.

USER_DIM_LEVEL_KEY

This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the key column

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.

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

COMPRESSION

VARCHAR2(11)

Enabled or disabled

PREFIX_LENGTH

NUMBER

The number of columns in the prefix of the key used for compression

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, VALID or INPROGS (a DDL operation on the domain index is in progress).

DOMIDX_STATUS

VARCHAR

Reflects the status of the domain index. A NULL value means that the specified index is not a domain index. A Value of VALID means that the index is a domain index and the index does not have any errors. If the value of this column is IDXTYP_INVLD it means that the indextype corresponding to this domain index is invalid.

DOMIDX_OPSTATUS

VARCHAR

Reflects the status of an operation that was performed on the domain index. A value of NULL indicates that the specified index is not a domain index. A value of VALID specifies that the index does not have any errors. A value of FAILED indicates that the operation that was performed on the domain index failed with an error.

FUNCIDX_STATUS

VARCHAR

A value of NULL indicates a non function-based index. ENABLED indicates the function-based index is enabled. DISABLED indicates the function-based index is disabled.

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?

SECONDARY

VARCHAR2(1)

Is the index object created as part of icreate for domain indexes?

BUFFER_POOL

VARCHAR2(7)

Name of the default buffer pool for the appropriate object

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

The duration

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

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

DESCEND

VARCHAR2(4)

Y/N, Y if this column is sorted in descending order

USER_IND_EXPRESSIONS

This view lists functional index expressions 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_EXPRESSION

LONG

Functional index expression defining the column

COLUMN_POSITION

NUMBER

NOT NULL

Position of column or attribute within index

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

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

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_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

PCT_DIRECT_ACCESS

NUMBER

If index on IOT, then this is percentage of rows with Valid guess

USER_IND_SUBPARTITIONS

Column Datatype NULL Description

INDEX_NAME

VARCHAR2(30)

NOT NULL

Index name

PARTITION_NAME

VARCHAR2(30)

Partition name

SUBPARTITION_NAME

VARCHAR2(30)

Subpartition name

SUBPARTITION_POSITION

NUMBER

NOT NULL

Position of a subpartition within a partition

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_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

USER_INDEXTYPES

This view lists all the indextypes.

USER_INDEXTYPE_OPERATORS

This view lists all the operators supported by indextypes.

USER_JOBS

This view lists all jobs owned by the user. For more information, see the Oracle8i 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

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

INSTANCE

NUMBER

Indicates which instance can execute the job; default is 0

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_LOB_PARTITIONS

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

USER_LOB_SUBPARTITIONS

This view displays partition-level attributes of LOB data subpartitions.

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_MVIEW_AGGREGATES

This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.

USER_MVIEW_ANALYSIS

USER_MVIEW_DETAIL_RELATIONS

USER_MVIEW_JOINS

This view represents a join between two columns in the WHERE clause of a materialized view.

USER_MVIEW_KEYS

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

STORAGE_SPEC

VARCHAR2(30)

Indication of default or user-specified storage for the varray

RETURN_TYPE

VARCHAR2(20)

Return type of the varray column locator or value

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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

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

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is enabled or disabled

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

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 of the object (eg, TABLE, INDEX)

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?

SECONDARY

VARCHAR2(1)

Is this a secondary object created as part of create for domain indexes?

USER_OBJECT_SIZE

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

Column Datatype NULL Description

NAME

VARCHAR2(30)

NOT NULL

Name of the object

TYPE

VARCHAR2(12)

Type of the object: "TYPE", "TYPE BODY", "TABLE", "VIEW", "SYNONYM", "SEQUENCE", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "JAVA SOURCE", "JAVA CLASS" or "JAVA RESOURCE"

SOURCE_SIZE

NUMBER

Size of source code in bytes. Must be in memory during compilation, or dynamic recompilation

PARSED_SIZE

NUMBER

Size of parsed code in bytes. Must be in memory when an object is being compiled that references this object

CODE_SIZE

NUMBER

Size of compiled code in bytes. Must be in memory when this object is executing

ERROR_SIZE

NUMBER

Size of error messages in bytes. In memory during the compilation of the object when there are compilation errors

USER_OBJ_AUDIT_OPTS

This view, created by CATAUDIT.SQL, lists auditing options for all objects owned by a user.

USER_OPANCILLARY

This view lists ancillary information for operators.

USER_OPARGUMENTS

This view lists argument information for operator bindings.

USER_OPBINDINGS

This view lists operator bindings.

USER_OPERATORS

This view lists operators.

USER_OUTLINE_HINTS

This view lists the set of hints which make up the outlines.

USER_OUTLINES

This view lists information about outlines.

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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

USER_PART_LOBS

This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.

USER_PART_TABLES

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

USER_PARTIAL_DROP_TABS

This view describes tables which have partially dropped tables.

Column Datatype NULL Description

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

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_POLICIES

This view lists policies on objects that are under the user's schema.

Column Datatype NULL Description

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of the table or view

POLICY_NAME

VARCHAR2(30)

NOT NULL

Name of the policy

PF_OWNER

VARCHAR2(30)

NOT NULL

Owner of the policy function

PACKAGE

VARCHAR2(30)

Name of the package containing the policy function

FUNCTION

VARCHAR2(30)

NOT NULL

Name of the policy function

SEL

VARCHAR2(3)

If YES, policy is applied to query on the object

INS

VARCHAR2(3)

If YES, policy is applied to insert on the object

UPD

VARCHAR2(3)

If YES, policy is applied to update on the object

DEL

VARCHAR2(3)

If YES, policy is applied to delete on the object

CHK_OPTION

VARCHAR2(3)

Is check option enforced for this policy?

ENABLE

VARCHAR2(3)

Is this policy enabled?

USER_QUEUE_SCHEDULES

This view lists information about queue schedules.

Column Datatype NULL Description

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(200)

Function to compute the start of the next propagation window

LATENCY

NUMBER

Maximum wait time to propagate a message during the propagation window

SCHEDULE_DISABLED

VARCHAR2(1)

N if enabled; Y if disabled and schedule will not be executed

PROCESS_NAME

VARCHAR2(8)

The name of the SNP background process executing this schedule. NULL if not currently executing

SESSION_ID

NUMBER

The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing

INSTANCE

NUMBER

The OPS instance number executing this schedule

LAST_RUN_DATE

DATE

The date on the last successful execution

LAST_RUN_TIME

VARCHAR2(8)

The time of the last successful execution in HH:MI:SS format

CURRENT_START_DATE

DATE

The date at which the current window of this schedule was started

CURRENT_START_TIME

VARCHAR2(8)

The time of day at which the current window of this schedule was started in HH:MI:SS format

NEXT_RUN_DATE

DATE

The date at which the next window of this schedule will be started

NEXT_RUN_TIME

VARCHAR2(8)

The time of day at which the next window of this schedule will be started in HH:MI:SS format

TOTAL_TIME

NUMBER

The total time, in seconds, spent by the system in executing this schedule

TOTAL_NUMBER

NUMBER

The total number of messages propagated in this schedule

TOTAL_BYTES

NUMBER

The total number of bytes propagated in this schedule

MAX_NUMBER

NUMBER

The maximum number of messages propagated in a propagation window

MAX_BYTES

NUMBER

The maximum number of bytes propagated in a propagation window

AVG_NUMBER

NUMBER

The average number of messages propagated in a propagation window

AVG_SIZE

NUMBER

The average size of a propagated message in bytes

AVG_TIME

NUMBER

The average time, in seconds, to propagate a message

FAILURES

NUMBER

The number of times the execution failed. If 16, the schedule will be disabled

LAST_ERROR_DATE

DATE

The date of the last unsuccessful execution

LAST_ERROR_TIME

VARCHAR2(8)

The time of the last unsuccessful execution

LAST_ERROR_MSG

VARCHAR2(4000)

The error number and error message text of the last unsuccessful execution

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 Oracle8i Application Developer's Guide - Fundamentals.

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

COMPATIBLE

VARCHAR2(5)

The lowest release level which this is compatible with (eg, 8.0.4)

PRIMARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the primary owner of the queue table. A value of 0 indicates that there is no primary owner

SECONDARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the secondary owner of the queue table. This instance becomes the owner of the queue table if the primary owner is not alive. A value of 0 indicates that there is no secondary owner.

OWNER_INSTANCE

NUMBER

The instance number of the instance which currently owns the queue table

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 Oracle8i Application Developer's Guide - Fundamentals.

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(20)

Queue type:
NORMAL_QUEUE - Normal queue
EXCEPTION_QUEUE - Exception queue
NON_PERSISTENT_QUEUE - Non-persistent 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

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

USER_REGISTERED_SNAPSHOTS

This view lists users' registered snapshots.

USER_REPCATLOG

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

USER_REPCOLUMN

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

USER_REPCOLUMN_GROUP

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

USER_REPCONFLICT

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

USER_REPDDL

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

USER_REPGENERATED

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

USER_REPGENOBJECTS

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

USER_REPGROUP

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

USER_REPGROUPED_COLUMN

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

USER_REPKEY_COLUMNS

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

USER_REPOBJECT

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

USER_REPPARAMETER_COLUMN

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

USER_REPPRIORITY

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

USER_REPPRIORITY_GROUP

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

USER_REPPROP

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

USER_REPRESOLUTION

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

USER_REPRESOL_STATS_CONTROL

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

USER_REPRESOLUTION_METHOD

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

USER_REPRESOLUTION_STATISTICS

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

USER_REPSITES

This view is used with Advanced Replication. For more information, see Oracle8i 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_RSRC_CONSUMER_GROUP_PRIVS

This view lists all resource consumer groups granted to the user.

Column Datatype NULL Description

GRANTED_GROUP

VARCHAR2(30)

Granted consumer group name

GRANT_OPTION

VARCHAR2(3)

Whether grant was with the GRANT option

INITIAL_GROUP

VARCHAR2(3)

Whether consumer group is designated as the default

USER_RSRC_MANAGER_SYSTEM_PRIVS

This view lists all the users who are granted system privileges for the DBMS_RESOURCE_MANAGER package.

Column Datatype NULL Description

PRIVILEGE

VARCHAR2(40)

NOT NULL

What type of privilege the user has

ADMIN_OPTION

VARCHAR2(3)

Whether the grant was with the ADMIN option

USER_RULESETS

This view lists information about rulesets.

Column Datatype NULL Description

RULESET_NAME

VARCHAR2(30)

NOT NULL

The name of the ruleset

RULESET_STORAGE_TABLE

VARCHAR2(61)

The table in which the ruleset is stored (will be schema.table)

BASE_TABLE

VARCHAR2(61)

The table on which the rules are defined (will be schema.table)

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

STATUS

VARCHAR2(7)

The status of the contents of the snapshot

REFRESH_MODE

VARCHAR2(8)

This indicates how and when the snapshot will be refreshed

PREBUILT

VARCHAR2(3)

If YES, this snapshot uses a prebuilt table as the base table

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 Oracle8i 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_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

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_SUBPART_COL_STATISTICS

This view lists column statistics and histogram information for table subpartitions.

Column Datatype NULL Description

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table name

SUBPARTITION_NAME

VARCHAR2(30)

Table subpartition 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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying subpartitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

USER_SUBPART_HISTOGRAMS

This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.

Column Datatype NULL Description

TABLE_NAME

VARCHAR2(30)

Table name

SUBPARTITION_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_SUBPART_KEY_COLUMNS

This view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.

Column Datatype NULL Description

NAME

VARCHAR2(30)

The partitioned table or index name

OBJECT_TYPE

VARCHAR2(11)

The object type (TABLE or INDEX)

COLUMN_NAME

VARCHAR2(30)

The column name

COLUMN_POSITION

NUMBER

The position of the column within the subpartitioning key

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

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

AVG_COL_LEN

NUMBER

The average length of the column, in bytes

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

Column Datatype NULL Description

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table name

COMPOSITE

VARCHAR2(3)

'YES' if the partition belongs to a Local index on a table partitioned using Composite method; 'NO' otherwise

SUBPARTITION_COUNT

NUMBER

If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition

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

GLOBAL_STATS

VARCHAR2(3)

USER_STATS

VARCHAR2(3)

USER_TAB_PRIVS

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

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_TAB_SUBPARTITIONS

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.

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

EXTENT_MANAGEMENT

VARCHAR2(10)

Extent management tracking: "DICTIONARY" or "LOCAL"

ALLOCATION_TYPE

VARCHAR2(9)

Type of extent allocation in effect for this tablespace

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 STATEMENT, BEFORE EACH ROW, BEFORE EVENT, AFTER STATEMENT, AFTER EACH ROW, and AFTER EVENT

TRIGGERING_EVENT

VARCHAR2(75)

Events that fire the trigger: INSERT, UPDATE, DELETE, STARTUP, SHUTDOWN, ERROR, LOGON, LOGOFF, CREATE, ALTER, DROP

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table on which the trigger is defined

BASE_OBJECT_TYPE

VARCHAR2(16)

The base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASE

TABLE_NAME

VARCHAR2(30)

If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, this columns indicates the table/view name on which the trigger is defined

COLUMN_NAME

VARCHAR2(30)

Name of the nested table column (if nested table trigger), else null

REFERENCING_NAMES

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.

ACTION_TYPE

VARCHAR2(11)

The action type of the trigger body: CALL or PL/SQL

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

ATTR_NO

NUMBER

NOT NULL

Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number)

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_UNUSED_COL_TABS

This view contains a description of all tables containing unused columns.

Column Datatype NULL Description

TABLE_NAME

VARCHAR2(30)

NOT NULL

The name of the table

COUNT

NUMBER

The number of unused columns

USER_UPDATABLE_COLUMNS

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

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

INITIAL_RSRC_CONSUMER
_GROUP

VARCHAR2(30)

The initial resource consumer group for the user

EXTERNAL_NAME

VARCHAR2(4000)

User external name

USER_USTATS

This view contains information about the current user.

USER_VARRAYS

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

Column Datatype NULL Description

PARENT_TABLE_NAME

VARCHAR2(30)

Name of the containing table

PARENT_TABLE_COLUMN

VARCHAR2(4000)

Name of the varray column or attribute

TYPE_OWNER

VARCHAR2(30)

Owner of the varray type

TYPE_NAME

VARCHAR2(30)

Name of the varray type

LOB_NAME

VARCHAR2(30)

Name of the LOB if the varray is stored in a LOB

STORAGE_SPEC

VARCHAR2(30)

DEFAULT value indicates that the storage was defaulted. USER_SPECIFIED value indicates that the storage was user-specified

RETURN_TYPE

VARCHAR2(20)

Return type of the column

USER_VIEWS

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

Column Datatype NULL Description

VIEW_NAME

VARCHAR2(30)

NOT NULL

Name of the view

TEXT_LENGTH

NUMBER

Length of the view text

TEXT

LONG

View text

TYPE_TEXT_LENGTH

NUMBER

Length of the type clause of the typed view

TYPE_TEXT

VARCHAR2(4000)

Type clause of the typed view

OID_TEXT_LENGTH

NUMBER

Length of the WITH OID clause of the typed view

OID_TEXT

VARCHAR2(4000)

WITH OID clause of the typed view

VIEW_TYPE_OWNER

VARCHAR2(30)

Owner of the type of the view if the view is a typed view

VIEW_TYPE

VARCHAR2(30)

Type of the view if the view is a typed view

Column	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
DESCEND	VARCHAR2(4)		Y/N, Y if this column is sorted in descending order

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
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
INSTANCE	NUMBER		Indicates which instance can execute or is executing the job; the default is 0

Column	Datatype	Description
TABLE_OWNER	VARCHAR2(30)	Table owner
TABLE_NAME	VARCHAR2(30)	Table name
COLUMN_NAME	VARCHAR2(30)	Name of a LOB column
LOB_NAME	VARCHAR2(30)	Name of a partitioned LOB item
PARTITION_NAME	VARCHAR2(30)	Name of a table partition
LOB_PARTITION_NAME	VARCHAR2(30)	Name of LOB data partition
LOB_INDPART_NAME	VARCHAR2(30)	Name of corresponding LOB index partition
PARTITION_POSITION	NUMBER	Position of the LOB data partition within the lOB item
COMPOSITE	VARCHAR2(3)	Is it a Composite partition (one of YES, NO)?
CHUNK	NUMBER	CHUNK attribute of a LOB data partition
PCTVERSION	NUMBER	PCTVERSION attribute of a LOB data partition
CACHE	VARCHAR2(3)	CACHE attribute of a LOB data partition
IN_ROW	VARCHAR2(3)	IN_ROW attribute of a LOB data partition
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the LOB data partition
INITIAL_EXTENT	VARCHAR2(40)	Size of the initial extent in bytes for a LOB data partition
NEXT_EXTENT	VARCHAR2(40)	Size of secondary extents in bytes for a LOB data partition
MIN_EXTENTS	VARCHAR2(40)	Minimum number of extents allowed in the segment of a LOB data partition
MAX_EXTENTS	VARCHAR2(40)	Maximum number of extents allowed in the segment of a LOB data partition
PCT_INCREASE	VARCHAR2(40)	Percentage increase in extent size for a LOB data partition
FREELISTS	VARCHAR2(40)	Number of process freelists allocated in the segment of a LOB data partition
FREELIST_GROUPS	VARCHAR2(40)	Number of freelist groups allocated in the segment of a LOB data partition
LOGGING	VARCHAR2(7)	The logging attribute of a LOB data partition
BUFFER_POOL	VARCHAR2(7)	Buffer pool of a LOB data partition

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the nested table
TABLE_NAME	VARCHAR2(30)	Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2(30)	Name of the type of the nested table
PARENT_TABLE _NAME	VARCHAR2(30)	Name of the parent table containing the nested table
PARENT_TABLE _COLUMN	VARCHAR2(4000)	Column name of the parent table that corresponds to the nested table
STORAGE_SPEC	VARCHAR2(30)	Indication of default or user-specified storage for the varray
RETURN_TYPE	VARCHAR2(20)	Return type of the varray column locator or value

Column	Datatype	Description
NAME	VARCHAR2(30)	Name of the outline
NODE	NUMBER	I.D. of the query or subquery to which the hint applies. The top-level query is labelled 1. Subqueries are assigned sequentially numbered labels, starting with 2
JOIN_POS	NUMBER	Position of the table in the join order. The JOIN_POS column is 0 for all hints except the access method hints. The access method hints identify a table to which the hint and the join position apply
HINT	VARCHAR2(512)	Text of the hint

Column	Datatype	Description
NAME	VARCHAR2(30)	The user-specified or generated name of the stored outline. The name must be of a form that can be expressed in SQL
CATEGORY	VARCHAR2(30)	A user-defined name used to group outlines into collections
USED	VARCHAR2(9)	Flag indicating whether the outline has ever been used
TIMESTAMP	DATE	Timestamp at which the outline was created
VERSION	VARCHAR2(64)	Oracle Version that created the outline
SQL_TEXT	LONG	SQL text of the query-including any hints that were a part of the original statement. If bind variables are included, the variable names are stored as SQL text, not the values that are assigned to the variables

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

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

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

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

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 Oracle8i Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserted 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

Column	Datatype	Description
OWNER	VARCHAR2(30)	The partitioned table or index owner
NAME	VARCHAR2(30)	The partitioned table or index name
OBJECT_TYPE	VARCHAR2(11)	The object type (TABLE or INDEX)
COLUMN_NAME	VARCHAR2(30)	The column name
COLUMN_POSITION	NUMBER	The position of the column within the subpartitioning key

Column	Datatype	NULL	Description
TABLEOBJ#	NUMBER	NOT NULL	Object number of the table
PARTITIONOBJ#	NUMBER	NOT NULL	Object number of table partitions (if the table is partitioned)
DMLOPERATION	VARCHAR2(1)		Type of DML operation applied to the table
SCN	NUMBER	NOT NULL	SCN when the bulk DML occurred
TIMESTAMP	DATE	NOT NULL	Timestamp of log entry
LOWROWID	ROWID	NOT NULL	The start ROWID in the loaded rowid range
HIGHROWID	ROWID	NOT NULL	The end ROWID in the loaded rowid range

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

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.

Column	Datatype	Description
OBJECT_OWNER	VARCHAR2(30)	Owner of the table or index for which the statistics have been collected
OBJECT_NAME	VARCHAR2(30)	Name of the table or index for which the statistics have been collected
PROPERTY	VARCHAR2(6)	Property of the object - column or index
COLUMN_NAME	VARCHAR2(30)	Column name, if property is column for which statistics have been collected
STATSTYPE_SCHEMA	VARCHAR2(30)	Schema of statistics type which was used to collect the statistics
STATSTYPE_NAME	VARCHAR2(30)	Name of statistics type which was used to collect statistics
STATISTICS	RAW(2000)	User collected statistics for the object

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table containing the varray
PARENT_TABLE_NAME	VARCHAR2(30)	Name of the containing table
PARENT_TABLE_COLUMN	VARCHAR2(4000)	Name of the varray column or attribute
TYPE_OWNER	VARCHAR2(30)	Owner of the varray type
TYPE_NAME	VARCHAR2(30)	Name of the varray type
LOB_NAME	VARCHAR2(30)	Name of the LOB if the varray is stored in a LOB
STORAGE_SPEC	VARCHAR2(30)	DEFAULT value indicates that the storage was defaulted. USER_SPECIFIED value indicates that the storage was user-specified
RETURN_TYPE	VARCHAR2(20)	Return type of the column

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

Column	Description
OWNER_NAME	Table owner
TABLE_NAME	Table name
CLUSTER_NAME	Cluster the table is in, if any
PARTITION_NAME	The name of the partition
SUBPARTITION_NAME	The name of the subpartition
HEAD_ROWID	ROWID the chained row is accessed by
ANALYZE_TIMESTAMP	Date/time that the ANALYZE command was issued

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

2Static Data Dictionary Views

Data Dictionary Views

ALL_ALL_TABLES

ALL_ARGUMENTS

ALL_ASSOCIATIONS

ALL_CATALOG

ALL_CLUSTERS

ALL_CLUSTER_HASH_EXPRESSIONS

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_COLL_TYPES

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_CONTEXT

ALL_DB_LINKS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_DIMENSIONS

ALL_DIM_ATTRIBUTES

ALL_DIM_CHILD_OF

ALL_DIM_HIERARCHIES

ALL_DIM_JOIN_KEY

ALL_DIM_LEVELS

ALL_DIM_LEVEL_KEY

ALL_DIRECTORIES

ALL_ERRORS

ALL_IND_COLUMNS

ALL_IND_EXPRESSIONS

ALL_IND_PARTITIONS

ALL_IND_SUBPARTITIONS

ALL_INDEXES

ALL_INDEXTYPES

ALL_INDEXTYPE_OPERATORS

ALL_JOBS

ALL_LABELS

ALL_LIBRARIES

ALL_LOBS

ALL_LOB_PARTITIONS

ALL_LOB_SUBPARTITIONS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_MVIEW_AGGREGATES

ALL_MVIEW_ANALYSIS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_KEYS

ALL_NESTED_TABLES

ALL_OBJECT_TABLES

ALL_OBJECTS

ALL_OPANCILLARY

ALL_OPARGUMENTS

ALL_OPBINDINGS

ALL_OPERATORS

ALL_OUTLINE_HINTS

ALL_OUTLINES

ALL_PART_COL_STATISTICS

ALL_PART_HISTOGRAMS

ALL_PART_INDEXES

ALL_PART_KEY_COLUMNS

ALL_PART_LOBS

ALL_PART_TABLES

ALL_PARTIAL_DROP_TABS

ALL_POLICIES

ALL_QUEUES

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REFRESH_DEPENDENCIES

ALL_REFS

ALL_REGISTERED_SNAPSHOTS

ALL_REPCATLOG

ALL_REPCOLUMN

ALL_REPCOLUMN_GROUP

ALL_REPCONFLICT

ALL_REPDDL

ALL_REPGENERATED

ALL_REPGENOBJECTS

ALL_REPGROUP

ALL_REPGROUPED_COLUMN

2
Static Data Dictionary Views

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

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
USER_BYTES	NUMBER		Corresponding number of bytes
USER_BLOCKS	NUMBER		Number of blocks which can be used by the data

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

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, "Lock Modes for the DBA_DML_LOCKS View"
MODE_REQUESTED	VARCHAR2(13)		Lock request type: see Table 2-1, "Lock Modes for the DBA_DML_LOCKS View"
LAST_CONVERT	NUMBER		The last convert
BLOCKING_OTHERS	VARCHAR2(40)		Blocking others

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

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)

Column	Datatype	Description
SID	NUMBER	Identifier of process that is executing the job. See "V$LOCK".
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.
INSTANCE	NUMBER	Indicates which instance can execute or is executing the job; the default is 0

Column	Datatype	Description
FORMATID	NUMBER	The format identifier of the transaction identifier
GLOBALID	RAW(64)	The global part (gtrid) of the transaction identifier
BRANCHID	RAW(64)	The branch qualifier (bqual) of the transaction identifier

Column	Datatype	NULL	Description
USER_NAME	VARCHAR2(30)		User name if by user auditing. ANY CLIENT if access by a proxy on behalf of a client is being audited NULL for system-wide auditing
PROXY_NAME	VARCHAR2(30)		The name of the proxy user which is performing an operation for the client. NULL if the client is performing the operation directly
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

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