Oracle8 Reference
Release 8.0

A58242-01

Library

Product

Contents

Index

Prev Next

2
Static Data Dictionary Views

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

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

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

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

Data Dictionary Views

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

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

ALL_ALL_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a bloc

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last modification?

 

NUM_ROWS

 

NUMBER

 

 

The number of rows in the table

 

BLOCKS

 

NUMBER

 

 

The number of used blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

The number of empty (never used) blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

The average available free space in the table

 

CHAIN_CNT

 

NUMBER

 

 

The number of chained rows in the table

 

AVG_ROW_LEN

 

NUMBER

 

 

The average row length, including row overhead

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

The sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

The date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Is this table partitioned? YES or NO

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

 

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

 

TABLE_TYPE

 

VARCHAR2(30)

 

 

Type of the table if the table is a typed table

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

ALL_ARGUMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the object

 

OBJECT_NAME

 

VARCHAR2(30)

 

 

Procedure or function name

 

OVERLOAD

 

VARCHAR2(40)

 

 

Overload unique identifier

 

PACKAGE_NAME

 

VARCHAR2(30)

 

 

Package name

 

OBJECT_ID

 

NUMBER

 

NOT NULL

 

Object number of the object

 

ARGUMENT_NAME

 

VARCHAR2(30)

 

 

Argument name

 

POSITION

 

NUMBER

 

NOT NULL

 

Position in argument list, or NULL for function return value

 

SEQUENCE

 

NUMBER

 

NOT NULL

 

Argument sequence, including all nesting levels

 

DATA_LEVEL

 

NUMBER

 

NOT NULL

 

Nesting depth of argument for composite types

 

DATA_TYPE

 

VARCHAR2(14)

 

 

Datatype of the argument

 

DEFAULT_VALUE

 

LONG

 

 

Default value for the argument

 

DEFAULT_LENGTH

 

NUMBER

 

 

Length of default value for the argument

 

IN_OUT

 

VARCHAR2(9)

 

 

Argument direction (IN, OUT, or IN/OUT)

 

DATA_LENGTH

 

NUMBER

 

 

Length of the column in bytes

 

DATA_PRECISION

 

NUMBER

 

 

Length: decimal digits (NUMBER) or binary digits (FLOAT)

 

DATA_SCALE

 

NUMBER

 

 

Digits to right of decimal point in a number

 

RADIX

 

NUMBER

 

 

Argument radix for a number

 

CHARACTER_SET_NAME

 

VARCHAR2(44)

 

 

Character set name for the argument

 

TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner name of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

 

Name

 

TYPE_SUBNAME

 

VARCHAR2(30)

 

 

This is valid only in case of package local types; in such cases, the package name is the name and the type name is the subname

 

TYPE_LINK

 

VARCHAR2(128)

 

 

Database link valid only in case of package local types, in case the package is remote

 

ALL_CATALOG

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TABLE_TYPE

 

VARCHAR2(11)

 

 

Type of the object

 

ALL_CLUSTERS

This view list all clusters accessible to the user.

This view list all clusters accessible to the user.
Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the cluster

 

CLUSTER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the cluster

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the cluster

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

NOT NULL

 

Minimum percentage of used space in a block

 

KEY_SIZE

 

NUMBER

 

 

Estimated size of cluster key plus associated rows

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

AVG_BLOCKS_PER
_KEY

 

NUMBER

 

 

Number of blocks in the table divided by number of hash keys

 

CLUSTER_TYPE

 

VARCHAR2(5)

 

 

Type of cluster: B-Tree index or hash

 

FUNCTION

 

VARCHAR2(15)

 

 

If a hash cluster, the hash function

 

HASHKEYS

 

NUMBER

 

 

If a hash cluster, the number of hash keys (hash buckets)

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the cluster

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the cluster is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the cluster is to be cached in the buffer cache

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

ALL_COL_COMMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the column

 

COMMENTS

 

VARCHAR2(4000)

 

 

Comment on the column

 

ALL_COL_PRIVS

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

Column   Datatype   NULL   Description  

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

TABLE_SCHEMA

 

VARCHAR2(30)

 

NOT NULL

 

Schema of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the column

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the column

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privileges was granted with ADMIN OPTION; otherwise NO

 

ALL_COL_PRIVS_MADE

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

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the column

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the column

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privilege was granted with ADMIN OPTION; otherwise NO

 

ALL_COL_PRIVS_RECD

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

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NUL

 

Username of the owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the column

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privilege was granted with ADMIN OPTION; otherwise NO

 

ALL_COLL_TYPES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

COLL_TYPE

 

VARCHAR2(30)

 

NOT NULL

 

Collection type

 

UPPER_BOUND

 

NUMBER

 

 

Maximum size of the VARRAY type

 

ELEM_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the element

 

ELEM_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the element

 

ELEM_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the element

 

LENGTH

 

NUMBER

 

 

Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element

 

PRECISION

 

NUMBER

 

 

Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element

 

SCALE

 

NUMBER

 

 

Scale of the NUMBER or DECIMAL element

 

CHARACTER_SET
_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS NCHAR_CS

 

ALL_CONS_COLUMNS

This view contains information about accessible columns in constraint definitions.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the constraint definition

 

CONSTRAINT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with the constraint definition

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with table with constraint definition

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name associated with column or attribute of the object type column specified in the constraint definition

 

POSITION

 

NUMBER

 

 

Original position of column or attribute in definition

 

ALL_CONSTRAINTS

This view lists constraint definitions on accessible tables.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the constraint definition

 

CONSTRAINT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with the constraint definition

 

CONSTRAINT_TYPE

 

VARCHAR2(1)

 

 

Type of constraint definition: C (check constraint on a table), P (primary key), U (unique key), R (referential integrity), or V (with check option, on a view), or O (with read only, on a view)

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with table with constraint definition

 

SEARCH_CONDITION

 

LONG

 

 

Text of search condition for table check

 

R_OWNER

 

VARCHAR2(30)

 

 

Owner of table used in referential constraint

 

R_CONSTRAINT
_NAME

 

VARCHAR2(30)

 

 

Name of unique constraint definition for referenced table

 

DELETE_RULE

 

VARCHAR2(9)

 

 

Delete rule for a referential constraint: CASCADE / NO ACTION

 

STATUS

 

VARCHAR2(8)

 

 

Enforcement status of constraint: ENABLED or DISABLED

 

DEFERRABLE

 

VARCHAR2(14)

 

 

Indicates whether the constraint is deferrable

 

DEFERRED

 

VARCHAR2(9)

 

 

Indicates whether the constraint was initially deferred

 

VALIDATED

 

VARCHAR2(13)

 

 

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

 

GENERATED

 

VARCHAR2(14)

 

 

Indicates whether the name system is generated

 

BAD

 

VARCHAR2(3)

 

 

Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.

 

LAST_CHANGE

 

DATE

 

 

Indicates when the constraint was last enabled or disabled

 

ALL_DB_LINKS

This view lists database links accessible to the user.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the database link

 

DB_LINK

 

VARCHAR2(12)

 

NOT NULL

 

Name of the database link

 

USERNAME

 

VARCHAR2(30)

 

 

Name of user when logging in

 

HOST

 

VARCHAR2(200)

 

 

Net8 string for connect

 

CREATED

 

DATE

 

NOT NULL

 

Creation time of the database link

 

ALL_DEF_AUDIT_OPTS

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

Column   Datatype   NULL   Description  

ALT

 

VARCHAR2(3)

 

 

Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

AUD

 

VARCHAR2(3)

 

 

Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

COM

 

VARCHAR2(3)

 

 

Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

DEL

 

VARCHAR2(3)

 

 

Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

GRA

 

VARCHAR2(3)

 

 

Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

IND

 

VARCHAR2(3)

 

 

Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

INS

 

VARCHAR2(3)

 

 

Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

LOC

 

VARCHAR2(3)

 

 

Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

REN

 

VARCHAR2(3)

 

 

Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

SEL

 

VARCHAR2(3)

 

 

Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

UPD

 

VARCHAR2(3)

 

 

Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

REF

 

VARCHAR2(3)

 

 

Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

EXE

 

VARCHAR2(3)

 

 

Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

 

ALL_DEPENDENCIES

This view lists dependencies between objects accessible to the user.

.
Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of object

 

TYPE

 

VARCHAR2(12)

 

 

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

 

REFERENCED
_OWNER

 

VARCHAR2(30)

 

 

Owner of the parent object

 

REFERENCED
_NAME

 

VARCHAR2(64)

 

 

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

 

REFERENCED_TYPE

 

VARCHAR2(12)

 

 

Type of referenced object

 

REFERENCED_
LINK_NAME

 

VARCHAR2(128)

 

 

Name of the link to the parent object (if remote)

 

DEPENDENCY_TYPE

 

VARCHAR2(4)

 

 

Two values: REF when the dependency is a REF dependency; HARD otherwise

 

ALL_DIRECTORIES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the directory (always SYS)

 

DIRECTORY_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the directory

 

DIRECTORY_PATH

 

VARCHAR2(4000)

 

 

Operating system pathname for the directory

 

ALL_ERRORS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of object

 

TYPE

 

VARCHAR2(12)

 

 

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

 

SEQUENCE

 

NUMBER

 

NOT NULL

 

Sequence number, for ordering

 

LINE

 

NUMBER

 

NOT NULL

 

Line number at which this error occurs

 

POSITION

 

NUMBER

 

NOT NULL

 

Position in the line at which this error occurs

 

TEXT

 

VARCHAR2(4000)

 

NOT NULL

 

Text of the error

 

ALL_IND_COLUMNS

This view lists columns of the indexes on accessible tables.

Column   Datatype   NULL   Description  

INDEX_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Index owner

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Index name

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Table or cluster owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table or cluster name

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Column name or attribute of object type column

 

COLUMN_POSITION

 

NUMBER

 

NOT NULL

 

Position of column or attribute within index

 

COLUMN_LENGTH

 

NUMBER

 

NOT NULL

 

Indexed length of the column

 

ALL_IND_PARTITIONS

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

Column   Datatype   NULL   Description  

INDEX_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Index owner

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Index name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Partition name

 

HIGH_VALUE

 

LONG

 

 

Partition bound value expression

 

HIGH_VALUE_LENGTH

 

NUMBER

 

NOT NULL

 

Length of partition bound value expression

 

PARTITION_POSITION

 

NUMBER

 

NOT NULL

 

Position of the partition within the index

 

STATUS

 

VARCHAR2(8)

 

 

Indicates whether index partition is usable or not

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the partition

 

PCT_FREE

 

NUMBER

 

NOT NULL

 

Minimum percentage of free space in a block

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENT

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENT

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of process freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute of partition

 

BLEVEL

 

NUMBER

 

 

B-Tree level

 

LEAF_BLOCKS

 

NUMBER

 

 

Number of leaf blocks in the index partition

 

DISTINCT_KEYS

 

NUMBER

 

 

Number of distinct keys in the index partition

 

AVG_LEAF_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of leaf blocks per key

 

AVG_DATA_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of data blocks per key

 

CLUSTERING_FACTOR

 

NUMBER

 

 

Measurement of the amount of (dis)order of the table this index partition is for

 

NUM_ROWS

 

NUMBER

 

 

Number of rows returned by the ANALYZE command

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this partition

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this partition was analyzed

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The actual buffer pool for the partition

 

ALL_INDEXES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the index

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the index

 

INDEX_TYPE

 

VARCHAR2(12)

 

 

Type of index

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the indexed object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the indexed object

 

TABLE_TYPE

 

CHAR(5)

 

 

Type of the indexed object

 

UNIQUENESS

 

VARCHAR2(9)

 

 

Uniqueness status of the index: UNIQUE or NONUNIQUE

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the index

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

PCT_THRESHOLD

 

NUMBER

 

 

Threshold percentage of block space allowed per index entry

 

INCLUDE_COLUMN

 

NUMBER

 

 

User column-id for last column to be included in index organized table top index

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

LOGGING

 

VARCHAR(2(3)

 

 

Logging information

 

BLEVEL

 

NUMBER

 

 

B-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.

 

LEAF_BLOCKS

 

NUMBER

 

 

Number of leaf blocks in the index

 

DISTINCT_KEYS

 

NUMBER

 

 

Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS)

 

AVG_LEAF_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of leaf blocks in which each distinct value in the index appears. This statistic is rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.

 

AVG_DATA_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of data blocks in the table that are pointed to by a distinct value in the index. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns. This statistic is rounded to the nearest integer.

 

CLUSTERING_FACTOR

 

NUMBER

 

 

Statistic that represents the amount of order of the rows in the table based on the values of the index. If its value is near the number of blocks, then the table is very well ordered. In such a case, the index entries in a single leaf block tend to point to rows in the same data blocks. If its value is near the number of rows, then the table is very randomly ordered. In such a case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.

 

STATUS

 

VARCHAR2(8)

 

 

State of the index: DIRECT LOAD or VALID

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in this index

 

SAMPLE_SIZE

 

NUMBER

 

 

Size of the sample used to analyze this index

 

LAST_ANALYZED

 

DATE

 

 

Timestamp for when this index was last analyzed

 

DEGREE

 

VARCHAR2(40)

 

 

Number of threads per instance for scanning the index, NULL if PARTITIONED=NO.

 

INSTANCES

 

VARCHAR2(40)

 

 

Number of instances across which the indexes to be scanned. NULL if PARTITIONED=NO.

 

PARTITIONED

 

VARCHAR2(3)

 

 

