DBA_2PC_NEIGHBORS

LOCAL_TRAN_ID

IN_OUT "in" for incoming connections, "out" for outgoing

DATABASE in: client database name; out: outgoing db link

DBUSER_OWNER in: name of local user; out: owner of db link

INTERFACE "C" for request commit, else "N" for prepare or request readonly commit

DBID the database id at the other end of the connection

SESS# session number at this database of the connection

BRANCH transaction branch ID at this database of the connection

DBA_2PC_PENDING

LOCAL_TRAN_ID string of form: n.n.n, n a number

GLOBAL_TRAN_ID globally unique transaction id

STATE collecting, prepared, committed, forced commit, or forced rollback

MIXED yes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used)

ADVICE C for commit, R for rollback, else null

TRAN_COMMENT text for "commit work comment "

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

FORCE_TIME time of manual force decision (null if not forced locally)

RETRY_TIME time automatic recovery (RECO) last tried to recover the transaction

OS_USER operating system specific name for the end-user

OS_TERMINAL operating system specific name for the end-user terminal

HOST name of the host machine for the end-user

DB_USER Oracle user name of the end-user at the topmost database

COMMIT# global commit number for committed transactions

DBA_ALL_TABLES

OBJECT_ID_TYPE If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM GENERATED

TABLE_TYPE_OWNER Owner of the type of the table if the table is an object table

TABLE_TYPE Type of the table if the table is an object table

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

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

NESTED Is the table a nested table?

BUFFER_POOL The default buffer pool to be used for table blocks

ROW_MOVEMENT Whether partitioned row movement is enabled or disabled

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

USER_STATS Were the statistics entered directly by the user?

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

SKIP_CORRUPT Whether skip corrupt blocks is enabled or disabled

MONITORING Should we keep track of the amount of modification?

CLUSTER_OWNER Owner of the cluster, if any, to which the table belongs

DEPENDENCIES Should we keep track of row level dependencies?

OWNER Owner of the table

TABLE_NAME Name of the table

TABLESPACE_NAME Name of the tablespace containing the table

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

IOT_NAME Name of the index-only table, if any, to which the overflow or mapping table entry belongs

PCT_FREE Minimum percentage of free space in a block

PCT_USED Minimum percentage of used space in a block

INI_TRANS Initial number of transactions

MAX_TRANS Maximum number of transactions

INITIAL_EXTENT Size of the initial extent in bytes

NEXT_EXTENT Size of secondary extents in bytes

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

PCT_INCREASE Percentage increase in extent size

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated in this segment

LOGGING Logging attribute

BACKED_UP Has table been backed up since last modification?

NUM_ROWS The number of rows in the table

BLOCKS The number of used blocks in the table

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

AVG_SPACE The average available free space in the table

CHAIN_CNT The number of chained rows in the table

AVG_ROW_LEN The average row length, including row overhead

AVG_SPACE_FREELIST_BLOCKS The average freespace of all blocks on a freelist

NUM_FREELIST_BLOCKS The number of blocks on the freelist

DEGREE The number of threads per instance for scanning the table

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

CACHE Whether the table is to be cached in the buffer cache

TABLE_LOCK Whether table locking is enabled or disabled

SAMPLE_SIZE The sample size used in analyzing this table

LAST_ANALYZED The date of the most recent time this table was analyzed

PARTITIONED Is this table partitioned? YES or NO

IOT_TYPE If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL

DBA_APPLICATION_ROLES

ROLE Name of Application Role

SCHEMA Schema name of authorizing package

PACKAGE Name of authorizing package

DBA_APPLY

APPLY_NAME Name of the apply process

QUEUE_NAME Name of the queue the apply process dequeues from

QUEUE_OWNER Owner of the queue the apply process dequeues from

APPLY_CAPTURED Yes, if applying captured messages; No, if applying enqueued messages

RULE_SET_NAME Rule set used by apply process for filtering

RULE_SET_OWNER Owner of the rule set

APPLY_USER Current user who is applying the messages

APPLY_DATABASE_LINK For remote objects, the database link pointing to the remote database

APPLY_TAG Tag associated with DDL and DML change records that will be applied

DDL_HANDLER Name of the user specified ddl handler

MESSAGE_HANDLER User specified procedure to handle messages other than DDL and DML messages

STATUS Status of the apply process: DISABLED, ENABLED, ABORTED

DBA_APPLY_CONFLICT_COLUMNS

OBJECT_OWNER Owner of the object

OBJECT_NAME Name of the object

METHOD_NAME Name of the method used to resolve conflict

RESOLUTION_COLUMN Name of the column used to resolve conflict

COLUMN_NAME Name of the column that is to be considered as part of a group to resolve conflict

APPLY_DATABASE_LINK For remote objects, name of database link pointing to remote database

DBA_APPLY_DML_HANDLERS

OBJECT_OWNER Owner of the object

OBJECT_NAME Name of the object

OPERATION_NAME Name of the DML operation

USER_PROCEDURE Name of the DML handler specified by the user

ERROR_HANDLER Y if the user procedure is the error handler, N if it is the DML handler

APPLY_DATABASE_LINK For remote objects, name of database link pointing to remote database

DBA_APPLY_ERROR

APPLY_NAME Name of the apply process at the local site which processed the transaction

QUEUE_NAME Name of the queue at the local site where the transaction came from

QUEUE_OWNER Owner of the queue at the local site where the transaction came from

LOCAL_TRANSACTION_ID Local transaction ID for the error creation transaction

SOURCE_DATABASE Database where the transaction originated

SOURCE_TRANSACTION_ID Original transaction ID at the source database

SOURCE_COMMIT_SCN Original commit SCN for the transaction at the source database

MESSAGE_NUMBER Identifier for the message in the transaction that raised an error

ERROR_NUMBER Error number

ERROR_MESSAGE Error message

RECIPIENT_ID User ID of the original recipient

RECIPIENT_NAME Name of the original recipient

MESSAGE_COUNT Total number of messages inside the error transaction

DBA_APPLY_INSTANTIATED_OBJECTS

SOURCE_DATABASE Name of the database where the objects originated

SOURCE_OBJECT_OWNER Owner of the object at the source database

SOURCE_OBJECT_NAME Name of the object at source

SOURCE_OBJECT_TYPE Type of the object at source

INSTANTIATION_SCN Point in time when the object was instantiated at source

IGNORE_SCN SCN lower bound for messages that will be considered for apply

APPLY_DATABASE_LINK For remote objects, the database link pointing to the remote database

DBA_APPLY_KEY_COLUMNS

OBJECT_OWNER Owner of the object

OBJECT_NAME Name of the object

COLUMN_NAME Column name of the object

APPLY_DATABASE_LINK Remote database link to which changes will be aplied

DBA_APPLY_PARAMETERS

APPLY_NAME Name of the apply process

PARAMETER Name of the parameter

VALUE Either the default value or the value set by the user for the parameter

SET_BY_USER YES if the value is set by the user, NO otherwise

DBA_APPLY_PROGRESS

APPLY_NAME Name of the apply process

APPLIED_MESSAGE_NUMBER All messages before this number have been successfully applied

OLDEST_MESSAGE_NUMBER Earliest commit number of the transactions currently being applied

APPLY_TIME Time at which the message was applied

APPLIED_MESSAGE_CREATE_TIME Time at which the message to be applied was created

DBA_ASSOCIATIONS

OBJECT_OWNER Owner of the object for which the association is being defined

OBJECT_NAME Object name for which the association is being defined

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

OBJECT_TYPE Schema type of the object - table, type, package or function

STATSTYPE_SCHEMA Owner of the statistics type

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

DEF_SELECTIVITY Default Selectivity if any of the object

DEF_CPU_COST Default CPU cost if any of the object

DEF_IO_COST Default I/O cost if any of the object

DEF_NET_COST Default Networking cost if any of the object

INTERFACE_VERSION Version number of Statistics type interface implemented

DBA_AUDIT_POLICIES

OBJECT_SCHEMA Owner of the table or view

OBJECT_NAME Name of the table or view

POLICY_NAME Name of the policy

POLICY_TEXT Audit condition

POLICY_COLUMN Relevant column

PF_SCHEMA Owner of the audit handler function

PF_PACKAGE Name of the package containing the audit handler function

PF_FUNCTION Name of the audit handler function

ENABLED Is this policy is enabled?

DBA_AUDIT_TRAIL

OS_USERNAME Operating System logon user name of the user whose actions were audited

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

USERHOST Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files (e.g., clustered Oracle on

DEC VAX/VMS clusters)

TERMINAL Identifier for the user's terminal

TIMESTAMP Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)

OWNER Creator of object affected by the action

OBJ_NAME Name of the object affected by the action

ACTION Numeric action type code. The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME

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

NEW_OWNER The owner of the object named in the NEW_NAME column

NEW_NAME New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)

OBJ_PRIVILEGE Object privileges granted/revoked by a GRANT/REVOKE statement

SYS_PRIVILEGE System privileges granted/revoked by a GRANT/REVOKE statement

ADMIN_OPTION If role/sys_priv was granted WITH ADMIN OPTON, A/-

GRANTEE The name of the grantee specified in a GRANT/REVOKE statement

AUDIT_OPTION Auditing option set with the audit statement

SES_ACTIONS Session summary. A string of 11 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "S" = Succ

ess, "F" = Failure, "B" = Both

LOGOFF_TIME Timestamp for user logoff

LOGOFF_LREAD Logical reads for the session

LOGOFF_PREAD Physical reads for the session

LOGOFF_LWRITE Logical writes for the session

LOGOFF_DLOCK Deadlocks detected during the session

COMMENT_TEXT Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authe

ntication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type.

SESSIONID Numeric ID for each Oracle session

ENTRYID Numeric ID for each audit trail entry in the session

STATEMENTID Numeric ID for each statement run (a statement may cause many actions)

RETURNCODE Oracle error code generated by the action. Zero if the action succeeded

PRIV_USED System privilege used to execute the action

CLIENT_ID Client identifier in each Oracle session

SESSION_CPU Amount cpu time used by each oracel session

DBA_AWS

OWNER Owner of the Analytic Workspace

AW_NUMBER Number of the Analytic Workspace

AW_NAME Name of the Analytic Workspace

PAGESPACES Number of pagespaces in the Analytic Workspace

GENERATIONS Number of active generations in the Analytic Workspace

DBA_AW_PS

OWNER Owner of the Analytic Workspace

AW_NUMBER

AW_NAME Name of the Analytic Workspace

PSNUMBER Number of the pagespace

GENERATIONS Number of active generations in the pagespace

DBA_BASE_TABLE_MVIEWS

OWNER Owner of the master table which changes are logged

MASTER Name of the master table which changes are logged

MVIEW_LAST_REFRESH_TIME One date per materialized view -- the date the materialized view was last refreshed

MVIEW_ID Unique identifier of the materialized view

DBA_CAPTURE

CAPTURE_NAME Name of the capture process

QUEUE_NAME Name of queue used for holding captured changes

QUEUE_OWNER Owner of the queue used for holding captured changes

RULE_SET_NAME Rule set used by capture process for filtering

RULE_SET_OWNER Owner of the rule set

START_SCN The SCN from which capturing will be resumed

STATUS Status of the capture process: DISABLED, ENABLED, ABORTED

CAPTURED_SCN Everything up to this SCN has been captured

APPLIED_SCN Everything up to this SCN has been applied

DBA_CAPTURE_PARAMETERS

CAPTURE_NAME Name of the capture process

PARAMETER Name of the parameter

VALUE Either the default value or the value set by the user for the parameter

SET_BY_USER YES if the value is set by the user, NO otherwise

DBA_CAPTURE_PREPARED_DATABASE

TIMESTAMP Time at which the database was ready to be instantiated

DBA_CAPTURE_PREPARED_SCHEMAS

SCHEMA_NAME Name of schema prepared for instantiation

TIMESTAMP Time at which the schema was ready to be instantiated

DBA_CAPTURE_PREPARED_TABLES

TABLE_OWNER Owner of the table prepared for instantiation

TABLE_NAME Name of the table prepared for instantiation

SCN SCN from which changes can be captured

TIMESTAMP Time at which the table was ready to be instantiated

DBA_CATALOG

OWNER Owner of the object

TABLE_NAME Name of the object

TABLE_TYPE Type of the object

DBA_CLUSTERS

OWNER Owner of the cluster

CLUSTER_NAME Name of the cluster

TABLESPACE_NAME Name of the tablespace containing the cluster

PCT_FREE Minimum percentage of free space in a block

PCT_USED Minimum percentage of used space in a block

KEY_SIZE Estimated size of cluster key plus associated rows

INI_TRANS Initial number of transactions

MAX_TRANS Maximum number of transactions

INITIAL_EXTENT Size of the initial extent in bytes

NEXT_EXTENT Size of secondary extents in bytes

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

PCT_INCREASE Percentage increase in extent size

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated in this segment

AVG_BLOCKS_PER_KEY Average number of blocks containing rows with a given cluster key

CLUSTER_TYPE Type of cluster: b-tree index or hash

FUNCTION If a hash cluster, the hash function

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

DEGREE The number of threads per instance for scanning the cluster

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

CACHE Whether the cluster is to be cached in the buffer cache

BUFFER_POOL The default buffer pool to be used for cluster blocks

SINGLE_TABLE Whether the cluster can contain only a single table

DEPENDENCIES Should we keep track of row level dependencies?

DBA_CLUSTER_HASH_EXPRESSIONS

OWNER Name of owner of cluster

CLUSTER_NAME Text of hash function of the cluster

HASH_EXPRESSION Text of hash function of cluster

DBA_CLU_COLUMNS

OWNER Owner of the cluster

CLUSTER_NAME Cluster name

CLU_COLUMN_NAME Key column in the cluster

TABLE_NAME Clustered table name

TAB_COLUMN_NAME Key column or attribute of object column in the table

DBA_COLL_TYPES

OWNER Owner of the type

TYPE_NAME Name of the type

COLL_TYPE Collection type

UPPER_BOUND Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type

ELEM_TYPE_MOD Type modifier of the element

ELEM_TYPE_OWNER Owner of the type of the element

ELEM_TYPE_NAME Name of the type of the element

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

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

SCALE Scale of the NUMBER or DECIMAL element

CHARACTER_SET_NAME Character set name of the element

ELEM_STORAGE Storage optimization specification for VARRAY of numeric elements

NULLS_STORED Is null information stored with each VARRAY element?

DBA_COL_COMMENTS

OWNER Name of the owner of the object

TABLE_NAME Name of the object

COLUMN_NAME Name of the column

COMMENTS Comment on the object

DBA_COL_PRIVS

GRANTEE Name of the user to whom access was granted

OWNER Username of the owner of the object

TABLE_NAME Name of the object

COLUMN_NAME Name of the column

GRANTOR Name of the user who performed the grant

PRIVILEGE Column Privilege

GRANTABLE Privilege is grantable

DBA_CONSTRAINTS

OWNER Owner of the table

CONSTRAINT_NAME Name associated with constraint definition

CONSTRAINT_TYPE Type of constraint definition

TABLE_NAME Name associated with table with constraint definition

