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
|
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
|
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
|
SEQ
This is a synonym for USER_SEQUENCES. For more information see "USER_SEQUENCES" on page 2-157.
SESSION_PRIVS
This view lists the privileges that are currently available to the user.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
PRIVILEGE
|
VARCHAR2(40)
|
NOT NULL
|
Name of the privilege
|
SESSION_ROLES
This view lists the roles that are currently enabled to the user.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
ROLE
|
VARCHAR2(30)
|
NOT NULL
|
Name of the role
|
SOURCE_SIZE
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" on page 2-68, and "USER_OBJECT_SIZE" on page 2-146.
STMT_AUDIT_OPTION_MAP
This view contains information about auditing option type codes.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
OPTION#
|
NUMBER
|
NOT NULL
|
Numeric auditing option type code
|
|
NAME
|
VARCHAR2(40)
|
NOT NULL
|
Name of the auditing option
|
SYN
This is a synonym for USER_SYNONYMS. For more information, see "USER_SYNONYMS" on page 2-159.
SYNONYMS
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
SYSCATALOG
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
SYSFILES
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
SYSSEGOBJ
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
SYSTEM_PRIVILEGE_MAP
This view contains information about system privilege codes.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
PRIVILEGE
|
NUMBER
|
NOT NULL
|
Numeric privilege type code
|
|
NAME
|
VARCHAR2(40)
|
NOT NULL
|
Name of the type of privilege
|
SYS_OBJECTS
This view maps object IDs to object types and segment data block addresses.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
OBJECT_TYPE
|
VARCHAR2(15)
|
|
Type of the object
|
|
OBJECT_TYPE_ID
|
NUMBER
|
|
Type ID of the object
|
|
SEGMENT_TYPE_ID
|
NUMBER
|
|
Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE
|
|
OBJECT_ID
|
NUMBER
|
|
Object identifier
|
|
HEADER_FILE
|
NUMBER
|
|
ID of the file containing the segment header
|
|
HEADER_BLOCK
|
NUMBER
|
|
ID of the block containing the segment header
|
|
TS_NUMBER
|
NUMBER
|
|
The tablespace number
|
TAB
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
TABLE_PRIVILEGES
This view contains information on grants on objects for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee. This view is included for compatibility with Oracle version 6. Use of this view is not recommended.
|
Column
|
Datatype
|
NULL
|
Descrip >Column
|
Datatype
|
NULL
|
Description
|
|---|
|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
The owner of the object
|
|
NAME
|
VARCHAR2(30)
|
NOT NULL
|
The name of the object that will be lost as a result of undergoing tablespace point-in-time recovery
|
|
CREATION_TIME
|
DATE
|
NOT NULL
|
Creation timestamp of the object
|
|
TABLESPACE_NAME
|
VARCHAR2(30)
|
|
Name of the tablespace containing the object
|
USER_ALL_TABLES
This table contains descriptions of the tables (object tables and relational tables) available to the user.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
TABLE_NAME
|
VARCHAR2(30)
|
|
Name of the table
|
|
TABLESPACE_NAME
|
VARCHAR2(30)
|
|
Name of the tablespace containing the table
|
|
CLUSTER_NAME
|
VARCHAR2(30)
|
|
Name of the cluster, if any, to which the table belongs
|
|
IOT_NAME
|
VARCHAR2(30)
|
|
Name of the index organized table, if any, to which the overflow entry belongs
|
|
PCT_FREE
|
NUMBER
|
|
Minimum percentage of free space in a block
|
|
PCT_USED
|
NUMBER
|
|
Minimum percentage of used space in a block
|
|
INI_TRANS
|
NUMBER
|
|
Initial number of transactions
|
|
MAX_TRANS
|
NUMBER
|
|
Maximum number of transactions
|
|
INITIAL_EXTENT
|
NUMBER
|
|
Size of the initial extent in bytes
|
|
NEXT_EXTENT
|
NUMBER
|
|
Size of secondary extents in bytes
|
|
MIN_EXTENTS
|
NUMBER
|
|
Minimum number of extents allowed in the segment
|
|
MAX_EXTENTS
|
NUMBER
|
|
Maximum number of extents allowed in the segment
|
|
PCT_INCREASE
|
NUMBER
|
|
Percentage increase in extent size
|
|
FREELISTS
|
NUMBER
|
|
Number of process freelists allocated in this segment
|
|
FREELIST_GROUPS
|
NUMBER
|
|
Number of freelist groups allocated in this segment
|
|
LOGGING
|
VARCHAR2(3)
|
|
Logging attribute
|
|
BACKED_UP
|
VARCHAR2(1)
|
|
Has table been backed up since last modification?
|
|
NUM_ROWS
|
NUMBER
|
|
The number of rows in the table
|
|
BLOCKS
|
NUMBER
|
|
The number of used blocks in the table
|
|
EMPTY_BLOCKS
|
NUMBER
|
|
The number of empty (never used) blocks in the table
|
|
AVG_SPACE
|
NUMBER
|
|
The average available free space in the table
|
|
CHAIN_CNT
|
NUMBER
|
|
The number of chained rows in the table
|
|
AVG_ROW_LEN
|
NUMBER
|
|
The average row length, including row overhead
|
|
AVG_SPACE_FREELIST
_BLOCKS
|
NUMBER
|
|
The average freespace of all blocks on a freelist
|
|
NUM_FREELIST_BLOCKS
|
NUMBER
|
|
The number of blocks on the freelist
|
|
DEGREE
|
VARCHAR2(10)
|
|
The number of threads per instance f P>
|
Collection type
|
|
UPPER_BOUND
|
NUMBER
|
|
Maximum size of the VARYING ARRAY type
|
|
ELEM_TYPE_MOD
|
VARCHAR2(7)
|
|
Type modifier of the element
|
|
ELEM_TYPE_OWNER
|
VARCHAR2(30)
|
|
Owner of the type of the element
|
|
ELEM_TYPE_NAME
|
VARCHAR2(30)
|
|
Name of the type of the element
|
|
LENGTH
|
NUMBER
|
|
Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
|
|
PRECISION
|
NUMBER
|
|
Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
|
|
SCALE
|
NUMBER
|
|
Scale of the NUMBER or DECIMAL element
|
|
CHARACTER_SET_NAME
|
VARCHAR2(44)
|
|
The name of the character set: CHAR_CS, NCHAR_CS
|
USER_CONSTRAINTS
This view lists constraint definitions on user's tables.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
OWNER
|
T SIZE="-1">Maximum length of the column in bytes
|
DATA_TYPE
|
VARCHAR2(30)
|
|
Datatype of the column
|
|
DATA_TYPE_MOD
|
VARCHAR2(3)
|
|
Datatype modifier of the column
|
|
DATA_TYPE_OWNER
|
VARCHAR2(30)
|
|
Owner of the datatype of the column
|
|
DATA_PRECISION
|
NUMBER
|
|
Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes
|
|
DATA_SCALE
|
NUMBER
|
|
Digits to right of decimal point in a number
|
|
NULLABLE
|
VARCHAR2(1)
|
|
Does column allow NULLs? Value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY.
|
|
COLUMN_ID
|
NUMBER
|
NOT NULL
|
Sequence number of the column as created
|
|
DEFAULT_LENGTH
|
NUMBER
|
|
Length of default value for the column
|
|
DATA_DEFAULT
|
LONG
|
|
Default value for the column
|
|
NUM_DISTINCT
|
NUMBER
|
|
These columns remain for backward compatibility with Oracle7. This information is now in the {TAB|PART}_COL_STATISTICS views. This view now picks up these values from HIST_HEAD$ rather than COL$.
|
|
LOW_VALUE HIGH_ |
NOT NULL
|
Tablespace name
|
|
BYTES
|
NUMBER
|
|
Number of bytes charged to the user
|
|
MAX_BYTES
|
NUMBER
|
|
User's quota in bytes, or -1 for UNLIMITED
|
|
BLOCKS
|
NUMBER
|
NOT NULL
|
Number of Oracle blocks charged to the user
|
|
MAX_BLOCKS
|
NUMBER
|
|
User's quota in Oracle blocks, or -1 or UNLIMITED
|
USER_TYPES
This view displays the user's types in a table.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
TYPE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the type
|
|
TYPE_OID
|
RAW(16)
|
NOT NULL
|
Object identifier (OID) of the type
|
|
TYPECODE
|
VARCHAR2(30)
|
|
Typecode of the type
|
|
ATTRIBUTES
|
NUMBER
|
|
Number of attributes (if any) in the type
|
|
METHODS
|
NUMBER
|
|
Number of methods (if any) in the type
|
|
PREDEFINED
|
VARCHAR2(3)
|
|
Indicates whether the type is a predefined type
|
|
INCOMPLETE
|
VARCHAR2(3)
|
|
Indicates whether the type is an incomplete type
|
USER_TYPE_ATTRS
This view displays the attributes of the user's types.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
TYPE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the type
|
|
ATTR_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the attribute
|
|
ATTR_TYPE_MOD
|
VARCHAR2(7)
|
|
Type modifier of the attribute
|
|
ATTR_TYPE_OWNER
|
VARCHAR2(30)
|
|
Owner of the type of the attribute
|
|
ATTR_TYPE_NAME
|
VARCHAR2(30)
|
|
Name of the type of the attribute
|
|
LENGTH
|
NUMBER
|
|
Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
|
|
PRECISION
|
NUMBER
|
|
Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
|
|
SCALE
|
NUMBER
|
|
Scale of the NUMBER or DECIMAL attribute
|
|
CHARACTER_SET_NAME
|
VARCHAR2(44)
|
|
The name of the character set: CHAR_CS, NCHAR_CS
|
USER_TYPE_METHODS
This view is a description of the user's methods types.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
TYPE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the type
|
|
METHOD_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the method
|
|
METHOD_NO
|
NUMBER
|
|
Method number for distinguishing overloaded method (not to be used as ID number)
|
|
METHOD_TYPE
|
VARCHAR2(6)
|
|
Type of the method
|
|
PARAMETERS
|
NUMBER
|
NOT NULL
|
Number of parameters to the method
|
|
RESULTS
|
NUMBER
|
NOT NULL
|
Number of results returned by the method
|
USER_UPDATABLE_COLUMNS
This view contains a description of columns that are updatable to the user in a join view.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Table owner
|
|
TABLE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Table name
|
|
COLUMN_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Column name
|
|
UPDATABLE
|
VARCHAR2(3)
|
|
Indicates whether the column is updatable
|
|
INSERTABLE
|
VARCHAR2(3)
|
|
Indicates whether the column is insertable
|
|
DELETABLE
|
VARCHAR2(3)
|
|
Indicates whether the column is deletable
|
USER_USERS
This view contains information about the current user.
|
Column
|
Datatype
|
NULL
|
Description
|
|---|
|
USERNAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the user
|
|
USER_ID
|
NUMBER
|
NOT NULL
|
ID number of the user
|
|
ACCOUNT_STATUS
|
VARCHAR2(32)
|
NOT NULL
|
Indicates if the account is locked, expired, or unlocked
|
|
LOCK_DATE
|
DATE
|
|
Date the account was locked if account status is locked
|
|
EXPIRY_DATE
|
DATE
|
|
Date of expiration of the account if account status is expired
|
|
DEFAULT_TABLESPACE
|
VARCHAR2(30)
|
NOT NULL
|
Default tablespace for data
|
|
TEMPORARY_TABLESPACE
|
VARCHAR2(30)
|
NOT NULL
|
Default tablespace for temporary tables
|
|
CREATED
|
DATE
|
NOT NULL
|
User creation date
|
|
EXTERNAL_NAME
|
VARCHAR2(4000)
|
|
User external name
|
USER_VIEWS
This view contains the text of views owned by the user.
|
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
|
|