Indicates whether this index is partitioned. Set to `YES' if it is partitioned

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it places in this object itself?

 

GENERATED

 

VARCHAR2(1)

 

 

Was the name of this index system generated?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

ALL_LABELS

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

ALL_LIBRARIES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the library

 

LIBRARY_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Library name

 

FILE_SPEC

 

VARCHAR2(2000)

 

 

Operating system file specification associated with the library

 

DYNAMIC

 

VARCHAR2(1)

 

 

Is the library dynamically loadable? (YES or NO)

 

STATUS

 

VARCHAR2(7)

 

 

Status of the library

 

ALL_LOBS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table containing the LOB

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table containing the LOB

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name of the LOB column or attribute

 

SEGMENT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the LOB segment

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the LOB index

 

CHUNK

 

NUMBER

 

 

Size of the LOB chunk as a unit of allocation/manipulation in bytes

 

PCTVERSION

 

NUMBER

 

NOT NULL

 

Maximum percentage of the LOB space used for versioning

 

CACHE

 

VARCHAR2(3)

 

 

Indicates whether the LOB is accessed through the buffer cache

 

LOGGING

 

VARCHAR2(3)

 

 

Indicates whether the changes to the LOB are logged

 

IN_ROW

 

VARCHAR2(3)

 

 

Are some of the LOBs stored with the base row?

 

ALL_METHOD_PARAMS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

Method number for distinguishing overloaded method (not to be used as ID number)

 

PARAM_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the parameter

 

PARAM_NO

 

NUMBER

 

NOT NULL

 

Parameter number or position

 

PARAM_MODE

 

VARCHAR2(6)

 

 

Mode of the parameter

 

PARAM_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the parameter

 

PARAM_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the parameter

 

PARAM_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the parameter

 

CHARACTER_SET_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS or NCHAR_CS

 

ALL_METHOD_RESULTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

Method number for distinguishing overloaded method (not to be used as ID number)

 

RESULT_TYPE_MOD

 

VARCHAR2(7)

 

NOT NULL

 

Type modifier of the result

 

RESULT_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the result

 

RESULT_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the result

 

CHARACTER_SET_NAME

 

VARCHAR2(44

 

 

The name of the character set: CHAR_CS or NCHAR_CS

 

ALL_NESTED_TABLES

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

Column   Datatype   Null   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the nested table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the nested table

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of which the nested table was created

 

TABLE_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the nested table

 

PARENT_TABLE
_NAME

 

VARCHAR2(30)

 

 

Name of the parent table containing the nested table

 

PARENT_TABLE
_COLUMN

 

VARCHAR2(4000)

 

 

Column name of the parent table that corresponds to the nested table

 

ALL_OBJECT_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last modification?

 

NUM_ROWS

 

NUMBER

 

 

The number of rows in the table

 

BLOCKS

 

NUMBER

 

 

The number of used blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

The number of empty (never used) blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

The average available free space in the table

 

CHAIN_CNT

 

NUMBER

 

 

The number of chained rows in the table

 

AVG_ROW_LEN

 

NUMBER

 

 

The average row length, including row overhead

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

The sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

The date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Is this table partitioned? YES or NO

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

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

 

TABLE_TYPE

 

VARCHAR2(30)

 

NOT NULL

 

Type of the table if the table is a typed table

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The default buffer pool to be used for table blocks

 

ALL_OBJECTS

This view lists objects accessible to the user.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the object

 

OBJECT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

SUBOBJECT_NAME

 

VARCHAR2(30)

 

 

Name of the sub-object (for example, partition)

 

OBJECT_ID

 

NUMBER

 

NOT NULL

 

Object number of the object

 

DATA_OBJECT_ID

 

NUMBER

 

 

Object number of the segment which contains the object

 

OBJECT_TYPE

 

VARCHAR2(15)

 

 

Type and type body of the object: INDEX PARTITION, TABLE PARTITION, PACKAGE, PACKAGE BODY, TRIGGER

 

CREATED

 

DATE

 

NOT NULL

 

Timestamp for the creation of the object

 

LAST_DDL_TIME

 

DATE

 

NOT NULL

 

Timestamp for the last modification of the object resulting from a DDL command (including grants and revokes)

 

TIMESTAMP

 

VARCHAR2(20)

 

 

Timestamp for the creation of the object (character data)

 

STATUS

 

VARCHAR2(7)

 

 

Status of the object: VALID, INVALID, or N/A

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it placed in this object itself?

 

GENERATED

 

VARCHAR2(1)

 

 

Was the name of this object system generated?

 

ALL_PART_COL_STATISTICS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner name

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Table partition name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

NUM_DISTINCT

 

NUMBER

 

 

Number of distinct values in the column

 

LOW_VALUE

 

RAW(32)

 

 

Low value in the column

 

HIGH_VALUE

 

RAW(32)

 

 

High value in the column

 

DENSITY

 

NUMBER

 

 

Density of the column

 

NUM_NULLS

 

NUMBER

 

 

Number of nulls in the column

 

NUM_BUCKETS

 

NUMBER

 

 

Number of buckets in histogram for the column

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this column

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this column was analyzed

 

ALL_PART_HISTOGRAMS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner name

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Table partition name

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Column name

 

BUCKET_NUMBER

 

NUMBER

 

 

Bucket number

 

ENDPOINT_VALUE

 

NUMBER

 

 

Normalized endpoint values for this bucket

 

ALL_PART_INDEXES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of this partitioned index

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of this partitioned index

 

PARTITIONING_TYPE

 

VARCHAR2(7)

 

 

Partitioning algorithm: RANGE

 

PARTITION_COUNT

 

NUMBER

 

NOT NULL

 

Number of partitions in this index

 

PARTITIONING_KEY
_COUNT

 

NUMBER

 

NOT NULL

 

Number of columns in the partitioning key

 

LOCALITY

 

VARCHAR2(6)

 

 

Indicates whether this partitioned index is LOCAL or GLOBAL

 

ALIGNMENT

 

VARCHAR2(12)

 

 

Indicates whether this partitioned index is PREFIXED or NON-PREFIXED

 

DEF_TABLESPACE
_NAME

 

VARCHAR2(30)

 

 

Default TABLESPACE, for LOCAL index, for ADD/SPLIT TABLE partition

 

DEF_PCT_FREE

 

NUMBER

 

NOT NULL

 

Default PCTFREE, for LOCAL index, for ADD TABLE partition

 

DEF_INI_TRANS

 

NUMBER

 

NOT NULL

 

Default INITRANS, for LOCAL index, for ADD TABLE partition

 

DEF_MAX_TRANS

 

NUMBER

 

NOT NULL

 

Default MAXTRANS, for LOCAL index, for ADD TABLE partition

 

DEF_INITIAL_EXTENT

 

VARCHAR2(40)

 

NOT NULL

 

Default INITIAL, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified

 

DEF_NEXT_EXTENT

 

VARCHAR2(40)

 

NOT NULL

 

Default NEXT, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified

 

DEF_MIN_EXTENTS

 

VARCHAR2(40)

 

NOT NULL

 

Default MINEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified

 

DEF_MAX_EXTENTS

 

VARCHAR2(40)

 

NOT NULL

 

Default MAXEXTENTS, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified

 

DEF_PCT_INCREASE

 

VARCHAR2(40)

 

NOT NULL

 

Default PCTINCREASE, for LOCAL index, for ADD TABLE partition, `DEFAULT' if attribute was not specified

 

DEF_FREELISTS

 

NUMBER

 

NOT NULL

 

Default FREELISTS, for LOCAL index, for ADD TABLE partition

 

DEF_FREELIST_GROUPS

 

NUMBER

 

NOT NULL

 

Default FREELIST GROUPS, for LOCAL index, for ADD TABLE partition

 

DEF_LOGGING

 

VARCHAR2(7)

 

 

Default LOGGING, for LOCAL index, for ADD TABLE PARTITION

 

DEF_BUFFER_POOL

 

VARCHAR2(7)

 

 

Default buffer pool for LOCAL index, for ADD TABLE PARTITION

 

ALL_PART_KEY_COLUMNS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Partitioned table or index owner

 

NAME

 

VARCHAR2(30)

 

 

Partitioned table or index name

 

OBJECT_TYPE

 

VARCHAR2(11)

 

 

Object type (`TABLE' or `INDEX)

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Column name

 

COLUMN_POSITION

 

NUMBER

 

 

Position of the column within the partitioning key

 

ALL_PART_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of this partitioned table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of this partitioned table

 

PARTITIONING_TYPE

 

VARCHAR2(7)

 

 

Partitioning algorithm: `RANGE'

 

PARTITION_COUNT

 

NUMBER

 

NOT NULL

 

Number of partitions in this table

 

PARTITIONING_KEY_COUNT

 

NUMBER

 

NOT NULL

 

Number of columns in the partitioning key

 

DEF_TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Default TABLESPACE, used for add partition

 

DEF_PCT_FREE

 

NUMBER

 

NOT NULL

 

Default PCTFREE, used for add partition

 

DEF_PCT_USED

 

NUMBER

 

NOT NULL

 

Default PCTUSED, used for add partition

 

DEF_INI_TRANS

 

NUMBER

 

NOT NULL

 

Default INITRANS, used for add partition

 

DEF_MAX_TRANS

 

NUMBER

 

NOT NULL

 

Default MAXTRANS, used for add partition

 

DEF_INITIAL_EXTENT

 

VARCHAR2(40)

 

 

Default INITIAL, used for add partition, `DEFAULT' if attribute was not specified

 

DEF_NEXT_EXTENT

 

VARCHAR2(40)

 

 

Default NEXT, used for add partition, `DEFAULT' if attribute was not specified

 

DEF_MIN_EXTENTS

 

VARCHAR2(40)

 

 

Default MINEXTENTS, used for add partition, `DEFAULT' if attribute was not specified

 

DEF_MAX_EXTENTS

 

VARCHAR2(40)

 

 

Default MAXEXTENTS, used for add partition,
`DEFAULT' if attribute was not specified

 

DEF_PCT_INCREASE

 

VARCHAR2(40)

 

 

Default PCTINCREASE, used for add partition,
`DEFAULT' if attribute was not specified

 

DEF_FREELISTS

 

NUMBER

 

NOT NULL

 

Default FREELISTS, used for add partition

 

DEF_FREELIST_GROUPS

 

NUMBER

 

NOT NULL

 

Default FREELIST GROUPS, used for add partition

 

DEF_LOGGING

 

VARCHAR2(7)

 

 

Default LOGGING attribute, used for add partition

 

DEF_BUFFER_POOL

 

VARCHAR2(7)

 

 

Default buffer pool for the given object, used for add partition

 

ALL_REFRESH

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

Column   Datatype   NULL   Description  

ROWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the refresh group

 

RNAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the refresh group

 

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

IMPLICIT_DESTROY

 

VARCHAR2(1)

 

 

Y or N; if Y, then destroy the refresh group when its last item is subtracted

 

PUSH_DEFERRED_RPC

 

VARCHAR2(1)

 

 

Y or N; if Y then push changes from snapshot to master before refresh

 

REFRESH_AFTER
_ERRORS

 

VARCHAR2(1)

 

 

If Y, proceed with refresh despite error when pushing deferred RPCs

 

ROLLBACK_SEG

 

VARCHAR2(30)

 

 

Name of the rollback segment to use while refreshing

 

JOB

 

NUMBER

 

 

Identifier of job used to refresh the group automatically

 

NEXT_DATE

 

DATE

 

 

Date that this job will next be refreshed automatically, if not broken

 

INTERVAL

 

VARCHAR2(200)

 

 

A date function used to compute the next NEXT_DATE

 

BROKEN

 

VARCHAR2(1)

 

 

Y or N; Y means the job is broken and will never be run

 

PURGE_OPTION

 

NUMBER(38)

 

 

The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option

 

PARALLELISM

 

NUMBER(38)

 

 

The level of parallelism for transaction propagation

 

HEAP_SIZE

 

NUMBER(38)

 

 

The size of the heap.

 

ALL_REFRESH_CHILDREN

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object in the refresh group

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object in the refresh group

 

TYPE

 

VARCHAR2(30)

 

 

Type of the object in the refresh group

 

ROWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the refresh group

 

RNAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the refresh group

 

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

IMPLICIT_DESTROY

 

VARCHAR2(1)

 

 

Y or N; if Y, then destroy the refresh group when its last item is subtracted

 

PUSH_DEFERRED_RPC

 

VARCHAR2(1)

 

 

Y or N; if Y then push changes from snapshot to master before refresh

 

REFRESH_AFTER
_ERRORS

 

VARCHAR2(1)

 

 

If Y, proceed with refresh despite error when pushing deferred RPCs

 

ROLLBACK_SEG

 

VARCHAR2(30)

 

 

Name of the rollback segment to use while refreshing

 

JOB

 

NUMBER

 

 

Identifier of job used to refresh the group automatically

 

NEXT_DATE

 

DATE

 

 

Date that this job will next be refreshed automatically, if not broken

 

INTERVAL

 

VARCHAR2(200)

 

 

A date function used to compute the next NEXT_DATE

 

BROKEN

 

VARCHAR2(1)

 

 

Y or N; Y means the job is broken and will never be run

 

PURGE_OPTION

 

NUMBER(38)

 

 

The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option

 

PARALLELISM

 

NUMBER(38)

 

 

The level of parallelism for transaction propagation

 

HEAP_SIZE

 

NUMBER(38)

 

 

The size of the heap.

 

ALL_REFS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name.

 

WITH_ROWID

 

VARCHAR2(3)

 

 

Is the REF value stored with ROWID (YES or NO)?

 

IS_SCOPED

 

VARCHAR2(3)

 

 

Is the REF column scoped (YES or NO)?

 

SCOPE_TABLE_OWNER

 

VARCHAR2(30)

 

 

Name of the owner of the scope table, if it exists and is accessible by the user

 

SCOPE_TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the scope table, if it exists and is accessible by the user

 

ALL_REGISTERED_SNAPSHOTS

This view lists all registered snapshots.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the snapshot

 

SNAPSHOT_SITE

 

VARCHAR2(128)

 

NOT NULL

 

Global name of the snapshot site.

 

CAN_USE_LOG

 

VARCHAR2(3)

 

 

YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log

 

UPDATABLE

 

VARCHAR2(3)

 

 

Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to NO, the snapshot is read only.

 

REFRESH_METHOD

 

VARCHAR2(11)

 

 

Whether the snapshot uses rowids or primary key for fast refresh

 

SNAPSHOT_ID

 

NUMBER(38)

 

 

Identifier for the snapshot used by the master for fast refresh

 

VERSION

 

VARCHAR2(17)

 

 

Version of snapshot

 

QUERY_TXT

 

LONG

 

 

Original query of which this snapshot is an instantiation

 

ALL_REPCATLOG

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

ALL_REPCOLUMN

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

ALL_REPCOLUMN_GROUP

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

ALL_REPCONFLICT

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

ALL_REPDDL

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

ALL_REPGENERATED

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

ALL_REPGROUP

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

ALL_REPGROUPED_COLUMN

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

ALL_REPKEY_COLUMNS

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

ALL_REPOBJECT

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

ALL_REPPARAMETER_COLUMN

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

ALL_REPPRIORITY

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

ALL_REPPRIORITY_GROUP

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

ALL_REPPROP

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

ALL_REPRESOLUTION

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

ALL_REPRESOL_STATS_CONTROL

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

ALL_REPRESOLUTION_METHOD

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

ALL_REPRESOLUTION_STATISTICS

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

ALL_REPSITES

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

ALL_SEQUENCES

This view lists descriptions of sequences accessible to the user.

Column   Datatype   NULL   Description  

SEQUENCE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the sequence

 

SEQUENCE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Sequence name

 

MIN_VALUE

 

NUMBER

 

 

Minimum value of the sequence

 

MAX_VALUE

 

NUMBER

 

 

Maximum value of the sequence

 

INCREMENT_BY

 

NUMBER

 

NOT NULL

 

Value by which sequence is incremented

 

CYCLE_FLAG

 

VARCHAR2(1)

 

 

Does sequence wrap around on reaching limit

 

ORDER_FLAG

 

VARCHAR2(1)

 

 

Are sequence numbers generated in order

 

CACHE_SIZE

 

NUMBER

 

NOT NULL

 

Number of sequence numbers to cache

 

LAST_NUMBER

 

NUMBER

 

NOT NULL

 

Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.

 

ALL_SNAPSHOT_LOGS

This view lists all snapshot logs.

Column   Datatype   NULL   Description  

LOG_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the log

 

MASTER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the master table whose changes are logged

 

LOG_TABLE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table where the changes to the master table are recorded

 

LOG_TRIGGER

 

VARCHAR2(30)

 

 

Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserts rows into the log.

 

ROWIDS

 

VARCHAR2(3)

 

 

If YES, records ROWID information

 

PRIMARY_KEY

 

VARCHAR2(3)

 

 

If YES, records primary key information

 

FILTER_COLUMNS

 

VARCHAR2(3)

 

 

If YES, snapshot log records filter columns

 

CURRENT_SNAPSHOTS

 

DATE

 

 

One date per snapshot; the date the snapshot of the master was last refreshed

 

SNAPSHOT_ID

 

NUMBER(38)

 

 

Unique identifier of the snapshot

 

ALL_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the snapshot view

 

MASTER_OWNER

 

VARCHAR2(30)

 

 

Owner of the master table

 

MASTER

 

VARCHAR2(30)

 

 

Name of the master table

 

LAST_REFRESH

 

DATE

 

 

The last refresh

 

ALL_SNAPSHOTS

This view lists all snapshots accessible to the user.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the view used by users and applications for viewing the snapshot

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table the snapshot is stored in. This table may have additional columns.

 

MASTER_VIEW

 

VARCHAR2(30)

 

 

View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8 and is set to NULL.

 

MASTER_OWNER

 

VARCHAR2(30)

 

 

Owner of the master table

 

MASTER

 

VARCHAR2(30)

 

 

Name of the master table of which this snapshot is a copy

 

MASTER_LINK

 

VARCHAR2(128)

 

 

Database link name to the master site

 

CAN_USE_LOG

 

VARCHAR2(3)

 

 

YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log

 

UPDATABLE

 

VARCHAR2(3)

 

 

Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to YES, the snapshot is read only.

 

REFRESH_METHOD

 

VARCHAR2(11)

 

 