SEARCH_CONDITION Text of search condition for table check

R_OWNER Owner of table used in referential constraint

R_CONSTRAINT_NAME Name of unique constraint definition for referenced table

DELETE_RULE The delete rule for a referential constraint

STATUS Enforcement status of constraint - ENABLED or DISABLED

DEFERRABLE Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE

DEFERRED Is the constraint deferred by default - DEFERRED or IMMEDIATE

VALIDATED Was this constraint system validated? - VALIDATED or NOT VALIDATED

GENERATED Was the constraint name system generated? - GENERATED NAME or USER NAME

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

RELY If set, this flag will be used in optimizer

LAST_CHANGE The date when this column was last enabled or disabled

INDEX_OWNER The owner of the index used by this constraint

INDEX_NAME The index used by this constraint

INVALID

VIEW_RELATED

DBA_CONS_COLUMNS

OWNER Owner of the constraint definition

CONSTRAINT_NAME Name associated with the constraint definition

TABLE_NAME Name associated with table with constraint definition

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

POSITION Original position of column or attribute in definition

DBA_CONS_OBJ_COLUMNS

OWNER Owner of the table

TABLE_NAME Name of the table containing the object column or attribute

COLUMN_NAME Fully qualified name of the object column or attribute

CONS_TYPE_OWNER Owner of the type that the column is constrained to

CONS_TYPE_NAME Name of the type that the column is constrained to

CONS_TYPE_ONLY Indication of whether the column is constrained to ONLY type

DBA_CONTEXT

NAMESPACE Namespace of the context

SCHEMA Schema of the designated package

PACKAGE Name of the designated package

TYPE Type of the context create

DBA_DATA_FILES

FILE_NAME Name of the database data file

FILE_ID ID of the database data file

TABLESPACE_NAME Name of the tablespace to which the file belongs

BYTES Size of the file in bytes

BLOCKS Size of the file in ORACLE blocks

STATUS File status: "INVALID" or "AVAILABLE"

RELATIVE_FNO Tablespace-relative file number

AUTOEXTENSIBLE Autoextensible indicator: "YES" or "NO"

MAXBYTES Maximum size of the file in bytes

MAXBLOCKS Maximum size of the file in ORACLE blocks

INCREMENT_BY Default increment for autoextension

USER_BYTES Size of the useful portion of file in bytes

USER_BLOCKS Size of the useful portion of file in ORACLE blocks

DBA_DB_LINKS

OWNER

DB_LINK Name of the database link

USERNAME Name of user to log on as

HOST SQL*Net string for connect

CREATED Creation time of the database link

DBA_DEPENDENCIES

OWNER Owner of the object

NAME Name of the object

TYPE Type of the object

REFERENCED_OWNER Owner of referenced object (remote owner if remote object)

REFERENCED_NAME Name of referenced object

REFERENCED_TYPE Type of referenced object

REFERENCED_LINK_NAME Name of dblink if this is a remote object

DEPENDENCY_TYPE

DBA_DIMENSIONS

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

INVALID Invalidity of the dimension, Y = INVALID, N = VALID. The column is deprecated, please use COMPILE_STATE instead.

COMPILE_STATE Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR

REVISION Revision levle of the dimension

DBA_DIM_ATTRIBUTES

OWNER Owner of the dimentsion

DIMENSION_NAME Name of the dimension

LEVEL_NAME Name of the hierarchy level

COLUMN_NAME Name of the dependent column

INFERRED Whether this attribute is inferred from a JOIN KEY specification

DBA_DIM_CHILD_OF

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

HIERARCHY_NAME Name of the hierarchy

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

CHILD_LEVEL_NAME Name of the child-side level of this 1:n relationship

JOIN_KEY_ID Keys that join child uniquely to the parent

PARENT_LEVEL_NAME Name of the parent-side level of this 1:n relationship

DBA_DIM_HIERARCHIES

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

HIERARCHY_NAME Name of the hierarchy

DBA_DIM_JOIN_KEY

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

DIM_KEY_ID Join key ID (unique within a dimension)

LEVEL_NAME Name of the hierarchy level

KEY_POSITION Position of the key column within the level

HIERARCHY_NAME Name of the hierarchy

CHILD_JOIN_COLUMN Name of the join column

DBA_DIM_LEVELS

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

LEVEL_NAME Name of the dimension level (unique within a dimension)

NUM_COLUMNS Number of columns in the level definition

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

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

DBA_DIM_LEVEL_KEY

OWNER Owner of the dimension

DIMENSION_NAME Name of the dimension

LEVEL_NAME Name of the hierarchy level

KEY_POSITION Ordinal position of the key column within the level

COLUMN_NAME Name of the key column

DBA_DIRECTORIES

OWNER Owner of the directory (always SYS)

DIRECTORY_NAME Name of the directory

DIRECTORY_PATH Operating system pathname for the directory

DBA_DMT_FREE_SPACE

TABLESPACE_ID ID of the tablespace containing the extent

FILE_ID ID number of the file containing the extent

BLOCK_ID Starting block number of the extent

BLOCKS Size of the extent in blocks

DBA_DMT_USED_EXTENTS

SEGMENT_FILEID File number of segment header of the extent

SEGMENT_BLOCK Block number of segment header of the extent

TABLESPACE_ID ID of the tablespace containing the extent

EXTENT_ID Extent number in the segment

FILEID File Number of the extent

BLOCK Starting block number of the extent

LENGTH Number of blocks in the extent

DBA_ERRORS

OWNER

NAME Name of the object

TYPE Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "JAVA SOURCE" or "JAVA CLASS"

SEQUENCE Sequence number used for ordering purposes

LINE Line number at which this error occurs

POSITION Position in the line at which this error occurs

TEXT Text of the error

DBA_EVALUATION_CONTEXTS

EVALUATION_CONTEXT_OWNER Owner of the evaluation context

EVALUATION_CONTEXT_NAME Name of the evaluation context

EVALUATION_FUNCTION User supplied function to evaluate rules

EVALUATION_CONTEXT_COMMENT user description of the evaluation context

DBA_EVALUATION_CONTEXT_TABLES

EVALUATION_CONTEXT_OWNER Owner of the evaluation context

EVALUATION_CONTEXT_NAME Name of the evaluation context

TABLE_ALIAS Alias of the table

TABLE_NAME Name of the table

DBA_EVALUATION_CONTEXT_VARS

EVALUATION_CONTEXT_OWNER Owner of the evaluation context

EVALUATION_CONTEXT_NAME Name of the evaluation context

VARIABLE_NAME Name of the variable

VARIABLE_TYPE

VARIABLE_VALUE_FUNCTION Function to provide variable value

VARIABLE_METHOD_FUNCTION Function to provide variable method return value

DBA_EXP_FILES

EXP_VERSION Version number of the export session

EXP_TYPE

FILE_NAME Name of the export file

USER_NAME Name of user who executed export

TIMESTAMP Timestamp of the export session

DBA_EXP_OBJECTS

OWNER Owner of exported object

OBJECT_NAME Name of exported object

OBJECT_TYPE Type of exported object

CUMULATIVE Timestamp of last cumulative export

INCREMENTAL Timestamp of last incremental export

EXPORT_VERSION The id of the export session

DBA_EXP_VERSION

EXP_VERSION Version number of the last export session

DBA_EXTENTS

OWNER Owner of the segment associated with the extent

SEGMENT_NAME Name of the segment associated with the extent

PARTITION_NAME Partition/Subpartition Name, if any, of the segment

SEGMENT_TYPE Type of the segment

TABLESPACE_NAME Name of the tablespace containing the extent

EXTENT_ID Extent number in the segment

FILE_ID Name of the file containing the extent

BLOCK_ID Starting block number of the extent

BYTES Size of the extent in bytes

BLOCKS Size of the extent in ORACLE blocks

RELATIVE_FNO Relative number of the file containing the segment header

DBA_EXTERNAL_LOCATIONS

OWNER Owner of the external table location

TABLE_NAME Name of the corresponding external table

LOCATION External table location

DIRECTORY_OWNER Owner of the directory containing the external table location

DIRECTORY_NAME Name of the directory containing the location

DBA_EXTERNAL_TABLES

OWNER Owner of the external table

TABLE_NAME Name of the external table

TYPE_OWNER Owner of the implementation type for the external table access driver

TYPE_NAME Name of the implementation type for the external table access driver

DEFAULT_DIRECTORY_OWNER Owner of the default directory for the external table

DEFAULT_DIRECTORY_NAME Name of the default directory for the external table

REJECT_LIMIT Reject limit for the external table

ACCESS_TYPE Type of access parameters for the external table (CLOB/BLOB)

ACCESS_PARAMETERS Access parameters for the external table

DBA_FGA_AUDIT_TRAIL

SESSION_ID Session id of the query

TIMESTAMP Time of the query

DB_USER Database username who executes the query

OS_USER OS username who executes the query

USERHOST Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files (e.g., clustered Oracle on

DEC VAX/VMS clusters)

CLIENT_ID Client identifier in each Oracle session

EXT_NAME External name

OBJECT_SCHEMA Owner of the table or view

OBJECT_NAME Name of the table or view

POLICY_NAME Name of Fine Grained Auditing Policy

SCN SCN of the query

SQL_TEXT SQL text of the query

SQL_BIND Bind variable data of the query

COMMENT$TEXT Comments

DBA_FREE_SPACE

TABLESPACE_NAME Name of the tablespace containing the extent

FILE_ID ID number of the file containing the extent

BLOCK_ID Starting block number of the extent

BYTES Size of the extent in bytes

BLOCKS Size of the extent in ORACLE blocks

RELATIVE_FNO Relative number of the file containing the extent

DBA_FREE_SPACE_COALESCED

TABLESPACE_NAME Name of Tablespace

TOTAL_EXTENTS Total Number of Free Extents in Tablespace

EXTENTS_COALESCED Total Number of Coalesced Free Extents in Tablespace

PERCENT_EXTENTS_COALESCED Percentage of Coalesced Free Extents in Tablespace

TOTAL_BYTES Total Number of Free Bytes in Tablespace

BYTES_COALESCED Total Number of Coalesced Free Bytes in Tablespace

TOTAL_BLOCKS Total Number of Free Oracle Blocks in Tablespace

BLOCKS_COALESCED Total Number of Coalesced Free Oracle Blocks in Tablespace

PERCENT_BLOCKS_COALESCED Percentage of Coalesced Free Oracle Blocks in Tablespace

DBA_FREE_SPACE_COALESCED_TMP1

TS# Number of Tablespace

EXTENTS_COALESCED Number of Coalesced Free Extents in Tablespace

BLOCKS_COALESCED Total Coalesced Free Oracle Blocks in Tablespace

DBA_FREE_SPACE_COALESCED_TMP2

TS# Number of Tablespace

TOTAL_EXTENTS Number of Free Extents in Tablespace

TOTAL_BLOCKS Total Free Blocks in Tablespace

DBA_FREE_SPACE_COALESCED_TMP3

TS# Number of Tablespace

TOTAL_EXTENTS Number of Free Extents in Tablespace

TOTAL_BLOCKS Total Free Blocks in Tablespace

DBA_GLOBAL_CONTEXT

NAMESPACE

SCHEMA Schema of the package that administers the globally accessible context

PACKAGE Package that administers the globally accessible context

DBA_HISTOGRAMS

OWNER Owner of table

TABLE_NAME Table name

COLUMN_NAME Column name or attribute of object column

ENDPOINT_NUMBER Endpoint number

ENDPOINT_VALUE Normalized endpoint value

ENDPOINT_ACTUAL_VALUE Actual endpoint value

DBA_INDEXES

OWNER Username of the owner of the index

INDEX_NAME Name of the index

INDEX_TYPE

TABLE_OWNER Owner of the indexed object

TABLE_NAME Name of the indexed object

TABLE_TYPE Type of the indexed object

UNIQUENESS Uniqueness status of the index: "UNIQUE", "NONUNIQUE", or "BITMAP"

COMPRESSION Compression property of the index: "ENABLED", "DISABLED", or NULL

PREFIX_LENGTH Number of key columns in the prefix used for compression

TABLESPACE_NAME Name of the tablespace containing the index

INI_TRANS Initial number of transactions

MAX_TRANS Maximum number of transactions

INITIAL_EXTENT Size of the initial extent

NEXT_EXTENT Size of secondary extents

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

PCT_INCREASE Percentage increase in extent size

PCT_THRESHOLD Threshold percentage of block space allowed per index entry

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

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated to this segment

PCT_FREE Minimum percentage of free space in a block

LOGGING Logging attribute

BLEVEL B-Tree level

LEAF_BLOCKS The number of leaf blocks in the index

DISTINCT_KEYS The number of distinct keys in the index

AVG_LEAF_BLOCKS_PER_KEY The average number of leaf blocks per key

AVG_DATA_BLOCKS_PER_KEY The average number of data blocks per key

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

STATUS Whether non-partitioned index is in UNUSABLE state or not

NUM_ROWS

SAMPLE_SIZE The sample size used in analyzing this index

LAST_ANALYZED The date of the most recent time this index was analyzed

DEGREE The number of threads per instance for scanning the partitioned index

INSTANCES The number of instances across which the partitioned index is to be scanned

PARTITIONED Is this index partitioned? YES or NO

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

GENERATED Was the name of this index system generated?

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

BUFFER_POOL The default buffer pool to be used for index blocks

USER_STATS Were the statistics entered directly by the user?

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

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

ITYP_OWNER If domain index, then this is the indextype owner

ITYP_NAME If domain index, then this is the name of the associated indextype

PARAMETERS If domain index, then this is the parameter string

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

DOMIDX_STATUS Is the indextype of the domain index valid

DOMIDX_OPSTATUS Status of the operation on the domain index

FUNCIDX_STATUS Is the Function-based Index DISABLED or ENABLED?

JOIN_INDEX Is this index a join index?

DBA_INDEXTYPES

OWNER Owner of the indextype

INDEXTYPE_NAME Name of the indextype

IMPLEMENTATION_SCHEMA Name of the schema for indextype implementation

IMPLEMENTATION_NAME Name of indextype implementation

INTERFACE_VERSION Version of indextype interface

IMPLEMENTATION_VERSION Version of indextype implementation

NUMBER_OF_OPERATORS Number of operators associated with the indextype

PARTITIONING Kinds of local partitioning supported by the indextype

DBA_INDEXTYPE_COMMENTS

OWNER Owner of the user-defined indextype

INDEXTYPE_NAME Name of the user-defined indextype

COMMENTS Comment for the user-defined indextype

DBA_INDEXTYPE_OPERATORS

OWNER Owner of the indextype

INDEXTYPE_NAME Name of the indextype

OPERATOR_SCHEMA Name of the operator schema

OPERATOR_NAME Name of the operator for which the indextype is defined

BINDING# Binding# associated with the operator

DBA_IND_COLUMNS

INDEX_OWNER Index owner

INDEX_NAME Index name

TABLE_OWNER Table or cluster owner

TABLE_NAME Table or cluster name

COLUMN_NAME Column name or attribute of object column

COLUMN_POSITION Position of column or attribute within index

