This chapter describes the system tables that are equivalent to those of ORACLE7 and are only known in the SQLMODE ORACLE. These system tables belong to the user 'SYS' the name of whom can, but need not, be placed in front of the name of the system table. All system tables the names of which start with DBA_ are only visible to users with DBA status; all the other tables are visible to all users. System tables the names of which start with USER_ contain information about objects related to the current user (e.g., that are owned by the current user). System tables the names of which start with ALL_ contain information about objects known to the user; i.e., objects that are owned by him or for which he has privileges.
System tables denoted by an '*' after the table name are known to ADABAS, but do not contain any entries because the corresponding information or objects do not exist in ADABAS. An '*' at the beginning of a column description means that this column always contains the NULL value, because this information is not available in the format required for ADABAS. The table and column descriptions are those given in ORACLE7. Therefore, they also refer to objects that are not available in ADABAS, e.g, PACKAGE.
If you want to retrieve information about certain tables, users, etc., ensure that their names are enclosed in single quotation marks. Names specified as <simple identifier>s must be specified in uppercase characters. Names specified as <special identifier>s are specified in the desired combination of upper- and lowercase characters without the enclosing <double quotes>. If <double quotes> belong to the <special identifier>, they are not entered twice.
ALL_CATALOG All tables, views, synonyms, sequences accessible to the user
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
TABLE_TYPE VARCHAR2 ( 11) Type of the object
ALL_COL_COMMENTS Comments on columns of accessible tables and views
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
COMMENTS VARCHAR2 (254) Comment on the column
ALL_COL_PRIVS Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
TABLE_SCHEMA VARCHAR2 ( 30) Schema of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
PRIVILEGE VARCHAR2 ( 30) Column Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_COL_PRIVS_MADE Grants on columns for which the user is owner or grantor
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Username of the owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Column Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_COL_PRIVS_RECD Grants on columns for which the user, PUBLIC or enabled role is the grantee
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Username of the owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Column privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_CONSTRAINTS Constraint definitions on accessible tables
OWNER VARCHAR2 ( 30) Owner of the table
CONSTRAINT_NAME VARCHAR2 ( 30) Name associated with constraint definition
CONSTRAINT_TYPE VARCHAR2 ( 2) Type of constraint definition
TABLE_NAME VARCHAR2 ( 30) Name associated with table with constraint definition
SEARCH_CONDITION VARCHAR2 (254) Text of search condition for table check
R_OWNER VARCHAR2 ( 30) Owner of table used in referential constraint
R_CONSTRAINT_NAME VARCHAR2 ( 30) Name of unique constraint definition for referenced table
DELETE_RULE VARCHAR2 ( 18) The delete rule for a referential constraint
STATUS VARCHAR2 ( 8) enforcement status of constraint - ENABLED or DISABLED
ALL_CONS_COLUMNS Information about accessible columns in constraint definitions
OWNER VARCHAR2 ( 30) Owner of the constraint definition
CONSTRAINT_NAME VARCHAR2 ( 30) Name associated with the constraint definition
TABLE_NAME VARCHAR2 ( 30) Name associated with table with constraint definition
COLUMN_NAME VARCHAR2 ( 30) Name associated with column specified in the constraint definition
POSITION NUMBER Original position of column in definition
ALL_DB_LINKS * Database links accessible to the user
The structure of the system table ALL_db_links and the meaning of its columns correspond to those of the system table DBA_db_links. In contrast to DBA_db_links, ALL_db_links does not contain the column PASSWORD.
ALL_DEF_AUDIT_OPTS Auditing options for newly created objects
ALT VARCHAR2 ( 3) Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD VARCHAR2 ( 3) Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM VARCHAR2 ( 3) Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL VARCHAR2 ( 3) Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA VARCHAR2 ( 3) Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND VARCHAR2 ( 3) Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS VARCHAR2 ( 3) Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC VARCHAR2 ( 3) Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN VARCHAR2 ( 3) Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL VARCHAR2 ( 3) Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD VARCHAR2 ( 3) Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF VARCHAR2 ( 3) Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)
EXE VARCHAR2 ( 3) Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL
ALL_DEPENDENCIES Dependencies to and from objects accessible to the user
OWNER VARCHAR2 ( 30) Owner of the object
NAME VARCHAR2 ( 30) Name of the object
TYPE VARCHAR2 ( 12) Type of the object
REFERENCED_OWNER VARCHAR2 ( 30) Owner of referenced object (remote owner if remote object)
REFERENCED_NAME VARCHAR2 ( 30) Name of referenced object
REFERENCED_TYPE VARCHAR2 ( 12) Type of referenced object
REFERENCED_LINK_NAME VARCHAR2 ( 30) * Name of dblink if this is a remote object
ALL_ERRORS * Current errors on stored objects that user is allowed to create
OWNER VARCHAR2 ( 30) Owner of the object
NAME VARCHAR2 ( 30) Name of the object
TYPE VARCHAR2 ( 12) Type of object: "view", "procedure", "function", "package" or "package body"
SEQUENCE NUMBER Sequence number used for ordering purposes
LINE NUMBER Line number at which this error occurs
POSITION NUMBER Position in the line at which this error occurs
TEXT VARCHAR2 (200) Text of the error
ALL_INDEXES Descriptions of indexes on tables accessible to the user
OWNER VARCHAR2 ( 30) Username of the owner of the index
INDEX_NAME VARCHAR2 ( 30) Name of the index
TABLE_OWNER VARCHAR2 ( 30) Owner of the indexed object
TABLE_NAME VARCHAR2 ( 30) Name of the indexed object
TABLE_TYPE VARCHAR2 ( 11) Type of the indexed object
UNIQUENESS VARCHAR2 ( 9) Uniqueness status of the index: "unique" or "nonunique"
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the index
INI_TRANS NUMBER * Initial number of transactions
MAX_TRANS NUMBER * Maximum number of transactions
INITIAL_EXTENT NUMBER * Size of the initial extent
NEXT_EXTENT NUMBER * Size of secondary extents
MIN_EXTENTS NUMBER * Minimum number of extents allowed in the segment
MAX_EXTENTS NUMBER * Maximum number of extents allowed in the segment
PCT_INCREASE NUMBER * Percentage increase in extent size
PCT_FREE NUMBER * Minimum percentage of free space in a block
BLEVEL NUMBER * B*-Tree level
LEAF_BLOCKS NUMBER * The number of leaf blocks in the index
DISTINCT_KEYS NUMBER The number of distinct keys in the index
AVG_LEAF_BLOCKS_
PER_KEY NUMBER * The average number of leaf blocks per key
AVG_DATA_BLOCKS_
PER_KEY NUMBER * The average number of data blocks per key
CLUSTERING_FACTOR NUMBER * A measurement of the amount of (dis)order of the table this index is for
STATUS VARCHAR2 ( 11) Whether index is in Direct Load State or not
ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES
INDEX_OWNER VARCHAR2 ( 30) Index owner
INDEX_NAME VARCHAR2 ( 30) Index name
TABLE_OWNER VARCHAR2 ( 30) Table or cluster owner
TABLE_NAME VARCHAR2 ( 30) Table or cluster name
COLUMN_NAME VARCHAR2 ( 30) Column name
COLUMN_POSITION NUMBER Position of column within index
COLUMN_LENGTH NUMBER Indexed length of the column
ALL_OBJECTS Objects accessible to the user
OWNER VARCHAR2 ( 30) Username of the owner of the object
OBJECT_NAME VARCHAR2 ( 30) Name of the object
OBJECT_ID RAW ( 8) Object number of the object
OBJECT_TYPE VARCHAR2 ( 11) Type of the object
CREATED DATE Timestamp for the creation of the object
LAST_DDL_TIME DATE Timestamp for the last DDL change (including GRANT and REVOKE) to the object
TIMESTAMP VARCHAR2 ( 75) Timestamp for the specification of the object
STATUS VARCHAR2 ( 7) Status of the object
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
SEQUENCE_OWNER VARCHAR2 ( 30) Name of the owner of the sequence
SEQUENCE_NAME VARCHAR2 ( 30) SEQUENCE name
MIN_VALUE NUMBER Minimum value of the sequence
MAX_VALUE NUMBER Maximum value of the sequence
INCREMENT_BY NUMBER Value by which sequence is incremented
CYCLE_FLAG VARCHAR2 ( 1) Does sequence wrap around on reaching limit?
ORDER_FLAG VARCHAR2 ( 1) Are sequence numbers generated in order?
CACHE_SIZE NUMBER Number of sequence numbers to cache
LAST_NUMBER NUMBER Last sequence number written to disk
ALL_SNAPSHOTS Snapshots the user can look at
OWNER VARCHAR2 ( 30) Owner of the snapshot
NAME VARCHAR2 ( 30) The view used by users and applications for viewing the snapshot
TABLE_NAME VARCHAR2 ( 30) * Table the snapshot is stored in -- has an extra column for the master rowid
MASTER_VIEW VARCHAR2 ( 30) * View of the master table, owned by the snapshot owner, used for refreshes
MASTER_OWNER VARCHAR2 ( 30) Owner of the master table
MASTER VARCHAR2 ( 30) Name of the master table that this snapshot is a copy of
MASTER_LINK VARCHAR2 ( 30) * Database link name to the master site
CAN_USE_LOG VARCHAR2 ( 3) If NO, this snapshot is complex and will never use a log
LAST_REFRESH DATE * SYSDATE from the master site at the time of the last refresh
ERROR NUMBER * The error returned last time an automatic refresh was attempted
TYPE VARCHAR2 ( 8) The type of refresh (complete,fast,force) for all automatic refreshes
NEXT VARCHAR2 (254) * The date function used to compute next refresh dates
START_WITH DATE * The date function used to compute next refresh dates
QUERY LONG The original query that this snapshot is an instantiation of
ALL_SOURCE * Current source on stored objects that user is allowed to create
OWNER VARCHAR2 ( 30) Owner of the object
NAME VARCHAR2 ( 30) Name of the object
TYPE VARCHAR2 ( 11) Type of the object: "procedure", "function", "package" or "package body"
LINE NUMBER Line number of this line of source
TEXT VARCHAR2 (200) Source text
ALL_SYNONYMS All synonyms accessible to the user
OWNER VARCHAR2 ( 30) Owner of the synonym
SYNONYM_NAME VARCHAR2 ( 30) Name of the synonym
TABLE_OWNER VARCHAR2 ( 30) Owner of the object referenced by the synonym
TABLE_NAME VARCHAR2 ( 30) Name of the object referenced by the synonym
DB_LINK VARCHAR2 ( 30) * Name of the database link referenced in a remote synonym
ALL_TABLES Description of tables accessible to the user
OWNER VARCHAR2 ( 30) Owner of the table
TABLE_NAME VARCHAR2 ( 30) Name of the table
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the table
CLUSTER_NAME VARCHAR2 ( 30) * Name of the cluster, if any, to which the table belongs
PCT_FREE NUMBER * Minimum percentage of free space in a block
PCT_USED NUMBER * Minimum percentage of used space in a block
INI_TRANS NUMBER * Initial number of transactions
MAX_TRANS NUMBER * Maximum number of transactions
INITIAL_EXTENT NUMBER * Size of the initial extent in bytes
NEXT_EXTENT NUMBER * Size of secondary extents in bytes
MIN_EXTENTS NUMBER * Minimum number of extents allowed in the segment
MAX_EXTENTS NUMBER * Maximum number of extents allowed in the segment
PCT_INCREASE NUMBER * Percentage increase in extent size
BACKED_UP VARCHAR2 ( 1) * Has table been backed up since last modification?
NUM_ROWS NUMBER * The number of rows in the table
BLOCKS NUMBER * The number of used blocks in the table
EMPTY_BLOCKS NUMBER * The number of empty (never used) blocks in the table
AVG_SPACE NUMBER * The average available free space in the table
CHAIN_CNT NUMBER * The number of chained rows in the table
AVG_ROW_LEN NUMBER * The average row length, including row overhead
ALL_TAB_COLUMNS Columns of all tables, views and clusters
OWNER VARCHAR2 ( 30) Owner of the table, view or cluster
TABLE_NAME VARCHAR2 ( 30) Table, view or cluster name
COLUMN_NAME VARCHAR2 ( 30) Column name
DATA_TYPE VARCHAR2 ( 9) Datatype of the column
DATA_LENGTH NUMBER Length of the column in bytes
DATA_PRECISION NUMBER Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE NUMBER Digits to right of decimal point in a number
NULLABLE VARCHAR2 ( 1) Does column allow NULL values?
COLUMN_ID NUMBER Sequence number of the column as created
DEFAULT_LENGTH NUMBER Length of default value for the column
DATA_DEFAULT VARCHAR2 (254) Default value for the column
NUM_DISTINCT NUMBER The number of distinct values for the column
LOW_VALUE RAW ( 1) * The second smallest value for the column
HIGH_VALUE RAW ( 1) * The second highest value for the column
DENSITY NUMBER * The density of the column
ALL_TAB_COMMENTS Comments on tables and views accessible to the user
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
TABLE_TYPE VARCHAR2 ( 11) Type of the object
COMMENTS VARCHAR2 (254) Comment on the object
ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
TABLE_SCHEMA VARCHAR2 ( 30) Schema of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_TAB_PRIVS_MADE User's grants and grants on user's objects
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
ALL_TRIGGERS Triggers accessible to the current user
OWNER VARCHAR2 ( 30) Owner of the trigger
TRIGGER_NAME VARCHAR2 ( 30) Name of the trigger
TRIGGER_TYPE VARCHAR2 ( 16) When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
TRIGGERING_EVENT VARCHAR2 ( 26) Statement that will fire the trigger - INSERT, UPDATE and/or DELETE
TABLE_OWNER VARCHAR2 ( 30) Owner of the table that this trigger is associated with
TABLE_NAME VARCHAR2 ( 30) Name of the table that this trigger is associated with
REFERENCING_NAMES VARCHAR2 ( 87) * Names used for referencing to OLD and NEW values within the trigger
WHEN_CLAUSE VARCHAR2 (200) * WHEN clause must evaluate to true in order for triggering body to execute
STATUS VARCHAR2 ( 8) If DISABLED then trigger will not fire
DESCRIPTION VARCHAR2 (254) Trigger description, useful for re-creating trigger creation statement
TRIGGER_BODY RAW ( 1) * Action taken by this trigger when it fires
ALL_TRIGGER_COLS * Column usage in user's triggers or in triggers on user's tables
TRIGGER_OWNER VARCHAR2 ( 30) Owner of the trigger
TRIGGER_NAME VARCHAR2 ( 30) Name of the trigger
TABLE_OWNER VARCHAR2 ( 30) Owner of the table
TABLE_NAME VARCHAR2 ( 30) Name of the table on which the trigger is defined
COLUMN_NAME VARCHAR2 ( 30) Name of the column used in trigger definition
COLUMN_LIST VARCHAR2 ( 3) Is column specified in UPDATE OF clause?
COLUMN_USAGE VARCHAR2 ( 17) Usage of column within trigger body
ALL_USERS Information about all users of the database
USERNAME VARCHAR2 ( 30) Name of the user
USER_ID NUMBER ID number of the user
CREATED DATE User creation date
ALL_VIEWS Text of views accessible to the user
OWNER VARCHAR2 ( 30) Owner of the view
VIEW_NAME VARCHAR2 ( 30) Name of the view
TEXT_LENGTH NUMBER Length of the view text
TEXT LONG View text
AUDIT_ACTIONS Description table for audit trail action type codes. Maps action type numbers to action type names
ACTION FLOAT ( 22) Numeric audit trail action type code
NAME VARCHAR2 ( 27) Name of the type of audit trail action
COLUMN_PRIVILEGES Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Username of the object's owner
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
INSERT_PRIV VARCHAR2 ( 1) Permission to insert into the column
UPDATE_PRIV VARCHAR2 ( 1) Permission to update the column
REFERENCES_PRIV VARCHAR2 ( 1) Permission to reference the column
CREATED DATE Timestamp for the grant
DBA_2PC_NEIGHBORS * information about incoming and outgoing connections for pending transactions
LOCAL_TRAN_ID VARCHAR2 ( 22) Transaction ID on the local database in the format n.n.n
IN_OUT VARCHAR2 ( 3) "in" for incoming connections, "out" for outgoing
DATABASE VARCHAR2 (128) in: client database name; out: outgoing db link
DBUSER_OWNER VARCHAR2 ( 30) in: name of local user; out: owner of db link
INTERFACE VARCHAR2 ( 1) "c" for request commit, else "n" for prepare or request readonly commit
DBID VARCHAR2 ( 16) the database id at the other end of the connection
SESS# NUMBER session number at this database of the connection
BRANCH VARCHAR2 (128) transaction branch ID at this database of the connection
DBA_2PC_PENDING * info about distributed transactions awaiting recovery
LOCAL_TRAN_ID VARCHAR2 ( 22) string of form: n.n.n, n a number
GLOBAL_TRAN_ID VARCHAR2 (169) globally unique transaction id
STATE VARCHAR2 ( 16) collecting, prepared, committed, forced commit, or forced rollback
MIXED VARCHAR2 ( 3) yes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used)
ADVICE VARCHAR2 ( 1) C for commit, R for rollback, else null
TRAN_COMMENT VARCHAR2 (254) text for "commit work comment <text>"
FAIL_TIME DATE value of SYSDATE when the row was inserted (tx or system recovery)
FORCE_TIME DATE time of manual force decision (null if not forced locally)
RETRY_TIME DATE time automatic recovery (RECO) last tried to recover the transaction
OS_USER VARCHAR2 (254) operating system specific name for the end-user
OS_TERMINAL VARCHAR2 (254) operating system specific name for the end-user terminal
HOST VARCHAR2 (254) name of the host machine for the end-user
DB_USER VARCHAR2 ( 30) Oracle user name of the end-user at the topmost database
COMMIT# VARCHAR2 ( 16) global commit number for committed transactions
DBA_AUDIT_EXISTS * All audit trail entries
OS_USERNAME VARCHAR2 (254) Operating System logon user name of the user whose actions were audited
USERNAME VARCHAR2 ( 30) Name (not ID number) of the user whose actions were audited
USERHOST VARCHAR2 (254) 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 VARCHAR2 (254) Identifier for the user's terminal
TIMESTAMP DATE Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
OWNER VARCHAR2 ( 30) Creator of object affected by the action
OBJ_NAME VARCHAR2 (128) Name of the object affected by the action
ACTION_NAME VARCHAR2 ( 27) Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER VARCHAR2 ( 30) The owner of the object named in the NEW_NAME column
NEW_NAME VARCHAR2 (128) 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 VARCHAR2 ( 16) Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE VARCHAR2 ( 40) System privileges granted/revoked by a GRANT/REVOKE statement
GRANTEE VARCHAR2 ( 30) The name of the grantee specified in a GRANT/REVOKE statement
SESSIONID NUMBER Numeric ID for each Oracle session
ENTRYID NUMBER Numeric ID for each audit trail entry in the session
STATEMENTID NUMBER Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE NUMBER Oracle error code generated by the action. Zero if the action succeeded
DBA_AUDIT_OBJECT * Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
OS_USERNAME VARCHAR2 (254) Operating System logon user name of the user whose actions were audited
USERNAME VARCHAR2 ( 30) Name (not ID number) of the user whose actions were audited
USERHOST VARCHAR2 (254) 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 VARCHAR2 (254) Identifier for the user's terminal
TIMESTAMP DATE Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
OWNER VARCHAR2 ( 30) Creator of object affected by the action
OBJ_NAME VARCHAR2 (128) Name of the object affected by the action
ACTION_NAME VARCHAR2 ( 27) Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER VARCHAR2 ( 30) The owner of the object named in the NEW_NAME column
NEW_NAME VARCHAR2 (128) New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)
SES_ACTIONS VARCHAR2 ( 16) Session summary. A string of 11 characters, one for each action type, in this order: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "s" = Success, "f" = Failure, "b" = Both
COMMENT_TEXT VARCHAR2 (254) Text comment on the audit trail entry
SESSIONID NUMBER Numeric ID for each Oracle session
ENTRYID NUMBER Numeric ID for each audit trail entry in the session
STATEMENTID NUMBER Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE NUMBER Oracle error code generated by the action. Zero if the action succeeded
PRIV_USED VARCHAR2 ( 40) System privilege used to execute the action
OBJECT_LABEL VARCHAR2 ( 1) Optional Trusted ORACLE label associated with object being audited
SESSION_LABEL VARCHAR2 ( 1) Trusted ORACLE label associated with user session
DBA_AUDIT_SESSION * All audit trail entries concerning connect and disconnect
OS_USERNAME VARCHAR2 (254) Operating System logon user name of the user whose actions were audited
USERNAME VARCHAR2 ( 30) Name (not ID number) of the user whose actions were audited
USERHOST VARCHAR2 (254) 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 VARCHAR2 (254) Identifier for the user's terminal
TIMESTAMP DATE Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
ACTION_NAME VARCHAR2 ( 27) Name of the action type corresponding to the numeric code in ACTION
LOGOFF_TIME DATE Timestamp for user logoff
LOGOFF_LREAD NUMBER Logical reads for the session
LOGOFF_PREAD NUMBER Physical reads for the session
LOGOFF_LWRITE NUMBER Logical writes for the session
LOGOFF_DLOCK VARCHAR2 ( 40) Deadlocks detected during the session
SESSIONID NUMBER Numeric ID for each Oracle session
RETURNCODE NUMBER Oracle error code generated by the action. Zero if the action succeeded
SESSION_LABEL VARCHAR2 ( 1) Trusted ORACLE label associated with user session
DBA_AUDIT_STATEMENT * Audit trail records concerning grant, revoke, audit, noaudit and alter system
OS_USERNAME VARCHAR2 (254) Operating System logon user name of the user whose actions were audited
USERNAME VARCHAR2 ( 30) Name (not ID number) of the user whose actions were audited
USERHOST VARCHAR2 (254) 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 VARCHAR2 (254) Identifier for the user's terminal
TIMESTAMP DATE Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
OWNER VARCHAR2 ( 30) Creator of object affected by the action
OBJ_NAME VARCHAR2 (128) Name of the object affected by the action
ACTION_NAME VARCHAR2 ( 27) Name of the action type corresponding to the numeric code in ACTION
NEW_NAME VARCHAR2 (128) New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)
OBJ_PRIVILEGE VARCHAR2 ( 16) Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE VARCHAR2 ( 40) System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION VARCHAR2 ( 1) If role/sys_priv was granted WITH ADMIN OPTION, A/-
GRANTEE VARCHAR2 ( 30) The name of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION VARCHAR2 ( 40) Auditing option set with the audit statement
SES_ACTIONS VARCHAR2 ( 16) Session summary. A string of 11 characters, one for each action type, in this order: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "s" = Success, "f" = Failure, "b" = Both
COMMENT_TEXT VARCHAR2 (254) Text comment on the audit trail entry
SESSIONID NUMBER Numeric ID for each Oracle session
ENTRYID NUMBER Numeric ID for each audit trail entry in the session
STATEMENTID NUMBER Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE NUMBER Oracle error code generated by the action. Zero if the action succeeded
PRIV_USED VARCHAR2 ( 40) System privilege used to execute the action
SESSION_LABEL VARCHAR2 ( 1) Trusted ORACLE label associated with user session
DBA_AUDIT_TRAIL * All audit trail entries
OS_USERNAME VARCHAR2 (254) Operating System logon user name of the user whose actions were audited
USERNAME VARCHAR2 ( 30) Name (not ID number) of the user whose actions were audited
USERHOST VARCHAR2 (254) 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 VARCHAR2 (254) Identifier for the user's terminal
TIMESTAMP DATE Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
OWNER VARCHAR2 ( 30) Creator of object affected by the action
OBJ_NAME VARCHAR2 (128) Name of the object affected by the action
ACTION NUMBER Numeric action type code. The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME
ACTION_NAME VARCHAR2 ( 27) Name of the action type corresponding to the numeric code in ACTION
NEW_OWNER VARCHAR2 ( 30) The owner of the object named in the NEW_NAME column
NEW_NAME VARCHAR2 (128) 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 VARCHAR2 ( 16) Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE VARCHAR2 ( 40) System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION VARCHAR2 ( 1) If role/sys_priv was granted WITH ADMIN OPTION, A/-
GRANTEE VARCHAR2 ( 30) The name of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION VARCHAR2 ( 40) Auditing option set with the audit statement
SES_ACTIONS VARCHAR2 ( 16) Session summary. A string of 11 characters, one for each action type, in this order: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update. Values: "-" = None, "s" = Success, "f" = Failure, "b" = Both
LOGOFF_TIME DATE Timestamp for user logoff
LOGOFF_LREAD NUMBER Logical reads for the session
LOGOFF_PREAD NUMBER Physical reads for the session
LOGOFF_LWRITE NUMBER Logical writes for the session
LOGOFF_DLOCK VARCHAR2 ( 40) Deadlocks detected during the session
COMMENT_TEXT VARCHAR2 (254) Text comment on the audit trail entry
SESSIONID NUMBER Numeric ID for each Oracle session
ENTRYID NUMBER Numeric ID for each audit trail entry in the session
STATEMENTID NUMBER Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE NUMBER Oracle error code generated by the action. Zero if the action succeeded
PRIV_USED VARCHAR2 ( 40) System privilege used to execute the action
OBJECT_LABEL VARCHAR2 ( 1) Optional Trusted ORACLE label associated with object being audited
SESSION_LABEL VARCHAR2 ( 1) Trusted ORACLE label associated with user session
DBA_BLOCKERS * All sessions that have someone waiting on a lock they hold that are not themselves waiting on a lock
SESSION_ID NUMBER Session holding a lock
DBA_CATALOG All database Tables, Views, Synonyms, Sequences
The structure of the system table dba_catalog and the meaning of its columns correspond to those of the system table all_catalog.
DBA_CLUSTERS * Description of all clusters in the database
OWNER VARCHAR2 ( 30) Owner of the cluster
CLUSTER_NAME VARCHAR2 ( 30) Name of the cluster
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the cluster
PCT_FREE NUMBER Minimum percentage of free space in a block
PCT_USED NUMBER Minimum percentage of used space in a block
KEY_SIZE NUMBER Estimated size of cluster key plus associated rows
INI_TRANS NUMBER Initial number of transactions
MAX_TRANS NUMBER Maximum number of transactions
INITIAL_EXTENT NUMBER Size of the initial extent in bytes
NEXT_EXTENT NUMBER Size of secondary extents in bytes
MIN_EXTENTS NUMBER Minimum number of extents allowed in the segment
MAX_EXTENTS NUMBER Maximum number of extents allowed in the segment
PCT_INCREASE NUMBER Percentage increase in extent size
AVG_BLOCKS_PER_KEY NUMBER Average number of blocks containing rows with a given cluster key
CLUSTER_TYPE VARCHAR2 ( 5) Type of cluster: b-tree index or hash
FUNCTION VARCHAR2 ( 7) If a hash cluster, the hash function
HASHKEYS NUMBER If a hash cluster, the number of hash keys (hash buckets)
DBA_CLU_COLUMNS * Mapping of table columns to cluster columns
OWNER VARCHAR2 ( 30) Owner of the cluster
CLUSTER_NAME VARCHAR2 ( 30) Cluster name
CLU_COLUMN_NAME VARCHAR2 ( 30) Key column in the cluster
TABLE_NAME VARCHAR2 ( 30) Clustered table name
TAB_COLUMN_NAME VARCHAR2 ( 30) Key column in the table
DBA_COL_COMMENTS Comments on columns of all tables and views
The structure of the system table dba_col_comments and the meaning of its columns correspond to those of the system table all_col_comments.
DBA_COL_PRIVS All grants on columns in the database
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Username of the owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Column Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
DBA_CONSTRAINTS Constraint definitions on all tables
The structure of the system table dba_constraints and the meaning of its columns correspond to those of the system table all_constraints.
DBA_CONS_COLUMNS Information about accessible columns in constraint definitions
The structure of the system table dba_cons_columns and the meaning of its columns correspond to those of the system table all_cons_columns.
DBA_DATA_FILES * Information about database files
FILE_NAME VARCHAR2 ( 72) Name of the database file
FILE_ID NUMBER ID of the database file
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace to which the file belongs
BYTES NUMBER Size of the file in bytes
BLOCKS NUMBER Size of the file in ORACLE blocks
STATUS VARCHAR2 ( 9) File status: "invalid" or "available"
DBA_DB_LINKS * All database links in the database
OWNER VARCHAR2 ( 30) Owner of the database link
DB_LINK VARCHAR2 ( 30) Name of the database link
USERNAME VARCHAR2 ( 30) Name of user to log on as
PASSWORD VARCHAR2 ( 30) Password for logon
HOST VARCHAR2 (254) SQL*Net string for connect
CREATED DATE Creation time of the database link
DBA_DDL_LOCKS * All DDL locks held in the database and all outstanding requests for a DDL lock
SESSION_ID NUMBER Session identifier
OWNER VARCHAR2 ( 30) Owner of the lock
NAME VARCHAR2 ( 1) Name of the lock
TYPE VARCHAR2 ( 1) Lock type: Cursor, Table/Procedure, Body, Trigger, Index, Cluster
MODE_HELD VARCHAR2 ( 10) Lock mode: None, Null, Share, Exclusive
MODE_REQUESTED VARCHAR2 ( 10) Lock request type: None, Null, Share, Exclusive
DBA_DEPENDENCIES Dependencies to and from objects
The structure of the system table dba_dependencies and the meaning of its columns correspond to those of the system table all_dependencies.
DBA_DML_LOCKS * All DML locks held in the database and all outstanding requests for a DML lock
SESSION_ID NUMBER Session holding or aquiring the lock
OWNER VARCHAR2 ( 30) Owner of the lock
NAME VARCHAR2 ( 1) Name of the lock
MODE_HELD VARCHAR2 ( 10) Lock mode
MODE_REQUESTED VARCHAR2 ( 10) Lock request type: None, Null, Share, Exclusive
DBA_ERRORS * Current errors on all stored objects in the database
The structure of the system table dba_errors and the meaning of its columns correspond to those of the system table all_errors.
DBA_EXP_FILES * Description of export files
EXP_VERSION NUMBER Version number of the export session
EXP_TYPE VARCHAR2 ( 11) Type of export file (full, cumulative, or incremental)
FILE_NAME VARCHAR2 ( 72) Name of the export file
USER_NAME VARCHAR2 ( 30) Name of user who executed export
TIMESTAMP DATE Timestamp of the export session
DBA_EXP_OBJECTS * Objects that have been incrementally exported
OWNER VARCHAR2 ( 30) Owner of exported object
OBJECT_NAME VARCHAR2 ( 30) Name of exported object
OBJECT_TYPE VARCHAR2 ( 12) Type of exported object
CUMULATIVE DATE Timestamp of last cumulative export
INCREMENTAL DATE Timestamp of last incremental export
EXPORT_VERSION NUMBER The id of the export session
DBA_EXP_VERSION * Version number of the last export session
EXP_VERSION NUMBER Version number of the last export session
DBA_EXTENTS * Extents comprising all segments in the database
OWNER VARCHAR2 ( 30) Owner of the segment associated with the extent
SEGMENT_NAME VARCHAR2 ( 72) Name of the segment associated with the extent
SEGMENT_TYPE VARCHAR2 ( 17) Type of the segment
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the extent
EXTENT_ID NUMBER Extent number in the segment
FILE_ID NUMBER Name of the file containing the extent
BLOCK_ID NUMBER Starting block number of the extent
BYTES NUMBER Size of the extent in bytes
BLOCKS NUMBER Size of the extent in ORACLE blocks
DBA_FREE_SPACE * Free extents in all tablespaces
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the extent
FILE_ID NUMBER ID number of the file containing the extent
BLOCK_ID NUMBER Starting block number of the extent
BYTES NUMBER Size of the extent in bytes
BLOCKS NUMBER Size of the extent in ORACLE blocks
DBA_INDEXES Description for all indexes in the database
The structure of the system table dba_indexes and the meaning of its columns correspond to those of the system table all_indexes.
DBA_IND_COLUMNS COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
The structure of the system table dba_ind_columns and the meaning of its columns correspond to those of the system table all_ind_columns.
DBA_LOCKS * All locks or latch held in the database, and all outstanding requests for a lock or latch. This view includes DML locks and DDL locks
SESSION_ID NUMBER Session holding or aquiring the lock
TYPE VARCHAR2 ( 2) Lock type
MODE_HELD VARCHAR2 ( 4) Lock mode
MODE_REQUESTED VARCHAR2 ( 4) Lock request type
LOCK_ID1 NUMBER Type-specific lock identifier, part 1
LOCK_ID2 NUMBER Type-specific lock identifier, part 2
DBA_OBJECTS All objects in the database
The structure of the system table dba_objects and the meaning of its columns correspond to those of the system table all_objects.
DBA_OBJECT_SIZE * Sizes, in bytes, of various pl/sql objects
OWNER VARCHAR2 ( 30) Owner of the object
NAME VARCHAR2 ( 30) Name of the object
TYPE VARCHAR2 ( 12) Type of the object: "table", "view", "synonym", "sequence", "procedure", "function", "package" or "package body"
SOURCE_SIZE NUMBER Size of the source, in bytes. Must be in memory during compilation, or dynamic recompilation
PARSED_SIZE NUMBER Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object
CODE_SIZE NUMBER Code size, in bytes. Must be in memory when this object is executing
ERROR_SIZE NUMBER Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors
DBA_OBJ_AUDIT_OPTS Auditing options for all tables and views
OWNER VARCHAR2 ( 30) Owner of the object
OBJECT_NAME VARCHAR2 ( 30) Name of the object
OBJECT_TYPE VARCHAR2 ( 11) Type of the object
ALT VARCHAR2 ( 3) Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD VARCHAR2 ( 3) Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM VARCHAR2 ( 3) Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL VARCHAR2 ( 3) Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA VARCHAR2 ( 3) Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND VARCHAR2 ( 3) Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS VARCHAR2 ( 3) Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC VARCHAR2 ( 3) Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN VARCHAR2 ( 3) Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL VARCHAR2 ( 3) Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD VARCHAR2 ( 3) Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF VARCHAR2 ( 3) Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)
EXE VARCHAR2 ( 3) Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL
DBA_PRIV_AUDIT_OPTS * Describes current system privileges being audited across the system and by user
USER_NAME VARCHAR2 ( 30) User name if by user auditing, else null for system wide auditing
PRIVILEGE VARCHAR2 ( 40) Name of the system privilege being audited
SUCCESS VARCHAR2 ( 10) Mode for WHENEVER SUCCESSFUL system auditing
FAILURE VARCHAR2 ( 10) Mode for WHENEVER NOT SUCCESSFUL system auditing
DBA_PROFILES * Display all profiles and their limits
PROFILE VARCHAR2 ( 30) Profile name
RESOURCE_NAME VARCHAR2 ( 32) Resource name
LIMIT VARCHAR2 ( 40) Limit placed on this resource for this profile
DBA_ROLES * All Roles which exist in the database
ROLE VARCHAR2 ( 30) Role Name
PASSWORD_REQUIRED VARCHAR2 ( 8) Indicates if the role requires a password to be enabled
DBA_ROLE_PRIVS * Roles granted to users and roles
GRANTEE VARCHAR2 ( 30) Grantee Name, User or Role receiving the grant
GRANTED_ROLE VARCHAR2 ( 30) Granted role name
ADMIN_OPTION VARCHAR2 ( 3) Grant was with the ADMIN option
DEFAULT_ROLE VARCHAR2 ( 3) Role is designated as a DEFAULT ROLE for the user
DBA_ROLLBACK_SEGS * Description of rollback segments
SEGMENT_NAME VARCHAR2 ( 30) Name of the rollback segment
OWNER VARCHAR2 ( 30) Owner of the rollback segment
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the rollback segment
SEGMENT_ID NUMBER ID number of the rollback segment
FILE_ID NUMBER ID number of the file containing the segment header
BLOCK_ID NUMBER ID number of the block containing the segment header
INITIAL_EXTENT NUMBER Initial extent size in bytes
NEXT_EXTENT NUMBER Secondary extent size in bytes
MIN_EXTENTS NUMBER Minimum number of extents
MAX_EXTENTS NUMBER Maximum number of extents
PCT_INCREASE NUMBER Percent increase for extent size
STATUS VARCHAR2 ( 1) Rollback segment status
INSTANCE_NUM NUMBER Rollback segment owning parallel server instance number
DBA_SEGMENTS Storage allocated for all database segments
OWNER VARCHAR2 ( 30) Username of the segment owner
SEGMENT_NAME VARCHAR2 ( 81) Name, if any, of the segment
SEGMENT_TYPE VARCHAR2 ( 17) Type of segment: "table", "cluster", "index", "rollback", "deferred rollback", "temporary", or "cache"
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the segment
HEADER_FILE NUMBER * ID of the file containing the segment header
HEADER_BLOCK NUMBER * ID of the block containing the segment header
BYTES NUMBER * Size, in bytes, of the segment
BLOCKS NUMBER * Size, in Oracle blocks, of the segment
EXTENTS NUMBER * Number of extents allocated to the segment
INITIAL_EXTENT NUMBER * Size, in Oracle blocks, of the initial extent of the segment
NEXT_EXTENT NUMBER * Size, in Oracle blocks, of the next extent to be allocated to the segment
MIN_EXTENTS NUMBER * Minimum number of extents allowed in the segment
MAX_EXTENTS NUMBER * Maximum number of extents allowed in the segment
PCT_INCREASE NUMBER * Percent by which to increase the size of the next extent to be allocated
FREELISTS NUMBER * Number of process freelists allocated in this segment
FREELIST_GROUPS NUMBER * Number of freelist groups allocated in this segment
DBA_SEQUENCES Description of all SEQUENCEs in the database
The structure of the system table dba_seqences and the meaning of its columns correspond to those of the system table all_sequences.
DBA_SNAPSHOTS All snapshots in the database
The structure of the system table dba_snapshots and the meaning of its columns correspond to those of the system table all_snapshots.
DBA_SNAPSHOT_LOGS All snapshot logs in the database
LOG_OWNER VARCHAR2 ( 30) Owner of the snapshot log
MASTER VARCHAR2 ( 30) Name of the master table which the log logs changes of
LOG_TABLE VARCHAR2 ( 30) Log table that holds the rowids and timestamps of rows that changed in the master table
LOG_TRIGGER VARCHAR2 ( 30) * An after-row trigger on the master which inserts rows into the log
CURRENT_SNAPSHOTS DATE * One date per snapshot -- the date the snapshot of the master last refreshed
DBA_SOURCE * Source of all stored objects in the database
The structure of the system table dba_source and the meaning of its columns correspond to those of the system table all_source.
DBA_STMT_AUDIT_OPTS * Describes current system auditing options across the system and by user
USER_NAME VARCHAR2 ( 30) User name if by user auditing, else null for system wide auditing
AUDIT_OPTION VARCHAR2 ( 3) Name of the system auditing option
SUCCESS VARCHAR2 ( 3) Mode for WHENEVER SUCCESSFUL system auditing
FAILURE VARCHAR2 ( 3) Mode for WHENEVER NOT SUCCESSFUL system auditing
DBA_SYNONYMS All synonyms in the database
The structure of the system table dba_synonyms and the meaning of its columns correspond to those of the system table all_synonyms.
DBA_SYS_PRIVS * System privileges granted to users and roles
GRANTEE VARCHAR2 ( 30) Grantee Name, User or Role receiving the grant
PRIVILEGE VARCHAR2 ( 40) System privilege
ADMIN_OPTION VARCHAR2 ( 3) Grant was with the ADMIN option
DBA_TABLES Description of all tables in the database
The structure of the system table dba_tables and the meaning of its columns correspond to those of the system table all_tables.
DBA_TABLESPACES * Description of all tablespaces
TABLESPACE_NAME VARCHAR2 ( 30) Tablespace name
INITIAL_EXTENT NUMBER Default initial extent size
NEXT_EXTENT NUMBER Default incremental extent size
MIN_EXTENTS NUMBER Default minimum number of extents
MAX_EXTENTS NUMBER Default maximum number of extents
PCT_INCREASE NUMBER Default percent increase for extent size
STATUS VARCHAR2 ( 9) Tablespace status: "online" or "offline"
DBA_TAB_COLUMNS Columns of all tables, views and clusters
The structure of the system table dba_tab_columns and the meaning of its columns correspond to those of the system table all_tab_columns.
DBA_TAB_COMMENTS Comments on all tables and views in the database
The structure of the system table dba_tab_comments and the meaning of its columns correspond to those of the system table all_tab_comments.
DBA_TAB_PRIVS All grants on objects in the database
GRANTEE VARCHAR2 ( 30) User to whom access was granted
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
DBA_TRIGGERS All triggers in the database
The structure of the system table dba_triggers and the meaning of its columns correspond to those of the system table all_triggers.
DBA_TRIGGER_COLS * Column usage in all triggers
The structure of the system table dba_trigger_cols and the meaning of its columns correspond to those of the system table all_trigger_cols.
DBA_TS_QUOTAS * Tablespace quotas for all users
TABLESPACE_NAME VARCHAR2 ( 30) Tablespace name
USERNAME VARCHAR2 ( 30) User with resource rights on the tablespace
BYTES NUMBER Number of bytes charged to the user
MAX_BYTES NUMBER User's quota in bytes. NULL if no limit
BLOCKS NUMBER Number of ORACLE blocks charged to the user
MAX_BLOCKS NUMBER User's quota in ORACLE blocks. NULL if no limit
DBA_USERS Information about all users of the database
USERNAME VARCHAR2 ( 30) Name of the user
USER_ID NUMBER ID number of the user
PASSWORD VARCHAR2 ( 30) Encrypted password
DEFAULT_TABLESPACE VARCHAR2 ( 30) Default tablespace for data
TEMPORARY_TABLESPACE VARCHAR2 ( 30) Default tablespace for temporary tables
CREATED DATE User creation date
PROFILE VARCHAR2 ( 30) * User resource profile name
DBA_VIEWS Text of all views in the database
OWNER VARCHAR2 ( 30) Owner of the view
VIEW_NAME VARCHAR2 ( 30) Name of the view
TEXT_LENGTH NUMBER Length of the view text
TEXT LONG View text
DBA_WAITERS * All locks or latch held in the database, and all outstanding requests for a lock or latch. This view includes DML locks and DDL locks
WAITING_SESSION NUMBER Session waiting for a lock
HOLDING_SESSION NUMBER Session holding a lock
TYPE VARCHAR2 ( 2) Lock type
MODE_HELD VARCHAR2 ( 9) Lock mode: Row-S (SS), Row-X (SX), Share, S/Row-X(SSX), Exclusive
MODE_REQUESTED VARCHAR2 ( 9) Lock request type: Null, Row-S (SS), Row-X (SX), Share, S/Row-X(SSX), Exclusive
LOCK_ID1 NUMBER Type-specific lock identifier, part 1
LOCK_ID2 NUMBER Type-specific lock identifier, part 2
DICTIONARY Description of data dictionary tables and views
TABLE_NAME VARCHAR2 ( 30) Name of the object
COMMENTS VARCHAR2 (254) Text comment on the object
DICT_COLUMNS Description of columns in data dictionary tables and views
TABLE_NAME VARCHAR2 ( 30) Name of the object that contains the column
COLUMN_NAME VARCHAR2 ( 30) Name of the column
COMMENTS VARCHAR2 (254) Text comment on the object
LOBAL_NAME Global database name
GLOBAL_NAME VARCHAR2 ( 83) Global name of the database
PUBLIC_DEPENDENCY * Dependencies to and from objects, by object number
OBJECT_ID RAW ( 8) Object number
REFERENCED_OBJECT_ID RAW ( 8) Referenced object (the parent object)
RESOURCE_COST * Cost for each resource
RESOURCE_NAME VARCHAR2 ( 32) Name of the resource
UNIT_COST NUMBER Cost of the resource
ROLE_ROLE_PRIVS * Roles which are granted to roles
ROLE VARCHAR2 ( 30) Name of the role
GRANTED_ROLE VARCHAR2 ( 30) Role that was granted
ADMIN_OPTION VARCHAR2 ( 3) Signifies that the role was granted with ADMIN option
ROLE_SYS_PRIVS * System privileges granted to roles
ROLE VARCHAR2 ( 30) Name of the role
PRIVILEGE VARCHAR2 ( 40) System privilege granted to the role
ADMIN_OPTION VARCHAR2 ( 3) Signifies the grant was with the ADMIN option
ROLE_TAB_PRIVS * Table privileges granted to roles
ROLE VARCHAR2 ( 30) Name of the role
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
COLUMN_NAME VARCHAR2 ( 30) Name of the column, if applicable
PRIVILEGE VARCHAR2 ( 30) Object privilege granted to the role
GRANTABLE VARCHAR2 ( 3) YES if the role was granted with ADMIN OPTION, otherwise NO
SESSION_PRIVS * Privileges which the user currently has set
PRIVILEGE VARCHAR2 ( 40) Name of the privilege
SESSION_ROLES * Roles which the user currently has enabled
ROLE VARCHAR2 ( 30) Name of the role
TABLE_PRIVILEGES Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
OWNER VARCHAR2 ( 30) Username of the object's owner
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
SELECT_PRIV VARCHAR2 ( 1) Permission to select from the object
INSERT_PRIV VARCHAR2 ( 1) Permission to insert into the column
DELETE_PRIV VARCHAR2 ( 1) Permission to update the object
UPDATE_PRIV VARCHAR2 ( 1) Permission to update the column
REFERENCES_PRIV VARCHAR2 ( 1) Permission to reference the column
ALTER_PRIV VARCHAR2 ( 1) Permission to alter the object
INDEX_PRIV VARCHAR2 ( 1) Permission to create or drop an index on the object
CREATED DATE Timestamp for the grant
USER_AUDIT_OBJECT * Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
The structure of the system table user_audit_object and the meaning of its columns correspond to those of the system table DBA_audit_object.
USER_AUDIT_SESSION * All audit trail entries concerning connect and disconnect
The structure of the system table user_audit_session and the meaning of its columns correspond to those of the system table DBA_audit_session.
USER_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
The structure of the system table user_audit_statement and the meaning of its columns correspond to those of the system table DBA_audit_statement.
USER_AUDIT_TRAIL * Audit trail entries relevant to the user
The structure of the system table user_audit_trail and the meaning of its columns correspond to those of the system table DBA_audit_trail.
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user
The structure of the system table user_catalog and the meaning of its columns correspond to those of the system table ALL_catalog. In contrast to all_catalog, user_catalog does not contain the column OWNER.
USER_CLUSTERS * Descriptions of user's own clusters
The structure of the system table user_clusters and the meaning of its columns correspond to those of the system table DBA_clusters. In contrast to DBA_clusters, user_clusters does not contain the column OWNER.
USER_CLU_COLUMNS * Mapping of table columns to cluster columns
The structure of the system table user_clu_columns and the meaning of its columns correspond to those of the system table DBA_clu_columns. In contrast to DBA_clu_columns, user_clu_columns does not contain the column owner.
USER_COL_COMMENTS Comments on columns of user's tables and views
The structure of the system table user_col_comments and the meaning of its columns correspond to those of the system table all_col_comments. In contrast to all_col_comments, user_col_comments does not contain the column OWNer.
USER_COL_PRIVS Grants on columns for which the user is the owner, grantor or grantee
The structure of the system table user_col_privs and the meaning of its columns correspond to those of the system table DBA_col_privs.
USER_COL_PRIVS_MADE All grants on columns of objects owned by the user
The structure of the system table user_col_privs_made and the meaning of its columns correspond to those of the system table all_col_privs_made. In contrast to all_col_privs_made, user_col_privs_made does not contain the column owner.
USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee
The structure of the system table user_col_privs_recd and the meaning of its columns correspond to those of the system table all_col_privs_recd. In contrast to All-col_privs_recd, user_col_privs_recd does not contain the column grantee.
USER_CONSTRAINTS Constraint definitions on user's own tables
The structure of the system table user_constraints and the meaning of its columns correspond to those of the system table all_constraints.
USER_CONS_COLUMNS Information about accessible columns in constraint definitions
The structure of the system table user_cons_columns and the meaning of its columns correspond to those of the system table all_cons_columns.
USER_DB_LINKS * Database links owned by the user
The structure of the system table user_db_links and the meaning of its columns correspond to those of the system table DBA_db_links.
USER_DEPENDENCIES Dependencies to and from a users objects
The structure of the system table user_dependencies and the meaning of its columns correspond to those of the system table all_dependencies. In contrast to all_dependencies, user_dependencies does not contain the column owner.
USER_ERRORS * Current errors on stored objects owned by the user
The structure of the system table user_errors and the meaning of its columns correspond to those of the system table all_errors. In contrast to all_errors, user_errors does not contain the column owner.
USER_EXTENTS * Extents comprising segments owned by the user
SEGMENT_NAME VARCHAR2 ( 81) Name of the segment associated with the extent
SEGMENT_TYPE VARCHAR2 ( 17) Type of the segment
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the extent
EXTENT_ID NUMBER Extent number in the segment
BYTES NUMBER Size of the extent in bytes
BLOCKS NUMBER Size of the extent in ORACLE blocks
USER_FREE_SPACE * Free extents in tablespaces accessible to the user
TABLESPACE_NAME VARCHAR2 ( 30) Name of the tablespace containing the extent
FILE_ID NUMBER ID number of the file containing the extent
BLOCK_ID NUMBER Starting block number of the extent
BYTES NUMBER Size of the extent in bytes
BLOCKS NUMBER Size of the extent in ORACLE blocks
USER_INDEXES Description of the user's own indexes
The structure of the system table user_indexes and the meaning of its columns correspond to those of the system table all_indexes. In contrast to ALL_INDEXES, USER_INDEXES does not contain the column OWNER.
USER_IND_COLUMNS COLUMNs comprising user's INDEXes or on user's TABLES
The structure of the system table user_ind_columns and the meaning of its columns correspond to those of the system table all_ind_columns. In contrast to all_ind_columns, user_ind_columns does not contain the column index_owner.
USER_OBJECTS Objects owned by the user
The structure of the system table user_objects and the meaning of its columns correspond to those of the system table all_objects. In contrast to all_objects, user_objects does not contain the column owner.
USER_OBJECT_SIZE * Sizes, in bytes, of various pl/sql objects
The structure of the system table user_objects_size and the meaning of its columns correspond to those of the system table DBA_objects_size. In contrast to DBA_object_size, user_object_size does not contain the column owner.
USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views
The structure of the system table user_obj_audit_opts and the meaning of its columns correspond to those of the system table DBA_Obj_audit_opts. In contrast to DBA_obj_audit_opts, user_obj_audit_opts does not contain the column owner.
USER_RESOURCE_LIMITS * Display resource limit of the user
RESOURCE_NAME VARCHAR2 ( 32) Resource name
LIMIT VARCHAR2 ( 40) Limit placed on this resource
USER_ROLE_PRIVS * Roles granted to current user
USERNAME VARCHAR2 ( 30) User Name or PUBLIC
GRANTED_ROLE VARCHAR2 ( 30) Granted role name
ADMIN_OPTION VARCHAR2 ( 3) Grant was with the ADMIN option
DEFAULT_ROLE VARCHAR2 ( 3) Role is designated as a DEFAULT ROLE for the user
OS_GRANTED VARCHAR2 ( 3) Role is granted via the operating system (using OS_ROLES = TRUE)
USER_SEGMENTS Storage allocated for all database segments
The structure of the system table user_segments and the meaning of its columns correspond to those of the system table DBA_segments. In contrast to DBA_segments, user_segments does not contain the columns owner, header_file and header_block.
USER_SEQUENCES Description of the user's own SEQUENCEs
The structure of the system table user_sequences and the meaning of its columns correspond to those of the system table all_sequences. In contrast to all_sequences, user_sequences does not contain the column owner.
USER_SNAPSHOTS Snapshots the user can look at
The structure of the system table user_snapshots and the meaning of its columns correspond to those of the system table all_snapshots.
USER_SNAPSHOT_LOGS All snapshot logs owned by the user
The structure of the system table user_snapshot_logs and the meaning of its columns correspond to those of the system table DBA_snapshot_logs.
USER_SOURCE * Source of stored objects accessible to the user
The structure of the system table user_source and the meaning of its columns correspond to those of the system table all_source. In contrast to all_source, user_source does not contain the column owner.
USER_SYNONYMS The user's private synonyms
The structure of the system table user_synonyms and the meaning of its columns correspond to those of the system table all_synonyms. In contrast to all_synonyms, user_synonyms does not contain the column owner.
USER_SYS_PRIVS * System privileges granted to current user
USERNAME VARCHAR2 ( 30) User Name or PUBLIC
PRIVILEGE VARCHAR2 ( 40) System privilege
ADMIN_OPTION VARCHAR2 ( 3) Grant was with the ADMIN option
USER_TABLES Description of the user's own tables
The structure of the system table user_tables and the meaning of its columns correspond to those of the system table all_tables. In contrast to all_tables, user_tables does not contain the column owner.
USER_TABLESPACES * Description of accessible tablespaces
The structure of the system table user_tablespaces and the meaning of its columns correspond to those of the system table DBA_tablespaces.
USER_TAB_COLUMNS Columns of user's tables, views and clusters
The structure of the system table user_tab_columns and the meaning of its columns correspond to those of the system table all_tab_columns. In contrast to all_tab_columns, user_tab_columns does not contain the column owner.
USER_TAB_COMMENTS Comments on the tables and views owned by the user
The structure of the system table user_tab_comments and the meaning of its columns correspond to those of the system table all_tab_comments. In contrast to all_tab_comments, user_tab_comments does not contain the column owner.
USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee
The structure of the system table user_tab_privs and the meaning of its columns correspond to those of the system table DBA_tab_privs.
USER_TAB_PRIVS_MADE All grants on objects owned by the user
GRANTEE VARCHAR2 ( 30) Name of the user to whom access was granted
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
OWNER VARCHAR2 ( 30) Owner of the object
TABLE_NAME VARCHAR2 ( 30) Name of the object
GRANTOR VARCHAR2 ( 30) Name of the user who performed the grant
PRIVILEGE VARCHAR2 ( 30) Table Privilege
GRANTABLE VARCHAR2 ( 3) Privilege is grantable
USER_TRIGGERS Triggers owned by the user
The structure of the system table user_triggers and the meaning of its columns correspond to those of the system table all_triggers. In contrast to all_triggers, user_triggers does not contain the column owner.
USER_TRIGGER_COLS * Column usage in user's triggers
The structure of the system table user_trigger_cols and the meaning of its columns correspond to those of the system table all_trigger_cols.
USER_TS_QUOTAS * Tablespace quotas for the user
The structure of the system table user_ts_quotas and the meaning of its columns correspond to those of the system table DBA_ts_quotas. In contrast to DBA_ts_quotas, user_ts_quotas does not contain the column username.
USER_USERS Information about the current user
The structure of the system table user_users and the meaning of its columns correspond to those of the system table DBA_users. In contrast to DBA_users, user_users does not contain the columns Password and profile.
USER_VIEWS Text of views owned by the user
VIEW_NAME VARCHAR2 ( 30) Name of the view
TEXT_LENGTH NUMBER Length of the view text
TEXT LONG View text