Values used to drive a refresh of the snapshot
(PRIMARY KEY/ROWID/COMPLEX). If PRIMARY KEY, then the snapshot uses primary keys to drive a fast refresh. If ROWID, then it uses RowIDs to drive a fast refresh. If COMPLEX, then fast refreshes are not allowed and the snapshot can only perform complete refreshes.

 

LAST_REFRESH

 

DATE

 

 

Date and time at the master site of the last refresh

 

ERROR

 

NUMBER

 

 

The number of failed automatic refreshes since last successful refresh

 

FR_OPERATIONS

 

VARCHAR2(10)

 

 

Status of generated fast refresh operations: (REGENERATE, VALID)

 

CR_OPERATIONS

 

VARCHAR2(10)

 

 

Status of generated complete refresh operations: (REGENERATE, VALID)

 

TYPE

 

VARCHAR2(8)

 

 

Type of refresh for all automatic refreshes: COMPLETE, FAST, FORCE

 

NEXT

 

VARCHAR2(200)

 

 

Date function used to compute next refresh dates

 

START_WITH

 

DATE

 

 

Date function used to compute next refresh dates

 

REFRESH_GROUP

 

NUMBER

 

 

All snapshots in a given refresh group get refreshed in the same transaction

 

UPDATE_TRIG

 

VARCHAR2(30)

 

 

Obsolete. It is NULL for Oracle8 snapshots. Formerly, the name of the trigger that fills the UPDATE_LOG

 

UPDATE_LOG

 

VARCHAR2(30)

 

 

The table that logs changes made to an updatable snapshots

 

QUERY

 

LONG

 

 

Original query of which this snapshot is an instantiation

 

MASTER_ROLLBACK
_SEG

 

VARCHAR2(30)

 

 

Rollback segment to use at the master site

 

ALL_SOURCE

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TYPE

 

VARCHAR2(12)

 

 

Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER, TYPE, TYPE BODY

 

LINE

 

NUMBER

 

NOT NULL

 

Line number of this line of source

 

TEXT

 

VARCHAR2(4000)

 

 

Text source of the stored object

 

ALL_SYNONYMS

This view lists all synonyms accessible to the user.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the synonym

 

SYNONYM_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the synonym

 

TABLE_OWNER

 

VARCHAR2(30)

 

 

Owner of the object referenced by the synonym

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object referenced by the synonym

 

DB_LINK

 

VARCHAR2(128)

 

 

Name of the database link referenced, if any

 

ALL_TAB_COL_STATISTICS

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

Column   Datatype   NULL   Description  

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

NUM_DISTINCT

 

NUMBER

 

 

Number of distinct values in the column

 

LOW_VALUE

 

RAW(32)

 

 

Low value in the column

 

HIGH_VALUE

 

RAW(32)

 

 

High value in the column

 

DENSITY

 

NUMBER

 

 

Density of the column

 

NUM_NULLS

 

NUMBER

 

 

Number of nulls in the column

 

NUM_BUCKETS

 

NUMBER

 

 

Number of buckets in histogram for the column

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this column was analyzed

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this column

 

ALL_TAB_COLUMNS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table, view or cluster

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table, view, or cluster name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

DATA_TYPE

 

VARCHAR2(30)

 

 

Datatype of the column

 

DATA_TYPE_MOD

 

VARCHAR2(3)

 

 

Datatype modifier of the column

 

DATA_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the datatype of the column

 

DATA_LENGTH

 

NUMBER

 

NOT NULL

 

Length of the column in bytes

 

DATA_PRECISION

 

NUMBER

 

 

Decimal precision for NUMBER datatype; binary precision for FLOAT datatype, NULL for all other datatypes

 

DATA_SCALE

 

NUMBER

 

 

Digits to right of decimal point in a number

 

NULLABLE

 

VARCHAR2(1)

 

 

Specifies whether a column allows NULLs. Value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY.

 

COLUMN_ID

 

NUMBER

 

NOT NULL

 

Sequence number of the column as created

 

DEFAULT_LENGTH

 

NUMBER

 

 

Length of default value for the column

 

DATA_DEFAULT

 

LONG

 

 

Default value for the column

 

NUM_DISTINCT

 

NUMBER

 

 

These columns remain for backward compatibility with Oracle7. This information is now in the {TAB|PART}_COL_STATISTICS views. This view now picks up these values from HIST_HEAD$ rather than COL$.

 

LOW_VALUE

 

RAW(32)

 

 

HIGH_VALUE

 

RAW(32)

 

 

DENSITY

 

NUMBER

 

 

NUM_NULLS

 

NUMBER

 

 

The number of nulls in the column

 

NUM_BUCKETS

 

NUMBER

 

 

The number of buckets in histogram for the column

 

LAST_ANALYZED

 

DATE

 

 

The date of the most recent time this column was analyzed

 

SAMPLE_SIZE

 

 

 

The sample size used in analyzing this column

 

CHARACTER_SET
_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS or NCHAR_CS

 

CHAR_COL_DECL
_LENGTH

 

NUMBER

 

 

The length of something

 

ALL_TAB_COMMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TABLE_TYPE

 

VARCHAR2(11)

 

 

Type of the object

 

COMMENTS

 

VARCHAR2(4000)

 

 

Comment on the object

 

ALL_TAB_HISTOGRAMS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Table name

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Column name or attribute of the object type column

 

BUCKET_NUMBER

 

NUMBER

 

 

Bucket number

 

ENDPOINT_VALUE

 

NUMBER

 

 

Normalized endpoint values for this bucket

 

ALL_TAB_PARTITIONS

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

Column   Datatype   NULL   Description  

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Table owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Partition name

 

HIGH_VALUE

 

LONG

 

 

Partition bound value expression

 

HIGH_VALUE_LENGTH

 

NUMBER

 

NOT NULL

 

Length of partition bound value expression

 

PARTITION_POSITION

 

NUMBER

 

NOT NULL

 

Position of the partition within the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the partition

 

PCT_FREE

 

NUMBER

 

NOT NULL

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

NOT NULL

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENT

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENT

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute of partition

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in the partition

 

BLOCKS

 

NUMBER

 

 

Number of used blocks in the partition

 

EMPTY_BLOCKS

 

NUMBER

 

 

Number of empty (never used) blocks in the partition

 

AVG_SPACE

 

NUMBER

 

 

Average available free space in the partition

 

CHAIN_CNT

 

NUMBER

 

 

Number of chained rows in the partition

 

AVG_ROW_LEN

 

NUMBER

 

 

Average row length, including row overhead

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this partition

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this partition was analyzed

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The actual buffer pool for this partition

 

ALL_TAB_PRIVS

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

Column   Datatype   NULL   Description  

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access is granted

 

TABLE_SCHEMA

 

VARCHAR2(30)

 

NOT NULL

 

Schema of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the object

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privilege was granted with ADMIN OPTION; otherwise NO

 

ALL_TAB_PRIVS_MADE

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

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the object

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privilege was granted with ADMIN OPTION; otherwise NO

 

ALL_TAB_PRIVS_RECD

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

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Privilege on the object

 

GRANTABLE

 

VARCHAR2(3)

 

 

YES if the privilege was granted with ADMIN OPTION; otherwise NO

 

ALL_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of the secondary extension bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last change

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in the table

 

BLOCKS

 

NUMBER

 

 

Number of used data blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

Number of empty (never used) data blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

Average amount of free space, in bytes, in a data block allocated to the table

 

CHAIN_CNT

 

NUMBER

 

 

Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID

 

AVG_ROW_LEN

 

NUMBER

 

 

Average length of a row in the table in bytes

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Indicates whether this table is partitioned. Set to YES if it is partitioned

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If this is an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW. If this is not an index organized table, then IOT_TYPE is NULL

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

ALL_TRIGGERS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the trigger

 

TRIGGER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the trigger

 

TRIGGER_TYPE

 

VARCHAR2(16)

 

 

When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT

 

TRIGGERING_EVENT

 

VARCHAR2(26)

 

 

Statement that fires the trigger: INSERT, UPDATE, DELETE

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table on which the trigger is defined

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table on which the trigger is defined

 

REFERENCING_NAME

 

VARCHAR2(87)

 

 

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

 

WHEN_CLAUSE

 

VARCHAR2(4000)

 

 

WHEN clause. Must evaluate to TRUE for TRIGGER_BODY to execute.

 

STATUS

 

VARCHAR2(8)

 

 

Whether the trigger is enabled: ENABLED or DISABLED

 

DESCRIPTION

 

VARCHAR2(4000)

 

 

Trigger description. Useful for re-creating a trigger creation statement.

 

TRIGGER_BODY

 

LONG

 

 

Statement(s) executed by the trigger when it fires

 

ALL_TRIGGER_COLS

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

Column   Datatype   NULL   Description  

TRIGGER_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the triggers

 

TRIGGER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the trigger

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table on which the trigger is defined

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table on which the trigger is defined

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name of the column used in the trigger

 

COLUMN_LIST

 

VARCHAR2(3)

 

 

Column specified in UPDATE clause: Y/N

 

COLUMN_USAGE

 

VARCHAR2(17)

 

 

How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT.

 

ALL_TYPE_ATTRS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

ATTR_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the attribute

 

ATTR_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the attribute

 

ATTR_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the attribute

 

ATTR_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the attribute

 

LENGTH

 

NUMBER

 

 

Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute

 

PRECISION

 

NUMBER

 

 

Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute

 

SCALE

 

NUMBER

 

 

Scale of the NUMBER or DECIMAL attribute

 

CHARACTER_SET
_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS or NCHAR_CS

 

ALL_TYPE_METHODS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

Method number for distinguishing overloaded method (not to be used as ID number)

 

METHOD_TYPE

 

VARCHAR2(6)

 

 

Type of the method

 

PARAMETERS

 

NUMBER

 

NOT NULL

 

Number of parameters to the method

 

RESULTS

 

NUMBER

 

NOT NULL

 

Number of results returned by the method

 

ALL_TYPES

This view displays the types accessible to the user.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

TYPE_OID

 

RAW(16)

 

NOT NULL

 

Object identifier (OID) of the type

 

TYPECODE

 

VARCHAR2(30)

 

 

Typecode of the type

 

ATTRIBUTES

 

NUMBER

 

 

Number of attributes in the type

 

METHODS

 

NUMBER

 

 

Number of methods in the type

 

PREDEFINED

 

VARCHAR2(3)

 

 

Indicates whether the type is a predefined type

 

INCOMPLETE

 

VARCHAR2(3)

 

 

Indicates whether the type is an incomplete type

 

ALL_UPDATABLE_COLUMNS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Table owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

UPDATABLE

 

VARCHAR2(3)

 

 

Indicates whether the column is updatable

 

INSERTABLE

 

VARCHAR2(3)

 

 

Indicates whether the column is insertable

 

DELETABLE

 

VARCHAR2(3)

 

 

Indicates whether the column is deletable

 

ALL_USERS

This view contains information about all users of the database.

Column   Datatype   NULL   Description  

USERNAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user

 

USER_ID

 

NUMBER

 

NOT NULL

 

ID number of the user

 

CREATED

 

DATE

 

NOT NULL

 

User creation date

 

ALL_VIEWS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the view

 

VIEW_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the view

 

TEXT_LENGTH

 

NUMBER

 

 

Length of the view text

 

TEXT

 

LONG

 

 

View text

 

TYPE_TEXT_LENGTH

 

NUMBER

 

 

Length of the type clause of the typed view

 

TYPE_TEXT

 

VARCHAR2(4000)

 

 

Type clause of the typed view

 

OID_TEXT_LENGTH

 

NUMBER

 

 

Length of the WITH OID clause of the typed view

 

OID_TEXT

 

VARCHAR2(4000)

 

 

WITH OID clause of the typed view

 

VIEW_TYPE_OWNER

 

VARCHAR2(30)

 

 

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

 

VIEW_TYPE

 

VARCHAR2(30)

 

 

Type of the view if the view is a typed view

 

AUDIT_ACTIONS

This view contains descriptions for audit trail action type codes.

Column   Datatype   NULL   Description  

ACTION

 

NUMBER

 

NOT NULL

 

Numeric audit trail action type code

 

NAME

 

VARCHAR2(27)

 

NOT NULL

 

Name of the type of audit trail action

 

CATALOG

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

CAT

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

CHAINED_ROWS

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

Column   Description  

OWNER_NAME

 

Table owner

 

TABLE_NAME

 

Table name

 

CLUSTER_NAME

 

Cluster the table is in, if any

 

HEAD_ROWID

 

ROWID the chained row is accessed by

 

TIMESTAMP

 

Date/time that the ANALYZE command was issued

 

CLU

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

CODE_PIECES

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

CODE_SIZE

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

COL

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

COLS

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

COLUMN_PRIVILEGES

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

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

Column   Description  

GRANTEE

 

Name of the user to whom access was granted.

 

OWNER

 

Username of the object's owner.

 

TABLE_NAME

 

Name of the object.

 

COLUMN_NAME

 

Name of the column.

 

GRANTOR

 

Name of the user who performed the grant.

 

INSERT_PRIV

 

Permission to insert into the column.

 

UPDATE_PRIV

 

Permission to update the column.

 

REFERENCES_PRIV

 

Permission to reference the column.

 

CREATED

 

Timestamp for the grant.

 

DBA_2PC_NEIGHBORS

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

Column   Datatype   NULL   Description  

LOCAL_TRAN_ID

 

VARCHAR2(22)

 

 

Local identifier of a transaction

 

IN_OUT

 

VARCHAR2(3)

 

 

IN for incoming connections, OUT for outgoing

 

DATABASE

 

VARCHAR2(128)

 

 

IN: client database name; OUT: outgoing database link

 

DBUSER_OWNER

 

VARCHAR2(30)

 

 

IN: name of local user; OUT: owner of database link

 

INTERFACE

 

VARCHAR2(1)

 

 

"C" for request commit, otherwise "N" for prepare or request readonly commit

 

DBID

 

VARCHAR2(16)

 

 

The database ID at the other end of the connection

 

SESS#

 

NUMBER

 

 

Session number of the connection at this database

 

BRANCH

 

VARCHAR2(128)

 

 

Transaction branch ID of the connection at this database

 

DBA_2PC_PENDING

This view contains information about distributed transactions awaiting recovery.

Column   Datatype   NULL   Description  

LOCAL_TRAN_ID

 

VARCHAR2(22)

 

NOT NULL

 

String of form: n.n.n; n is a number

 

GLOBAL_TRAN_ID

 

VARCHAR2(169)

 

 

Globally unique transaction ID

 

STATE

 

VARCHAR2(16)

 

NOT NULL

 

Collecting, prepared, committed, forced commit, or forced rollback

 

MIXED

 

VARCHAR2(3)

 

 

YES = part of the transaction committed and part rolled back

 

ADVICE

 

VARCHAR2(1)

 

 

C for commit, R for rollback, else NULL

 

TRAN_COMMENT

 

VARCHAR2(2000)

 

 

Text for commit work comment text

 

FAIL_TIME

 

DATE

 

NOT NULL

 

Value of SYSDATE when the row was inserted (tx or system recovery)

 

FORCE_TIME

 

DATE

 

 

Time of manual force decision (null if not forced locally)

 

RETRY_TIME

 

DATE

 

NOT NULL

 

Time automatic recovery (RECO) last tried to recover the transaction

 

OS_USER

 

VARCHAR2(2000)

 

 

Time automatic recovery (RECO) last tried to recover the transaction

 

OS_TERMINAL

 

VARCHAR2(2000)

 

 

Time automatic recovery (RECO) last tried to recover the transaction

 

HOST

 

VARCHAR2(2000)

 

 

Name of the host machine for the end-user

 

DB_USER

 

VARCHAR2(30)

 

 

Name of the host machine for the end-user

 

COMMIT#

 

VARCHAR2(16)

 

 

Name of the host machine for the end-user

 

DBA_ALL_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last modification?

 

NUM_ROWS

 

NUMBER

 

 

The number of rows in the table

 

BLOCKS

 

NUMBER

 

 

The number of used blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