COLUMN_LENGTH Maximum length of the column or attribute, in bytes

CHAR_LENGTH Maximum length of the column or attribute, in characters

DESCEND DESC if this column is sorted in descending order on disk, otherwise ASC

DBA_IND_EXPRESSIONS

INDEX_OWNER Index owner

INDEX_NAME Index name

TABLE_OWNER Table or cluster owner

TABLE_NAME Table or cluster name

COLUMN_EXPRESSION Functional index expression defining the column

COLUMN_POSITION Position of column or attribute within index

DBA_INTERNAL_TRIGGERS

TABLE_NAME Name of the table

OWNER_NAME Name of the owner

INTERNAL_TRIGGER_TYPE Type of internal trigger

DBA_JOBS

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

LOG_USER USER who was logged in when the job was submitted

PRIV_USER USER whose default privileges apply to this job

SCHEMA_USER select * from bar means select * from schema_user.bar

LAST_DATE Date that this job last successfully executed

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

THIS_DATE Date that this job started executing (usually null if not executing)

THIS_SEC Same as THIS_DATE. This is when the last successful execution started.

NEXT_DATE Date that this job will next be executed

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

TOTAL_TIME Total wallclock time spent by the system on this job, in seconds

BROKEN If Y, no attempt is being made to run this job. See dbms_jobq.broken(job).

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

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

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

NLS_ENV alter session parameters describing the NLS environment of the job

MISC_ENV a versioned raw maintained by the kernel, for other session parameters

INSTANCE Instance number restricted to run the job

DBA_JOBS_RUNNING

SID Identifier of process which is executing the job. See v$lock.

JOB Identifier of job. This job is currently executing.

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

LAST_DATE Date that this job last successfully executed

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

THIS_DATE Date that this job started executing (usually null if not executing)

THIS_SEC Same as THIS_DATE. This is when the last successful execution started.

INSTANCE The instance number restricted to run the job

DBA_JOIN_IND_COLUMNS

INDEX_OWNER Index owner

INDEX_NAME Index name

INNER_TABLE_OWNER Table owner of inner table (table closer to the fact table)

INNER_TABLE_NAME Table name of inner table (table closer to the fact table)

INNER_TABLE_COLUMN Column name of inner table (table closer to the fact table)

OUTER_TABLE_OWNER Table owner of outer table (table closer to the fact table)

OUTER_TABLE_NAME Table name of outer table (table closer to the fact table)

OUTER_TABLE_COLUMN Column name of outer table (table closer to the fact table)

DBA_LIBRARIES

OWNER Owner of the library

LIBRARY_NAME Name of the library

FILE_SPEC Operating system file specification of the library

DYNAMIC Is the library dynamically loadable

STATUS Status of the library

DBA_LMT_FREE_SPACE

TABLESPACE_ID ID of the tablespace containing the extent

FILE_ID ID number of the file containing the extent

BLOCK_ID Starting block number of the extent

BLOCKS Size of the extent in blocks

DBA_LMT_USED_EXTENTS

DBA_LOBS

OWNER Owner of the table containing the LOB

TABLE_NAME Name of the table containing the LOB

COLUMN_NAME Name of the LOB column or attribute

SEGMENT_NAME Name of the LOB segment

INDEX_NAME Name of the LOB index

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

PCTVERSION Maximum percentage of the LOB space used for versioning

RETENTION Maximum time duration for versioning of the LOB space

FREEPOOLS Number of freepools for this LOB segment

CACHE Is the LOB accessed through the buffer cache?

LOGGING Are changes to the LOB logged?

IN_ROW Are some of the LOBs stored with the base row?

DBA_LOGSTDBY_EVENTS

EVENT_TIME Time the event took place

CURRENT_SCN Change vector SCN for the change

COMMIT_SCN SCN for the commit record of the transaction

XIDUSN Transaction id, part 1 of 3

XIDSLT Transaction id, part 2 of 3

XIDSQN Transaction id, part 3 of 3

EVENT A SQL statement or other text describing the event

STATUS_CODE A number describing the event

STATUS A text string describing the event

DBA_LOGSTDBY_LOG

THREAD# Redo thread number

SEQUENCE# Redo log sequence number

FIRST_CHANGE# First change# in the archived log

NEXT_CHANGE# First change in the next log

FIRST_TIME Timestamp of the first change

NEXT_TIME Timestamp of the next change

FILE_NAME Archived log file name

TIMESTAMP Time when the archiving completed

DICT_BEGIN Contains beginning of Log Miner Dictionary

DICT_END Contains end of Log Miner Dictionary

DBA_LOGSTDBY_NOT_UNIQUE

OWNER Schema name of the non-unique table

TABLE_NAME Table name of the non-unique table

BAD_COLUMN Indicates that the table has a column not useful in the where clause

DBA_LOGSTDBY_PARAMETERS

NAME Name of the parameter

VALUE Optional value of the parameter

DBA_LOGSTDBY_PROGRESS

APPLIED_SCN All transactions with a commit SCN <= this value have been applied

APPLIED_TIME Estimate of the time the applied_scn was generated

READ_SCN All log data greater than this SCN has been preserved in the database

READ_TIME Estimate of the time the read_scn was generated

NEWEST_SCN The most recent SCN available on standby.

NEWEST_TIME Estimate of the time the newest_scn was generated

DBA_LOGSTDBY_SKIP

ERROR Does this skip setting only apply to failed attempts

STATEMENT_OPT The statement option choosen to skip

OWNER Schema name under which this skip option should be applied

NAME Object name under which this skip option should be applied

PROC The stored procedure to call for this skip setting. DDL only

DBA_LOGSTDBY_SKIP_TRANSACTION

XIDUSN Transaction id, component 1 of 3

XIDSLT Transaction id, component 2 of 3

XIDSQN Transaction id, component 3 of 3

DBA_LOGSTDBY_UNSUPPORTED

OWNER Schema name of unsupported column

TABLE_NAME Table name of unsupported column

COLUMN_NAME Column name of unsupported column

DATA_TYPE Datatype of unsupported column

DBA_LOG_GROUPS

OWNER Owner of the table

LOG_GROUP_NAME Name associated with log group definition

TABLE_NAME

ALWAYS If set, these columns are always logged

DBA_LOG_GROUP_COLUMNS

OWNER Owner of the log group definition

LOG_GROUP_NAME Name associated with the log group definition

TABLE_NAME Name associated with table with log group definition

COLUMN_NAME Name associated with column or attribute of object column specified in the log group definition

POSITION Original position of column or attribute in definition

DBA_METHOD_PARAMS

OWNER Onwer of the type

TYPE_NAME Name of the type

METHOD_NAME Name of the method

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

PARAM_NAME Name of the parameter

PARAM_NO Parameter number or position

PARAM_MODE Mode of the parameter

PARAM_TYPE_MOD Type modifier of the parameter

PARAM_TYPE_OWNER Owner of the type of the parameter

PARAM_TYPE_NAME Name of the type of the parameter

CHARACTER_SET_NAME Character set name of the parameter

DBA_METHOD_RESULTS

OWNER Onwer of the type

TYPE_NAME Name of the type

METHOD_NAME Name of the method

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

RESULT_TYPE_MOD Type modifier of the result

RESULT_TYPE_OWNER Owner of the type of the result

RESULT_TYPE_NAME Name of the type of the result

CHARACTER_SET_NAME Character set name of the result

DBA_MVIEWS

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

CONTAINER_NAME Name of the materialized view container table

QUERY The defining query that the materialized view instantiates

QUERY_LEN The number of bytes in the defining query (based on the server character set

UPDATABLE Indicates whether the materialized view can be updated

UPDATE_LOG Name of the table that logs changes to an updatable materialized view

MASTER_ROLLBACK_SEG Name of the rollback segment to use at the master site

MASTER_LINK Name of the database link to the master site

REWRITE_ENABLED Indicates whether rewrite is enabled for the materialized view

REWRITE_CAPABILITY Indicates the kind of rewrite that is enabled

REFRESH_MODE Indicates how and when the materialized view will be refreshed

REFRESH_METHOD The default refresh method for the materialized view (complete, fast, ...)

BUILD_MODE How and when to initially build (load) the materialized view container

FAST_REFRESHABLE Indicates the kinds of operations that can be fast refreshed for the MV

LAST_REFRESH_TYPE Indicates the kind of refresh that was last performed on the MV

LAST_REFRESH_DATE The date that the materialized view was last refreshed

STALENESS Indicates the staleness state of the materialized view (fresh, stale, ...)

AFTER_FAST_REFRESH Indicates the staleness state the MV will have after a fast refresh is done

UNKNOWN_PREBUILT Indicates if the materialized view is prebuilt

UNKNOWN_PLSQL_FUNC Indicates if the materialized view contains PL/SQL function

UNKNOWN_EXTERNAL_TABLE Indicates if the materialized view contains external tables

UNKNOWN_CONSIDER_FRESH Indicates if the materialized view is considered fresh

UNKNOWN_IMPORT Indicates if the materialized view is imported

COMPILE_STATE Indicates the validity of the MV meta-data

USE_NO_INDEX Indicates whether the MV uses no index

DBA_MVIEW_AGGREGATES

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

POSITION_IN_SELECT Position of this aggregated measure with the SELECT list

CONTAINER_COLUMN Name of this column in the container table

AGG_FUNCTION Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV

DISTINCTFLAG Set to Y is this is a DISTINCT aggregation

MEASURE The SQL text of the measure, excluding the aggregation function

DBA_MVIEW_ANALYSIS

QUERY SELECT expression of the materialized view definition

REVISION Reserved for internal use

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

MVIEW_TABLE_OWNER Owner of the container table

CONTAINER_NAME Name of the container table for this materialized view

LAST_REFRESH_SCN The SCN of the last transaction to refresh the materialized view

LAST_REFRESH_DATE The date of the last refresh of the materialized view

REFRESH_METHOD User declared method of refresh for the materialized view

SUMMARY

FULLREFRESHTIM The time that it took to fully refresh the materialized view

INCREFRESHTIM The time that it took to incrementally refresh the materialized view

CONTAINS_VIEWS This materialized view contains views in the FROM clause

UNUSABLE This materialized view is unusable, the build was deferred

RESTRICTED_SYNTAX This materialized view contains restrictive syntax

INC_REFRESHABLE This materialized view is not restricted from being incrementally refreshed

KNOWN_STALE This materialized view is directly stale

INVALID Invalidity of the materialized view, Y = INVALID, N = VALID

REWRITE_ENABLED This materialized view is enabled for query rewrite

QUERY_LEN The length (in bytes) of the query field

DBA_MVIEW_DETAIL_RELATIONS

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

DETAILOBJ_OWNER Owner of the detail relation

DETAILOBJ_NAME Name of the materialized view detail table

DETAILOBJ_TYPE Type of materialized detail table type

DETAILOBJ_ALIAS Alias of the detail relation if used

DBA_MVIEW_JOINS

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

DETAILOBJ1_OWNER Owner of the 1st detail object

DETAILOBJ1_RELATION Name of the 1st detail object

DETAILOBJ1_COLUMN Name of the 1st detail object column

OPERATOR Name of the join operator. Currently only = is defined

OPERATOR_TYPE Indicates inner or outer join. I = inner join, L = DETAILOBJ1 table is the left side of an outer join, R = DETAILOBJ2 table is the right side of an outer join

DETAILOBJ2_OWNER Owner of the 2nd detail object

DETAILOBJ2_RELATION Name of the 2nd detail object

DETAILOBJ2_COLUMN Name of the 2nd detail object column

DBA_MVIEW_KEYS

OWNER Owner of the materialized view

MVIEW_NAME Name of the materialized view

POSITION_IN_SELECT Position of this key within the SELECT list

CONTAINER_COLUMN Name of the column in the container table

DETAILOBJ_OWNER Owner of the detail object

DETAILOBJ_NAME Name of the detail object

DETAILOBJ_ALIAS Alias of the detail object

DETAILOBJ_TYPE Type of the detail object: VIEW or TABLE

DETAILOBJ_COLUMN Name of the detail object column

DBA_MVIEW_LOGS

LOG_OWNER Owner of the materialized view log

MASTER Name of the master table which changes are logged

LOG_TABLE Log table; with rowids and timestamps of rows which changed in the master

LOG_TRIGGER An after-row trigger on the master which inserts rows into the log

ROWIDS If YES, the materialized view log records rowid information

PRIMARY_KEY If YES, the materialized view log records primary key information

OBJECT_ID If YES, the materialized view log records object id information

FILTER_COLUMNS If YES, the materialized view log records filter column information

SEQUENCE If YES, the materialized view log records sequence information

INCLUDE_NEW_VALUES If YES, the materialized view log records old and new values (else only old values)

DBA_MVIEW_LOG_FILTER_COLS

OWNER Owner of the master table being logged

NAME Name of the master table being logged

COLUMN_NAME Filter column being logged

DBA_MVIEW_REFRESH_TIMES

OWNER Owner of the materialized view

NAME The view used by users and applications for viewing the MV

MASTER_OWNER Owner of the master table

MASTER Name of the master table

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

DBA_NESTED_TABLES

OWNER Owner of the nested table

TABLE_NAME Name of the nested table

TABLE_TYPE_OWNER Owner of the type of which the nested table was created

TABLE_TYPE_NAME Name of the type of the nested table

PARENT_TABLE_NAME Name of the parent table containing the nested table

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

STORAGE_SPEC

RETURN_TYPE

ELEMENT_SUBSTITUTABLE Indication of whether the nested table element is substitutable or not

DBA_OBJECTS

OWNER Username of the owner of the object

OBJECT_NAME Name of the object

SUBOBJECT_NAME Name of the sub-object (for example, partititon)

OBJECT_ID Object number of the object

DATA_OBJECT_ID Object number of the segment which contains the object

OBJECT_TYPE Type of the object

CREATED Timestamp for the creation of the object

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

TIMESTAMP Timestamp for the specification of the object

STATUS Status of the object

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

GENERATED Was the name of this object system generated?

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

DBA_OBJECT_SIZE

OWNER Owner of the object

NAME Name of the object

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

TA"

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

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

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

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

DBA_OBJECT_TABLES

AVG_SPACE_FREELIST_BLOCKS The average freespace of all blocks on a freelist

NUM_FREELIST_BLOCKS The number of blocks on the freelist

DEGREE The number of threads per instance for scanning the table

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

CACHE Whether the table is to be cached in the buffer cache

TABLE_LOCK Whether table locking is enabled or disabled

SAMPLE_SIZE The sample size used in analyzing this table

LAST_ANALYZED The date of the most recent time this table was analyzed

PARTITIONED Is this table partitioned? YES or NO

IOT_TYPE If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL

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

TABLE_TYPE_OWNER Owner of the type of the table if the table is an object table

TABLE_TYPE Type of the table if the table is an object table

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

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

NESTED Is the table a nested table?

BUFFER_POOL The default buffer pool to be used for table blocks

ROW_MOVEMENT Whether partitioned row movement is enabled or disabled

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

USER_STATS Were the statistics entered directly by the user?

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

SKIP_CORRUPT Whether skip corrupt blocks is enabled or disabled

MONITORING Should we keep track of the amount of modification?

CLUSTER_OWNER Owner of the cluster, if any, to which the table belongs

DEPENDENCIES Should we keep track of row level dependencies?

OWNER Owner of the table

TABLE_NAME Name of the table

TABLESPACE_NAME Name of the tablespace containing the table

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

IOT_NAME Name of the index-only table, if any, to which the overflow or mapping table entry belongs

PCT_FREE Minimum percentage of free space in a block

PCT_USED Minimum percentage of used space in a block

INI_TRANS Initial number of transactions

MAX_TRANS Maximum number of transactions

INITIAL_EXTENT Size of the initial extent in bytes

NEXT_EXTENT Size of secondary extents in bytes

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

PCT_INCREASE Percentage increase in extent size

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated in this segment

LOGGING Logging attribute

BACKED_UP Has table been backed up since last modification?

NUM_ROWS The number of rows in the table

BLOCKS The number of used blocks in the table

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

AVG_SPACE The average available free space in the table

CHAIN_CNT The number of chained rows in the table

AVG_ROW_LEN The average row length, including row overhead

DBA_OBJ_AUDIT_OPTS

OWNER Owner of the object

OBJECT_NAME Name of the object

OBJECT_TYPE Type of the object

ALT Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL

AUD Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL

COM Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL

DEL Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL

GRA Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL

IND Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL

INS Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL

LOC Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL

REN Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL

SEL Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL

UPD Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL

REF Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)

