Table Name
| Description
|
DBA_2PC_NEIGHBORS
| information about incoming and outgoing connections for pending transactions
|
DBA_2PC_PENDING
| info about distributed transactions awaiting recovery
|
DBA_ALL_TABLES
| Description of all object and relational tables in the database
|
DBA_ANALYZE_OBJECTS
|
|
DBA_APPLICATION_ROLES
|
|
DBA_APPLY
| Details about the apply process
|
DBA_APPLY_CONFLICT_COLUMNS
| Details about conflict resolution
|
DBA_APPLY_DML_HANDLERS
| Details about the dml handler
|
DBA_APPLY_ERROR
| Error transactions
|
DBA_APPLY_INSTANTIATED_OBJECTS
| Details about objects instantiated
|
DBA_APPLY_KEY_COLUMNS
| alternative key columns for a table for STREAMS
|
DBA_APPLY_PARAMETERS
| All parameters for apply process
|
DBA_APPLY_PROGRESS
| Information about the progress made by apply process
|
DBA_AQ_AGENTS
|
|
DBA_AQ_AGENT_PRIVS
|
|
DBA_ASSOCIATIONS
| All associations
|
DBA_ATTRIBUTE_TRANSFORMATIONS
|
|
DBA_AUDIT_EXISTS
| Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
|
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
|
DBA_AUDIT_POLICIES
| All fine grained auditing policies in the database
|
DBA_AUDIT_SESSION
| All audit trail records concerning CONNECT and DISCONNECT
|
DBA_AUDIT_STATEMENT
| Audit trail records concerning grant, revoke, audit, noaudit and alter system
|
DBA_AUDIT_TRAIL
| All audit trail entries
|
DBA_AWS
| Analytic Workspaces in the database
|
DBA_AW_PS
| Pagespaces in Analytic Workspaces owned by the user
|
DBA_BASE_TABLE_MVIEWS
| All materialized views with log(s) in the database
|
DBA_BLOCKERS
|
|
DBA_CACHEABLE_NONTABLE_OBJECTS
|
|
DBA_CACHEABLE_OBJECTS
|
|
DBA_CACHEABLE_OBJECTS_BASE
|
|
DBA_CACHEABLE_TABLES
|
|
DBA_CACHEABLE_TABLES_BASE
|
|
DBA_CAPTURE
| Details about the capture process
|
DBA_CAPTURE_PARAMETERS
| All parameters for capture process
|
DBA_CAPTURE_PREPARED_DATABASE
| Is the local database prepared for instantiation?
|
DBA_CAPTURE_PREPARED_SCHEMAS
| All schemas at the local database that are prepared for instantiation
|
DBA_CAPTURE_PREPARED_TABLES
| All tables prepared for instantiation
|
DBA_CATALOG
| All database Tables, Views, Synonyms, Sequences
|
DBA_CLUSTERS
| Description of all clusters in the database
|
DBA_CLUSTER_HASH_EXPRESSIONS
| Hash functions for all clusters
|
DBA_CLU_COLUMNS
| Mapping of table columns to cluster columns
|
DBA_COLL_TYPES
| Description of all named collection types in the database
|
DBA_COL_COMMENTS
| Comments on columns of all tables and views
|
DBA_COL_PRIVS
| All grants on columns in the database
|
DBA_CONSTRAINTS
| Constraint definitions on all tables
|
DBA_CONS_COLUMNS
| Information about accessible columns in constraint definitions
|
DBA_CONS_OBJ_COLUMNS
| List of types an object column or attribute is constrained to in all tables in the database
|
DBA_CONTEXT
| Description of all context namespace information
|
DBA_DATA_FILES
| Information about database data files
|
DBA_DB_LINKS
| All database links in the database
|
DBA_DDL_LOCKS
|
|
DBA_DEPENDENCIES
| Dependencies to and from objects
|
DBA_DIMENSIONS
| Description of the dimension objects accessible to the DBA
|
DBA_DIM_ATTRIBUTES
| Representation of the relationship between a dimension level and a functionally dependent column
|
DBA_DIM_CHILD_OF
| Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
|
DBA_DIM_HIERARCHIES
| Representation of a dimension hierarchy
|
DBA_DIM_JOIN_KEY
| Representation of a join between two dimension tables.
|
DBA_DIM_LEVELS
| Description of dimension levels visible to DBA
|
DBA_DIM_LEVEL_KEY
| Representations of columns of a dimension level
|
DBA_DIRECTORIES
| Description of all directories
|
DBA_DML_LOCKS
|
|
DBA_DMT_FREE_SPACE
| Free extents in all dictionary managed tablespaces
|
DBA_DMT_USED_EXTENTS
| All extents in the dictionary managed tablespaces
|
DBA_ERRORS
| Current errors on all stored objects in the database
|
DBA_EVALUATION_CONTEXTS
| rule evaluation contexts in the database
|
DBA_EVALUATION_CONTEXT_TABLES
| tables in all rule evaluation contexts in the database
|
DBA_EVALUATION_CONTEXT_VARS
| variables in all rule evaluation contexts in the database
|
DBA_EXP_FILES
| Description of export files
|
DBA_EXP_OBJECTS
| Objects that have been incrementally exported
|
DBA_EXP_VERSION
| Version number of the last export session
|
DBA_EXTENTS
| Extents comprising all segments in the database
|
DBA_EXTERNAL_LOCATIONS
| Description of the external tables locations accessible to the DBA
|
DBA_EXTERNAL_TABLES
| Description of the external tables accessible to the DBA
|
DBA_FGA_AUDIT_TRAIL
| All fine grained audit event logs
|
DBA_FREE_SPACE
| Free extents in all tablespaces
|
DBA_FREE_SPACE_COALESCED
| Statistics on Coalesced Space in Tablespaces
|
DBA_FREE_SPACE_COALESCED_TMP1
|
|
DBA_FREE_SPACE_COALESCED_TMP2
|
|
DBA_FREE_SPACE_COALESCED_TMP3
|
|
DBA_GLOBAL_CONTEXT
| Description of all context information accessible globally
|
DBA_HISTOGRAMS
| Synonym for DBA_TAB_HISTOGRAMS
|
DBA_IAS_CONSTRAINT_EXP
|
|
DBA_IAS_GEN_STMTS
|
|
DBA_IAS_GEN_STMTS_EXP
|
|
DBA_IAS_OBJECTS
|
|
DBA_IAS_OBJECTS_BASE
|
|
DBA_IAS_OBJECTS_EXP
|
|
DBA_IAS_POSTGEN_STMTS
|
|
DBA_IAS_PREGEN_STMTS
|
|
DBA_IAS_SITES
|
|
DBA_IAS_TEMPLATES
|
|
DBA_INDEXES
| Description for all indexes in the database
|
DBA_INDEXTYPES
| All indextypes
|
DBA_INDEXTYPE_COMMENTS
| Comments for user-defined indextypes
|
DBA_INDEXTYPE_OPERATORS
| All indextype operators
|
DBA_IND_COLUMNS
| COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
|
DBA_IND_EXPRESSIONS
| FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
|
DBA_IND_PARTITIONS
|
|
DBA_IND_SUBPARTITIONS
|
|
DBA_INTERNAL_TRIGGERS
| Description of the internal triggers on all tables in the database
|
DBA_JAVA_ARGUMENTS
| argument information of all stored java class
|
DBA_JAVA_CLASSES
| class level information of all stored java classes
|
DBA_JAVA_DERIVATIONS
| this view maps java source objects and their derived java class objects and java resource objects for all java classes
|
DBA_JAVA_FIELDS
| field information of all stored java class
|
DBA_JAVA_IMPLEMENTS
| interfaces implemented by the stored java class
|
DBA_JAVA_INNERS
| list of inner classes refered by the stored java class
|
DBA_JAVA_LAYOUTS
| class layout information about stored java class
|
DBA_JAVA_METHODS
| method information of all stored java class
|
DBA_JAVA_NCOMPS
|
|
DBA_JAVA_POLICY
| java security Permissions for all users
|
DBA_JAVA_RESOLVERS
| resolver of java class owned by user
|
DBA_JAVA_THROWS
| list of exceptions thrown from a method of a class owned by user
|
DBA_JOBS
| All jobs in the database
|
DBA_JOBS_RUNNING
| All jobs in the database which are currently running, join v$lock and job$
|
DBA_JOIN_IND_COLUMNS
| Join Index columns comprising the join conditions
|
DBA_KGLLOCK
|
|
DBA_LIBRARIES
| Description of all libraries in the database
|
DBA_LMT_FREE_SPACE
| Free extents in all locally managed tablespaces
|
DBA_LMT_USED_EXTENTS
| All extents in the locally managed tablespaces
|
DBA_LOBS
| Description of LOBs contained in all tables
|
DBA_LOB_PARTITIONS
|
|
DBA_LOB_SUBPARTITIONS
|
|
DBA_LOB_TEMPLATES
|
|
DBA_LOCK
|
|
DBA_LOCKS
| Synonym for DBA_LOCK
|
DBA_LOCK_INTERNAL
|
|
DBA_LOGSTDBY_EVENTS
| Information on why logical standby events
|
DBA_LOGSTDBY_LOG
| List the information about received logs from the primary
|
DBA_LOGSTDBY_NOT_UNIQUE
| List of all the tables with out primary or unique key not null constraints
|
DBA_LOGSTDBY_PARAMETERS
| Miscellaneous options and settings for Logical Standby
|
DBA_LOGSTDBY_PROGRESS
| List the SCN values describing read and apply progress
|
DBA_LOGSTDBY_SKIP
| List the skip settings choosen
|
DBA_LOGSTDBY_SKIP_TRANSACTION
| List the transactions to be skipped
|
DBA_LOGSTDBY_UNSUPPORTED
| List of all the columns that are not supported by Logical Standby
|
DBA_LOG_GROUPS
| Log group definitions on all tables
|
DBA_LOG_GROUP_COLUMNS
| Information about columns in log group definitions
|
DBA_METHOD_PARAMS
| Description of method parameters of all types in the database
|
DBA_METHOD_RESULTS
| Description of method results of all types in the database
|
DBA_MVIEWS
| All materialized views in the database
|
DBA_MVIEW_AGGREGATES
| Description of the materialized view aggregates accessible to dba
|
DBA_MVIEW_ANALYSIS
| Description of the materialized views accessible to dba
|
DBA_MVIEW_DETAIL_RELATIONS
| Description of the materialized view detail tables accessible to dba
|
DBA_MVIEW_JOINS
| Description of a join between two columns in the WHERE clause of a materialized view accessible to dba
|
DBA_MVIEW_KEYS
| Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba
|
DBA_MVIEW_LOGS
| All materialized view logs in the database
|
DBA_MVIEW_LOG_FILTER_COLS
| All filter columns (excluding PK cols) being logged in the materialized view logs
|
DBA_MVIEW_REFRESH_TIMES
| All fast refreshable materialized views and their last refresh times for each master table
|
DBA_NESTED_TABLES
| Description of nested tables contained in all tables
|
DBA_OBJECTS
| All objects in the database
|
DBA_OBJECT_SIZE
| Sizes, in bytes, of various pl/sql objects
|
DBA_OBJECT_TABLES
| Description of all object tables in the database
|
DBA_OBJ_AUDIT_OPTS
| Auditing options for all tables and views
|
DBA_OBJ_COLATTRS
| Description of object columns and attributes contained in all tables in the database
|
DBA_OPANCILLARY
| All ancillary operators
|
DBA_OPARGUMENTS
| All operator arguments
|
DBA_OPBINDINGS
| All operator binding functiosn or methods
|
DBA_OPERATORS
| All operators
|
DBA_OPERATOR_COMMENTS
| Comments for user-defined operators
|
DBA_OUTLINES
| Stored outlines
|
DBA_OUTLINE_HINTS
| Hints stored in outlines
|
DBA_PARTIAL_DROP_TABS
| All tables with partially dropped columns in the database
|
DBA_PART_COL_STATISTICS
|
|
DBA_PART_HISTOGRAMS
|
|
DBA_PART_INDEXES
|
|
DBA_PART_KEY_COLUMNS
|
|
DBA_PART_LOBS
|
|
DBA_PART_TABLES
|
|
DBA_PENDING_CONV_TABLES
| All tables which are not upgraded to the latest type version in the database
|
DBA_PENDING_TRANSACTIONS
| information about unresolved global transactions
|
DBA_POLICIES
| All row level security policies in the database
|
DBA_POLICY_CONTEXTS
| All policy driving context defined for any synonym, table, or view in the database
|
DBA_POLICY_GROUPS
| All policy groups defined for any synonym, table, view in the database
|
DBA_PRIV_AUDIT_OPTS
| Describes current system privileges being audited across the system and by user
|
DBA_PROCEDURES
| Description of all procedures
|
DBA_PROFILES
| Display all profiles and their limits
|
DBA_PROPAGATION
| Streams propagation in the database
|
DBA_PROXIES
| Information about all proxy connections
|
DBA_PUBLISHED_COLUMNS
|
|
DBA_QUEUES
| All database queues
|
DBA_QUEUE_PUBLISHERS
|
|
DBA_QUEUE_SCHEDULES
|
|
DBA_QUEUE_TABLES
| All queue tables created in the database
|
DBA_RCHILD
| All the children in any refresh group. This view is not a join.
|
DBA_REFRESH
| All the refresh groups
|
DBA_REFRESH_CHILDREN
| All the objects in refresh groups
|
DBA_REFS
| Description of REF columns contained in all tables
|
DBA_REGISTERED_MVIEWS
| Remote materialized views of local tables
|
DBA_REGISTERED_MVIEW_GROUPS
| Materialized view repgroup registration information
|
DBA_REGISTERED_SNAPSHOTS
| Remote snapshots of local tables
|
DBA_REGISTERED_SNAPSHOT_GROUPS
| Snapshot repgroup registration information
|
DBA_REGISTRY
|
|
DBA_REGISTRY_HIERARCHY
|
|
DBA_REPAUDIT_ATTRIBUTE
| Information about attributes automatically maintained for replication
|
DBA_REPAUDIT_COLUMN
| Information about columns in all shadow tables for all replicated tables in the database
|
DBA_REPCAT
|
|
DBA_REPCATLOG
| Information about asynchronous administration requests
|
DBA_REPCAT_EXCEPTIONS
| Repcat processing exceptions table.
|
DBA_REPCAT_REFRESH_TEMPLATES
|
|
DBA_REPCAT_TEMPLATE_OBJECTS
|
|
DBA_REPCAT_TEMPLATE_PARMS
|
|
DBA_REPCAT_TEMPLATE_SITES
|
|
DBA_REPCAT_USER_AUTHORIZATIONS
|
|
DBA_REPCAT_USER_PARM_VALUES
|
|
DBA_REPCOLUMN
| Replicated top-level columns (table) sorted alphabetically in ascending order
|
DBA_REPCOLUMN_GROUP
| All column groups of replicated tables in the database
|
DBA_REPCONFLICT
| All conflicts for which users have specified resolutions in the database
|
DBA_REPDDL
| Arguments that do not fit in a single repcat log record
|
DBA_REPEXTENSIONS
| Information about replication extension requests
|
DBA_REPFLAVORS
| Flavors defined for replicated object groups
|
DBA_REPFLAVOR_COLUMNS
| Replicated columns in flavors
|
DBA_REPFLAVOR_OBJECTS
| Replicated objects in flavors
|
DBA_REPGENERATED
| Objects generated to support replication
|
DBA_REPGENOBJECTS
| Objects generated to support replication
|
DBA_REPGROUP
| Information about all replicated object groups
|
DBA_REPGROUPED_COLUMN
| Columns in the all column groups of replicated tables in the database
|
DBA_REPGROUP_PRIVILEGES
| Information about users who are registered for object group privileges
|
DBA_REPKEY_COLUMNS
| Primary columns for a table using column-level replication
|
DBA_REPOBJECT
| Information about replicated objects
|
DBA_REPPARAMETER_COLUMN
| All columns used for resolving conflicts in the database
|
DBA_REPPRIORITY
| Values and their corresponding priorities in all priority groups in the database
|
DBA_REPPRIORITY_GROUP
| Information about all priority groups in the database
|
DBA_REPPROP
| Propagation information about replicated objects
|
DBA_REPRESOLUTION
| Description of all conflict resolutions in the database
|
DBA_REPRESOLUTION_METHOD
| All conflict resolution methods in the database
|
DBA_REPRESOLUTION_STATISTICS
| Statistics for conflict resolutions for all replicated tables in the database
|
DBA_REPRESOL_STATS_CONTROL
| Information about statistics collection for conflict resolutions for all replicated tables in the database
|
DBA_REPSCHEMA
| N-way replication information
|
DBA_REPSITES
| N-way replication information
|
DBA_REPSITES_NEW
| Information about new masters for replication extension
|
DBA_RESUMABLE
| Resumable session information in the system
|
DBA_RGROUP
| All refresh groups. This view is not a join.
|
DBA_ROLES
| All Roles which exist in the database
|
DBA_ROLE_PRIVS
| Roles granted to users and roles
|
DBA_ROLLBACK_SEGS
| Description of rollback segments
|
DBA_RSRC_CONSUMER_GROUPS
| all the resource consumer groups
|
DBA_RSRC_CONSUMER_GROUP_PRIVS
| Switch privileges for consumer groups
|
DBA_RSRC_MANAGER_SYSTEM_PRIVS
| system privileges for the resource manager
|
DBA_RSRC_PLANS
| All the resource plans
|
DBA_RSRC_PLAN_DIRECTIVES
| all the resource plan directives
|
DBA_RULES
| Rules in the databse
|
DBA_RULESETS
| Rulesets in the database: maintained for backward compatibility
|
DBA_RULE_SETS
| Rule sets in the database
|
DBA_RULE_SET_RULES
| Rules in all rule sets in the database
|
DBA_SECONDARY_OBJECTS
| All secondary objects for domain indexes
|
DBA_SEGMENTS
| Storage allocated for all database segments
|
DBA_SEQUENCES
| Description of all SEQUENCEs in the database
|
DBA_SNAPSHOTS
| All snapshots in the database
|
DBA_SNAPSHOT_LOGS
| All snapshot logs in the database
|
DBA_SNAPSHOT_LOG_FILTER_COLS
| Synonym for DBA_MVIEW_LOG_FILTER_COLS
|
DBA_SNAPSHOT_REFRESH_TIMES
| Synonym for DBA_MVIEW_REFRESH_TIMES
|
DBA_SOURCE
| Source of all stored objects in the database
|
DBA_SOURCE_TABLES
|
|
DBA_SOURCE_TAB_COLUMNS
|
|
DBA_SQLJ_TYPES
| Description of all types in the database
|
DBA_SQLJ_TYPE_ATTRS
| Description of attributes of all types in the database
|
DBA_SQLJ_TYPE_METHODS
| Description of methods of all types in the database
|
DBA_STMT_AUDIT_OPTS
| Describes current system auditing options across the system and by user
|
DBA_STORED_SETTINGS
| Parameter settings for all objects
|
DBA_STREAMS_GLOBAL_RULES
| Global rules created by streams administrative APIs
|
DBA_STREAMS_SCHEMA_RULES
| Schema rules created by streams administrative APIs
|
DBA_STREAMS_TABLE_RULES
| Table rules created by streams administrative APIs
|
DBA_SUBPARTITION_TEMPLATES
|
|
DBA_SUBPART_COL_STATISTICS
|
|
DBA_SUBPART_HISTOGRAMS
|
|
DBA_SUBPART_KEY_COLUMNS
|
|
DBA_SUBSCRIBED_COLUMNS
|
|
DBA_SUBSCRIBED_TABLES
|
|
DBA_SUBSCRIPTIONS
|
|
DBA_SUMMARIES
| Description of the summaries accessible to dba
|
DBA_SUMMARY_AGGREGATES
|
|
DBA_SUMMARY_DETAIL_TABLES
|
|
DBA_SUMMARY_JOINS
|
|
DBA_SUMMARY_KEYS
|
|
DBA_SYNONYMS
| All synonyms in the database
|
DBA_SYS_PRIVS
| System privileges granted to users and roles
|
DBA_TABLES
| Description of all relational tables in the database
|
DBA_TABLESPACES
| Description of all tablespaces
|
DBA_TAB_COLS
| Columns of user's tables, views and clusters
|
DBA_TAB_COLUMNS
| Columns of user's tables, views and clusters
|
DBA_TAB_COL_STATISTICS
| Columns of user's tables, views and clusters
|
DBA_TAB_COMMENTS
| Comments on all tables and views in the database
|
DBA_TAB_HISTOGRAMS
| Histograms on columns of all tables
|
DBA_TAB_MODIFICATIONS
| Information regarding modifications to tables
|
DBA_TAB_PARTITIONS
|
|
DBA_TAB_PRIVS
| All grants on objects in the database
|
DBA_TAB_SUBPARTITIONS
|
|
DBA_TEMPLATE_REFGROUPS
| Table for maintaining refresh group information for template.
|
DBA_TEMPLATE_TARGETS
| Internal table for tracking potential target databases for templates.
|
DBA_TEMP_FILES
| Information about database temp files
|
DBA_TRANSFORMATIONS
|
|
DBA_TRIGGERS
| All triggers in the database
|
DBA_TRIGGER_COLS
| Column usage in all triggers
|
DBA_TS_QUOTAS
| Tablespace quotas for all users
|
DBA_TYPES
| Description of all types in the database
|
DBA_TYPE_ATTRS
| Description of attributes of all types in the database
|
DBA_TYPE_METHODS
| Description of methods of all types in the database
|
DBA_TYPE_VERSIONS
| Description of each type version in the database
|
DBA_UNDO_EXTENTS
| Extents comprising all segments in the system managed undo tablespaces
|
DBA_UNUSED_COL_TABS
| All tables with unused columns in the database
|
DBA_UPDATABLE_COLUMNS
| Description of dba updatable columns
|
DBA_USERS
| Information about all users of the database
|
DBA_USTATS
| All statistics collected on either tables or indexes
|
DBA_VARRAYS
| Description of varrays in tables accessible to the user
|
DBA_VIEWS
| Description of all views in the database
|
DBA_WAITERS
|
|
DBA_WORKSPACES
|
|
DBA_WORKSPACE_SESSIONS
|
|