The number of empty (never used) blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

The average available free space in the table

 

CHAIN_CNT

 

NUMBER

 

 

The number of chained rows in the table

 

AVG_ROW_LEN

 

NUMBER

 

 

The average row length, including row overhead

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST
_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

The sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

The date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Is this table partitioned? YES or NO

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

 

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

 

TABLE_TYPE

 

VARCHAR2(30)

 

 

Type of the table if the table is a typed table

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The default buffer pool to be used for table blocks

 

DBA_AUDIT_EXISTS

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

Column   Datatype   NULL   Description  

OS_USERNAME

 

VARCHAR2(255)

 

 

Operating system login username of the user whose actions were audited

 

USERNAME

 

VARCHAR2(30)

 

 

Name (not ID number) of the user whose actions were audited

 

USERHOST

 

VARCHAR2(2000)

 

 

Numeric instance ID for the Oracle instance from which the user is accessing the database

 

TERMINAL

 

VARCHAR2(2000)

 

 

Identifier of the user's terminal

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp for the creation of the audit trail entry

 

OWNER

 

VARCHAR2(30)

 

 

Intended creator of the non-existent object

 

OBJ_NAME

 

VARCHAR2(128)

 

 

Name of the object affected by the action

 

ACTION_NAME

 

VARCHAR2(27)

 

 

Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL

 

NEW_OWNER

 

VARCHAR2(30)

 

 

Owner of the object named in the NEW_NAME column

 

NEW_NAME

 

VARCHAR2(128)

 

 

New name of an object after a RENAME or the name of the underlying object

 

OBJ_PRIVILEGE

 

VARCHAR2(16)

 

 

Object privileges granted or revoked by a GRANT or REVOKE statement

 

SYS_PRIVILEGE

 

VARCHAR2(40)

 

 

System privileges granted or revoked by a GRANT or REVOKE statement

 

GRANTEE

 

VARCHAR2(30)

 

 

Name of grantee specified in a GRANT or REVOKE statement

 

SESSIONID

 

NUMBER

 

NOT NULL

 

Numeric ID for each Oracle session

 

ENTRYID

 

NUMBER

 

NOT NULL

 

Numeric ID for each audit trail entry in the session

 

STATEMENTID

 

NUMBER

 

NOT NULL

 

Numeric ID for each statement run

 

RETURNCODE

 

NUMBER

 

NOT NULL

 

Oracle Server message code generated by the action. Some useful values:

  • zero: the action succeeded
  • 2004: security violation
 

DBA_AUDIT_OBJECT

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

Column   Datatype   NULL   Description  

OS_USERNAME

 

VARCHAR2(255)

 

 

Operating system login username of the user whose actions were audited

 

USERNAME

 

VARCHAR2(30)

 

 

Name (not ID number) of the user whose actions were audited

 

USERHOST

 

VARCHAR2(2000)

 

 

Numeric instance ID for the Oracle instance from which the user is accessing the database

 

TERMINAL

 

VARCHAR2(2000)

 

 

Identifier of the user's terminal

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp for the creation of the audit trail entry or login time for the CONNECT statement

 

OWNER

 

VARCHAR2(30)

 

 

Creator of the object affected by the action

 

OBJ_NAME

 

VARCHAR2(128)

 

 

Name of the object affected by the action

 

ACTION_NAME

 

VARCHAR2(27)

 

 

Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL

 

NEW_OWNER

 

VARCHAR2(30)

 

 

Owner of the object named in the NEW_NAME column

 

NEW_NAME

 

VARCHAR2(128)

 

 

New name of an object after a RENAME or the name of the underlying object

 

SES_ACTIONS

 

VARCHAR2(19)

 

 

Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)

 

COMMENT_TEXT

 

VARCHAR2(4000

 

 

Text comment on the audit trail

 

SESSIONID

 

NUMBER

 

NOT NULL

 

Numeric ID for each Oracle session

 

ENTRYID

 

NUMBER

 

NOT NULL

 

Numeric ID for each audit trail entry in the session

 

STATEMENTID

 

NUMBER

 

NOT NULL

 

Numeric ID for each statement run

 

RETURNCODE

 

NUMBER

 

NOT NULL

 

Oracle Server message code generated by the action. Some useful values:

  • zero: the action succeeded
  • 2004: security violation
 

PRIV_USED

 

VARCHAR2(40)

 

 

System privilege used to execute the action

 

OBJECT_LABEL

 

MLSLABEL

 

 

Label associated with the object being audited. Applies to Trusted Oracle Server only.

 

SESSION_LABEL

 

MLSLABEL

 

 

Label associated with the session. Applies to Trusted Oracle Server only.

 

DBA_AUDIT_SESSION

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

Column   Datatype   NULL   Description  

OS_USERNAME

 

VARCHAR2(255)

 

 

Operating system login username of the user whose actions were audited

 

USERNAME

 

VARCHAR2(30)

 

 

Name (not ID number) of the user whose actions were audited

 

USERHOST

 

VARCHAR2(2000)

 

 

Numeric instance ID for the Oracle instance from which the user is accessing the database

 

TERMINAL

 

VARCHAR2(2000)

 

 

Identifier of the user's terminal

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp for the creation of the audit trail entry or login time for the CONNECT statement

 

ACTION_NAME

 

VARCHAR2(27)

 

 

Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL

 

LOGOFF_TIME

 

DATE

 

 

Timestamp for user log off

 

LOGOFF_LREAD

 

NUMBER

 

 

Logical reads for the session

 

LOGOFF_PREAD

 

NUMBER

 

 

Physical reads for the session

 

LOGOFF_LWRITE

 

NUMBER

 

 

Logical writes for the session

 

LOGOFF_DLOCK

 

VARCHAR2(40)

 

 

Deadlocks detected during the session

 

SESSIONID

 

NUMBER

 

NOT NULL

 

Numeric ID for each Oracle session

 

RETURNCODE

 

NUMBER

 

NOT NULL

 

Oracle Server message code generated by the action. Some useful values:

  • zero: the action succeeded
  • 2004: security violation
 

SESSION_LABEL

 

MLSLABEL

 

 

Label associated with the session. Applies to Trusted Oracle Server only.

 

DBA_AUDIT_STATEMENT

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

Column   Datatype   NULL   Description  

OS_USERNAME

 

VARCHAR2(255)

 

 

Operating system login username of the user whose actions were audited

 

USERNAME

 

VARCHAR2(30)

 

 

Name (not ID number) of the user whose actions were audited

 

USERHOST

 

VARCHAR2(2000)

 

 

Numeric instance ID for the Oracle instance from which the user is accessing the database

 

TERMINAL

 

VARCHAR2(2000)

 

 

Identifier of the user's terminal

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp for the creation of the audit trail entry or login time for the CONNECT statement

 

OWNER

 

VARCHAR2(30)

 

 

Creator of the object affected by the action

 

OBJ_NAME

 

VARCHAR2(128)

 

 

Name of object affected by the action

 

ACTION_NAME

 

VARCHAR2(27)

 

 

Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL

 

NEW_NAME

 

VARCHAR2(128)

 

 

New name of an object after a RENAME or the name of the underlying object

 

OBJ_PRIVILEGE

 

VARCHAR2(16)

 

 

Object privileges granted or revoked by a GRANT or REVOKE statement

 

SYS_PRIVILEGE

 

VARCHAR2(40)

 

 

System privileges granted or revoked by a GRANT or REVOKE statement

 

ADMIN_OPTION

 

VARCHAR2(1)

 

 

Signifies the role or system privilege was granted with ADMIN option

 

GRANTEE

 

VARCHAR2(30)

 

 

Name of grantee specified in a GRANT or REVOKE statement

 

AUDIT_OPTION

 

VARCHAR2(40)

 

 

Auditing option set with the AUDIT statement

 

SES_ACTIONS

 

VARCHAR2(19)

 

 

Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)

 

COMMENT_TEXT

 

VARCHAR2(4000)

 

 

Text comment on the audit trail, inserted by the application

 

SESSIONID

 

NUMBER

 

NOT NULL

 

Numeric ID for each Oracle session

 

ENTRYID

 

NUMBER

 

NOT NULL

 

Numeric ID for each audit trail entry in the session

 

STATEMENTID

 

NUMBER

 

NOT NULL

 

Numeric ID for each statement run

 

RETURNCODE

 

NUMBER

 

NOT NULL

 

Oracle Server message code generated by the action. Some useful values:

  • zero: the action succeeded
  • 2004: security violation
 

PRIV_USED

 

VARCHAR2(40)

 

 

System privilege used to execute the action

 

SESSION_LABEL

 

MLSLABEL

 

 

Label associated with the session. Applies to Trusted Oracle Server only.

 

DBA_AUDIT_TRAIL

This view lists all audit trail entries.

Column   Datatype   NULL   Description  

OS_USERNAME

 

VARCHAR2(255)

 

 

Operating system login username of the user whose actions were audited

 

USERNAME

 

VARCHAR2(30)

 

 

Name (not ID number) of the user whose actions were audited

 

USERHOST

 

VARCHAR2(2000)

 

 

Numeric instance ID for the Oracle instance from which the user is accessing the database

 

TERMINAL

 

VARCHAR2(2000)

 

 

Identifier of the user's terminal

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp for the creation of the audit trail entry or login time for the CONNECT statement

 

OWNER

 

VARCHAR2(30)

 

 

Creator of the object affected by the action

 

OBJ_NAME

 

VARCHAR2(128)

 

 

Name of the object affected by the action

 

ACTION

 

NUMBER

 

NOT NULL

 

Numeric type code corresponding to the action

 

ACTION_NAME

 

VARCHAR2(27)

 

 

Name of the action type corresponding to the numeric code in the ACTION column

 

NEW_OWNER

 

VARCHAR2(30)

 

 

Owner of the object named in the NEW_NAME column

 

NEW_NAME

 

VARCHAR2(128)

 

 

New name of an object after a RENAME or the name of the underlying object

 

OBJ_PRIVILEGE

 

VARCHAR2(16)

 

 

Object privileges granted or revoked by a GRANT or REVOKE statement

 

SYS_PRIVILEGE

 

VARCHAR2(40)

 

 

System privileges granted or revoked by a GRANT or REVOKE statement

 

ADMIN_OPTION

 

VARCHAR2(1)

 

 

Signifies the role or system privilege was granted with ADMIN option

 

GRANTEE

 

VARCHAR2(30)

 

 

Name of grantee specified in a GRANT or REVOKE statement

 

AUDIT_OPTION

 

VARCHAR2(40)

 

 

Auditing option set with the AUDIT statement

 

SES_ACTIONS

 

VARCHAR2(19)

 

 

Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - for none, S for success, F for failure, and B for both)

 

LOGOFF_TIME

 

DATE

 

 

Timestamp for user log off

 

LOGOFF_LREAD

 

NUMBER

 

 

Logical reads for the session

 

LOGOFF_PREAD

 

NUMBER

 

 

Physical reads for the session

 

LOGOFF_LWRITE

 

NUMBER

 

 

Logical writes for the session

 

LOGOFF_DLOCK

 

VARCHAR2(40)

 

 

Deadlocks detected during the session

 

COMMENT_TEXT

 

VARCHAR2(4000)

 

 

Text comment on the audit trail entry, providing more information about the statement audited

 

SESSIONID

 

NUMBER

 

NOT NULL

 

Numeric ID for each Oracle session

 

ENTRYID

 

NUMBER

 

NOT NULL

 

Numeric ID for each audit trail entry in the session

 

STATEMENTID

 

NUMBER

 

NOT NULL

 

Numeric ID for each statement run

 

RETURNCODE

 

NUMBER

 

NOT NULL

 

Oracle Server message code generated by the action. Some useful values:

  • zero: the action succeeded
  • 2004: security violation
 

PRIV_USED

 

VARCHAR2(40)

 

 

System privilege used to execute the action

 

OBJECT_LABEL

 

MLSLABEL

 

 

Label associated with the object being audited. Applies to Trusted Oracle Server only.

 

SESSION_LABEL

 

MLSLABEL

 

 

Label associated with the session. Applies to Trusted Oracle Server only.

 

DBA_BLOCKERS

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

Column   Datatype   NULL   Description  

HOLDING_SESSION

 

NUMBER

 

 

Session holding a lock

 

DBA_CATALOG

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TABLE_TYPE

 

VARCHAR2(11)

 

 

Type of the object

 

DBA_CLU_COLUMNS

This view lists mappings of table columns to cluster columns.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the cluster

 

CLUSTER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Cluster name

 

CLU_COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Key column in the cluster

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Clustered table name

 

TAB_COLUMN_NAME

 

VARCHAR2(4000)

 

 

Key column or attribute of the object type column

 

DBA_CLUSTERS

This view contains description of all clusters in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the cluster

 

CLUSTER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the cluster

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the cluster

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

NOT NULL

 

Minimum percentage of used space in a block

 

KEY_SIZE

 

NUMBER

 

 

Estimated size of cluster key plus associated rows

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

AVG_BLOCKS_PER_KEY

 

NUMBER

 

 

Average number of blocks containing rows with a given cluster key

 

CLUSTER_TYPE

 

VARCHAR2(5)

 

 

Type of cluster: B-Tree index or hash

 

FUNCTION

 

VARCHAR2(15)

 

 

If a hash cluster, the hash function

 

HASHKEYS

 

NUMBER

 

 

If a hash cluster, the number of hash keys (hash buckets)

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

DBA_COL_COMMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the column

 

COMMENTS

 

VARCHAR2(4000)

 

 

Comment on the object

 

DBA_COL_PRIVS

This view lists all grants on columns in the database.

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the column

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Column privilege

 

GRANTABLE

 

VARCHAR2(3)

 

 

Privilege is Grantable

 

DBA_COLL_TYPES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

COLL_TYPE

 

VARCHAR2(30)

 

NOT NULL

 

Collection type

 

UPPER_BOUND

 

NUMBER

 

 

Maximum size of the VARRAY type

 

ELEM_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the element

 

ELEM_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the element

 

ELEM_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the element

 

LENGTH

 

NUMBER

 

 

Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element

 

PRECISION

 

NUMBER

 

 

Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element

 

SCALE

 

NUMBER

 

 

Scale of the NUMBER or DECIMAL element

 

CHARACTER_SET_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS NCHAR_CS

 

DBA_CONSTRAINTS

This view contains constraint definitions on all tables.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table

 

CONSTRAINT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with constraint definition

 

CONSTRAINT_TYPE

 

VARCHAR2(1)

 

 

Type of constraint definition:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option on a view)
O (with read only, on a view)

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with table with constraint definition

 

SEARCH_CONDITION

 

LONG

 

 

Text of search condition for table check

 

R_OWNER

 

VARCHAR2(30)

 

 

Owner of table used in referential constraint

 

R_CONSTRAINT_NAME

 

VARCHAR2(30)

 

 

Owner of table used in referential constraint

 

DELETE_RULE

 

VARCHAR2(9)

 

 

The delete rule for a referential constraint

 

STATUS

 

VARCHAR2(8)

 

 

Enforcement status of constraint: ENABLED or DISABLED

 

DEFERRABLE

 

VARCHAR2(14)

 

 

Indicates whether the constraint is deferrable

 

DEFERRED

 

VARCHAR2(9)

 

 

Indicates whether the constraint was initially deferred

 

GENERATED

 

VARCHAR2(14)

 

 

Indicates whether the name system is generated

 

LAST_CHANGE

 

DATE

 

 

Indicates when the constraint was last enabled or disabled

 

BAD

 

VARCHAR2(3)

 

 

Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.

 

VALIDATED

 

VARCHAR2(13)

 

 

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

 

DBA_CONS_COLUMNS

This view contains information about accessible columns in constraint definitions.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the constraint definition

 

CONSTRAINT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with the constraint definition

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name associated with table with constraint definition

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name associated with column or attribute of the object type column specified in the constraint definition

 

POSITION

 

NUMBER

 

 

Original position of column or attribute in definition

 

DBA_DATA_FILES