EXE Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

CRE

REA

WRI

DBA_OBJ_COLATTRS

OWNER Owner of the table

TABLE_NAME Name of the table containing the object column or attribute

COLUMN_NAME Fully qualified name of the object column or attribute

SUBSTITUTABLE Indication of whether the column is substitutable or not

DBA_OPANCILLARY

OWNER Owner of ancillary operator

OPERATOR_NAME Name of ancillary operator

BINDING# Binding number of ancillary operator

PRIMOP_OWNER Owner of primary operator

PRIMOP_NAME Name of primary operator

PRIMOP_BIND# Binding number of primary operator

DBA_OPARGUMENTS

OWNER Owner of the operator

OPERATOR_NAME Name of the operator

BINDING# Binding# of the operator

POSITION Position of the operator argument

ARGUMENT_TYPE Datatype of the operator argument

DBA_OPBINDINGS

OWNER Owner of the operator

OPERATOR_NAME Name of the operator

BINDING# Binding# of the operator

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

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

RETURN_TYPE Name of the return type

IMPLEMENTATION_TYPE_SCHEMA Schema of the implementation type of the indextype

IMPLEMENTATION_TYPE Implementation type of the indextype

PROPERTY Property of the operator binding

DBA_OPERATORS

OWNER Owner of the operator

OPERATOR_NAME Name of the operator

NUMBER_OF_BINDS Number of bindings associated with the operator

DBA_OPERATOR_COMMENTS

OWNER Owner of the user-defined operator

OPERATOR_NAME Name of the user-defined operator

COMMENTS Comment for the user-defined operator

DBA_OUTLINES

NAME Name of the outline

OWNER User who created the outline

CATEGORY Category to which the outline belongs

USED Flag indicating whether the outline has ever been used

TIMESTAMP Timestamp at which the outline was created

VERSION Oracle Version that created the outline

SQL_TEXT SQL text of the query

SIGNATURE Signature uniquely identifying the outline SQL text

DBA_OUTLINE_HINTS

NAME Name of the outline

OWNER User who created the outline

NODE I.D. of the query or subquery to which the hint applies

STAGE Stage at which the outline is processed

JOIN_POS Position of the table in the join order

HINT Text of the hint

DBA_PARTIAL_DROP_TABS

OWNER Owner of the table

TABLE_NAME Name of the table

DBA_PENDING_CONV_TABLES

OWNER Owner of the table

TABLE_NAME Name of the table

DBA_PENDING_TRANSACTIONS

FORMATID format identifier of the transaction identifier

GLOBALID global part (gtrid) of the transaction identifier

BRANCHID branch qualifier (bqual) of the transaction identifier

DBA_POLICIES

OBJECT_OWNER Owner of the synonym, table, or view

OBJECT_NAME Name of the synonym, table, or view

POLICY_GROUP Name of the policy group

POLICY_NAME Name of the policy

PF_OWNER Owner of the policy function

PACKAGE Name of the package containing the policy function

FUNCTION Name of the policy function

SEL If YES, policy is applied to query on the object

INS If YES, policy is applied to insert on the object

UPD If YES, policy is applied to update on the object

DEL If YES, policy is applied to delete on the object

CHK_OPTION Is check option enforced for this policy?

ENABLE Is this policy is enabled?

STATIC_POLICY Is this policy is static?

DBA_POLICY_CONTEXTS

OBJECT_OWNER Schema of the synonym, table, or view

OBJECT_NAME Name of the synonym, table, or view

NAMESPACE Namespace of the context

ATTRIBUTE Attribute of the context

DBA_POLICY_GROUPS

OBJECT_OWNER Schema of the synonym, table, or view

OBJECT_NAME Name of the synonym, table, or view

POLICY_GROUP Policy group defined

DBA_PRIV_AUDIT_OPTS

USER_NAME User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done

PROXY_NAME Name of the proxy user if auditing is being done for operations being done on behalf of a client. Null if auditing is being done for operations done by the client directly

PRIVILEGE Name of the system privilege being audited

SUCCESS Mode for WHENEVER SUCCESSFUL system auditing

FAILURE Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_PROCEDURES

OWNER

OBJECT_NAME Name of the object : top level function/procedure/package name

PROCEDURE_NAME Name of the procedure

AGGREGATE Is it an aggregate function ?

PIPELINED Is it a pipelined table function ?

IMPLTYPEOWNER Name of the owner of the implementation type (if any)

IMPLTYPENAME Name of the implementation type (if any)

PARALLEL Is the procedure parallel enabled ?

INTERFACE

DETERMINISTIC

AUTHID

DBA_PROFILES

PROFILE Profile name

RESOURCE_NAME Resource name

RESOURCE_TYPE

LIMIT Limit placed on this resource for this profile

DBA_PROPAGATION

PROPAGATION_NAME name of the Streams propagation

SOURCE_QUEUE_OWNER owner of the propgation source queue

SOURCE_QUEUE_NAME name of the propagation source queue

DESTINATION_QUEUE_OWNER owner of the propagation destination queue

DESTINATION_QUEUE_NAME name of the propagation destination queue

DESTINATION_DBLINK database link to access the propagation destination queue

RULE_SET_OWNER propagation rule set owner

RULE_SET_NAME propagation rule set name

DBA_PROXIES

PROXY Name of the proxy user

CLIENT Name of the client user who the proxy user can act on behalf of

CREDENTIAL Credential passed by the proxy for the client (if any)

TYPE Type of the credential

VERSION Version of the credential

AUTHORIZATION_CONSTRAINT Indicates the proxy's authority to exercise roles on client's behalf

ROLE Name of the role referenced in authorization constraint

DBA_QUEUES

OWNER Owner of the queue

NAME Name of the queue

QUEUE_TABLE Name of the table the queue data resides in

QID Object number of the queue

QUEUE_TYPE Type of the queue

MAX_RETRIES Maximum number of retries allowed when dequeuing from the queue

RETRY_DELAY Time interval between retries

ENQUEUE_ENABLED Queue is enabled for enqueue

DEQUEUE_ENABLED Queue is enabled for dequeue

RETENTION Time interval processed messages retained in the queue

USER_COMMENT User specified comment

DBA_QUEUE_TABLES

OWNER Owner of the queue table

QUEUE_TABLE Name of the queue table

TYPE Name of the payload type

OBJECT_TYPE Name of the payload type for object type payload

SORT_ORDER Sort order for the queue table

RECIPIENTS Mulitple or single recipient queue

MESSAGE_GROUPING Transaction grouping

COMPATIBLE Compatibility version of the queue table

PRIMARY_INSTANCE Instance assigned as the primary owner of the queue table

SECONDARY_INSTANCE Instance assigned as the secondary owner of the queue table

OWNER_INSTANCE Instance which owns the queue table currently

USER_COMMENT User specified comment

SECURE Secure queue table

DBA_REFRESH

ROWNER Name of the owner of the refresh group

RNAME Name of the refresh group

REFGROUP Internal identifier of refresh group

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

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

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

ROLLBACK_SEG Name of the rollback segment to use while refreshing

JOB Identifier of job used to automatically refresh the group

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

INTERVAL A date function used to compute the next NEXT_DATE

BROKEN Y or N, Y is the job is broken and will never be run

PURGE_OPTION The method for purging the transaction queue after each push

PARALLELISM The level of parallelism for transaction propagation

HEAP_SIZE The heap size used for transaction propagation

DBA_REFRESH_CHILDREN

OWNER Owner of the object in the refresh group

NAME Name of the object in the refresh group

TYPE Type of the object in the refresh group

ROWNER Name of the owner of the refresh group

RNAME Name of the refresh group

REFGROUP Internal identifier of refresh group

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

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

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

ROLLBACK_SEG Name of the rollback segment to use while refreshing

JOB Identifier of job used to automatically refresh the group

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

INTERVAL A date function used to compute the next NEXT_DATE

BROKEN Y or N, Y is the job is broken and will never be run

PURGE_OPTION The method for purging the transaction queue after each push

PARALLELISM The level of parallelism for transaction propagation

HEAP_SIZE The heap size used for transaction propagation

DBA_REFS

OWNER Owner of the table containing the REF column

TABLE_NAME Name of the table containing the REF column

COLUMN_NAME Column name or attribute of object column

WITH_ROWID Is the REF value stored with the rowid?

IS_SCOPED Is the REF column scoped?

SCOPE_TABLE_OWNER Owner of the scope table, if it exists

SCOPE_TABLE_NAME Name of the scope table, if it exists

OBJECT_ID_TYPE If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED

DBA_REGISTERED_MVIEWS

OWNER Owner of the materialized view

NAME The name of the materialized view

MVIEW_SITE Global name of the materialized view site

CAN_USE_LOG If NO, this materialized view is complex and cannot fast refresh

UPDATABLE If NO, the materialized view is read only

REFRESH_METHOD Whether the materialized view uses rowid, primary key or object id for fast refresh

MVIEW_ID Identifier for the materialized view used by the master for fast refresh

VERSION Version of materialized view

QUERY_TXT Query defining the materialized view

DBA_REGISTERED_MVIEW_GROUPS

NAME Name of the materialized view repgroup

MVIEW_SITE Database site of the materialized view repgroup

GROUP_COMMENT Description of the materialized view repgroup

VERSION Version of the materialized view repgroup

FNAME Name of the flavor of the materialized view repgroup

OWNER Owner of the materialized view repgroup

DBA_REGISTERED_SNAPSHOTS

OWNER Owner of the snapshot

NAME The name of the snapshot

SNAPSHOT_SITE Global name of the snapshot site

CAN_USE_LOG If NO, this snapshot is complex and cannot fast refresh

UPDATABLE If NO, the snapshot is read only

REFRESH_METHOD Whether the snapshot uses rowid, primary key or object id for fast refresh

SNAPSHOT_ID Identifier for the snapshot used by the master for fast refresh

VERSION Version of snapshot

QUERY_TXT Query defining the snapshot

DBA_REGISTERED_SNAPSHOT_GROUPS

NAME Name of the snapshot repgroup

SNAPSHOT_SITE Database site of the snapshot repgroup

GROUP_COMMENT Description of the snapshot repgroup

VERSION Version of the snapshot repgroup

FNAME Name of the flavor of the snapshot repgroup

OWNER Owner of the snapshot repgroup

DBA_REPAUDIT_ATTRIBUTE

ATTRIBUTE Description of the attribute

DATA_TYPE Datatype of the attribute value

DATA_LENGTH Length of the attribute value in byte

SOURCE Name of the function which returns the attribute value

DBA_REPAUDIT_COLUMN

SNAME Owner of the shadow table

ONAME Name of the shadow table

COLUMN_NAME Name of the column in the shadow table

BASE_SNAME Owner of replicated table

BASE_ONAME Name of the replicated table

BASE_CONFLICT_TYPE Type of conflict

BASE_REFERENCE_NAME Table name, unique constraint name, or column group name

ATTRIBUTE Description of the attribute

DBA_REPCATLOG

ID Identifying number of repcat log record

SOURCE Name of the database at which the request originated

STATUS Status of the request at this database

USERID Name of the user who submitted the request

TIMESTAMP When the request was submitted

ROLE Is this database the masterdef for the request

MASTER Name of the database that processes this request

SNAME Schema of replicated object name, if applicable

REQUEST Name of the requested operation

ONAME Replicated object name, if applicable

TYPE Type of replicated object, if applicable

MESSAGE Error message associated with processing the request

ERRNUM Oracle error number associated with processing the request

GNAME Name of the replicated object group

DBA_REPCAT_EXCEPTIONS

EXCEPTION_ID Internal primary key of the exceptions table.

USER_NAME User name of user submitting the exception.

REQUEST Originating request containing the exception.

JOB Originating job containing the exception.

ERROR_DATE Date of occurance for the exception.

ERROR_NUMBER Error number generating the exception.

ERROR_MESSAGE Error message associated with the error generating the exception.

LINE_NUMBER Line number of the exception.

DBA_REPCAT_REFRESH_TEMPLATES

DBA_REPCAT_TEMPLATE_OBJECTS

REFRESH_TEMPLATE_NAME Name of the refresh group template.

OBJECT_NAME Name of the database object.

OBJECT_TYPE Type of database object.

DDL_NUM Order of DDLs for creating the object.

DDL_TEXT DDL string for creating the object or WHERE clause for snapshot query.

MASTER_ROLLBACK_SEGMENT Rollback segment for use during snapshot refreshes.

DERIVED_FROM_SNAME Schema name of schema containing object this was derived from.

DERIVED_FROM_ONAME Object name of object this object was derived from.

FLAVOR_ID Foreign key to the REPCAT$_FLAVORS table.

DBA_REPCAT_TEMPLATE_PARMS

REFRESH_TEMPLATE_NAME Name of the refresh group template.

OWNER Owner of the refresh group template.

REFRESH_GROUP_NAME Name of the refresh group to create during instantiation.

TEMPLATE_COMMENT Optional comment field for the refresh group template.

PUBLIC_TEMPLATE Flag specifying public template or private template.

PARAMETER_NAME name of the parameter.

DEFAULT_PARM_VALUE Default value for the parameter.

PROMPT_STRING String for use in prompting for parameter values.

USER_OVERRIDE User override flag.

DBA_REPCAT_TEMPLATE_SITES

REFRESH_TEMPLATE_NAME Name of the refresh group template.

REFRESH_GROUP_NAME Name of the refresh group to create during instantiation.

TEMPLATE_OWNER Owner of the refresh group template.

USER_NAME Database user name.

SITE_NAME Name of the site that has instantiated the template.

REPAPI_SITE_NAME Name of the repapi site that has instantiated the template.

STATUS Status of the instantiation at the site.

INSTANTIATION_DATE Date template was instantiated.

DBA_REPCAT_USER_AUTHORIZATIONS

DBA_REPCAT_USER_PARM_VALUES

DBA_REPCOLUMN

SNAME Name of the object owner

ONAME Name of the object

TYPE Type of the object

CNAME Name of the replicated column

ID ID of the replicated column

POS Ordering of the replicated column

COMPARE_OLD_ON_DELETE Compare the old value of the column in replicated deletes

COMPARE_OLD_ON_UPDATE Compare the old value of the column in replicated updates

SEND_OLD_ON_DELETE Send the old value of the column in replicated deletes

SEND_OLD_ON_UPDATE Send the old value of the column in replicated updates

CTYPE Type of the column

CTYPE_TOID Type OID of a column of TYPE

CTYPE_OWNER Type owner of a column of TYPE

CTYPE_HASHCODE Type hashcode of a column of TYPE

CTYPE_MOD Datatype modifier of a column

DATA_LENGTH Length of the column in bytes

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

DATA_SCALE Digits to right of decimal point in a number

NULLABLE Does column allow NULL values?

CHARACTER_SET_NAME Name of character set for column, if applicable

TOP Top column name for an attribute

CHAR_LENGTH The maximum length of the column in characters

CHAR_USED C if the width was specified in characters, B if in bytes

DBA_REPCOLUMN_GROUP

SNAME Owner of replicated object

ONAME Name of the replicated object

GROUP_NAME Name of the column group

GROUP_COMMENT Description of the column group

DBA_REPCONFLICT

SNAME Owner of replicated object

ONAME Name of the replicated object

CONFLICT_TYPE Type of conflict

REFERENCE_NAME Table name, unique constraint name, or column group name

DBA_REPDDL

LOG_ID Identifying number of the repcat log record

SOURCE Name of the database at which the request originated

ROLE Is this database the masterdef for the request

MASTER Name of the database that processes this request

LINE Ordering of records within a single request

TEXT Portion of an argument

DDL_NUM Order of ddls to execute

DBA_REPEXTENSIONS

EXTENSION_ID Globally unique identifier for replication extension

REQUEST Kind of replication extension

MASTERDEF Master definition site for replication extension

EXPORT_REQUIRED YES if this extension requires an export, and NO if no export is required

REPCATLOG_ID Identifier of repcatlog records related to replication extension

EXTENSION_STATUS Status of replication extension

FLASHBACK_SCN Flashback_scn for export or change-based recovery for replication extension

BREAK_TRANS_TO_MASTERDEF YES if existing masters partially push to masterdef, NO if no pushing

BREAK_TRANS_TO_NEW_MASTERS YES if existing masters partially push to new masters, NO if no pushing

PERCENTAGE_FOR_CATCHUP_MDEF Fraction of push to masterdef cycle devoted to catching up

CYCLE_SECONDS_MDEF Length of push to masterdef cycle when catching up

PERCENTAGE_FOR_CATCHUP_NEW Fraction of push to new masters cycle devoted to catching up

CYCLE_SECONDS_NEW Length of push to new masters cycle when catching up

DBA_REPFLAVORS

FLAVOR_ID Flavor identifier, unique within object group

GNAME Name of the object group

FNAME Name of the flavor

CREATION_DATE Date on which the flavor was created

CREATED_BY User that created the flavor

PUBLISHED Indicates whether flavor is published (Y/N) or obsolete (O)

GROUP_OWNER Owner of the object group

DBA_REPFLAVOR_COLUMNS

FNAME Flavor name

GNAME Object group name

SNAME Schema containing the object

ONAME Object name

CNAME Column name

TYPE Column type

POS Ordering of column used as IN parameter in the replication procedures

GROUP_OWNER Object group owner

TYPE_TOID Type OID of a column of TYPE

TYPE_OWNER Type owner of a column of TYPE

TYPE_HASHCODE Type hashcode of a column of TYPE

TYPE_MOD Datatype modifier of a column

TOP Top column of this attribute column

DBA_REPFLAVOR_OBJECTS

FNAME Flavor name

GNAME Object group name

SNAME Schema containing object

ONAME Name of object

TYPE Object type

GROUP_OWNER Object group owner

DBA_REPGENERATED

SNAME Schema containing the generated object

ONAME Name of the generated object

TYPE Type of the generated object

BASE_SNAME Name of the object's owner

BASE_ONAME Name of the object

BASE_TYPE Type of the object

PACKAGE_PREFIX Prefix for package wrapper

PROCEDURE_PREFIX Procedure prefix for package wrapper or procedure wrapper

DISTRIBUTED Is the generated object separately generated at each master

REASON Reason the object was generated

DBA_REPGENOBJECTS

DBA_REPGROUP

SNAME OBSOLETE COLUMN: Name of the replicated schema

MASTER Is the site a master site for the replicated object group

STATUS If the site is a master, the master's status

SCHEMA_COMMENT Description of the replicated object group

GNAME Name of the replicated object group

FNAME Flavor name

RPC_PROCESSING_DISABLED

OWNER Owner of the replicated object group

DBA_REPGROUPED_COLUMN

SNAME Owner of replicated object

ONAME Name of the replicated object

GROUP_NAME Name of the column group

COLUMN_NAME Name of the column in the column group

DBA_REPGROUP_PRIVILEGES

USERNAME Name of the user

GNAME Name of the replicated object group

CREATED Registration date

RECEIVER Receiver privileges

PROXY_SNAPADMIN Proxy snapadmin privileges

OWNER Owner of the replicated object group

DBA_REPKEY_COLUMNS

SNAME Schema containing table

ONAME Name of the table

COL Column in the table

DBA_REPOBJECT

SNAME Name of the object owner

ONAME Name of the object

TYPE Type of the object

STATUS Status of the last create or alter request on the local object

GENERATION_STATUS Status of whether the object needs to generate replication packages

ID Identifier of the local object

OBJECT_COMMENT Description of the replicated object

GNAME Name of the replicated object group

MIN_COMMUNICATION Send only necessary OLD and NEW values for an updated row?

REPLICATION_TRIGGER_EXISTS Internal replication trigger exists?

INTERNAL_PACKAGE_EXISTS Internal package exists?

GROUP_OWNER Owner of the replicated object group

NESTED_TABLE Storage table for a nested table column?

DBA_REPPARAMETER_COLUMN

SNAME Owner of replicated object

ONAME Name of the replicated object

CONFLICT_TYPE Type of conflict

REFERENCE_NAME Table name, unique constraint name, or column group name

SEQUENCE_NO Ordering on resolution

METHOD_NAME

FUNCTION_NAME

PRIORITY_GROUP

PARAMETER_TABLE_NAME Name of the table to which the parameter column belongs

PARAMETER_COLUMN_NAME Name of the parameter column used for resolving the conflict

PARAMETER_SEQUENCE_NO Ordering on parameter column

DBA_REPPRIORITY

SNAME OBSOLETE COLUMN: Name of the replicated schema

PRIORITY_GROUP Name of the priority group

PRIORITY Priority of the value

DATA_TYPE Datatype of the value

FIXED_DATA_LENGTH Length of the value in bytes if the datatype is CHAR

CHAR_VALUE Blank-padded character string

VARCHAR2_VALUE Character string

NUMBER_VALUE Numeric value

DATE_VALUE Date value

RAW_VALUE Raw value

GNAME Name of the replicated object group

NCHAR_VALUE NCHAR string

NVARCHAR2_VALUE NVARCHAR2 string

LARGE_CHAR_VALUE Blank-padded character string over 255 characters

DBA_REPPRIORITY_GROUP

SNAME OBSOLETE COLUMN: Name of the replicated schema

PRIORITY_GROUP Name of the priority group

DATA_TYPE Datatype of the value in the priority group

FIXED_DATA_LENGTH Length of the value in bytes if the datatype is CHAR

PRIORITY_COMMENT Description of the priority group

GNAME Name of the replicated object group

DBA_REPPROP

SNAME Name of the object owner

ONAME Name of the object

TYPE Type of the object

DBLINK Destination database for propagation

HOW Propagation choice for the destination database

PROPAGATE_COMMENT Description of the propagation choice

DBA_REPRESOLUTION

SNAME Owner of replicated object

ONAME Name of the replicated object

CONFLICT_TYPE Type of conflict

REFERENCE_NAME Table name, unique constraint name, or column group name

SEQUENCE_NO Ordering on resolution

METHOD_NAME Name of the conflict resolution method

FUNCTION_NAME Name of the resolution function

PRIORITY_GROUP Name of the priority group used in conflict resolution

RESOLUTION_COMMENT Description of the conflict resolution

DBA_REPRESOLUTION_METHOD

CONFLICT_TYPE Type of conflict

METHOD_NAME Name of the conflict resolution method

DBA_REPRESOLUTION_STATISTICS

SNAME Owner of replicated object

ONAME Name of the replicated object

CONFLICT_TYPE Type of conflict

REFERENCE_NAME Table name, unique constraint name, or column group name

METHOD_NAME Name of the conflict resolution method

FUNCTION_NAME Name of the resolution function

PRIORITY_GROUP Name of the priority group used in conflict resolution

RESOLVED_DATE Timestamp for the resolution of the conflict

PRIMARY_KEY_VALUE Primary key of the replicated row (character data)

DBA_REPRESOL_STATS_CONTROL

SNAME Owner of replicated object

ONAME Name of the replicated object

CREATED Timestamp for which statistics collection was first started

STATUS Status of statistics collection: ACTIVE, CANCELLED

STATUS_UPDATE_DATE Timestamp for which the status was last updated

PURGED_DATE Timestamp for the last purge of statistics data

LAST_PURGE_START_DATE The last start date of the statistics purging date range

LAST_PURGE_END_DATE The last end date of the statistics purging date range

DBA_REPSCHEMA

SNAME OBSOLETE COLUMN: Name of the replicated schema

DBLINK A database site replicating the object group

MASTERDEF Is the database the master definition site for the replicated object group

SNAPMASTER For a snapshot site, is the database the current refresh master

MASTER_COMMENT Description of the database site

MASTER Redundant information from dba_repcat.master

PROP_UPDATES Number of requested updates for master in repcat$_repprop

MY_DBLINK A sanity check after import: is this master the current site

GNAME Name of the replicated object group

GROUP_OWNER Owner of the replicated object group

DBA_REPSITES

GNAME Name of the replicated object group

DBLINK A database site replicating the schema

MASTERDEF Is the database the master definition site for the replicated object group

SNAPMASTER For a snapshot site, is the database the current refresh master

MASTER_COMMENT Description of the database site

MASTER Redundant information from dba_repcat.master

PROP_UPDATES Number of requested updates for master in repcat$_repprop

MY_DBLINK A sanity check after import: is this master the current site

GROUP_OWNER Owner of the replicated object group

DBA_REPSITES_NEW

EXTENSION_ID Globally unique identifier for replication extension

GOWNER Owner of the object group

GNAME Name of the replicated object group

DBLINK A database site that will replicate the object group

FULL_INSTANTIATION Y if the database uses full-database export or change-based recovery

MASTER_STATUS Instantiation status of the new master

DBA_RESUMABLE

USER_ID User who own this resumable session

SESSION_ID Session ID of this resumable session

INSTANCE_ID Instance ID of this resumable session

COORD_INSTANCE_ID Instance number of parallel query coordinator

COORD_SESSION_ID Session number of parallel query coordinator

STATUS Status of this resumable session

TIMEOUT Timeout of this resumable session

START_TIME Start time of the current transaction

SUSPEND_TIME Suspend time of the current statement

RESUME_TIME Resume time of the current statement

NAME Name of this resumable session

SQL_TEXT The current SQL text

ERROR_NUMBER The current error number

ERROR_PARAMETER1 The 1st parameter to the current error message

ERROR_PARAMETER2 The 2nd parameter to the current error message

ERROR_PARAMETER3 The 3rd parameter to the current error message

ERROR_PARAMETER4 The 4th parameter to the current error message

ERROR_PARAMETER5 The 5th parameter to the current error message

ERROR_MSG The current error message

DBA_RGROUP

REFGROUP Internal identifier of refresh group

OWNER Owner of the refresh group

NAME Name of the refresh group

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

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

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

ROLLBACK_SEG Name of the rollback segment to use while refreshing

JOB Identifier of job used to automatically refresh the group

PURGE_OPTION The method for purging the transaction queue after each push

PARALLELISM The level of parallelism for transaction propagation

HEAP_SIZE The heap size used for transaction propagation

DBA_ROLES

ROLE Role Name

PASSWORD_REQUIRED Indicates if the role requires a password to be enabled

DBA_ROLE_PRIVS

GRANTEE Grantee Name, User or Role receiving the grant

GRANTED_ROLE Granted role name

ADMIN_OPTION Grant was with the ADMIN option

DEFAULT_ROLE Role is designated as a DEFAULT ROLE for the user

DBA_ROLLBACK_SEGS

SEGMENT_NAME Name of the rollback segment

OWNER Owner of the rollback segment

TABLESPACE_NAME Name of the tablespace containing the rollback segment

SEGMENT_ID ID number of the rollback segment

FILE_ID ID number of the file containing the segment header

BLOCK_ID ID number of the block containing the segment header

INITIAL_EXTENT Initial extent size in bytes

NEXT_EXTENT Secondary extent size in bytes

MIN_EXTENTS Minimum number of extents

MAX_EXTENTS Maximum number of extents

PCT_INCREASE Percent increase for extent size

STATUS Rollback segment status

INSTANCE_NUM Rollback segment owning parallel server instance number

RELATIVE_FNO Relative number of the file containing the segment header

DBA_RSRC_CONSUMER_GROUPS

CONSUMER_GROUP consumer group name

CPU_METHOD CPU resource allocation method for the consumer group

COMMENTS Text comment on the consumer group

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

MANDATORY Whether the consumer group is mandatory

DBA_RSRC_CONSUMER_GROUP_PRIVS

GRANTEE Grantee name

GRANTED_GROUP consumer group granted to the grantee

GRANT_OPTION whether the grantee can grant the privilege to others

INITIAL_GROUP

DBA_RSRC_MANAGER_SYSTEM_PRIVS

GRANTEE Grantee name

PRIVILEGE name of the system privilege

ADMIN_OPTION whether the grantee can grant the privilege to others

DBA_RSRC_PLANS

PLAN Plan name

NUM_PLAN_DIRECTIVES Number of plan directives for the plan

CPU_METHOD CPU resource allocation method for the plan

ACTIVE_SESS_POOL_MTH maximum active sessions target resource allocation method for the plan

PARALLEL_DEGREE_LIMIT_MTH parallel degree limit resource allocation method for the plan

QUEUEING_MTH queueing method for groups

COMMENTS Text comment on the plan

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

MANDATORY Whether the plan is mandatory

DBA_RSRC_PLAN_DIRECTIVES

PLAN Name of the plan to which this directive belongs

GROUP_OR_SUBPLAN Name of the consumer group/sub-plan referred to

TYPE Whether GROUP_OR_SUBPLAN refers to a consumer group or a plan