This view contains information about database files.

Column   Datatype   NULL   Description  

FILE_NAME

 

VARCHAR2(513)

 

 

Name of the database file

 

FILE_ID

 

NUMBER

 

NOT NULL

 

ID of the database file

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace to which the file belongs

 

BYTES

 

NUMBER

 

 

Size of the file in bytes

 

BLOCKS

 

NUMBER

 

NOT NULL

 

Size of the file in Oracle blocks

 

STATUS

 

VARCHAR2(9)

 

 

File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)

 

RELATIVE_FNO

 

NUMBER

 

 

Relative file number

 

AUTOEXTENSIBLE

 

VARCHAR2(3)

 

 

Autoextensible indicator

 

MAXBYTES

 

NUMBER

 

 

Maximum file size in bytes

 

MAXBLOCKS

 

NUMBER

 

 

Maximum file size in blocks

 

INCREMENT_BY

 

NUMBER

 

 

Autoextension increment

 

DBA_DB_LINKS

This view lists all database links in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the database link

 

DB_LINK

 

VARCHAR2(128)

 

NOT NULL

 

Name of the database link

 

USERNAME

 

VARCHAR2(3)

 

 

Name of user to log in as

 

HOST

 

VARCHAR2(2000)

 

 

Connect string

 

CREATED

 

DATE

 

NOT NULL

 

Creation time of the database link

 

DBA_DDL_LOCKS

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

Column   Datatype   NULL   Description  

SESSION_ID

 

NUMBER

 

 

Session identifier

 

OWNER

 

VARCHAR2(30)

 

 

Owner of the lock

 

NAME

 

VARCHAR2(30)

 

 

Name of the lock

 

TYPE

 

VARCHAR2(40)

 

 

Lock type: CURSOR, TABLE/PROCEDURE/TYPE, BODY, TRIGGER, INDEX, CLUSTER

 

MODE_HELD

 

VARCHAR2(9)

 

 

Lock mode: NONE, NULL, SHARE, EXCLUSIVE

 

MODE_REQUESTED

 

VARCHAR2(9)

 

 

Lock request type: NONE, NULL, SHARE, EXCLUSIVE

 

DBA_DEPENDENCIES

This view lists dependencies to and from objects.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(3)

 

NOT NULL

 

Name of the object

 

TYPE

 

VARCHAR2(12)

 

 

Type of the object

 

REFERENCED_OWNER

 

VARCHAR2(30)

 

 

Owner of referenced object (remote owner if remote object)

 

REFERENCED_NAME

 

VARCHAR2(64)

 

 

Name of referenced object

 

REFERENCED_TYPE

 

VARCHAR2(12)

 

 

Type of referenced object

 

REFERENCED_LINK
_NAME

 

VARCHAR2(128)

 

 

Name of dblink if this is a remote object

 

DEPENDENCY_TYPE

 

VARCHAR2(4)

 

 

Two values: REF when the dependency is a REF dependency; HARD otherwise

 

DBA_DIRECTORIES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the directory (always SYS)

 

DIRECTORY_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the directory

 

DIRECTORY_PATH

 

VARCHAR2(4000)

 

 

Operating system pathname for the directory

 

DBA_DML_LOCKS

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

Column   Datatype   NULL   Description  

SESSION_ID

 

NUMBER

 

 

Session holding or acquiring the lock

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the lock

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the lock

 

MODE_HELD

 

VARCHAR2(13)

 

 

Lock mode: see Table 2-1

 

MODE_REQUESTED

 

VARCHAR2(13)

 

 

Lock request type: see Table 2-1

 

LAST_CONVERT

 

NUMBER

 

 

The last convert

 

BLOCKING_OTHERS

 

VARCHAR2(40)

 

 

Blocking others

 

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

Table 2-1 Lock Modes for the DBA_DML_LOCKS View
Lock Mode   Description  

ROWS-S (SS)

 

Row share

 

ROW-X (SX)

 

Row exclusive

 

SHARE (S)

 

Share

 

S/ROW-X (SSX)

 

Exclusive

 

NONE

 

MODE_HELD: Lock requested, not yet obtained MODE_REQUESTED: Lock identifier obtained, lock not held or requested

 

DBA_ERRORS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

The owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TYPE

 

VARCHAR2(12)

 

 

Type of object: VIEW, PROCEDURE, FUNCTION, PACKAGE, TYPE, TYPE BODY, PACKAGE BODY, or TRIGGER

 

SEQUENCE

 

NUMBER

 

NOT NULL

 

Sequence number used for ordering purposes

 

LINE

 

NUMBER

 

NOT NULL

 

Line number at which this error occurs

 

POSITION

 

NUMBER

 

NOT NULL

 

Position in the line at which this error occurs

 

TEXT

 

VARCHAR2(4000)

 

NOT NULL

 

Text of the error

 

DBA_EXP_FILES

This view contains a description of export files.

Column   Datatype   NULL   Description  

EXP_VERSION

 

NUMBER(3)

 

NOT NULL

 

Version number of the export session

 

EXP_TYPE

 

VARCHAR2(11)

 

 

Type of export file: complete, cumulative, or incremental

 

FILE_NAME

 

VARCHAR2(100)

 

NOT NULL

 

Name of the export file

 

USER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of user who executed export

 

TIMESTAMP

 

DATE

 

NOT NULL

 

Timestamp of the export session

 

DBA_EXP_OBJECTS

This view lists objects that have been incrementally exported.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of exported object

 

OBJECT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of exported object

 

OBJECT_TYPE

 

VARCHAR2(12)

 

 

Type of exported object

 

CUMULATIVE

 

DATE

 

 

Timestamp of last cumulative export

 

INCREMENTAL

 

DATE

 

NOT NULL

 

Timestamp of last incremental export

 

EXPORT_VERSION

 

NUMBER(3)

 

NOT NULL

 

The ID of the export session

 

DBA_EXP_VERSION

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

Column   Datatypes   NULL   Description  

EXP_VERSION

 

NUMBER(3)

 

NOT NULL

 

Version number of the last export session

 

DBA_EXTENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the segment associated with the extent

 

SEGMENT_NAME

 

VARCHAR2(81)

 

 

Name of the segment associated with the extent

 

SEGMENT_TYPE

 

VARCHAR2(17)

 

 

Type of the segment: INDEX PARTITION, TABLE PARTITION

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the extent

 

EXTENT_ID

 

NUMBER

 

NOT NULL

 

Extent number in the segment

 

FILE_ID

 

NUMBER

 

NOT NULL

 

Name of the file containing the extent

 

BLOCK_ID

 

NUMBER

 

NOT NULL

 

Starting block number of the extent

 

BYTES

 

NUMBER

 

 

Size of the extent in bytes

 

BLOCKS

 

NUMBER

 

NOT NULL

 

Size of the extent in Oracle blocks

 

RELATIVE_FNO

 

NUMBER

 

NOT NULL

 

Relative file number of the first extent block

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Object Partition Name (Set to NULL for non-partitioned objects).

 

DBA_FREE_SPACE

This view lists the free extents in all tablespaces.

Column   Datatype   NULL   Description  

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the extent

 

FILE_ID

 

NUMBER

 

NOT NULL

 

ID number of the file containing the extent

 

BLOCK_ID

 

NUMBER

 

NOT NULL

 

Starting block number of the extent

 

BYTES

 

NUMBER

 

 

Size of the extent in bytes

 

BLOCKS

 

NUMBER

 

NOT NULL

 

Size of the extent in Oracle blocks

 

RELATIVE_FNO

 

NUMBER

 

NOT NULL

 

Relative file number of the first extent block

 

DBA_FREE_SPACE_COALESCED

This view contains statistics on coalesced space in tablespaces.

Column   Datatype   NULL   Description  

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of tablespace

 

TOTAL_EXTENTS

 

NUMBER

 

 

Total number of free extents in tablespace

 

EXTENTS_COALESCED

 

NUMBER

 

 

Total number of coalesced free extents in tablespace

 

PERCENT_EXTENTS
_COALESCED

 

NUMBER

 

 

Percentage of coalesced free extents in tablespace

 

TOTAL_BYTES

 

NUMBER

 

 

Total number of free bytes in tablespace

 

BYTES_COALESCED

 

NUMBER

 

 

Total number of coalesced free bytes in tablespace

 

TOTAL_BLOCKS

 

NUMBER

 

 

Total number of free Oracle blocks in tablespace

 

BLOCKS_COALESCED

 

NUMBER

 

 

Total number of coalesced free Oracle blocks in tablespace

 

PERCENT_BLOCKS
_COALESCED

 

NUMBER

 

 

Percentage of coalesced free Oracle blocks in tablespace

 

DBA_INDEXES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the index

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the index

 

INDEX_TYPE

 

VARCHAR2(12)

 

 

Type of index

 

TABLE_OWNER

 

VARCHAR2(30)

 

 

Owner of the indexed object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the indexed object

 

TABLE_TYPE

 

VARCHAR2(11)

 

NOT NULL

 

Type of the indexed object

 

UNIQUENESS

 

VARCHAR2(9)

 

 

Uniqueness status of the index: UNIQUE or NONUNIQUE

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the index

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of initial extent

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

PCT_THRESHOLD

 

NUMBER

 

 

Threshold percentage of block space allowed per index entry

 

INCLUDE_COLUMN

 

NUMBER

 

 

User column-id for last column to be included in index organized table top index

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BLEVEL

 

NUMBER

 

 

B-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.

 

LEAF_BLOCKS

 

NUMBER

 

 

The number of leaf blocks in the index

 

DISTINCT_KEYS

 

NUMBER

 

 

The number of distinct keys in the index

 

AVG_LEAF_BLOCKS
_PER_KEY

 

NUMBER

 

 

The average number of leaf blocks per key

 

AVG_DATA_BLOCKS
_PER_KEY

 

NUMBER

 

 

The average number of data blocks per key

 

CLUSTERING_FACTOR

 

NUMBER

 

 

A measurement of the amount of (dis)order of the table this index is for

 

STATUS

 

VARCHAR2(8)

 

 

Whether index is in Direct Load State

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in this index

 

SAMPLE_SIZE

 

NUMBER

 

 

Size of the sample used to analyze this index

 

LAST_ANALYZED

 

DATE

 

 

Timestamp for when this index was last analyzed

 

DEGREE

 

VARCHAR2(40)

 

 

Number of threads per instance for scanning the index. NULL if PARTITIONED=NO.

 

INSTANCES

 

VARCHAR2(40)

 

 

Number of instances across which the indexes are to be scanned. NULL if PARTITIONED=NO.

 

PARTITIONED

 

VARCHAR2(3)

 

 

Indicates whether this index is partitioned. Set to YES if it is partitioned

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

GENERATED

 

VARCHAR2(1)

 

 

Was the name of this index system generated?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

DBA_IND_COLUMNS

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

Column   Datatype   NULL   Description  

INDEX_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Index owner

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Index name

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Table or cluster owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table or cluster name

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Column name or attribute of the object type column

 

COLUMN_POSITION

 

NUMBER

 

NOT NULL

 

Position of column or attribute within index

 

COLUMN_LENGTH

 

NUMBER

 

NOT NULL

 

Indexed length of the column or attribute

 

DBA_IND_PARTITIONS

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

Column   Datatype   NULL   Description  

INDEX_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Index owner

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Index name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Partition name

 

HIGH_VALUE

 

LONG

 

 

Partition bound value expression

 

HIGH_VALUE_LENGTH

 

NUMBER

 

NOT NULL

 

Length of partition bound value expression

 

PARTITION_POSITION

 

NUMBER

 

NOT NULL

 

Position of the partition within the index

 

STATUS

 

VARCHAR2(8)

 

 

Indicates whether index partition is usable or not

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the partition

 

PCT_FREE

 

NUMBER

 

NOT NULL

 

Minimum percentage of free space in a block

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENT

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENT

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of process freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute of partition

 

BLEVEL

 

NUMBER

 

 

B-Tree level

 

LEAF_BLOCKS

 

NUMBER

 

 

Number of leaf blocks in the index partition

 

DISTINCT_KEYS

 

NUMBER

 

 

Number of distinct keys in the index partition

 

AVG_LEAF_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of leaf blocks per key

 

AVG_DATA_BLOCKS
_PER_KEY

 

NUMBER

 

 

Average number of data blocks per key

 

CLUSTERING_FACTOR

 

NUMBER

 

 

Measurement of the amount of (dis)order of the table this index partition is for

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in this index partition

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this partition

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this partition was analyzed

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The buffer pool for this partition

 

DBA_JOBS

This view lists all jobs in the database.

Column   Datatype   NULL   Description  

JOB

 

NUMBER

 

NOT NULL

 

Identifier of job. Neither import/export nor repeated executions change it.

 

LOG_USER

 

VARCHAR2(30)

 

NOT NULL

 

USER who was logged in when the job was submitted

 

PRIV_USER

 

VARCHAR2(30)

 

NOT NULL

 

USER whose default privileges apply to this job

 

SCHEMA_USER

 

VARCHAR2(30)

 

NOT NULL

 

Default schema used to parse the job.

For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.

 

LAST_DATE

 

DATE

 

 

Date that this job last successfully executed

 

LAST_SEC

 

VARCHAR2(8)

 

 

Same as LAST_DATE. This is when the last successful execution started.

 

THIS_DATE

 

DATE

 

 

Date that this job started executing (usually NULL if not executing)

 

THIS_SEC

 

VARCHAR2(8)

 

 

Same as THIS_DATE.

 

NEXT_DATE

 

DATE

 

NOT NULL

 

Date that this job will next be executed

 

NEXT_SEC

 

VARCHAR2(8))

 

 

Same as NEXT_DATE. The job becomes due for execution at this time.

 

TOTAL_TIME

 

NUMBER

 

 

Total wall clock time spent by the system on this job, in seconds

 

BROKEN

 

VARCHAR2(1)

 

 

If Y, no attempt is made to run this job.

 

INTERVAL

 

VARCHAR2(200)

 

NOT NULL

 

A date function, evaluated at the start of execution, becomes next NEXT_DATE

 

FAILURES

 

NUMBER

 

 

How many times has this job started and failed since its last success?

 

WHAT

 

VARCHAR2(4000)

 

 

Body of the anonymous PL/SQL block that this job executes

 

CURRENT_SESSION
_LABEL

 

MLSLABEL

 

 

Trusted Oracle Server label of the current session as seen by the job. Applies to Trusted Oracle Server only.

 

CLEARANCE_HI

 

MLSLABEL

 

 

Highest level of clearance available to the job. Applies to Trusted Oracle Server only.

 

CLEARANCE_LO

 

MLSLABEL

 

 

Lowest level of clearance available to the job. Applies to Trusted Oracle Server only.

 

NLS_ENV

 

VARCHAR2(4000)

 

 

ALTER SESSION parameters describing the NLS environment of the job

 

MISC_ENV

 

RAW(32)

 

 

Other session parameters that apply to this job

 

DBA_JOBS_RUNNING

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

Column   Datatype   NULL   Description  

SID

 

NUMBER

 

 

Identifier of process that is executing the job. See "V$LOCK" on page 3-51.

 

JOB

 

NUMBER

 

 

Identifier of job. This job is currently executing.

 

FAILURES

 

NUMBER

 

 

Number of times this job started and failed since its last success

 

LAST_DATE

 

DATE

 

 

Date that this job last successfully executed

 

LAST_SEC

 

VARCHAR2(8)

 

 

Same as LAST_DATE. This is when the last successful execution started.

 

THIS_DATE

 

DATE

 

 

Date that this job started executing

 

THIS_SEC

 

VARCHAR2(8)

 

 

Same as THIS_DATE. This is when the job started executing.

 

DBA_LIBRARIES

This view lists all the libraries in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the library

 

LIBRARY_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Library name

 

FILE_SPEC

 

VARCHAR2(2000)

 

 

Operating system file specification associated with the library

 

DYNAMIC

 

VARCHAR2(1)

 

 

Is the library dynamically loadable? (YES or NO)

 

STATUS

 

VARCHAR2(7)

 

 

Status of the library

 

DBA_LOBS

This view displays the LOBs contained in all tables.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table containing the LOB

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table containing the LOB

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Name of the LOB column or attribute

 

SEGMENT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the LOB segment

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the LOB index

 

CHUNK

 

NUMBER

 

 

Size of the LOB chunk as a unit of allocation/manipulation in bytes

 

PCTVERSION

 

NUMBER

 

NOT NULL

 

Maximum percentage of the LOB space used for versioning

 

CACHE

 

VARCHAR2(3)

 

 

Indicates whether the LOB is accessed through the buffer cache

 

LOGGING

 

VARCHAR2(3)

 

 

Indicates whether the changes to the LOB are logged

 

IN_ROW

 

VARCHAR2(3)

 

 

Are some of the LOBs stored with the base row?

 

DBA_LOCKS

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

Column   Datatype   NULL   Description  

SESSION_ID

 

NUMBER

 

 

Session holding or acquiring the lock

 

LOCK_TYPE

 

VARCHAR2(26)

 

 

Lock type

 

MODE HELD

 

VARCHAR2(40)

 

 

Lock mode

 

MODE REQUESTED

 

VARCHAR2(40)

 

 

Lock mode requested

 

LOCK_ID1

 

VARCHAR2(40)

 

 

Type-specific lock identifier, part 1

 

LOCK_ID2

 

VARCHAR2(40)

 

 

Type-specific lock identifier, part 2

 

LAST_CONVERT

 

NUMBER

 

 

The last convert

 

BLOCKING_OTHERS

 

VARCHAR2(40)

 

 

Blocking others

 

DBA_METHOD_PARAMS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

Method number for distinguishing overloaded method (not to be used as ID number)

 

PARAM_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the parameter

 

PARAM_NO

 

NUMBER

 

NOT NULL

 

Parameter number or position

 

PARAM_MODE

 

VARCHAR2(6)

 

 

Mode of the parameter

 

PARAM_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the parameter

 

PARAM_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the parameter

 

PARAM_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the parameter

 

CHARACTER_SET
_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS NCHAR_CS

 

DBA_METHOD_RESULTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

The method number

 

RESULT_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the result

 

RESULT_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the result

 

RESULT_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the result

 

CHARACTER_SET_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS, NCHAR_CS

 

DBA_NESTED_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the nested table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the nested table

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of which the nested table was created

 

TABLE_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the nested table

 

PARENT_TABLE_NAME

 

VARCHAR2(30)

 

 

Name of the parent table containing the nested table

 

PARENT_TABLE_COLUMN

 

VARCHAR2(4000)

 

 

Column name of the parent table that corresponds to the nested table

 

DBA_OBJECT_SIZE

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TYPE

 

VARCHAR2(12)

 

 

Type of the object: TABLE, VIEW, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, or PACKAGE BODY

 

SOURCE_SIZE

 

NUMBER

 

 

Size of the source in bytes

 

PARSED_SIZE

 

NUMBER

 

 

Size of the parsed form of the object in bytes

 

CODE_SIZE

 

NUMBER

 

 

Code size in bytes

 

ERROR_SIZE

 

NUMBER

 

 

Size of error messages in bytes

 

DBA_OBJECT_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last modification?

 

NUM_ROWS

 

NUMBER

 

 

The number of rows in the table

 

BLOCKS

 

NUMBER

 

 

The number of used blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

The number of empty (never used) blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

The average available free space in the table

 

CHAIN_CNT

 

NUMBER

 

 

The number of chained rows in the table

 

AVG_ROW_LEN

 

NUMBER

 

 

The average row length, including row overhead

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

The number of threads per instance for scanning the table

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

The sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

The date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Is this table partitioned? YES or NO

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

 

TABLE_TYPE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

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

 

TABLE_TYPE

 

VARCHAR2(30)

 

NOT NULL

 

Type of the table if the table is a typed table

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

The default buffer pool to be used for table blocks

 

DBA_OBJECTS

This view lists all objects in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Username of the owner of the object

 

OBJECT_NAME

 

VARCHAR2(128)

 

 

Name of the object

 

SUBOBJECT_NAME

 

VARCHAR2(30)

 

 

Name of the sub-object (for example, partition)

 

OBJECT_ID

 

NUMBER

 

 

Object number of the object

 

DATA_OBJECT_ID

 

NUMBER

 

 

Object number of the segment which contains the object

 

OBJECT_TYPE

 

VARCHAR2(15)

 

 

Type and type body of the object: INDEX PARTITION, TABLE PARTITION, PACKAGE, PACKAGE BODY, or TRIGGER

 

CREATED

 

DATE

 

 

Timestamp for the creation of the object

 

LAST_DDL_TIME

 

DATE

 

 

Timestamp for the last DDL change (including GRANT and REVOKE) to the object

 

TIMESTAMP

 

VARCHAR2(20)

 

 

Timestamp for the specification of the object

 

STATUS

 

VARCHAR2(7)

 

 

Status of the object

 

TEMPORARY

 

VARCHAR2(1)

 

 

Can the current session only see data that it place in this object itself?

 

GENERATED

 

VARCHAR2(1)

 

 

Was the name of this object system generated?

 

DBA_OBJ_AUDIT_OPTS

This view lists auditing options for all tables and views.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the object

 

OBJECT_NAME

 

VARCHAR2(30)

 

 

Name of the object

 

OBJECT_TYPE

 

VARCHAR2(9)

 

 

Type of the object

 

ALT

 

VARCHAR2(3)

 

 

Auditing ALTER WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

AUD

 

VARCHAR2(3)

 

 

Auditing AUDIT WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

COM

 

VARCHAR2(3)

 

 

Auditing COMMENT WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

DEL

 

VARCHAR2(3)

 

 

Auditing DELETE WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

GRA

 

VARCHAR2(3)

 

 

Auditing GRANT WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

IND

 

VARCHAR2(3)

 

 

Auditing INDEX WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

INS

 

VARCHAR2(3)

 

 

Auditing INSERT WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

LOC

 

VARCHAR2(3)

 

 

Auditing LOCK WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

REN

 

VARCHAR2(3)

 

 

Auditing RENAME WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

SEL

 

VARCHAR2(3)

 

 

Auditing SELECT WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

UPD

 

VARCHAR2(3)

 

 

Auditing UPDATE WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

REF

 

VARCHAR2(3)

 

 

Auditing REFERENCE WHENEVER SUCCESSFUL/UNSUCCESSFUL (not used)

 

EXE

 

VARCHAR2(3)

 

 

Auditing EXE WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

CRE

 

VARCHAR2(3)

 

 

Auditing CRE WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

REA

 

VARCHAR2(3)

 

 

Auditing REA WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

WRI

 

VARCHAR2(3)

 

 

Auditing WRI WHENEVER SUCCESSFUL/UNSUCCESSFUL

 

DBA_PART_COL_STATISTICS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner name

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Table partition name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

NUM_DISTINCT

 

NUMBER

 

 

Number of distinct values in the column

 

LOW_VALUE

 

RAW(32)

 

 

Low value in the column

 

HIGH_VALUE

 

RAW(32)

 

 

High value in the column

 

DENSITY

 

NUMBER

 

 

Density of the column

 

NUM_NULLS

 

NUMBER

 

 

Number of nulls in the column

 

NUM_BUCKETS

 

NUMBER

 

 

Number of buckets in histogram for the column

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this column

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this column was analyzed

 

DBA_PART_HISTOGRAMS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner name

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Table partition name

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Column name

 

BUCKET_NUMBER

 

NUMBER

 

 

Bucket number

 

ENDPOINT_VALUE

 

NUMBER

 

 

Normalized endpoint values for this bucket

 

DBA_PART_INDEXES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of this partitioned index

 

INDEX_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of this partitioned index

 

PARTITIONING_TYPE

 

VARCHAR2(7)

 

 

Partitioning algorithm: RANGE

 

PARTITION_COUNT

 

NUMBER

 

NOT NULL

 

Number of partitions in this index

 

PARTITIONING_KEY
_COUNT

 

NUMBER

 

NOT NULL

 

Number of columns in the partitioning key

 

LOCALITY

 

VARCHAR2(6)

 

 

Indicates whether this partitioned index is LOCAL or GLOBAL

 

ALIGNMENT

 

VARCHAR2(12)

 

 

Indicates whether this partitioned index is PREFIXED or NON-PREFIXED

 

DEF_TABLESPACE
_NAME

 

VARCHAR2(30)

 

 

Default TABLESPACE, used for LOCAL index, for ADD/SPLIT TABLE PARTITION

 

DEF_PCT_FREE

 

NUMBER

 

NOT NULL

 

Default PCTFREE, used for LOCAL index, for ADD TABLE PARTITION

 

DEF_INI_TRANS

 

NUMBER

 

NOT NULL

 

Default INITRANS, used for LOCAL index, for ADD TABLE PARTITION

 

DEF_MAX_TRANS

 

NUMBER

 

NOT NULL

 

Default MAXTRANS, used for LOCAL index, for ADD TABLE PARTITION

 

DEF_INITIAL_EXTENT

 

NUMBER

 

 

Default INITIAL, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified

 

DEF_NEXT_EXTENT

 

NUMBER

 

 

Default NEXT, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified

 

DEF_MIN_EXTENTS

 

NUMBER

 

 

Default MINEXTENTS, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified

 

DEF_MAX_EXTENTS

 

NUMBER

 

 

Default MAXEXTENTS, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified

 

DEF_PCT_INCREASE

 

NUMBER

 

 

Default PCTINCREASE, used for LOCAL index, for ADD TABLE PARTITION, `DEFAULT' if attribute was not specified

 

DEF_FREELISTS

 

NUMBER

 

NOT NULL

 

Default FREELISTS, used for LOCAL index, for ADD TABLE PARTITION

 

DEF_FREELIST_GROUPS

 

NUMBER

 

NOT NULL

 

Default FREELISTS, used for LOCAL index, for ADD TABLE PARTITION

 

DEF_LOGGING

 

VARCHAR2(7)

 

 

Default LOGGING, for LOCAL index, for ADD TABLE PARTITION

 

DEF_BUFFER_POOL

 

VARCHAR2(7)

 

 

Default buffer pool for the index, for ADD TABLE PARTITION

 

DBA_PART_KEY_COLUMNS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Partitioned table or index owner

 

NAME

 

VARCHAR2(30)

 

 

Partitioned table or index name

 

OBJECT_TYPE

 

VARCHAR2(11)

 

 

The object type (`TABLE' or `INDEX')

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Column name

 

COLUMN_POSITION

 

NUMBER

 

 

Position of the column within the partitioning key

 

DBA_PART_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of this partitioned table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of this partitioned table

 

PARTITIONING_TYPE

 

VARCHAR2(7)

 

 

Partitioning algorithm: RANGE

 

PARTITION_COUNT

 

NUMBER

 

NOT NULL

 

Number of partitions in this table

 

PARTITIONING_KEY
_COUNT

 

NUMBER

 

NOT NULL

 

Number of columns in the partitioning key

 

DEF_TABLESPACE
_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Default TABLESPACE, used for ADD partition

 

DEF_PCT_FREE

 

NUMBER

 

NOT NULL

 

Default PCTFREE, used for ADD partition

 

DEF_PCT_USED

 

NUMBER

 

NOT NULL

 

Default PCTUSED, used for ADD partition

 

DEF_INI_TRANS

 

NUMBER

 

NOT NULL

 

Default INITRANS, used for ADD partition

 

DEF_MAX_TRANS

 

NUMBER

 

NOT NULL

 

Default MAXTRANS, used for ADD partition

 

DEF_INITIAL_EXTENT

 

VARCHAR2(40)

 

 

Default INITIAL, used for ADD partition, `DEFAULT' if attribute was not specified

 

DEF_NEXT_EXTENT

 

VARCHAR2(40)

 

 

Default NEXT, used for ADD partition, `DEFAULT' if attribute was not specified

 

DEF_MIN_EXTENTS

 

VARCHAR2(40)

 

 

Default MINEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified

 

DEF_MAX_EXTENTS

 

VARCHAR2(40)

 

 

Default MAXEXTENTS, used for ADD partition, `DEFAULT' if attribute was not specified

 

DEF_PCT_INCREASE

 

VARCHAR2(40)

 

 

Default PCTINCREASE, used for ADD partition, `DEFAULT' if attribute was not specified

 

DEF_FREELISTS

 

NUMBER

 

NOT NULL

 

Default FREELISTS, used for ADD partition

 

DEF_FREELIST
_GROUPS

 

NUMBER

 

NOT NULL

 

Default FREELIST GROUPS, used for ADD partition

 

DEF_LOGGING

 

VARCHAR2(7)

 

 

Default LOGGING attribute, used for ADD partition

 

DEF_BUFFER_POOL

 

VARCHAR2(7)

 

 

Default buffer pool for the given object, used for ADD partition

 

DBA_PRIV_AUDIT_OPTS

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

Column   Datatype   NULL   Description  

USER_NAME

 

VARCHAR2(30)

 

 

User name if by user auditing, else NULL for system-wide auditing

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Name of the system privilege being audited

 

SUCCESS

 

VARCHAR2(10)

 

 

Mode for WHENEVER SUCCESSFUL system auditing

 

FAILURE

 

VARCHAR2(10)

 

 

Mode for WHENEVER NOT SUCCESSFUL system auditing

 

DBA_PROFILES

This view displays all profiles and their limits.

Column   Datatype   NULL   Description  

PROFILE

 

VARCHAR2(30)

 

NOT NULL

 

Profile name

 

RESOURCE_NAME

 

VARCHAR2(32)

 

NOT NULL

 

Resource name

 

RESOURCE_TYPE

 

VARCHAR2(8)

 

 

Indicates whether the resource profile is a KERNEL or a PASSWORD parameter

 

LIMIT

 

VARCHAR2(40)

 

 

Limit placed on this resource for this profile

 

DBA_QUEUE_SCHEDULES

This view describes the current schedules for propagating messages.

Column   Datatype   NULL   Description  

SCHEMA

 

VARCHAR2(30)

 

NOT NULL

 

Schema name for the source queue

 

QNAME

 

VARCHAR2(30)

 

NOT NULL

 

Source queue name

 

DESTINATION

 

VARCHAR2(128)

 

NOT NULL

 

Destination name, currently limited to be a DBLINK name

 

START_DATE

 

DATE

 

 

Date to start propagation in the default date format

 

START_TIME

 

VARCHAR2(8)

 

 

Time of day at which to start propagation in HH:MI:SS format

 

PROPAGATION
_WINDOW

 

NUMBER

 

 

Duration in seconds for the propagation window

 

NEXT_TIME

 

VARCHAR2(128)

 

 

Function to compute the start of the next propagation window

 

LATENCY

 

NUMBER

 

 

Maximum wait time to propagate a message during the propagation window

 

DBA_ QUEUE_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Schema of the queue table

 

QUEUE_TABLE

 

VARCHAR2(30)

 

 

Name of the queue table

 

TYPE

 

VARCHAR2(7)

 

 

Type of user data:
RAW: raw type
OBJECT: user-defined object type
VARIANT: variant type (internal use only)

 

OBJECT_TYPE

 

VARCHAR2(61)

 

 

Object type of the payload when TYPE is OBJECT

 

SORT_ORDER

 

VARCHAR2(22)

 

 

User specified sort order

 

RECIPIENTS

 

VARCHAR2(8)

 

 

SINGLE or MULTIPLE recipients

 

MESSAGE_GROUPING

 

VARCHAR2(13)

 

 

NONE or TRANSACTIONAL

 

USER_COMMENT

 

VARCHAR2(50)

 

 

Comment supplied by the user

 

DBA_ QUEUES

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

Column   Datatypes   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the queue schema

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the queue

 

QUEUE_TABLE

 

VARCHAR2(30)

 

NOT NULL

 