CPU_P1 first parameter for the CPU resource allocation method

CPU_P2 second parameter for the CPU resource allocation method

CPU_P3 third parameter for the CPU resource allocation method

CPU_P4 fourth parameter for the CPU resource allocation method

CPU_P5 fifth parameter for the CPU resource allocation method

CPU_P6 sixth parameter for the CPU resource allocation method

CPU_P7 seventh parameter for the CPU resource allocation method

CPU_P8 eight parameter for the CPU resource allocation method

ACTIVE_SESS_POOL_P1 first parameter for the maximum active sessions target resource allocation method

QUEUEING_P1 first parameter for the queueing method

PARALLEL_DEGREE_LIMIT_P1 first parameter for the parallel degree limit resource allocation method

SWITCH_GROUP group to switch to once switch time is reached

SWITCH_TIME switch time limit for execution within a group

SWITCH_ESTIMATE use execution estimate to determine group?

MAX_EST_EXEC_TIME use of max. estimated execution time

UNDO_POOL max. undo allocation for consumer groups

COMMENTS Text comment on the plan directive

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

MANDATORY Whether the plan directive is mandatory

DBA_RULES

RULE_OWNER Owner of the rule

RULE_NAME Name of the rule

RULE_CONDITION the rule expression

RULE_EVALUATION_CONTEXT_OWNER

RULE_EVALUATION_CONTEXT_NAME

RULE_ACTION_CONTEXT action context of the rule

RULE_COMMENT user description of the rule

DBA_RULESETS

OWNER Owner of the ruleset

RULESET_NAME Name of the ruleset

RULESET_STORAGE_TABLE name of the table to store rules in the ruleset

BASE_TABLE name of the evaluation context for the rule set

RULESET_COMMENT user description of the ruleset

DBA_RULE_SETS

RULE_SET_OWNER Owner of the rule set

RULE_SET_NAME Name of the rule set

RULE_SET_EVAL_CONTEXT_OWNER The evaluation context owner name associated with the rule set, if any

RULE_SET_EVAL_CONTEXT_NAME The evaluation context name associated with the rule set, if any

RULE_SET_COMMENT user description of the rule set

DBA_RULE_SET_RULES

RULE_SET_OWNER Owner of the rule set

RULE_SET_NAME Name of the rule set

RULE_OWNER Owner of the rule

RULE_NAME Name of the rule

RULE_SET_RULE_ENABLED Whether the rule is enabled in this ruleset

RULE_SET_RULE_EVAL_CTX_OWNER evaluation context owner specified when the rule is added to this rule set

RULE_SET_RULE_EVAL_CTX_NAME evaluation context name specified when the rule is added to this rule set

RULE_SET_RULE_COMMENT User description of this mapping

DBA_SECONDARY_OBJECTS

INDEX_OWNER Name of the domain index owner

INDEX_NAME Name of the domain index

SECONDARY_OBJECT_OWNER Owner of the secondary object

SECONDARY_OBJECT_NAME Name of the secondary object

DBA_SEGMENTS

OWNER Username of the segment owner

SEGMENT_NAME Name, if any, of the segment

PARTITION_NAME Partition/Subpartition Name, if any, of the segment

SEGMENT_TYPE Type of segment: "TABLE", "CLUSTER", "INDEX", "ROLLBACK", "DEFERRED ROLLBACK", "TEMPORARY","SPACE HEADER", "TYPE2 UNDO" or "CACHE"

TABLESPACE_NAME Name of the tablespace containing the segment

HEADER_FILE ID of the file containing the segment header

HEADER_BLOCK ID of the block containing the segment header

BYTES Size, in bytes, of the segment

BLOCKS Size, in Oracle blocks, of the segment

EXTENTS Number of extents allocated to the segment

INITIAL_EXTENT Size, in bytes, of the initial extent of the segment

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

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

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

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated in this segment

RELATIVE_FNO Relative number of the file containing the segment header

BUFFER_POOL The default buffer pool to be used for segments blocks

DBA_SEQUENCES

SEQUENCE_OWNER Name of the owner of the sequence

SEQUENCE_NAME SEQUENCE name

MIN_VALUE Minimum value of the sequence

MAX_VALUE Maximum value of the sequence

INCREMENT_BY Value by which sequence is incremented

CYCLE_FLAG Does sequence wrap around on reaching limit?

ORDER_FLAG Are sequence numbers generated in order?

CACHE_SIZE Number of sequence numbers to cache

LAST_NUMBER Last sequence number written to disk

DBA_SNAPSHOTS

OWNER Owner of the snapshot

NAME The view used by users and applications for viewing the snapshot

TABLE_NAME Table the snapshot is stored in -- has an extra column for the master rowid

MASTER_VIEW View of the master table, owned by the snapshot owner, used for refreshes

MASTER_OWNER Owner of the master table

MASTER Name of the master table that this snapshot is a copy of

MASTER_LINK Database link name to the master site

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

UPDATABLE If NO, the snapshot is read only. Look up REPLICATION

REFRESH_METHOD The values used to drive a fast refresh of the snapshot

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

ERROR The number of failed automatic refreshes since last successful refresh

FR_OPERATIONS If REGENERATE, then the fast refresh operations have not been generated

CR_OPERATIONS If REGENERATE, then the complete refresh operations have not been generated

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

NEXT The date function used to compute next refresh dates

START_WITH The date function used to compute next refresh dates

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

UPDATE_TRIG The name of the trigger which fills the UPDATE_LOG

UPDATE_LOG The table which logs changes made to an updatable snapshots

QUERY The original query that this snapshot is an instantiation of

MASTER_ROLLBACK_SEG Rollback segment to use at the master site

STATUS The status of the contents of the snapshot

REFRESH_MODE This indicates how and when the snapshot will be refreshed

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

DBA_SNAPSHOT_LOGS

LOG_OWNER Owner of the snapshot log

MASTER Name of the master table which changes are logged

LOG_TABLE Log table; with rowids and timestamps of rows which changed in the master

LOG_TRIGGER An after-row trigger on the master which inserts rows into the log

ROWIDS If YES, the snapshot log records rowid information

PRIMARY_KEY If YES, the snapshot log records primary key information

OBJECT_ID If YES, the snapshot log records object id information

FILTER_COLUMNS If YES, the snapshot log records filter column information

SEQUENCE If YES, the snapshot log records sequence information

INCLUDE_NEW_VALUES If YES, the snapshot log records old and new values (else only old values)

CURRENT_SNAPSHOTS One date per snapshot -- the date the snapshot of the master last refreshed

SNAPSHOT_ID Unique identifier of the snapshot

DBA_SNAPSHOT_LOG_FILTER_COLS

OWNER Owner of the master table being logged

NAME Name of the master table being logged

COLUMN_NAME Filter column being logged

DBA_SNAPSHOT_REFRESH_TIMES

DBA_SOURCE

OWNER

NAME Name of the object

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

LINE Line number of this line of source

TEXT Source text

DBA_SQLJ_TYPES

OWNER Owner of the type

TYPE_NAME Name of the type

TYPE_OID Object identifier (OID) of the type

EXTERNAL_NAME External class name of the type

USING Representation of the type

TYPECODE Typecode of the type

ATTRIBUTES Number of attributes in the type

METHODS Number of methods in the type

PREDEFINED Is the type a predefined type?

INCOMPLETE Is the type an incomplete type?

FINAL Is the type a final type?

INSTANTIABLE Is the type an instantiable type?

SUPERTYPE_OWNER Owner of the supertype (null if type is not a subtype)

SUPERTYPE_NAME Name of the supertype (null if type is not a subtype)

LOCAL_ATTRIBUTES Number of local (not inherited) attributes (if any) in the subtype

LOCAL_METHODS Number of local (not inherited) methods (if any) in the subtype

DBA_SQLJ_TYPE_ATTRS

OWNER Owner of the type

TYPE_NAME Name of the type

ATTR_NAME Name of the attribute

EXTERNAL_ATTR_NAME External name of the attribute

ATTR_TYPE_MOD Type modifier of the attribute

ATTR_TYPE_OWNER Owner of the type of the attribute

ATTR_TYPE_NAME Name of the type of the attribute

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

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

SCALE Scale of the NUMBER or DECIMAL attribute

CHARACTER_SET_NAME Character set name of the attribute

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

INHERITED Is the attribute inherited from the supertype ?

DBA_SQLJ_TYPE_METHODS

OWNER Owner of the type

TYPE_NAME Name of the type

METHOD_NAME Name of the method

EXTERNAL_VAR_NAME Name of the external variable

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

METHOD_TYPE Type of the method

PARAMETERS Number of parameters to the method

RESULTS Number of results returned by the method

FINAL Is the method final ?

INSTANTIABLE Is the method instantiable ?

OVERRIDING Is the method overriding a supertype method ?

INHERITED Is the method inherited from the supertype ?

DBA_STMT_AUDIT_OPTS

USER_NAME User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done

PROXY_NAME Name of the proxy user if auditing is being done for operations being done on behalf of a client. Null if auditing is being done for operations done by the client directly

AUDIT_OPTION Name of the system auditing option

SUCCESS Mode for WHENEVER SUCCESSFUL system auditing

FAILURE Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_STORED_SETTINGS

OWNER Username of the owner of the object

OBJECT_NAME Name of the object

OBJECT_ID Object number of the object

OBJECT_TYPE Type of the object

PARAM_NAME Name of the parameter

PARAM_VALUE Value of the parameter

DBA_STREAMS_GLOBAL_RULES

STREAMS_NAME Name of the streams process: capture/propagation/apply process

STREAMS_TYPE Type of the streams process: CAPTURE, PROPAGATION or APPLY

RULE_TYPE Type of rule: DML or DDL

INCLUDE_TAGGED_LCR Whether or not to include tagged LCR

SOURCE_DATABASE Name of the database where the LCRs originated

RULE_NAME Name of the rule to be applied

RULE_OWNER Owner of the rule

RULE_CONDITION Generated rule condition evaluated by the rules engine

DBA_STREAMS_SCHEMA_RULES

STREAMS_NAME Name of the streams process: capture/propagation/apply process

STREAMS_TYPE Type of the streams process: CAPTURE, PROPAGATION or APPLY

SCHEMA_NAME Name of the schema selected by this rule

RULE_TYPE Type of rule: DML or DDL

INCLUDE_TAGGED_LCR Whether or not to include tagged LCR

SOURCE_DATABASE Name of the database where the LCRs originated

RULE_NAME Name of the rule to be applied

RULE_OWNER Owner of the rule

RULE_CONDITION Generated rule condition evaluated by the rules engine

DBA_STREAMS_TABLE_RULES

STREAMS_NAME Name of the streams process: capture/propagation/apply process

STREAMS_TYPE Type of the streams process: CAPTURE, PROPAGATION or APPLY

TABLE_OWNER Owner of the table selected by this rule

TABLE_NAME Name of the table selected by this rule

RULE_TYPE Type of rule: DML or DDL

DML_CONDITION Row subsetting condition

SUBSETTING_OPERATION DML operation for row subsetting

INCLUDE_TAGGED_LCR Whether or not to include tagged LCR

SOURCE_DATABASE Name of the database where the LCRs originated

RULE_NAME Name of the rule to be applied

RULE_OWNER Owner of the rule

RULE_CONDITION Generated rule condition evaluated by the rules engine

DBA_SUMMARIES

OWNER Owner of the summary

SUMMARY_NAME Name of the summary

CONTAINER_OWNER Owner of the container table

CONTAINER_NAME Name of the container table for this summary

LAST_REFRESH_SCN The SCN of the last transaction to refresh the summary

LAST_REFRESH_DATE The date of the last refresh of the summary

REFRESH_METHOD User declared method of refresh for the summary

SUMMARY Indicates the presence of either aggregation or a GROUP BY

FULLREFRESHTIM The time that it took to fully refresh the summary

INCREFRESHTIM The time that it took to incrementally refresh the summary

CONTAINS_VIEWS This summary contains views in the FROM clause

UNUSABLE This summary is unusable, the build was deferred

RESTRICTED_SYNTAX This summary contains restrictive syntax

INC_REFRESHABLE This summary is not restricted from being incrementally refreshed

KNOWN_STALE This summary is directly stale

QUERY_LEN

QUERY

DBA_SUMMARY_AGGREGATES

OWNER Owner of the summary

SUMMARY_NAME Name of the summary

POSITION_IN_SELECT Position of this aggregated measure with the SELECT list

CONTAINER_COLUMN Name of this column in the container table

AGG_FUNCTION Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV

DISTINCTFLAG Set to Y is this is a DISTINCT aggregation

MEASURE The SQL text of the measure, excluding the aggregation function

DBA_SUMMARY_DETAIL_TABLES

OWNER Owner of the summary

SUMMARY_NAME Name of the summary

DETAIL_OWNER Owner of the detail relation

DETAIL_RELATION Name of the summary detail table

DETAIL_TYPE Type of summary detail table type

DETAIL_ALIAS Alias of the detail relation if used

DBA_SUMMARY_JOINS

OWNER Owner of the summary

SUMMARY_NAME Name of the summary

DETAILOBJ1_OWNER Owner of the 1st detail object

DETAILOBJ1_RELATION Name of the 1st detail object

DETAILOBJ1_COLUMN Name of the 1st detail object column

OPERATOR Name of the join operator. Currently only = is defined

DETAILOBJ2_OWNER Owner of the 2nd detail object

DETAILOBJ2_RELATION Name of the 2nd detail object

DETAILOBJ2_COLUMN Name of the 2nd detail object column

DBA_SUMMARY_KEYS

OWNER Owner of the summary

SUMMARY_NAME Name of the summary

POSITION_IN_SELECT Position of this key within the SELECT list

CONTAINER_COLUMN Name of the column in the container table

DETAILOBJ_OWNER Owner of the detail object

DETAILOBJ_NAME Name of the detail object

DETAILOBJ_ALIAS Alias of the detail object

DETAILOBJ_TYPE Type of the detail object: VIEW or TABLE

DETAILOBJ_COLUMN Name of the detail object column

DBA_SYNONYMS

OWNER Username of the owner of the synonym

SYNONYM_NAME Name of the synonym

TABLE_OWNER Owner of the object referenced by the synonym

TABLE_NAME Name of the object referenced by the synonym

DB_LINK Name of the database link referenced in a remote synonym

DBA_SYS_PRIVS

GRANTEE Grantee Name, User or Role receiving the grant

PRIVILEGE System privilege

ADMIN_OPTION Grant was with the ADMIN option

DBA_TABLES

NEXT_EXTENT Size of secondary extents in bytes

MIN_EXTENTS Minimum number of extents allowed in the segment

MAX_EXTENTS Maximum number of extents allowed in the segment

PCT_INCREASE Percentage increase in extent size

FREELISTS Number of process freelists allocated in this segment

FREELIST_GROUPS Number of freelist groups allocated in this segment

LOGGING Logging attribute

BACKED_UP Has table been backed up since last modification?

NUM_ROWS The number of rows in the table

BLOCKS The number of used blocks in the table

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

AVG_SPACE The average available free space in the table

CHAIN_CNT The number of chained rows in the table