The name of the queue table where this queue resides

 

QID

 

NUMBER

 

NOT NULL

 

Unique queue identifier

 

QUEUE_TYPE

 

VARCHAR2(15)

 

 

Queue type:
NORMAL_QUEUE - Normal queue
EXCEPTION_QUEUE - Exception queue

 

MAX_RETRIES

 

NUMBER

 

 

Number of dequeue attempts allowed

 

RETRY_DELAY

 

NUMBER

 

 

Time lapse in seconds before retry takes place

 

ENQUEUE_ENABLED

 

VARCHAR2(7)

 

 

YES/NO

 

DEQUEUE_ENABLED

 

VARCHAR2(7)

 

 

YES/NO

 

RETENTION

 

VARCHAR2(40)

 

 

Number of seconds message is retained after dequeue FOREVER - messages stay in the queue permanently

 

USER_COMMENT

 

VARCHAR2(50)

 

 

User comment about the table

 

DBA_RCHILD

This view lists all the children in any refresh group.

Column   Datatype   NULL   Description  

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object in the refresh group

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object in the refresh group

 

TYPE#

 

VARCHAR2(30)

 

 

Type of the object in the refresh group

 

DBA_REFRESH

This view lists all the refresh groups.

Column   Datatype   NULL   Description  

ROWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the refresh group

 

RNAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the refresh group

 

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

IMPLICIT_DESTROY

 

VARCHAR2(1)

 

 

Y or N; if Y, then destroy the refresh group when its last item is removed

 

PUSH_DEFERRED_RPC

 

VARCHAR2(1)

 

 

Y or N; if Y, then push changes from snapshot to master before refresh

 

REFRESH_AFTER
_ERRORS

 

VARCHAR2(1)

 

 

Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's

 

ROLLBACK_SEG

 

VARCHAR2(30)

 

 

Name of the rollback segment to use while refreshing

 

JOB

 

NUMBER

 

 

Identifier of job used to refresh the group automatically

 

NEXT_DATE

 

DATE

 

 

Date that this job will next be refreshed automatically, if not broken

 

INTERVAL

 

VARCHAR2(200)

 

 

A date function used to compute the next NEXT_DATE

 

BROKEN

 

VARCHAR2(1)

 

 

Y or N; Y means the job is broken and will never be run

 

PURGE_OPTION

 

NUMBER(38)

 

 

The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option

 

PARALLELISM

 

NUMBER(38)

 

 

The level of parallelism for transaction propagation

 

HEAP_SIZE

 

NUMBER(38)

 

 

The size of the heap.

 

DBA_REFRESH_CHILDREN

This view lists all of the objects in refresh groups.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object in the refresh group

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object in the refresh group

 

TYPE

 

VARCHAR2(30)

 

 

Type of the object in the refresh group

 

ROWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the refresh group

 

RNAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the refresh group

 

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

IMPLICIT_DESTROY

 

VARCHAR2(1)

 

 

Y or N; if Y, then destroy the refresh group when its last item is removed

 

PUSH_DEFERRED_RPC

 

VARCHAR2(1)

 

 

Y or N; if Y, then push changes from snapshot to master before refresh

 

REFRESH_AFTER
_ERRORS

 

VARCHAR2(1)

 

 

Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's

 

ROLLBACK_SEG

 

VARCHAR2(30)

 

 

Name of the rollback segment to use while refreshing

 

JOB

 

NUMBER

 

 

Identifier of job used to refresh the group automatically

 

NEXT_DATE

 

DATE

 

 

Date that this job will next be refreshed automatically, if not broken

 

INTERVAL

 

VARCHAR2(200)

 

 

A date function used to compute the next NEXT_DATE

 

BROKEN

 

VARCHAR2(1)

 

 

Y or N; Y means the job is broken and will never be run

 

PURGE_OPTION

 

NUMBER(38)

 

 

The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge option

 

PARALLELISM

 

NUMBER(38)

 

 

The level of parallelism for transaction propagation

 

HEAP_SIZE

 

NUMBER(38)

 

 

The size of the heap.

 

DBA_REFS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

COLUMN_NAME

 

VARCHAR2
(4000)

 

 

Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name.

 

WITH_ROWID

 

VARCHAR2(3)

 

 

Is the REF value stored with ROWID? (YES or NO)

 

IS_SCOPED

 

VARCHAR2(3)

 

 

Is the REF column scoped? (YES or NO)

 

SCOPE_TABLE
_OWNER

 

VARCHAR2(30)

 

 

Name of the owner of the scope table, if it exists

 

SCOPE_TABLE
_NAME

 

VARCHAR2(30)

 

 

Name of the scope table, if it exists

 

DBA_REGISTERED_SNAPSHOT_GROUPS

This view lists all the snapshot repgroups at this site.

Column   Datatype   NULL   Description  

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the snapshot replication group

 

SNAPSHOT_SITE

 

VARCHAR2(128)

 

NOT NULL

 

Site of the master of the snapshot repgroup

 

GROUP_COMMENT

 

VARCHAR2(80)

 

 

Description of the snapshot repgroup

 

VERSION

 

VARCHAR2(8)

 

 

Version of the snapshot repgroup

 

DBA_REGISTERED_SNAPSHOTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the snapshot

 

SNAPSHOT_SITE

 

VARCHAR2(128)

 

NOT NULL

 

Global name of the snapshot site

 

CAN_USE_LOG

 

VARCHAR2(3)

 

 

If set to NO, this snapshot is complex and cannot fast refresh

 

UPDATABLE

 

VARCHAR2(3)

 

 

If set to NO, the snapshot is read only

 

REFRESH_METHOD

 

VARCHAR2(11)

 

 

Values used to drive a refresh of the snapshot
(PRIMARY KEY/ROWID/COMPLEX). If PRIMARY KEY, then the snapshot uses primary keys to drive a fast refresh. If ROWID, then it uses RowIDs to drive a fast refresh. If COMPLEX, then fast refreshes are not allowed and the snapshot can only perform complete refreshes.

 

SNAPSHOT_ID

 

NUMBER(38)

 

 

Identifier for the snapshot used by the master for fast refresh

 

VERSION

 

VARCHAR2(17)

 

 

Version of snapshot

 

QUERY_TXT

 

LONG

 

 

Query defining the snapshot

 

DBA_REPCATLOG

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

DBA_REPCOLUMN

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

DBA_REPCOLUMN_GROUP

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

DBA_REPCONFLICT

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

DBA_REPDDL

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

DBA_REPGENERATED

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

DBA_REPGROUP

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

DBA_REPGROUPED_COLUMN

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

DBA_REPKEY_COLUMNS

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

DBA_REPOBJECT

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

DBA_REPPARAMETER_COLUMN

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

DBA_REPPRIORITY

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

DBA_REPPRIORITY_GROUP

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

DBA_REPPROP

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

DBA_REPRESOLUTION

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

DBA_REPRESOLUTION_METHOD

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

DBA_REPRESOL_STATS_CONTROL

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

DBA_REPSITES

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

DBA_RGROUP

This view lists all refresh groups.

Column   Datatype   NULL   Description  

REFGROUP

 

NUMBER

 

 

Internal identifier of refresh group

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object in the refresh group

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object in the refresh group

 

IMPLICIT_DESTROY

 

VARCHAR2(1)

 

 

Y or N; if Y, then destroy the refresh group when its last item is removed

 

PUSH_DEFERRED_RPC

 

VARCHAR2(1)

 

 

Y or N; if Y, then push changes from snapshot to master before refresh

 

REFRESH_AFTER
_ERRORS

 

VARCHAR2(1)

 

 

Y or N; if Y, proceed with refresh despite error when pushing deferred RPC's

 

ROLLBACK_SEG

 

VARCHAR2(30)

 

 

Name of the rollback segment to use while refreshing

 

JOB

 

NUMBER

 

NOT NULL

 

Identifier of job used to refresh the group automatically

 

PURGE_OPTION

 

NUMBER(38)

 

 

The method for purging the transaction queue after each push. 1=quick purge option; 2=precise purge
option

 

PARALLELISM

 

NUMBER(38)

 

 

The level of parallelism for transaction propagation

 

HEAP_SIZE

 

NUMBER(38)

 

 

The size of the heap.

 

DBA_ROLES

This view lists all roles that exist in the database.

Column   Datatype   NULL   Description  

ROLE

 

VARCHAR2(30)

 

NOT NULL

 

Role name

 

PASSWORD_REQUIRED

 

VARCHAR2(8)

 

 

Indicates if the role requires a password to be enabled

 

DBA_ROLE_PRIVS

This view lists roles granted to users and roles.

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

 

Grantee name, user or role receiving the grant

 

GRANTED_ROLE

 

VARCHAR2(30)

 

NOT NULL

 

Granted role name

 

ADMIN_OPTION

 

VARCHAR2(3)

 

 

Whether the grant was with the ADMIN option: YES/NO

 

DEFAULT_ROLE

 

VARCHAR2(3)

 

 

Whether the role is designated as a DEFAULT ROLE for the user: YES/NO

 

DBA_ROLLBACK_SEGS

This view contains descriptions of rollback segments.

Column   Datatype   NULL   Description  

SEGMENT_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the rollback segment

 

OWNER

 

VARCHAR2(6)

 

 

Owner of the rollback segment

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the rollback segment

 

SEGMENT_ID

 

NUMBER

 

NOT NULL

 

ID number of the rollback segment

 

FILE_ID

 

NUMBER

 

NOT NULL

 

ID number of the file containing the segment head

 

BLOCK_ID

 

NUMBER

 

NOT NULL

 

ID number of the block containing the segment header

 

INITIAL_EXTENT

 

NUMBER

 

 

Initial extent size in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Secondary extent size in bytes

 

MIN_EXTENTS

 

NUMBER

 

NOT NULL

 

Minimum number of extents

 

MAX_EXTENTS

 

NUMBER

 

NOT NULL

 

Maximum number of extent

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percent increase for extent size

 

STATUS

 

VARCHAR2(16)

 

 

Rollback segment status

 

INSTANCE_NUM

 

VARCHAR2(40)

 

 

Rollback segment owning parallel server instance number

 

RELATIVE_FNO

 

NUMBER

 

NOT NULL

 

Relative file number of the segment header

 

DBA_SEGMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Username of the segment owner

 

SEGMENT_NAME

 

VARCHAR2(81)

 

 

Name, if any, of the segment

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Object Partition Name (Set to NULL for non-partitioned objects).

 

SEGMENT_TYPE

 

VARCHAR2(17)

 

 

Type of segment: INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, or CACHE

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the segment

 

HEADER_FILE

 

NUMBER

 

 

ID of the file containing the segment header

 

HEADER_BLOCK

 

NUMBER

 

 

ID of the block containing the segment header

 

BYTES

 

NUMBER

 

 

Size in bytes, of the segment

 

BLOCKS

 

NUMBER

 

 

Size, in Oracle blocks, of the segment

 

EXTENTS

 

NUMBER

 

 

Number of extents allocated to the segment

 

INITIAL_EXTENT

 

NUMBER

 

 

Size in bytes of the initial extent of the segment

 

NEXT_EXTENT

 

NUMBER

 

 

Size in bytes of the next extent to be allocated to the segment

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percent by which to increase the size of the next extent to be allocated

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

RELATIVE_FNO

 

NUMBER

 

 

Relative file number of the segment header

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

DBA_SEQUENCES

This view contains descriptions of all sequences in the database.

Column   Datatype   NULL   Description  

SEQUENCE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the owner of the sequence

 

SEQUENCE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Sequence name

 

MIN_VALUE

 

NUMBER

 

 

Minimum value of the sequence

 

MAX_VALUE

 

NUMBER

 

 

Maximum value of the sequence

 

INCREMENT_BY

 

NUMBER

 

NOT NULL

 

Value by which sequence is incremented

 

CYCLE_FLAG

 

VARCHAR2(1)

 

 

Does sequence wrap around on reaching limit?

 

ORDER_FLAG

 

VARCHAR2(1)

 

 

Are sequence numbers generated in order?

 

CACHE_SIZE

 

NUMBER

 

NOT NULL

 

Number of sequence numbers to cache

 

LAST_NUMBER

 

NUMBER

 

NOT NULL

 

Last sequence number written to disk

 

DBA_SNAPSHOT_LOGS

This view lists all snapshot logs in the database.

Column   Datatype   NULL   Description  

LOG_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot log

 

MASTER

 

VARCHAR2(30)

 

NOT NULL

 

Name of the master table of which the log logs changes

 

LOG_TABLE

 

VARCHAR2(30)

 

NOT NULL

 

Log table; holds timestamps and changes made to the master table

 

LOG_TRIGGER

 

VARCHAR2(30)

 

 

Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserts rows into the log

 

FILTER_COLUMNS

 

VARCHAR2(3)

 

 

If set to YES, the snapshot log records filter column information

 

ROWIDS

 

VARCHAR2(3)

 

 

If set to YES, the snapshot log records ROWID information

 

PRIMARY_KEY

 

VARCHAR2(3)

 

 

If set to YES, the snapshot log records primary key information

 

CURRENT_SNAPSHOTS

 

DATE

 

 

One date per snapshot; the date the snapshot of the master last refreshed

 

SNAPSHOT_ID

 

NUMBER(38)

 

 

Unique identifier of the snapshot

 

DBA_SNAPSHOT_REFRESH_TIMES

This view lists snapshot refresh times.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the snapshot view

 

MASTER_OWNER

 

VARCHAR2(30)

 

 

Owner of the master table

 

MASTER

 

VARCHAR2(30)

 

 

Name of the master table

 

LAST_REFRESH

 

DATE

 

 

The last refresh

 

DBA_SNAPSHOTS

This view lists all snapshots in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the snapshot

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

The view used by users and applications for viewing the snapshot

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table the snapshot is stored in.

 

MASTER_VIEW

 

VARCHAR2(30)

 

 

View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8 and is set to NULL.

 

MASTER_OWNER

 

VARCHAR2(30)

 

 

Owner of the master table

 

MASTER

 

VARCHAR2(30)

 

 

Name of the master table of which this snapshot is a copy

 

MASTER_LINK

 

VARCHAR2(128)

 

 

Database link name to the master site

 

CAN_USE_LOG

 

VARCHAR2(3)

 

 

If NO, this snapshot is complex and will never use a log

 

UPDATABLE

 

VARCHAR2(3)

 

 

If NO, the snapshot is read only

 

LAST_REFRESH

 

DATE

 

 

SYSDATE from the master site at the time of the last refresh

 

ERROR

 

NUMBER

 

 

The number of failed automatic refreshes since last successful refresh

 

TYPE

 

VARCHAR2(8)

 

 

The type of refresh (complete, fast, force) for all automatic refreshes

 

NEXT

 

VARCHAR2(200)

 

 

The date function used to compute next refresh dates

 

START_WITH

 

DATE

 

 

The date expression for the first automatic refresh time.

 

REFRESH_GROUP

 

NUMBER

 

 

All snapshots in a given refresh group get refreshed in the same transaction

 

REFRESH_METHOD

 

VARCHAR2(11)

 

 

Values used to drive a fast refresh of the snapshot

 

UPDATE_TRIG

 

VARCHAR2(30)

 

 

Obsolete with the release of Oracle8 Server. Set to NULL. Formerly, this parameter was the name of the trigger that fills the UPDATE_LOG

 

UPDATE_LOG

 

VARCHAR2(30)

 

 

The table that logs changes made to an updatable snapshots

 

QUERY

 

LONG

 

 

The original query of which this snapshot is an instantiation

 

FR_OPERATIONS

 

VARCHAR2(10)

 

 

Status of generated fast refresh operations: (REGENERATE, VALID)

 

CR_OPERATIONS

 

VARCHAR2(10)

 

 

Status of generated complete refresh operations: (REGENERATE, VALID)

 

MASTER_ROLLBACK
_SEG

 

VARCHAR2(30)

 

 

The rollback segment used at the master site

 

DBA_SOURCE

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TYPE

 