AVG_ROW_LEN The average row length, including row overhead

AVG_SPACE_FREELIST_BLOCKS The average freespace of all blocks on a freelist

NUM_FREELIST_BLOCKS The number of blocks on the freelist

DEGREE The number of threads per instance for scanning the table

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

CACHE Whether the table is to be cached in the buffer cache

TABLE_LOCK Whether table locking is enabled or disabled

SAMPLE_SIZE The sample size used in analyzing this table

LAST_ANALYZED The date of the most recent time this table was analyzed

PARTITIONED Is this table partitioned? YES or NO

IOT_TYPE If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL

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

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

NESTED Is the table a nested table?

BUFFER_POOL The default buffer pool to be used for table blocks

ROW_MOVEMENT Whether partitioned row movement is enabled or disabled

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

USER_STATS Were the statistics entered directly by the user?

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

SKIP_CORRUPT Whether skip corrupt blocks is enabled or disabled

MONITORING Should we keep track of the amount of modification?

CLUSTER_OWNER Owner of the cluster, if any, to which the table belongs

DEPENDENCIES Should we keep track of row level dependencies?

OWNER Owner of the table

TABLE_NAME Name of the table

TABLESPACE_NAME Name of the tablespace containing the table

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

IOT_NAME Name of the index-only table, if any, to which the overflow or mapping table entry belongs

PCT_FREE Minimum percentage of free space in a block

PCT_USED Minimum percentage of used space in a block

INI_TRANS Initial number of transactions

MAX_TRANS Maximum number of transactions

INITIAL_EXTENT Size of the initial extent in bytes

DBA_TABLESPACES

TABLESPACE_NAME Tablespace name

BLOCK_SIZE Tablespace block size

INITIAL_EXTENT Default initial extent size

NEXT_EXTENT Default incremental extent size

MIN_EXTENTS Default minimum number of extents

MAX_EXTENTS Default maximum number of extents

PCT_INCREASE Default percent increase for extent size

MIN_EXTLEN Minimum extent size for the tablespace

STATUS Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"

CONTENTS Tablespace contents: "PERMANENT", or "TEMPORARY"

LOGGING Default logging attribute

FORCE_LOGGING Tablespace force logging mode

EXTENT_MANAGEMENT Extent management tracking: "DICTIONARY" or "LOCAL"

ALLOCATION_TYPE Type of extent allocation in effect for this tablespace

PLUGGED_IN

SEGMENT_SPACE_MANAGEMENT Segment space management tracking: "AUTO" or "MANUAL"

DBA_TAB_COLS

OWNER

TABLE_NAME Table, view or cluster name

COLUMN_NAME Column name

DATA_TYPE Datatype of the column

DATA_TYPE_MOD Datatype modifier of the column

DATA_TYPE_OWNER Owner of the datatype of the column

DATA_LENGTH Length of the column in bytes

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

DATA_SCALE Digits to right of decimal point in a number

NULLABLE Does column allow NULL values?

COLUMN_ID Sequence number of the column as created

DEFAULT_LENGTH Length of default value for the column

DATA_DEFAULT Default value for the column

NUM_DISTINCT The number of distinct values in the column

LOW_VALUE The low value in the column

HIGH_VALUE The high value in the column

DENSITY The density of the column

NUM_NULLS The number of nulls in the column

NUM_BUCKETS The number of buckets in histogram for the column

LAST_ANALYZED The date of the most recent time this column was analyzed

SAMPLE_SIZE The sample size used in analyzing this column

CHARACTER_SET_NAME Character set name

CHAR_COL_DECL_LENGTH Declaration length of character type column

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

USER_STATS Were the statistics entered directly by the user?

AVG_COL_LEN The average length of the column in bytes

CHAR_LENGTH The maximum length of the column in characters

CHAR_USED C if the width was specified in characters, B if in bytes

V80_FMT_IMAGE Is column data in 8.0 image format?

DATA_UPGRADED Has column data been upgraded to the latest type version format?

HIDDEN_COLUMN Is this a hidden column?

VIRTUAL_COLUMN Is this a virtual column?

SEGMENT_COLUMN_ID Sequence number of the column in the segment

INTERNAL_COLUMN_ID Internal sequence number of the column

DBA_TAB_COLUMNS

DBA_TAB_COL_STATISTICS

OWNER Table, view or cluster owner

TABLE_NAME Table, view or cluster name

COLUMN_NAME Column name

NUM_DISTINCT The number of distinct values in the column

LOW_VALUE The low value in the column

HIGH_VALUE The high value in the column

DENSITY The density of the column

NUM_NULLS The number of nulls in the column

NUM_BUCKETS The number of buckets in histogram for the column

LAST_ANALYZED The date of the most recent time this column was analyzed

SAMPLE_SIZE The sample size used in analyzing this column

GLOBAL_STATS Are the statistics calculated without merging underlying partitions?

USER_STATS Were the statistics entered directly by the user?

AVG_COL_LEN The average length of the column in bytes

DBA_TAB_COMMENTS

OWNER Owner of the object

TABLE_NAME Name of the object

TABLE_TYPE Type of the object

COMMENTS Comment on the object

DBA_TAB_HISTOGRAMS

DBA_TAB_MODIFICATIONS

TABLE_OWNER Owner of modified table

TABLE_NAME Modified table

PARTITION_NAME Modified partition

SUBPARTITION_NAME Modified subpartition

INSERTS Approximate number of rows inserted since last analyze

UPDATES Approximate number of rows updated since last analyze

DELETES Approximate number of rows deleted since last analyze

TIMESTAMP Timestamp of last time this row was modified

TRUNCATED Was this object truncated since the last analyze?

DBA_TAB_PRIVS

GRANTEE User to whom access was granted

OWNER Owner of the object

TABLE_NAME Name of the object

GRANTOR Name of the user who performed the grant

PRIVILEGE Table Privilege

GRANTABLE Privilege is grantable

HIERARCHY Privilege is with hierarchy option

DBA_TEMPLATE_REFGROUPS

REFRESH_GROUP_ID Internal primary key of the refresh groups table.

REFRESH_GROUP_NAME Name of the refresh group

REFRESH_TEMPLATE_ID Primary key of the template containing the refresh group.

REFRESH_TEMPLATE_NAME Name of the deployment template containing the refresh group.

ROLLBACK_SEG Name of the rollback segment to use during refresh.

START_DATE Refresh start date.

INTERVAL Refresh interval.

DBA_TEMPLATE_TARGETS

TEMPLATE_TARGET_ID Internal primary key of the template targets table.

TARGET_DATABASE Global identifier of the target database.

TARGET_COMMENT Comment on the target database.

CONNECT_STRING The connection descriptor used to connect to the target database.

DBA_TEMP_FILES

FILE_NAME Name of the database temp file

FILE_ID ID of the database temp file

TABLESPACE_NAME Name of the tablespace to which the file belongs

BYTES Size of the file in bytes

BLOCKS Size of the file in ORACLE blocks

STATUS File status: "AVAILABLE"

RELATIVE_FNO Tablespace-relative file number

AUTOEXTENSIBLE Autoextensible indicator: "YES" or "NO"

MAXBYTES Maximum size of the file in bytes

MAXBLOCKS Maximum size of the file in ORACLE blocks

INCREMENT_BY Default increment for autoextension

USER_BYTES Size of the useful portion of file in bytes

USER_BLOCKS Size of the useful portion of file in ORACLE blocks

DBA_TRIGGERS

OWNER Owner of the trigger

TRIGGER_NAME Name of the trigger

TRIGGER_TYPE When the trigger fires - BEFORE/AFTER and STATEMENT/ROW

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

TABLE_OWNER Owner of the table that this trigger is associated with

BASE_OBJECT_TYPE

TABLE_NAME Name of the table that this trigger is associated with

COLUMN_NAME The name of the column on which the trigger is defined over

REFERENCING_NAMES Names used for referencing to OLD and NEW values within the trigger

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

STATUS If DISABLED then trigger will not fire

DESCRIPTION Trigger description, useful for re-creating trigger creation statement

ACTION_TYPE

TRIGGER_BODY Action taken by this trigger when it fires

DBA_TRIGGER_COLS

TRIGGER_OWNER Owner of the trigger

TRIGGER_NAME Name of the trigger

TABLE_OWNER Owner of the table

TABLE_NAME Name of the table on which the trigger is defined

COLUMN_NAME Name of the column or the attribute of the ADT column used in trigger definition

COLUMN_LIST Is column specified in UPDATE OF clause?

COLUMN_USAGE Usage of column within trigger body

DBA_TS_QUOTAS

TABLESPACE_NAME Tablespace name

USERNAME User with resource rights on the tablespace

BYTES Number of bytes charged to the user

MAX_BYTES User's quota in bytes. NULL if no limit

BLOCKS Number of ORACLE blocks charged to the user

MAX_BLOCKS User's quota in ORACLE blocks. NULL if no limit

DBA_TYPES

OWNER Owner of the type

TYPE_NAME Name of the type

TYPE_OID Object identifier (OID) of the type

TYPECODE Typecode of the type

ATTRIBUTES Number of attributes in the type

METHODS Number of methods in the type

PREDEFINED Is the type a predefined type?

INCOMPLETE Is the type an incomplete type?

FINAL Is the type a final type?

INSTANTIABLE Is the type an instantiable type?

SUPERTYPE_OWNER Owner of the supertype (null if type is not a subtype)

SUPERTYPE_NAME Name of the supertype (null if type is not a subtype)

LOCAL_ATTRIBUTES Number of local (not inherited) attributes (if any) in the subtype

LOCAL_METHODS Number of local (not inherited) methods (if any) in the subtype

TYPEID Type id value of the type

DBA_TYPE_ATTRS

OWNER Owner of the type

TYPE_NAME Name of the type

ATTR_NAME Name of the attribute

ATTR_TYPE_MOD Type modifier of the attribute

ATTR_TYPE_OWNER Owner of the type of the attribute

ATTR_TYPE_NAME Name of the type of the attribute

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

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

SCALE Scale of the NUMBER or DECIMAL attribute

CHARACTER_SET_NAME Character set name of the attribute

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

INHERITED Is the attribute inherited from the supertype ?

DBA_TYPE_METHODS

OWNER Owner of the type

TYPE_NAME Name of the type

METHOD_NAME Name of the method

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

METHOD_TYPE Type of the method

PARAMETERS Number of parameters to the method

RESULTS Number of results returned by the method

FINAL Is the method final ?

INSTANTIABLE Is the method instantiable ?

OVERRIDING Is the method overriding a supertype method ?

INHERITED Is the method inherited from the supertype ?

DBA_TYPE_VERSIONS

OWNER Owner of the type

TYPE_NAME Name of the type

VERSION# Internal version number of the type

TYPECODE Typecode of the type

STATUS Status of the type

LINE Line number of the type's spec

TEXT Text of the type's spec

HASHCODE Hashcode of the type

DBA_UNDO_EXTENTS

OWNER Owner of the segment associated with the extent

SEGMENT_NAME Name of the segment associated with the extent

TABLESPACE_NAME Name of the tablespace containing the extent

EXTENT_ID Extent number in the segment

FILE_ID Name of the file containing the extent

BLOCK_ID Starting block number of the extent

BYTES Size of the extent in bytes

BLOCKS Size of the extent in ORACLE blocks

RELATIVE_FNO Relative number of the file containing the segment header

COMMIT_JTIME Commit Time of the undo in the extent expressed as Julian date

COMMIT_WTIME Commit Time of the undo in the extent expressed as wall clock time

STATUS Transaction Status of the undo in the extent

DBA_UNUSED_COL_TABS

OWNER Owner of the table

TABLE_NAME Name of the table

COUNT Number of unused columns in table

DBA_UPDATABLE_COLUMNS

OWNER table owner

TABLE_NAME table name

COLUMN_NAME column name

UPDATABLE Is the column updatable?

INSERTABLE Is the column insertable?

DELETABLE Is the column deletable?

DBA_USERS

USERNAME Name of the user

USER_ID ID number of the user

PASSWORD Encrypted password

ACCOUNT_STATUS

LOCK_DATE

EXPIRY_DATE

DEFAULT_TABLESPACE Default tablespace for data

TEMPORARY_TABLESPACE Default tablespace for temporary tables

CREATED User creation date

PROFILE User resource profile name

INITIAL_RSRC_CONSUMER_GROUP User's initial consumer group

EXTERNAL_NAME User external name

DBA_USTATS

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

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

PARTITION_NAME Name of the partition (if applicable) for which the stats have been collected

OBJECT_TYPE Type of the object - Column or Index

ASSOCIATION If the statistics type association is direct or implicit

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

STATSTYPE_SCHEMA Schema of statistics type which was used to collect the statistics

STATSTYPE_NAME Name of statistics type which was used to collect statistics

STATISTICS User collected statistics for the object

DBA_VARRAYS

OWNER Owner of the varray

PARENT_TABLE_NAME Name of the parent table containing the varray

PARENT_TABLE_COLUMN Column name of the parent table that corresponds to the varray

TYPE_OWNER Owner of the type of which the varray was created

TYPE_NAME Name of the type of the varray

LOB_NAME Name of the lob if varray is stored in a lob

STORAGE_SPEC Indication of default or user-specified storage for the varray

RETURN_TYPE Return type of the varray column locator or value

ELEMENT_SUBSTITUTABLE Indication of whether the varray element is substitutable or not

DBA_VIEWS

OWNER Owner of the view

VIEW_NAME Name of the view

TEXT_LENGTH Length of the view text

TEXT View text

TYPE_TEXT_LENGTH Length of the type clause of the object view

TYPE_TEXT Type clause of the object view

OID_TEXT_LENGTH Length of the WITH OBJECT OID clause of the object view

OID_TEXT WITH OBJECT OID clause of the object view

VIEW_TYPE_OWNER Owner of the type of the view if the view is an object view

VIEW_TYPE Type of the view if the view is an object view

SUPERVIEW_NAME Name of the superview, if view is a subview


LOCAL_TRAN_ID

IN_OUT	"in" for incoming connections, "out" for outgoing
DATABASE	in: client database name; out: outgoing db link
DBUSER_OWNER	in: name of local user; out: owner of db link
INTERFACE	"C" for request commit, else "N" for prepare or request readonly commit
DBID	the database id at the other end of the connection
SESS#	session number at this database of the connection
BRANCH	transaction branch ID at this database of the connection


LOCAL_TRAN_ID	string of form: n.n.n, n a number
GLOBAL_TRAN_ID	globally unique transaction id
STATE	collecting, prepared, committed, forced commit, or forced rollback
MIXED	yes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used)
ADVICE	C for commit, R for rollback, else null
TRAN_COMMENT	text for "commit work comment "
FAIL_TIME	value of SYSDATE when the row was inserted (tx or system recovery)
FORCE_TIME	time of manual force decision (null if not forced locally)
RETRY_TIME	time automatic recovery (RECO) last tried to recover the transaction
OS_USER	operating system specific name for the end-user
OS_TERMINAL	operating system specific name for the end-user terminal
HOST	name of the host machine for the end-user
DB_USER	Oracle user name of the end-user at the topmost database
COMMIT#	global commit number for committed transactions


OBJECT_ID_TYPE	If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM GENERATED
TABLE_TYPE_OWNER	Owner of the type of the table if the table is an object table
TABLE_TYPE	Type of the table if the table is an object table
TEMPORARY	Can the current session only see data that it place in this object itself?
SECONDARY	Is this table object created as part of icreate for domain indexes?
NESTED	Is the table a nested table?
BUFFER_POOL	The default buffer pool to be used for table blocks
ROW_MOVEMENT	Whether partitioned row movement is enabled or disabled
GLOBAL_STATS	Are the statistics calculated without merging underlying partitions?
USER_STATS	Were the statistics entered directly by the user?
DURATION	If temporary table, then duration is sys$session or sys$transaction else NULL
SKIP_CORRUPT	Whether skip corrupt blocks is enabled or disabled
MONITORING	Should we keep track of the amount of modification?
CLUSTER_OWNER	Owner of the cluster, if any, to which the table belongs
DEPENDENCIES	Should we keep track of row level dependencies?
OWNER	Owner of the table
TABLE_NAME	Name of the table
TABLESPACE_NAME	Name of the tablespace containing the table
CLUSTER_NAME	Name of the cluster, if any, to which the table belongs
IOT_NAME	Name of the index-only table, if any, to which the overflow or mapping table entry belongs
PCT_FREE	Minimum percentage of free space in a block
PCT_USED	Minimum percentage of used space in a block
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Size of the initial extent in bytes
NEXT_EXTENT	Size of secondary extents in bytes
MIN_EXTENTS	Minimum number of extents allowed in the segment
MAX_EXTENTS	Maximum number of extents allowed in the segment
PCT_INCREASE	Percentage increase in extent size
FREELISTS	Number of process freelists allocated in this segment
FREELIST_GROUPS	Number of freelist groups allocated in this segment
LOGGING	Logging attribute
BACKED_UP	Has table been backed up since last modification?
NUM_ROWS	The number of rows in the table
BLOCKS	The number of used blocks in the table
EMPTY_BLOCKS	The number of empty (never used) blocks in the table
AVG_SPACE	The average available free space in the table
CHAIN_CNT	The number of chained rows in the table
AVG_ROW_LEN	The average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	The number of blocks on the freelist
DEGREE	The number of threads per instance for scanning the table
INSTANCES	The number of instances across which the table is to be scanned
CACHE	Whether the table is to be cached in the buffer cache
TABLE_LOCK	Whether table locking is enabled or disabled
SAMPLE_SIZE	The sample size used in analyzing this table
LAST_ANALYZED	The date of the most recent time this table was analyzed
PARTITIONED	Is this table partitioned? YES or NO
IOT_TYPE	If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL


ROLE	Name of Application Role
SCHEMA	Schema name of authorizing package
PACKAGE	Name of authorizing package


APPLY_NAME	Name of the apply process
QUEUE_NAME	Name of the queue the apply process dequeues from
QUEUE_OWNER	Owner of the queue the apply process dequeues from
APPLY_CAPTURED	Yes, if applying captured messages; No, if applying enqueued messages
RULE_SET_NAME	Rule set used by apply process for filtering
RULE_SET_OWNER	Owner of the rule set
APPLY_USER	Current user who is applying the messages
APPLY_DATABASE_LINK	For remote objects, the database link pointing to the remote database
APPLY_TAG	Tag associated with DDL and DML change records that will be applied
DDL_HANDLER	Name of the user specified ddl handler
MESSAGE_HANDLER	User specified procedure to handle messages other than DDL and DML messages
STATUS	Status of the apply process: DISABLED, ENABLED, ABORTED


OBJECT_OWNER	Owner of the object
OBJECT_NAME	Name of the object
METHOD_NAME	Name of the method used to resolve conflict
RESOLUTION_COLUMN	Name of the column used to resolve conflict
COLUMN_NAME	Name of the column that is to be considered as part of a group to resolve conflict
APPLY_DATABASE_LINK	For remote objects, name of database link pointing to remote database


APPLY_NAME	Name of the apply process at the local site which processed the transaction
QUEUE_NAME	Name of the queue at the local site where the transaction came from
QUEUE_OWNER	Owner of the queue at the local site where the transaction came from
LOCAL_TRANSACTION_ID	Local transaction ID for the error creation transaction
SOURCE_DATABASE	Database where the transaction originated
SOURCE_TRANSACTION_ID	Original transaction ID at the source database
SOURCE_COMMIT_SCN	Original commit SCN for the transaction at the source database
MESSAGE_NUMBER	Identifier for the message in the transaction that raised an error
ERROR_NUMBER	Error number
ERROR_MESSAGE	Error message
RECIPIENT_ID	User ID of the original recipient
RECIPIENT_NAME	Name of the original recipient
MESSAGE_COUNT	Total number of messages inside the error transaction


SOURCE_DATABASE	Name of the database where the objects originated
SOURCE_OBJECT_OWNER	Owner of the object at the source database
SOURCE_OBJECT_NAME	Name of the object at source
SOURCE_OBJECT_TYPE	Type of the object at source
INSTANTIATION_SCN	Point in time when the object was instantiated at source
IGNORE_SCN	SCN lower bound for messages that will be considered for apply
APPLY_DATABASE_LINK	For remote objects, the database link pointing to the remote database


APPLY_NAME	Name of the apply process
PARAMETER	Name of the parameter
VALUE	Either the default value or the value set by the user for the parameter
SET_BY_USER	YES if the value is set by the user, NO otherwise


APPLY_NAME	Name of the apply process
APPLIED_MESSAGE_NUMBER	All messages before this number have been successfully applied
OLDEST_MESSAGE_NUMBER	Earliest commit number of the transactions currently being applied
APPLY_TIME	Time at which the message was applied
APPLIED_MESSAGE_CREATE_TIME	Time at which the message to be applied was created


OBJECT_OWNER	Owner of the object for which the association is being defined
OBJECT_NAME	Object name for which the association is being defined
COLUMN_NAME	Column name in the object for which the association is being defined
OBJECT_TYPE	Schema type of the object - table, type, package or function
STATSTYPE_SCHEMA	Owner of the statistics type
STATSTYPE_NAME	Name of Statistics type which contains the cost, selectivity or stats funcs
DEF_SELECTIVITY	Default Selectivity if any of the object
DEF_CPU_COST	Default CPU cost if any of the object
DEF_IO_COST	Default I/O cost if any of the object
DEF_NET_COST	Default Networking cost if any of the object
INTERFACE_VERSION	Version number of Statistics type interface implemented


OBJECT_SCHEMA	Owner of the table or view
OBJECT_NAME	Name of the table or view
POLICY_NAME	Name of the policy
POLICY_TEXT	Audit condition
POLICY_COLUMN	Relevant column
PF_SCHEMA	Owner of the audit handler function
PF_PACKAGE	Name of the package containing the audit handler function
PF_FUNCTION	Name of the audit handler function
ENABLED	Is this policy is enabled?


OS_USERNAME	Operating System logon user name of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files (e.g., clustered Oracle on
	DEC VAX/VMS clusters)
TERMINAL	Identifier for the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
OWNER	Creator of object affected by the action
OBJ_NAME	Name of the object affected by the action
ACTION	Numeric action type code. The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME
ACTION_NAME	Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER	The owner of the object named in the NEW_NAME column
NEW_NAME	New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)
OBJ_PRIVILEGE	Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE	System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION	If role/sys_priv was granted WITH ADMIN OPTON, A/-
GRANTEE	The name of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION	Auditing option set with the audit statement
SES_ACTIONS	Session summary. A string of 11 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "S" = Succ
	ess, "F" = Failure, "B" = Both
LOGOFF_TIME	Timestamp for user logoff
LOGOFF_LREAD	Logical reads for the session
LOGOFF_PREAD	Physical reads for the session
LOGOFF_LWRITE	Logical writes for the session
LOGOFF_DLOCK	Deadlocks detected during the session
COMMENT_TEXT	Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authe
	ntication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type.
SESSIONID	Numeric ID for each Oracle session
ENTRYID	Numeric ID for each audit trail entry in the session
STATEMENTID	Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE	Oracle error code generated by the action. Zero if the action succeeded
PRIV_USED	System privilege used to execute the action
CLIENT_ID	Client identifier in each Oracle session
SESSION_CPU	Amount cpu time used by each oracel session


OWNER	Owner of the Analytic Workspace
AW_NUMBER	Number of the Analytic Workspace
AW_NAME	Name of the Analytic Workspace
PAGESPACES	Number of pagespaces in the Analytic Workspace
GENERATIONS	Number of active generations in the Analytic Workspace


OWNER	Owner of the master table which changes are logged
MASTER	Name of the master table which changes are logged
MVIEW_LAST_REFRESH_TIME	One date per materialized view -- the date the materialized view was last refreshed
MVIEW_ID	Unique identifier of the materialized view


CAPTURE_NAME	Name of the capture process
QUEUE_NAME	Name of queue used for holding captured changes
QUEUE_OWNER	Owner of the queue used for holding captured changes
RULE_SET_NAME	Rule set used by capture process for filtering
RULE_SET_OWNER	Owner of the rule set
START_SCN	The SCN from which capturing will be resumed
STATUS	Status of the capture process: DISABLED, ENABLED, ABORTED
CAPTURED_SCN	Everything up to this SCN has been captured
APPLIED_SCN	Everything up to this SCN has been applied


TIMESTAMP	Time at which the database was ready to be instantiated


SCHEMA_NAME	Name of schema prepared for instantiation
TIMESTAMP	Time at which the schema was ready to be instantiated


TABLE_OWNER	Owner of the table prepared for instantiation
TABLE_NAME	Name of the table prepared for instantiation
SCN	SCN from which changes can be captured
TIMESTAMP	Time at which the table was ready to be instantiated


OWNER	Owner of the cluster
CLUSTER_NAME	Name of the cluster
TABLESPACE_NAME	Name of the tablespace containing the cluster
PCT_FREE	Minimum percentage of free space in a block
PCT_USED	Minimum percentage of used space in a block
KEY_SIZE	Estimated size of cluster key plus associated rows
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Size of the initial extent in bytes
NEXT_EXTENT	Size of secondary extents in bytes
MIN_EXTENTS	Minimum number of extents allowed in the segment
MAX_EXTENTS	Maximum number of extents allowed in the segment
PCT_INCREASE	Percentage increase in extent size
FREELISTS	Number of process freelists allocated in this segment
FREELIST_GROUPS	Number of freelist groups allocated in this segment
AVG_BLOCKS_PER_KEY	Average number of blocks containing rows with a given cluster key
CLUSTER_TYPE	Type of cluster: b-tree index or hash
FUNCTION	If a hash cluster, the hash function
HASHKEYS	If a hash cluster, the number of hash keys (hash buckets)
DEGREE	The number of threads per instance for scanning the cluster
INSTANCES	The number of instances across which the cluster is to be scanned
CACHE	Whether the cluster is to be cached in the buffer cache
BUFFER_POOL	The default buffer pool to be used for cluster blocks
SINGLE_TABLE	Whether the cluster can contain only a single table
DEPENDENCIES	Should we keep track of row level dependencies?


OWNER	Name of owner of cluster
CLUSTER_NAME	Text of hash function of the cluster
HASH_EXPRESSION	Text of hash function of cluster


OWNER	Owner of the type
TYPE_NAME	Name of the type
COLL_TYPE	Collection type
UPPER_BOUND	Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type
ELEM_TYPE_MOD	Type modifier of the element
ELEM_TYPE_OWNER	Owner of the type of the element
ELEM_TYPE_NAME	Name of the type of the element
LENGTH	Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION	Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE	Scale of the NUMBER or DECIMAL element
CHARACTER_SET_NAME	Character set name of the element
ELEM_STORAGE	Storage optimization specification for VARRAY of numeric elements
NULLS_STORED	Is null information stored with each VARRAY element?


OWNER	Name of the owner of the object
TABLE_NAME	Name of the object
COLUMN_NAME	Name of the column
COMMENTS	Comment on the object


GRANTEE	Name of the user to whom access was granted
OWNER	Username of the owner of the object
TABLE_NAME	Name of the object
COLUMN_NAME	Name of the column
GRANTOR	Name of the user who performed the grant
PRIVILEGE	Column Privilege
GRANTABLE	Privilege is grantable


OWNER	Owner of the table
CONSTRAINT_NAME	Name associated with constraint definition
CONSTRAINT_TYPE	Type of constraint definition
TABLE_NAME	Name associated with table with constraint definition
SEARCH_CONDITION	Text of search condition for table check
R_OWNER	Owner of table used in referential constraint
R_CONSTRAINT_NAME	Name of unique constraint definition for referenced table
DELETE_RULE	The delete rule for a referential constraint
STATUS	Enforcement status of constraint - ENABLED or DISABLED
DEFERRABLE	Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE
DEFERRED	Is the constraint deferred by default - DEFERRED or IMMEDIATE
VALIDATED	Was this constraint system validated? - VALIDATED or NOT VALIDATED
GENERATED	Was the constraint name system generated? - GENERATED NAME or USER NAME
BAD	Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
RELY	If set, this flag will be used in optimizer
LAST_CHANGE	The date when this column was last enabled or disabled
INDEX_OWNER	The owner of the index used by this constraint
INDEX_NAME	The index used by this constraint
INVALID

VIEW_RELATED


OWNER	Owner of the constraint definition
CONSTRAINT_NAME	Name associated with the constraint definition
TABLE_NAME	Name associated with table with constraint definition
COLUMN_NAME	Name associated with column or attribute of object column specified in the constraint definition
POSITION	Original position of column or attribute in definition


NAMESPACE	Namespace of the context
SCHEMA	Schema of the designated package
PACKAGE	Name of the designated package
TYPE	Type of the context create


FILE_NAME	Name of the database data file
FILE_ID	ID of the database data file
TABLESPACE_NAME	Name of the tablespace to which the file belongs
BYTES	Size of the file in bytes
BLOCKS	Size of the file in ORACLE blocks
STATUS	File status: "INVALID" or "AVAILABLE"
RELATIVE_FNO	Tablespace-relative file number
AUTOEXTENSIBLE	Autoextensible indicator: "YES" or "NO"
MAXBYTES	Maximum size of the file in bytes
MAXBLOCKS	Maximum size of the file in ORACLE blocks
INCREMENT_BY	Default increment for autoextension
USER_BYTES	Size of the useful portion of file in bytes
USER_BLOCKS	Size of the useful portion of file in ORACLE blocks


OWNER

DB_LINK	Name of the database link
USERNAME	Name of user to log on as
HOST	SQL*Net string for connect
CREATED	Creation time of the database link


OWNER	Owner of the object
NAME	Name of the object
TYPE	Type of the object
REFERENCED_OWNER	Owner of referenced object (remote owner if remote object)
REFERENCED_NAME	Name of referenced object
REFERENCED_TYPE	Type of referenced object
REFERENCED_LINK_NAME	Name of dblink if this is a remote object
DEPENDENCY_TYPE