VARCHAR2(12)

 

 

Type of the object: PROCEDURE, FUNCTION, PACKAGE, TYPE, TYPE BODY, or PACKAGE BODY

 

LINE

 

NUMBER

 

NOT NULL

 

Line number of this line of source

 

TEXT

 

VARCHAR2(4000)

 

 

Source text

 

DBA_STMT_AUDIT_OPTS

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

Column   Datatype   NULL   Description  

USER_NAME

 

VARCHAR2(30)

 

 

User name if by user auditing, else NULL for system-wide auditing

 

AUDIT_OPTION

 

VARCHAR2(40)

 

NOT NULL

 

Name of the system auditing option

 

SUCCESS

 

VARCHAR2(10)

 

 

Mode for WHENEVER SUCCESSFUL system auditing

 

FAILURE

 

VARCHAR2(10)

 

 

Mode for WHENEVER NOT SUCCESSFUL system auditing

 

DBA_SYNONYMS

This view lists all synonyms in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Username of the owner of the synonym

 

SYNONYM_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the synonym

 

TABLE_OWNER

 

VARCHAR2(30)

 

 

Owner of the object referenced by the synonym

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object referenced by the synonym

 

DB_LINK

 

VARCHAR2(128)

 

 

Name of the database link referenced in a remote synonym

 

DBA_SYS_PRIVS

This view lists system privileges granted to users and roles.

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

Grantee name, user, or role receiving the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

System privilege

 

ADMIN_OPTION

 

VARCHAR2(3)

 

 

Grant was with the ADMIN option

 

DBA_TAB_COL_STATISTICS

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

Column   Datatype   NULL   Description  

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

NUM_DISTINCT

 

NUMBER

 

 

Number of distinct values in the column

 

LOW_VALUE

 

RAW(32)

 

 

Low value in the column

 

HIGH_VALUE

 

RAW(32)

 

 

High value in the column

 

DENSITY

 

NUMBER

 

 

Density of the column

 

NUM_NULLS

 

NUMBER

 

 

Number of nulls in the column

 

NUM_BUCKETS

 

NUMBER

 

 

Number of buckets in histogram for the column

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this column

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this column was analyzed

 

DBA_TAB_COLUMNS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table, view, or cluster

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table, view, or cluster name

 

COLUMN_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Column name

 

DATA_TYPE

 

VARCHAR2(30)

 

 

Datatype of the column

 

DATA_TYPE_MOD

 

VARCHAR2(3)

 

 

Datatype modifier of the column

 

DATA_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the datatype of the column

 

DATA_LENGTH

 

NUMBER

 

NOT NULL

 

Length of the column in bytes

 

DATA_PRECISION

 

NUMBER

 

 

Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes

 

DATA_SCALE

 

NUMBER

 

 

Digits to right of decimal point in a number

 

NULLABLE

 

VARCHAR2(1)

 

 

Does column allow NULL values?

 

COLUMN_ID

 

NUMBER

 

NOT NULL

 

Sequence number of the column as created

 

DEFAULT_LENGTH

 

NUMBER

 

 

Length of default value for the column

 

DATA_DEFAULT

 

LONG

 

 

 

NUM_DISTINCT

 

NUMBER

 

 


These columns remain for backward compatibility with Oracle7. This information is now in the {TAB|PART}_COL_STATISTICS views.

 

LOW_VALUE

 

RAW(32)

 

 

HIGH_VALUE

 

RAW(32)

 

 

DENSITY

 

NUMBER

 

 

NUM_NULLS

 

NUMBER

 

 

NUM_BUCKETS

 

NUMBER

 

 

 

LAST_ANALYZED

 

DATE

 

 

 

SAMPLE_SIZE

 

SAMPLE_SIZE

 

 

 

CHARACTER_SET
_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS, NCHAR_CS

 

CHAR_COL_DECL
_LENGTH

 

NUMBER

 

 

 

DBA_TAB_COMMENTS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

TABLE_TYPE

 

VARCHAR2(11)

 

 

Type of the object.

 

COMMENTS

 

VARCHAR2(4000)

 

 

Comment on the object

 

DBA_TAB_HISTOGRAMS

This view lists histograms on columns of all tables.

Column   Datatype   NULL   Description  

ENDPOINT_VALUE

 

VARCHAR2(30)

 

 

Owner of Table

 

TABLE_NAME

 

VARCHAR2(30)

 

 

Table name

 

COLUMN_NAME

 

VARCHAR2(30)

 

 

Column name or attribute of the object type column

 

BUCKET_NUMBER

 

NUMBER

 

 

Bucket number

 

ENDPOINT_VALUE

 

NUMBER

 

 

Normalized endpoint values for this bucket

 

DBA_TAB_PARTITIONS

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

Column   Datatype   NULL   Description  

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Table owner

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Table name

 

PARTITION_NAME

 

VARCHAR2(30)

 

 

Partition name

 

HIGH_VALUE

 

LONG

 

 

Partition bound value expression

 

HIGH_VALUE_LENGTH

 

NUMBER

 

NOT NULL

 

Length of partition bound value expression

 

PARTITION_POSITION

 

NUMBER

 

NOT NULL

 

Position of the partition within the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the tablespace containing the partition

 

PCT_FREE

 

NUMBER

 

NOT NULL

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

NOT NULL

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

NOT NULL

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

NOT NULL

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENT

 

NUMBER

 

NOT NULL

 

Minimum number of extents allowed in the segment

 

MAX_EXTENT

 

NUMBER

 

NOT NULL

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated in this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated in this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Logging attribute of partition

 

NUM_ROWS

 

NUMBER

 

 

Number of rows in the partition

 

BLOCKS

 

NUMBER

 

 

Number of used blocks in the partition

 

EMPTY_BLOCKS

 

NUMBER

 

 

Number of empty (never used) blocks in the partition

 

AVG_SPACE

 

NUMBER

 

 

Average available free space in the partition

 

CHAIN_CNT

 

NUMBER

 

 

Number of chained rows in the partition

 

AVG_ROW_LEN

 

NUMBER

 

 

Average row length, including row overhead

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this partition

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this partition was analyzed

 

BUFFER_POOL

 

VARCHAR2(7)

 

NOT NULL

 

The buffer pool for the partition

 

DBA_TAB_PRIVS

This view lists all grants on objects in the database.

Column   Datatype   NULL   Description  

GRANTEE

 

VARCHAR2(30)

 

NOT NULL

 

User to whom access was granted

 

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the object

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the object

 

GRANTOR

 

VARCHAR2(30)

 

NOT NULL

 

Name of the user who performed the grant

 

PRIVILEGE

 

VARCHAR2(40)

 

NOT NULL

 

Table Privilege

 

GRANTABLE

 

VARCHAR2(3)

 

 

Privilege is grantable

 

DBA_TABLES

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

TABLESPACE_NAME

 

VARCHAR2(30)

 

 

Name of the tablespace containing the table

 

CLUSTER_NAME

 

VARCHAR2(30)

 

 

Name of the cluster, if any, to which the table belongs

 

IOT_NAME

 

VARCHAR2(30)

 

 

Name of the index organized table, if any, to which the overflow entry belongs

 

PCT_FREE

 

NUMBER

 

 

Minimum percentage of free space in a block

 

PCT_USED

 

NUMBER

 

 

Minimum percentage of used space in a block

 

INI_TRANS

 

NUMBER

 

 

Initial number of transactions

 

MAX_TRANS

 

NUMBER

 

 

Maximum number of transactions

 

INITIAL_EXTENT

 

NUMBER

 

 

Size of the initial extent in bytes

 

NEXT_EXTENT

 

NUMBER

 

 

Size of secondary extents in bytes

 

MIN_EXTENTS

 

NUMBER

 

 

Minimum number of extents allowed in the segment

 

MAX_EXTENTS

 

NUMBER

 

 

Maximum number of extents allowed in the segment

 

PCT_INCREASE

 

NUMBER

 

 

Percentage increase in extent size

 

FREELISTS

 

NUMBER

 

 

Number of process freelists allocated to this segment

 

FREELIST_GROUPS

 

NUMBER

 

 

Number of freelist groups allocated to this segment

 

LOGGING

 

VARCHAR2(3)

 

 

Whether logging is enabled (YES or NO)

 

BACKED_UP

 

VARCHAR2(1)

 

 

Has table been backed up since last modification?

 

NUM_ROWS

 

NUMBER

 

 

Number of rows returned by the ANALYZE command

 

BLOCKS

 

NUMBER

 

 

The number of used data blocks in the table

 

EMPTY_BLOCKS

 

NUMBER

 

 

The number of empty (never used) data blocks in the table

 

AVG_SPACE

 

NUMBER

 

 

The average available free space in the table

 

CHAIN_CNT

 

NUMBER

 

 

The number of chained rows in the table

 

AVG_ROW_LEN

 

NUMBER

 

 

The average row length, including row overhead

 

AVG_SPACE_FREELIST
_BLOCKS

 

NUMBER

 

 

The average freespace of all blocks on a freelist

 

NUM_FREELIST_BLOCKS

 

NUMBER

 

 

The number of blocks on the freelist

 

DEGREE

 

VARCHAR2(10)

 

 

Number of query servers used for a full-table scan

 

INSTANCES

 

VARCHAR2(10)

 

 

The number of instances across which the table is to be scanned

 

CACHE

 

VARCHAR2(5)

 

 

Whether the table is to be cached in the buffer cache

 

TABLE_LOCK

 

VARCHAR2(8)

 

 

Whether table locking is enabled or disabled

 

SAMPLE_SIZE

 

NUMBER

 

 

Sample size used in analyzing this table

 

LAST_ANALYZED

 

DATE

 

 

Date of the most recent time this table was analyzed

 

PARTITIONED

 

VARCHAR2(3)

 

 

Indicates whether this table is partitioned. Set to YES if it is partitioned

 

IOT_TYPE

 

VARCHAR2(12)

 

 

If this is an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW. If this is not an index organized table, then IOT_TYPE is NULL

 

TABLE_TYPE_OWNER

 

VARCHAR2(0)

 

 

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

 

TABLE_TYPE

 

VARCHAR2(0)

 

 

Type of the table if the table is a typed table

 

PACKED

 

VARCHAR2(0)

 

 

If the table is a typed table, does it store objects in packed format?

 

TEMPORARY

 

VARCHAR2(1)

 

 

Whether the table is temporary (Y or N)

 

NESTED

 

VARCHAR2(3)

 

 

Is the table a nested table?

 

BUFFER_POOL

 

VARCHAR2(7)

 

 

Name of the default buffer pool for the appropriate object

 

DBA_TABLESPACES

This view contains descriptions of all tablespaces.

Column   Datatype   NULL   Description  

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Tablespace name

 

INITIAL_EXTENT

 

NUMBER

 

 

Default initial extent size

 

NEXT_EXTENT

 

NUMBER

 

 

Default incremental extent size

 

MIN_EXTENTS

 

NUMBER

 

NOT NULL

 

Default minimum number of extents

 

MAX_EXTENTS

 

NUMBER

 

NOT NULL

 

Default maximum number of extents

 

PCT_INCREASE

 

NUMBER

 

NOT NULL

 

Default percent increase for extent size

 

MIN_EXTLEN

 

NUMBER

 

 

Minimum extent size for the tablespace

 

STATUS

 

VARCHAR2(9)

 

 

Tablespace status: ONLINE, OFFLINE, or READ ONLY

 

CONTENTS

 

VARCHAR2(9)

 

 

Tablespace contents: "PERMANENT", or "TEMPORARY"

 

LOGGING

 

VARCHAR2(9)

 

 

Default logging attribute

 

DBA_TRIGGERS

This view lists all triggers in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the trigger

 

TRIGGER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the trigger

 

TRIGGER_TYPE

 

VARCHAR2(16)

 

 

When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT

 

TRIGGERING_EVENT

 

VARCHAR2(26)

 

 

Statement that will fire the trigger: INSERT, UPDATE, and/or DELETE

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table with which this trigger is associated

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table

 

REFERENCING
_NAMES

 

VARCHAR2(87)

 

 

Names used for referencing OLD and NEW values within the trigger

 

WHEN_CLAUSE

 

VARCHAR2(4000)

 

 

WHEN clause must evaluate to true in order for triggering body to execute

 

STATUS

 

VARCHAR2(8)

 

 

If DISABLED, then trigger will not fire

 

DESCRIPTION

 

VARCHAR2(4000)

 

 

Trigger description, useful for re-creating trigger creation statement

 

TRIGGER_BODY

 

LONG

 

 

Action taken by this trigger when it fires

 

DBA_TRIGGER_COLS

This view lists column usage in all triggers.

Column   Datatype   NULL   Description  

TRIGGER_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the trigger

 

TRIGGER_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the trigger

 

TABLE_OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the table

 

TABLE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the table on which the trigger is defined

 

COLUMN_NAME

 

VARCHAR2(4000)

 

 

Name of the column used in trigger definition

 

COLUMN_LIST

 

VARCHAR2(3)

 

 

Is column specified in UPDATE OF clause?

 

COLUMN_USAGE

 

VARCHAR2(17)

 

 

Usage of column within trigger body

 

DBA_TS_QUOTAS

This view lists tablespace quotas for all users.

Column   Datatype   NULL   Description  

TABLESPACE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Tablespace name

 

USERNAME

 

VARCHAR2(30)

 

NOT NULL

 

User with resource rights on the tablespace

 

BYTES

 

NUMBER

 

 

Number of bytes charged to the user

 

MAX_BYTES

 

NUMBER

 

 

User's quota in bytes, or -1 if no limit.

 

BLOCKS

 

NUMBER

 

NOT NULL

 

Number of Oracle blocks charged to the user

 

MAX_BLOCKS

 

NUMBER

 

 

User's quota in Oracle blocks, or -1 if no limit.

 

DBA_TYPE_ATTRS

This view displays the attributes of types in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

ATTR_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the attribute

 

ATTR_TYPE_MOD

 

VARCHAR2(7)

 

 

Type modifier of the attribute

 

ATTR_TYPE_OWNER

 

VARCHAR2(30)

 

 

Owner of the type of the attribute

 

ATTR_TYPE_NAME

 

VARCHAR2(30)

 

 

Name of the type of the attribute

 

LENGTH

 

NUMBER

 

 

Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute

 

PRECISION

 

NUMBER

 

 

Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute

 

SCALE

 

NUMBER

 

 

Scale of the NUMBER or DECIMAL attribute

 

CHARACTER_SET_NAME

 

VARCHAR2(44)

 

 

The name of the character set: CHAR_CS NCHAR_CS

 

DBA_TYPE_METHODS

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

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

NOT NULL

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

METHOD_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the method

 

METHOD_NO

 

NUMBER

 

NOT NULL

 

Method number for distinguishing overloaded method (not to be used as the ID number

 

METHOD_TYPE

 

VARCHAR2(6)

 

 

Type of the method

 

PARAMETERS

 

NUMBER

 

NOT NULL

 

Number of parameters to the method

 

RESULTS

 

NUMBER

 

NOT NULL

 

Number of results returned by the method

 

DBA_TYPES

This view displays all abstract datatypes in the database.

Column   Datatype   NULL   Description  

OWNER

 

VARCHAR2(30)

 

 

Owner of the type

 

TYPE_NAME

 

VARCHAR2(30)

 

NOT NULL

 

Name of the type

 

TYPE_OID

 

RAW(16)

 

NOT NULL

 

Object identifier (OID) of the type

 

TYPECODE

 

VARCHAR2(30)

 

 

Typecode of the type

 

ATTRIBUTES

 

NUMBER

 

 

Number of attributes in the type

 

METHODS

 

NUMBER

 

 

Number of methods in the type

 

PREDEFINED

 

VARCHAR2(3)

 

 

Indicates whether the type is a predefined type

 

INCOMPLETE

 

VARCHAR2(3)

 

 

Indicates whether the type is an incomplete type

 

DBA_UPDATABLE_COLUMNS

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

Column   Datatype   NULL   Description