Search notes:

Oracle Data Dictionary

The data dictionary stores and provides information about database objects. This information is stored in a set of dictionary base tables (whose names seem to end in a dollar, for example OBJ$).
The data dictionary is not supposed to be changed by a user. Rather, the data in the data dictionary is updated by Oracle when a DDL statement completes.
The data in the base tables is not always stored in a user friendly way and Oracle provides a set of views that are supposed to make data dictionary querying easier.
Each of these views comes in up to four variants that have one of the prefixes USER_, ALL_, DBA_ and/or CDB_:
Prefix
USER_ Only shows objects that are owned by the user that selects from that view. Thus, these views don't have an OWNER column.
ALL_ Shows objects on which the querying user has been granted privileges
DBA_ All objects, sometimes with addtional columns that are interesting for DBAs.
CDB_ Used in the root of a PDB to select information about all objects in the root and PDBs (thus it includes a CON_ID column). In a PDB, the CDB_* views show the objects that are visible throght the corresponding DBA_* views.
The data dictionary cache is the portion of the memory in which the data of the data dictionary is stored that is currently processed or cached.
SMON cleans up the data dictionary when it is in a transient and inconsistent state.

Installation

Oracle's data dictionary is created by $ORACLE_HOME/rdbms/admin/catalog.sql and stored in the SYSTEM tablespace which is always online when a database is open.
PL/SQL related views are created with $ORACLE_HOME/rdbms/admin/catproc.sql
dba_registry (which itself is part of the datadictionary…) can be queried to assert that the data dictionary was installed and its status is valid: 
select
   comp_id,
   status,
   version,
   comp_name
from
   dba_registry
where
   comp_id in ('CATALOG', 'CATPROC');

Views of the data dictionary

Views that expose the data of the data dictionary are:
- - DBA CDB 2PC_NEIGHBORS information about incoming and outgoing connections for pending transactions
- - DBA CDB 2PC_PENDING info about distributed transactions awaiting recovery
- - DBA CDB ACL_NAME_MAP New names of the access control lists for PL/SQL network utility packages from old XDB names
USER - DBA CDB ADDM_FDG_BREAKDOWN
USER - DBA CDB ADDM_FINDINGS
USER - DBA CDB ADDM_INSTANCES
- - DBA CDB ADDM_SYSTEM_DIRECTIVES
USER - DBA CDB ADDM_TASKS
USER - DBA CDB ADDM_TASK_DIRECTIVES
USER - DBA CDB ADVISOR_ACTIONS
- - DBA CDB ADVISOR_COMMANDS
- - DBA CDB ADVISOR_DEFINITIONS
- - DBA CDB ADVISOR_DEF_PARAMETERS
- - DBA CDB ADVISOR_DIR_DEFINITIONS
- - DBA CDB ADVISOR_DIR_INSTANCES
USER - DBA CDB ADVISOR_DIR_TASK_INST
USER - DBA CDB ADVISOR_EXECUTIONS
- - DBA CDB ADVISOR_EXECUTION_TYPES
USER - DBA CDB ADVISOR_EXEC_PARAMETERS
USER - DBA CDB ADVISOR_FDG_BREAKDOWN
USER - DBA CDB ADVISOR_FINDINGS
- - DBA CDB ADVISOR_FINDING_NAMES
USER - DBA CDB ADVISOR_JOURNAL
USER - DBA CDB ADVISOR_LOG
USER - DBA CDB ADVISOR_OBJECTS
- - DBA CDB ADVISOR_OBJECT_TYPES
USER - DBA CDB ADVISOR_PARAMETERS
- - DBA CDB ADVISOR_PARAMETERS_PROJ
USER - DBA CDB ADVISOR_RATIONALE
USER - DBA CDB ADVISOR_RECOMMENDATIONS
USER - DBA CDB ADVISOR_SQLA_COLVOL
USER - DBA CDB ADVISOR_SQLA_REC_SUM
USER - DBA CDB ADVISOR_SQLA_TABLES
USER - DBA CDB ADVISOR_SQLA_TABVOL
USER - DBA CDB ADVISOR_SQLA_WK_MAP
USER - DBA CDB ADVISOR_SQLA_WK_STMTS
USER - DBA CDB ADVISOR_SQLA_WK_SUM
USER - DBA CDB ADVISOR_SQLPLANS
USER - DBA CDB ADVISOR_SQLSTATS
USER - DBA CDB ADVISOR_SQLW_COLVOL
USER - DBA CDB ADVISOR_SQLW_JOURNAL
USER - DBA CDB ADVISOR_SQLW_PARAMETERS
USER - DBA CDB ADVISOR_SQLW_STMTS
USER - DBA CDB ADVISOR_SQLW_SUM
USER - DBA CDB ADVISOR_SQLW_TABLES
USER - DBA CDB ADVISOR_SQLW_TABVOL
USER - DBA CDB ADVISOR_SQLW_TEMPLATES
USER - DBA CDB ADVISOR_TASKS
USER - DBA CDB ADVISOR_TEMPLATES
- - DBA CDB ADVISOR_USAGE
- - DBA CDB ALERT_ARGUMENTS Message Id and arguments of outstanding alerts
- - DBA CDB ALERT_HISTORY History of Alerts
- - DBA CDB ALERT_HISTORY_DETAIL Detailed alert history
USER ALL DBA CDB ALL_TABLES Description of all object and relational tables
USER ALL DBA CDB ANALYTIC_VIEWS Analytic views in the database
USER ALL DBA CDB ANALYTIC_VIEW_ATTR_CLASS analytic view attribute classifications in the database
USER ALL DBA CDB ANALYTIC_VIEW_BASE_MEAS Analytic view base measures in the database
USER ALL DBA CDB ANALYTIC_VIEW_CALC_MEAS Analytic view calculated measures in the database
USER ALL DBA CDB ANALYTIC_VIEW_CLASS Analytic view classifications in the database
USER ALL DBA CDB ANALYTIC_VIEW_COLUMNS Analytic view columns in the database
USER ALL DBA CDB ANALYTIC_VIEW_DIMENSIONS Analytic view Dimensions in the database
USER ALL DBA CDB ANALYTIC_VIEW_DIM_CLASS Classifications of the analytic view dimensions in the database
USER ALL DBA CDB ANALYTIC_VIEW_HIERS Analytic view hierarchies in the database
USER ALL DBA CDB ANALYTIC_VIEW_HIER_CLASS Analytic view hierarchy classifications in the database
USER ALL DBA CDB ANALYTIC_VIEW_KEYS Analytic view keys in the database
USER ALL DBA CDB ANALYTIC_VIEW_LEVELS Analytic view levels in the database
USER ALL DBA CDB ANALYTIC_VIEW_LEVEL_CLASS analytic view level classifications in the database
USER ALL DBA CDB ANALYTIC_VIEW_LVLGRPS Level groupings for an analytic view
USER ALL DBA CDB ANALYTIC_VIEW_MEAS_CLASS Analytic view measure classifications in the database
- - DBA CDB ANALYZE_OBJECTS
- - DBA CDB APPLICATIONS Describes all applications in the Application Container
USER - DBA CDB APPLICATION_ROLES
- ALL DBA CDB APPLY Details about each apply process that dequeues from the queue
- ALL DBA CDB APPLY_CHANGE_HANDLERS Details about apply change handler
- ALL DBA CDB APPLY_CONFLICT_COLUMNS Details about conflict resolution on tables
- ALL DBA CDB APPLY_DML_CONF_COLUMNS Details about dml conflict handler column groups on objects
- ALL DBA CDB APPLY_DML_CONF_HANDLERS Details about dml conflict handlers on objects
- ALL DBA CDB APPLY_DML_HANDLERS Details about the dml handler on tables
- ALL DBA CDB APPLY_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists
USER ALL DBA CDB APPLY_ERROR Error transactions that were generated after dequeuing from the queue
- ALL DBA CDB APPLY_ERROR_MESSAGES Details about individual messages in an error transaction
- ALL DBA CDB APPLY_EXECUTE Details about the apply execute action for rules
- ALL DBA CDB APPLY_HANDLE_COLLISIONS Details about apply collision handlers on objects
- ALL DBA CDB APPLY_INSTANTIATED_GLOBAL Details about instantiated database
- ALL DBA CDB APPLY_INSTANTIATED_OBJECTS Details about instantiated objects
- ALL DBA CDB APPLY_INSTANTIATED_SCHEMAS Details about instantiated schemas
- ALL DBA CDB APPLY_KEY_COLUMNS Alternative key columns for a STREAMS table
- ALL DBA CDB APPLY_PARAMETERS Details about parameters of each apply process that dequeues from queues
- ALL DBA CDB APPLY_PROGRESS Information about the progress made by the apply process that dequeues from queues
- ALL DBA CDB APPLY_REPERROR_HANDLERS Details about apply reperror handlers on objects
- ALL DBA CDB APPLY_SPILL_TXN Streams apply spilled transactions info
- ALL DBA CDB APPLY_TABLE_COLUMNS Details about the columns of destination table
- - DBA CDB APP_ERRORS Describes all application error messages in the Application Container
- - DBA CDB APP_PATCHES Describes all application patches in the Application Container
- - DBA CDB APP_PDB_STATUS Describes all applications in the Application Container
- - DBA CDB APP_STATEMENTS Describes all statements from all applications in the Application Container
- - DBA CDB APP_VERSIONS Describes all applications in the Application Container
- - DBA CDB AQ_AGENTS Registered AQ agents
USER - DBA CDB AQ_AGENT_PRIVS Registered AG agents and their mapping to database users.
USER ALL DBA CDB ARGUMENTS Arguments
USER ALL DBA CDB ASSEMBLIES Description of assemblies
USER ALL DBA CDB ASSOCIATIONS All associations
USER - - - ASTATUS_MAP
USER ALL DBA CDB ATTRIBUTE_DIMENSIONS Attribute dimensions in the database
USER ALL DBA CDB ATTRIBUTE_DIM_ATTRS Attribute dimension attributes in the database
USER ALL DBA CDB ATTRIBUTE_DIM_ATTR_CLASS Attribute dimension attribute classifications in the database
USER ALL DBA CDB ATTRIBUTE_DIM_CLASS Attribute dimension classifications in the database
USER ALL DBA CDB ATTRIBUTE_DIM_JOIN_PATHS Attribute dimension join paths in the database
USER ALL DBA CDB ATTRIBUTE_DIM_KEYS Attribute dimension keys in the database
USER ALL DBA CDB ATTRIBUTE_DIM_LEVELS Attribute dimension Levels in the database
USER ALL DBA CDB ATTRIBUTE_DIM_LEVEL_ATTRS Determined attributes of each level in the database
USER ALL DBA CDB ATTRIBUTE_DIM_LVL_CLASS Attribute dimension level classifications in the database
USER ALL DBA CDB ATTRIBUTE_DIM_ORDER_ATTRS Attribute dimension order by elements in the database
USER ALL DBA CDB ATTRIBUTE_DIM_TABLES Attribute dimension tables in the database
USER ALL DBA CDB ATTRIBUTE_TRANSFORMATIONS
- ALL - - AUDITED_SYSTEM_ACTIONS
- - DBA CDB AUDIT_EXISTS Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
- - DBA CDB AUDIT_MGMT_CLEANUP_JOBS The view displays the currently configured audit trail purge jobs
- - DBA CDB AUDIT_MGMT_CLEAN_EVENTS The history of cleanup events
- - DBA CDB AUDIT_MGMT_CONFIG_PARAMS The view displays the currently configured audit trail properties that are defined by the DBMS_AUDIT_MGMT PL/SQL package
- - DBA CDB AUDIT_MGMT_LAST_ARCH_TS The Last Archive Timestamps set for the Audit Trail Clean up
USER - DBA CDB 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
USER ALL DBA CDB AUDIT_POLICIES All fine grained auditing policies in the database
USER ALL DBA CDB AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
USER - DBA CDB AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
USER - DBA CDB AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER - DBA CDB AUDIT_TRAIL All audit trail entries
- - DBA CDB AUTOTASK_CLIENT Autotask Client Summary Information
- - DBA CDB AUTOTASK_CLIENT_HISTORY Automated Maintenance Jobs history
- - DBA CDB AUTOTASK_CLIENT_JOB Current automated maintenance jobs
- - DBA CDB AUTOTASK_JOB_HISTORY Automated Maintenance Jobs history
- - DBA CDB AUTOTASK_OPERATION Automated Maintenance Task Operation Configuration
- - DBA CDB AUTOTASK_SCHEDULE Schedule of Maintenance Windows for the next 32 days
- - DBA CDB AUTOTASK_STATUS Autotask Status Information
- - DBA CDB AUTOTASK_TASK Information about current and past autmated maintenance tasks
- - DBA CDB AUTOTASK_WINDOW_CLIENTS Description of per-mainteance window activity
- - DBA CDB AUTOTASK_WINDOW_HISTORY Automated Maintenance view of window history
- - DBA CDB AUTO_SEGADV_CTL
- - DBA CDB AUTO_SEGADV_SUMMARY
USER ALL DBA CDB AWS Analytic Workspaces
USER ALL DBA CDB AW_PS Pagespaces in Analytic Workspaces
USER ALL DBA CDB BASE_TABLE_MVIEWS All materialized views with log(s);
- - DBA CDB BLOCKERS
- ALL DBA CDB CAPTURE Details about each capture process that stores the captured changes in a queue
- ALL DBA CDB CAPTURE_EXTRA_ATTRIBUTES Extra attributes for a capture process
- ALL DBA CDB CAPTURE_PARAMETERS Details about parameters for each capture process that stores the captured changes in a queue
- ALL DBA CDB CAPTURE_PREPARED_DATABASE Is the local database prepared for instantiation?
- ALL DBA CDB CAPTURE_PREPARED_SCHEMAS Schemas at the local database that are prepared for instantiation
- ALL DBA CDB CAPTURE_PREPARED_TABLES All tables that are prepared for instantiation
USER ALL DBA CDB CATALOG All tables, views, synonyms, sequences
- - DBA CDB CDB_RSRC_PLANS All the consolidation resource plans
- - DBA CDB CDB_RSRC_PLAN_DIRECTIVES all the CDB resource plan directives
USER - DBA CDB CHANGE_NOTIFICATION_REGS Description of the registrations for change notification
- - DBA CDB CHECKED_ROLES
- - DBA CDB CHECKED_ROLES_PATH
USER ALL DBA CDB CLUSTERING_DIMENSIONS Dimension details about clustering tables
USER ALL DBA CDB CLUSTERING_JOINS Join details about clustering tables
USER ALL DBA CDB CLUSTERING_KEYS Description of the keys of the clustering clause of tables
USER ALL DBA CDB CLUSTERING_TABLES Description of the clustering clause of tables
USER ALL DBA CDB CLUSTERS Description of clusters
USER ALL DBA CDB CLUSTER_HASH_EXPRESSIONS Hash functions for all accessible clusters
USER - DBA CDB CLU_COLUMNS Mapping of table columns to cluster columns
USER ALL DBA CDB CODE_ROLE_PRIVS Roles attached to the program units
USER ALL DBA CDB COLL_TYPES Description of named collection types
USER ALL DBA CDB COL_COMMENTS Comments on columns of tables and views.
USER ALL DBA CDB COL_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER ALL DBA CDB COL_PRIVS Grants on columns.
USER ALL - - COL_PRIVS_MADE Grants on columns, grantor perspective
USER ALL - - COL_PRIVS_RECD Grants on columns, grantee perspective
- - DBA CDB COL_USAGE_STATISTICS Aggregation of statistics for every column, object, stat_type triplet value related to column usage across the on-disk entries and the in-memory entries.
- - DBA CDB COMMON_AUDIT_TRAIL Combined Standard and Fine Grained audit trail entries
USER - DBA CDB COMPARISON Details about the comparison object
USER - DBA CDB COMPARISON_COLUMNS Details about the comparison object's columns
USER - DBA CDB COMPARISON_ROW_DIF Details about the differing rows in a comparison scan
USER - DBA CDB COMPARISON_SCAN Details about a comparison scan
USER ALL DBA CDB COMPARISON_SCAN_SUMMARY Details about a comparison scan
USER - DBA CDB COMPARISON_SCAN_VALUES Details about a comparison scan's values
- - DBA CDB CONNECTION_TESTS Information about Draining rules
- - DBA CDB CONNECT_ROLE_GRANTEES Information regarding which users are granted CONNECT
USER ALL DBA CDB CONSTRAINTS Constraint definitions on accessible tables
USER ALL DBA CDB CONS_COLUMNS Lists the columns of a given constraint.
USER ALL DBA CDB CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables
- - DBA CDB CONTAINER_DATA Describes default and object-specific CONTAINER_DATA attributes
- ALL DBA CDB CONTEXT Description of all active context namespaces under the current session
- - DBA CDB CPOOL_INFO Connection pool info
- - DBA CDB CPU_USAGE_STATISTICS Database CPU Usage Statistics
USER - DBA CDB CQ_NOTIFICATION_QUERIES Description of registered queries for CQ notification
USER ALL DBA CDB CREDENTIALS See also dba_scheduler_credentials
USER ALL DBA CDB CUBES OLAP Cubes in the database
USER ALL DBA CDB CUBE_ATTRIBUTES OLAP Attributes in the database
USER ALL DBA CDB CUBE_ATTR_MAPPINGS OLAP Cube Attribute Mappings in the database
USER ALL DBA CDB CUBE_ATTR_UNIQUE_KEYS OLAP Unique Key Attributes in the database
USER ALL DBA CDB CUBE_ATTR_VISIBILITY OLAP Attributes visible for Dimensions, Hierarchies, and Levels
USER ALL DBA CDB CUBE_BUILD_PROCESSES OLAP Build Processes in the database
USER ALL DBA CDB CUBE_CALCULATED_MEMBERS OLAP Calculated Members in the database
USER ALL DBA CDB CUBE_CLASSIFICATIONS OLAP Object Classifications
USER ALL DBA CDB CUBE_DEPENDENCIES OLAP metadata dependencies in the database
USER ALL DBA CDB CUBE_DESCRIPTIONS OLAP Descriptions
USER ALL DBA CDB CUBE_DIMENSIONALITY OLAP Cube Dimensionality in the database
USER ALL DBA CDB CUBE_DIMENSIONS OLAP Cube Dimensions in the database
USER ALL DBA CDB CUBE_DIMNL_MAPPINGS OLAP Cube Dimenisonality Mappings
USER ALL DBA CDB CUBE_DIM_LEVELS OLAP Dimension Levels in the database
USER ALL DBA CDB CUBE_DIM_MAPPINGS OLAP Cube Dimension Mappings
USER ALL DBA CDB CUBE_DIM_MODELS OLAP Dimension Models in the database
USER ALL DBA CDB CUBE_DIM_VIEWS OLAP Dimension Views in the database
USER ALL DBA CDB CUBE_DIM_VIEW_COLUMNS OLAP Dimension View Columns in the database
USER ALL DBA CDB CUBE_HIERARCHIES OLAP Hierarchies in the database
USER ALL DBA CDB CUBE_HIER_LEVELS OLAP Hierarchy Levels in the database
USER ALL DBA CDB CUBE_HIER_VIEWS OLAP Hierarchy Views in the database
USER ALL DBA CDB CUBE_HIER_VIEW_COLUMNS OLAP Hierarchy View Columns in the database
USER ALL DBA CDB CUBE_MAPPINGS OLAP Cube Mappings in the database
USER ALL DBA CDB CUBE_MEASURES OLAP Measures in the database
USER ALL DBA CDB CUBE_MEAS_MAPPINGS OLAP Cube Measure Mappings
USER ALL DBA CDB CUBE_NAMED_BUILD_SPECS OLAP Cube Named Build Specifications in the database
USER ALL DBA CDB CUBE_SUB_PARTITION_LEVELS OLAP Secondary Partition Levels in the database
USER ALL DBA CDB CUBE_VIEWS OLAP Cube Views in the database
USER ALL DBA CDB CUBE_VIEW_COLUMNS OLAP Cube View Columns in the database
USER - DBA CDB DATAPUMP_JOBS Datapump jobs
- - DBA CDB DATAPUMP_SESSIONS Datapump sessions attached to a job
- - DBA CDB DATA_FILES Information about database data files
USER - DBA CDB DBFS_HS
USER - DBA CDB DBFS_HS_COMMANDS
USER - - - DBFS_HS_FILES
USER - DBA CDB DBFS_HS_FIXED_PROPERTIES
USER - DBA CDB DBFS_HS_PROPERTIES
USER ALL DBA CDB DB_LINKS Database links
- - DBA CDB DB_LINK_SOURCES Database link sources
- - DBA CDB DDL_LOCKS
- ALL - - DEF_AUDIT_OPTS Auditing options for newly created objects
USER ALL DBA CDB DEPENDENCIES Dependencies to and from objects
- ALL - - DEQUEUE_QUEUES All queues
- - DBA CDB DIGEST_VERIFIERS Information about which users have Digest verifiers and the verifier types
USER ALL DBA CDB DIMENSIONS Description of the dimension objects accessible to the DBA
USER ALL DBA CDB DIM_ATTRIBUTES Representation of the relationship between a dimension level and a functionally dependent column
USER ALL DBA CDB DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
USER ALL DBA CDB DIM_HIERARCHIES Representation of a dimension hierarchy
USER ALL DBA CDB DIM_JOIN_KEY Representation of a join between two dimension tables.
USER ALL DBA CDB DIM_LEVELS Description of dimension levels
USER ALL DBA CDB DIM_LEVEL_KEY Representations of columns of a dimension level
- ALL DBA CDB DIRECTORIES Description of all directories
- - DBA CDB DISCOVERY_SOURCE Sources of sensitive data discovery
- - DBA CDB DML_LOCKS
- - DBA CDB DMT_FREE_SPACE Free extents in all dictionary managed tablespaces. See also dba_free_space and dmt_free_space.
- - DBA CDB DMT_USED_EXTENTS All extents in the dictionary managed tablespaces
USER - DBA CDB EDITIONED_TYPES
USER - - - EDITIONING$
USER ALL DBA CDB EDITIONING_VIEWS Description of Editioning Views
USER ALL DBA CDB EDITIONING_VIEWS_AE Description of Editioning Views
USER ALL DBA CDB EDITIONING_VIEW_COLS Relationship between columns of Editioning Views and the table columns to which they map
USER ALL DBA CDB EDITIONING_VIEW_COLS_AE Relationship between columns of Editioning Views and the table columns to which they map
- ALL DBA CDB EDITIONS Describes all editions in the database
- ALL DBA CDB EDITION_COMMENTS Describes comments on all editions in the database
- - DBA CDB ENABLED_AGGREGATIONS Information about enabled on-demand statistic aggregation
- - DBA CDB ENABLED_TRACES Information about enabled SQL traces.
USER ALL DBA CDB ENCRYPTED_COLUMNS Encryption information on all accessible columns
USER - DBA CDB EPG_DAD_AUTHORIZATION DADs authorized to use different user's privileges
USER ALL DBA CDB ERRORS Current errors on stored objects (PL/SQL code)
USER ALL DBA CDB ERRORS_AE Current errors on stored objects
USER ALL DBA CDB ERROR_TRANSLATIONS Describes all error translations
USER ALL DBA CDB EVALUATION_CONTEXTS rule evaluation contexts
USER ALL DBA CDB EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts
USER ALL DBA CDB EVALUATION_CONTEXT_VARS variables in all rule evaluation contexts
- - DBA CDB EXPORT_OBJECTS Export INCLUDE and EXCLUDE object type names
- - DBA CDB EXPORT_PATHS
USER ALL DBA CDB EXPRESSION_STATISTICS Expression Usage Tracking Statistics
- - DBA CDB EXP_FILES Description of export files
- - DBA CDB EXP_OBJECTS Objects that have been incrementally exported
- - DBA CDB EXP_VERSION Version number of the last export session
USER - DBA CDB EXTENTS Extents comprising all segments in the database
USER ALL DBA CDB EXTERNAL_LOCATIONS Description of the external tables locations
- - DBA CDB EXTERNAL_SCN_ACTIVITY
USER ALL DBA CDB EXTERNAL_TABLES Description of the external tables
- - DBA CDB FEATURE_USAGE_STATISTICS Database Feature Usage Statistics
- - DBA CDB FGA_AUDIT_TRAIL All fine grained audit event logs
- - - - FILE$
USER ALL DBA CDB FILE_GROUPS Details about file groups
USER ALL DBA CDB FILE_GROUP_EXPORT_INFO Details about export information of file group versions
USER ALL DBA CDB FILE_GROUP_FILES Details about file group files
USER ALL DBA CDB FILE_GROUP_TABLES Details about the tables in the file group repository
USER ALL DBA CDB FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
USER ALL DBA CDB FILE_GROUP_VERSIONS Details about file group versions
USER - DBA CDB FLASHBACK_ARCHIVE Description of the flashback archives available in the system
USER - DBA CDB FLASHBACK_ARCHIVE_TABLES Information about the tables that are enabled for flashback archive
- - DBA CDB FLASHBACK_ARCHIVE_TS Description of tablespaces in the flashback archives available in the system
USER - DBA CDB FLASHBACK_TXN_REPORT
USER - DBA CDB FLASHBACK_TXN_STATE
USER - DBA CDB FREE_SPACE Free extents in all tablespaces
- - DBA CDB FREE_SPACE_COALESCED Free space in a tablespace. One record per tablespace, unlike shown in dba_free_space.
- - DBA CDB FREE_SPACE_COALESCED_TMP1
- - DBA CDB FREE_SPACE_COALESCED_TMP2
- - DBA CDB FREE_SPACE_COALESCED_TMP3
- - DBA CDB FREE_SPACE_COALESCED_TMP4
- - DBA CDB FREE_SPACE_COALESCED_TMP5
- - DBA CDB FREE_SPACE_COALESCED_TMP6
- ALL DBA CDB GG_AUTO_CDR_COLUMNS Details about goldengate auto cdr columns
- ALL DBA CDB GG_AUTO_CDR_COLUMN_GROUPS Details about goldengate auto cdr column groups
- ALL DBA CDB GG_AUTO_CDR_TABLES Details about goldengate auto cdr tables
- ALL DBA CDB GG_INBOUND_PROGRESS
- - DBA CDB GG_PROCEDURE_ANNOTATION Annotate the position of Owner and Object arguments in procedure calls
- - DBA CDB GG_PROC_OBJECT_EXCLUSION Details all tables that should be filtered when operating on given objects
- - DBA CDB GG_SUPPORTED_PACKAGES Details about supported procedure packages for GoldenGate replication
- - DBA CDB GG_SUPPORTED_PROCEDURES Details all procedures that are supported for replication
- - DBA CDB GLOBAL_CONTEXT Description of all context information accessible globally
- ALL DBA CDB GOLDENGATE_CONTAINER_RULES Details about goldengate container inclusion/exclusion rules
- ALL DBA CDB GOLDENGATE_INBOUND Details about the XStream inbound server
- - DBA CDB GOLDENGATE_NOT_UNIQUE List of all the tables with out primary or unique key not null constraints
USER ALL DBA CDB GOLDENGATE_PRIVILEGES Details about goldengate privileges
- ALL DBA CDB GOLDENGATE_RULES Details about the GoldenGate server rules
- - DBA CDB GOLDENGATE_SUPPORT_MODE List of support mode for objects by GoldenGate
USER - - - GRANT
- - DBA CDB HANG_MANAGER_PARAMETERS Hang Manager parameters
- - DBA CDB HEATMAP_TOP_OBJECTS Heatmap for Top N objects
- - DBA CDB HEATMAP_TOP_TABLESPACES Heatmap for Top N tablespaces
USER ALL DBA CDB HEAT_MAP_SEGMENT Users segment last access time
USER ALL DBA CDB HEAT_MAP_SEG_HISTOGRAM Segment access information for all segments
USER ALL DBA CDB HIERARCHIES Hierarchies in the database
USER ALL DBA CDB HIER_CLASS Hierarchy classifications in the database
USER ALL DBA CDB HIER_COLUMNS Hierarchy columns in the database
USER ALL DBA CDB HIER_HIER_ATTRIBUTES Attribute dimension in the database
USER ALL DBA CDB HIER_HIER_ATTR_CLASS Hierarchical attribute classifications in the database
USER ALL DBA CDB HIER_JOIN_PATHS Hierarchy join paths in the database
USER ALL DBA CDB HIER_LEVELS Hierarchy levels in the database
USER ALL DBA CDB HIER_LEVEL_ID_ATTRS Hierarchy Level ID Attributes in the database
- - DBA CDB HIGH_WATER_MARK_STATISTICS Database High Water Mark Statistics
USER ALL DBA - HISTOGRAM USER_HISTOGRAM is a synonym for USER_TAB_HISTOGRAM etc.
USER - - - HISTORY$
- - DBA CDB HIST_ACTIVE_SESS_HISTORY Active Session Historical Statistics Information
- - DBA CDB HIST_APPLY_SUMMARY Streams/Goldengate/XStream Apply Historical Statistics Information
- - DBA CDB HIST_ASH_SNAPSHOT
- - DBA CDB HIST_ASM_BAD_DISK Non-Online ASM Disks
- - DBA CDB HIST_ASM_DISKGROUP ASM Diskgroups connected to this Database
- - DBA CDB HIST_ASM_DISKGROUP_STAT Statistics for ASM Diskgroup connected to this Database
- - DBA CDB HIST_ASM_DISK_STAT_SUMMARY Summary statistics for ASM Disks
- - DBA CDB HIST_BASELINE Baseline Metadata Information
- - DBA CDB HIST_BASELINE_DETAILS Baseline Stats on per Instance Level
- - DBA CDB HIST_BASELINE_METADATA Baseline Metadata Information
- - DBA CDB HIST_BASELINE_TEMPLATE Baseline Template Information
- - DBA CDB HIST_BG_EVENT_SUMMARY Summary of Background Event Historical Statistics Information
- - DBA CDB HIST_BUFFERED_QUEUES STREAMS Buffered Queues Historical Statistics Information
- - DBA CDB HIST_BUFFERED_SUBSCRIBERS STREAMS Buffered Queue Subscribers Historical Statistics Information
- - DBA CDB HIST_BUFFER_POOL_STAT Buffer Pool Historical Statistics Information
- - DBA CDB HIST_CAPTURE Streams/GoldenGate/XStream Capture Historical Statistics Information
- - DBA CDB HIST_CELL_CONFIG Exadata configuration information
- - DBA CDB HIST_CELL_CONFIG_DETAIL Exadata configuration information per snapshot
- - DBA CDB HIST_CELL_DB Cell Database IO Statistics Information
- - DBA CDB HIST_CELL_DISKTYPE Exadata Cell disk types
- - DBA CDB HIST_CELL_DISK_NAME Exadata Cell disk names
- - DBA CDB HIST_CELL_DISK_SUMMARY Cell Disk Summary Statistics
- - DBA CDB HIST_CELL_GLOBAL Cell Global Statistics Information
- - DBA CDB HIST_CELL_GLOBAL_SUMMARY Cell Global Summary Statistics
- - DBA CDB HIST_CELL_IOREASON Cell IO Reason Statistics Information
- - DBA CDB HIST_CELL_IOREASON_NAME Cell IO Reason Names
- - DBA CDB HIST_CELL_METRIC_DESC Cell Metric Names
- - DBA CDB HIST_CELL_NAME Exadata Cell names
- - DBA CDB HIST_CELL_OPEN_ALERTS Cell Open Alerts Information
- - DBA CDB HIST_CHANNEL_WAITS Channel Waits
- - DBA CDB HIST_CLUSTER_INTERCON Cluster Interconnect Historical Stats
- - DBA CDB HIST_COLORED_SQL Marked SQLs for snapshots
- - DBA CDB HIST_COMP_IOSTAT I/O stats aggregated on component level
- - DBA CDB HIST_CON_SYSMETRIC_HIST PDB System Metrics History
- - DBA CDB HIST_CON_SYSMETRIC_SUMM PDB System Metrics Summary
- - DBA CDB HIST_CON_SYSSTAT System Historical Statistics Information per PDB
- - DBA CDB HIST_CON_SYSTEM_EVENT System Event Historical Statistics Information
- - DBA CDB HIST_CON_SYS_TIME_MODEL PDB System Time Model Historical Statistics Information
- - DBA CDB HIST_CR_BLOCK_SERVER Consistent Read Block Server Historical Statistics
- - DBA CDB HIST_CURRENT_BLOCK_SERVER Current Block Server Historical Statistics
- - DBA CDB HIST_DATABASE_INSTANCE Database Instance Information
- - DBA CDB HIST_DATAFILE Names of Datafiles
- - DBA CDB HIST_DB_CACHE_ADVICE DB Cache Advice History Information
- - DBA CDB HIST_DISPATCHER Dispatcher statistics
- - DBA CDB HIST_DLM_MISC Distributed Lock Manager Miscellaneous Historical Statistics Information
- - DBA CDB HIST_DYN_REMASTER_STATS Dynamic remastering statistics
- - DBA CDB HIST_ENQUEUE_STAT Enqueue Historical Statistics Information
- - DBA CDB HIST_EVENT_HISTOGRAM Event Histogram Historical Statistics Information
- - DBA CDB HIST_EVENT_NAME Event Names
- - DBA CDB HIST_FILEMETRIC_HISTORY File Metrics History
- - DBA CDB HIST_FILESTATXS Datafile Historical Statistics Information
- - DBA CDB HIST_IC_CLIENT_STATS Historical interconnect client statistics
- - DBA CDB HIST_IC_DEVICE_STATS Historical interconnect device statistics
- - DBA CDB HIST_IM_SEG_STAT Historical IM Segment Statistics Information
- - DBA CDB HIST_IM_SEG_STAT_OBJ IM Segment Names
- - DBA CDB HIST_INSTANCE_RECOVERY Instance Recovery Historical Statistics Information
- - DBA CDB HIST_INST_CACHE_TRANSFER Instance Cache Transfer Historical Statistics
- - DBA CDB HIST_INTERCONNECT_PINGS Instance to instance ping stats
- - DBA CDB HIST_IOSTAT_DETAIL Historical I/O statistics by function and filetype
- - DBA CDB HIST_IOSTAT_FILETYPE Historical I/O statistics by file type
- - DBA CDB HIST_IOSTAT_FILETYPE_NAME File type names for historical I/O statistics
- - DBA CDB HIST_IOSTAT_FUNCTION Historical I/O statistics by function
- - DBA CDB HIST_IOSTAT_FUNCTION_NAME Function names for historical I/O statistics
- - DBA CDB HIST_JAVA_POOL_ADVICE Java Pool Advice History
- - DBA CDB HIST_LATCH Latch Historical Statistics Information
- - DBA CDB HIST_LATCH_CHILDREN Latch Children Historical Statistics Information
- - DBA CDB HIST_LATCH_MISSES_SUMMARY Latch Misses Summary Historical Statistics Information
- - DBA CDB HIST_LATCH_NAME Latch Names
- - DBA CDB HIST_LATCH_PARENT Latch Parent Historical Historical Statistics Information
- - DBA CDB HIST_LIBRARYCACHE Library Cache Historical Statistics Information
- - DBA CDB HIST_LMS_STATS LMS statistics
- - DBA CDB HIST_LOG Log Historical Statistics Information
- - DBA CDB HIST_MEMORY_RESIZE_OPS Memory Resize Operations History
- - DBA CDB HIST_MEMORY_TARGET_ADVICE Memory Target Advice History
- - DBA CDB HIST_MEM_DYNAMIC_COMP Historical memory component sizes
- - DBA CDB HIST_METRIC_NAME Segment Names
- - DBA CDB HIST_MTTR_TARGET_ADVICE Mean-Time-To-Recover Target Advice History
- - DBA CDB HIST_MUTEX_SLEEP Mutex Sleep Summary Historical Statistics Information
- - DBA CDB HIST_MVPARAMETER Multi-valued Parameter Historical Statistics Information
- - DBA CDB HIST_OPTIMIZER_ENV Optimizer Environment Information
- - DBA CDB HIST_OSSTAT Operating System Historical Statistics Information
- - DBA CDB HIST_OSSTAT_NAME Operating System Statistic Names
- - DBA CDB HIST_PARAMETER Parameter Historical Statistics Information
- - DBA CDB HIST_PARAMETER_NAME Parameter Names
- - DBA CDB HIST_PDB_INSTANCE Pluggable Database Instance Information
- - DBA CDB HIST_PDB_IN_SNAP Pluggable Databases in a snapshot
- - DBA CDB HIST_PERSISTENT_QMN_CACHE STREAMS AQ Persistent QMN Cache Historical Statistics Information
- - DBA CDB HIST_PERSISTENT_QUEUES STREAMS AQ Persistent Queues Historical Statistics Information
- - DBA CDB HIST_PERSISTENT_SUBS STREAMS AQ Persistent Queue Subscribers Historical Statistics Information
- - DBA CDB HIST_PGASTAT PGA Historical Statistics Information
- - DBA CDB HIST_PGA_TARGET_ADVICE PGA Target Advice History
- - DBA CDB HIST_PLAN_OPERATION_NAME Optimizer Explain Plan Operation Names
- - DBA CDB HIST_PLAN_OPTION_NAME Optimizer Explain Plan Option Names
- - DBA CDB HIST_PROCESS_MEM_SUMMARY Process Memory Historical Summary Information
- - DBA CDB HIST_PROCESS_WAITTIME cpu and wait time by process types
- - DBA CDB HIST_RECOVERY_PROGRESS Recovery Progress Stats Instance Wide
- - DBA CDB HIST_REPLICATION_TBL_STATS Replication Table Stats For GoldenGate/XStream Sessions
- - DBA CDB HIST_REPLICATION_TXN_STATS Replication Transaction Stats For GoldenGate/XStream Sessions
- - DBA CDB HIST_REPORTS
- - DBA CDB HIST_REPORTS_CONTROL
- - DBA CDB HIST_REPORTS_DETAILS
- - DBA CDB HIST_REPORTS_TIMEBANDS
- - DBA CDB HIST_RESOURCE_LIMIT Resource Limit Historical Statistics Information
- - DBA CDB HIST_ROWCACHE_SUMMARY Row Cache Historical Statistics Information Summary
- - DBA CDB HIST_RSRC_CONSUMER_GROUP Historical resource consumer group statistics
- - DBA CDB HIST_RSRC_METRIC Historical resource manager metrics
- - DBA CDB HIST_RSRC_PDB_METRIC Historical resource manager metrics by PDB
- - DBA CDB HIST_RSRC_PLAN Historical resource plan statistics
- - DBA CDB HIST_RULE_SET Rule sets historical statistics information
- - DBA CDB HIST_SEG_STAT Historical Statistics Information
- - DBA CDB HIST_SEG_STAT_OBJ Segment Names
- - DBA CDB HIST_SERVICE_NAME Service Names
- - DBA CDB HIST_SERVICE_STAT Historical Service Statistics
- - DBA CDB HIST_SERVICE_WAIT_CLASS Historical Service Wait Class Statistics
- - DBA CDB HIST_SESSMETRIC_HISTORY System Metrics History
- - DBA CDB HIST_SESS_SGA_STATS SGA Usage Stats For High Utilization GoldenGate/XStream Sessions
- - DBA CDB HIST_SESS_TIME_STATS CPU And I/O Time For High Utilization Streams/GoldenGate/XStream sessions
- - DBA CDB HIST_SGA SGA Historical Statistics Information
- - DBA CDB HIST_SGASTAT SGA Pool Historical Statistics Information
- - DBA CDB HIST_SGA_TARGET_ADVICE SGA Target Advice History
- - DBA CDB HIST_SHARED_POOL_ADVICE Shared Pool Advice History
- - DBA CDB HIST_SHARED_SERVER_SUMMARY Shared Server summary statistics
- - DBA CDB HIST_SNAPSHOT Snapshot Information
- - DBA CDB HIST_SNAP_ERROR Snapshot Error Information
- - DBA CDB HIST_SQLBIND Bind variable information
- - DBA CDB HIST_SQLCOMMAND_NAME Sql command types
- - DBA CDB HIST_SQLSTAT SQL Historical Statistics Information
- - DBA CDB HIST_SQLTEXT SQL Text
- - DBA CDB HIST_SQL_BIND_METADATA Bind variable metadata information
- - DBA CDB HIST_SQL_PLAN SQL execution plan
- - DBA CDB HIST_SQL_SUMMARY Summary of SQL Statistics
- - DBA CDB HIST_SQL_WORKAREA_HSTGRM SQL Workarea Histogram History
- - DBA CDB HIST_STAT_NAME Statistic Names
- - DBA CDB HIST_STREAMS_APPLY_SUM STREAMS Apply Historical Statistics Information
- - DBA CDB HIST_STREAMS_CAPTURE STREAMS Capture Historical Statistics Information
- - DBA CDB HIST_STREAMS_POOL_ADVICE Streams Pool Advice History
- - DBA CDB HIST_SYSMETRIC_HISTORY System Metrics History
- - DBA CDB HIST_SYSMETRIC_SUMMARY System Metrics History
- - DBA CDB HIST_SYSSTAT System Historical Statistics Information
- - DBA CDB HIST_SYSTEM_EVENT System Event Historical Statistics Information
- - DBA CDB HIST_SYS_TIME_MODEL System Time Model Historical Statistics Information
- - DBA CDB HIST_TABLESPACE Tablespace Static Information
- - DBA CDB HIST_TABLESPACE_STAT Tablespace Historical Statistics Information
- - DBA CDB HIST_TBSPC_SPACE_USAGE Tablespace Usage Historical Statistics Information
- - DBA CDB HIST_TEMPFILE Names of Temporary Datafiles
- - DBA CDB HIST_TEMPSTATXS Temporary Datafile Historical Statistics Information
- - DBA CDB HIST_THREAD Thread Historical Statistics Information
- - DBA CDB HIST_TOPLEVELCALL_NAME Oracle top level call type
- - DBA CDB HIST_UNDOSTAT Undo Historical Statistics Information
- - DBA CDB HIST_WAITCLASSMET_HISTORY Wait Class Metric History
- - DBA CDB HIST_WAITSTAT Wait Historical Statistics Information
- - DBA CDB HIST_WR_CONTROL Workload Repository Control Information
- - DBA CDB HIST_WR_SETTINGS Workload Repository Settings
USER - DBA CDB HOST_ACES Access control entries defined in host access control lists
- - DBA CDB HOST_ACLS Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
USER ALL DBA CDB IDENTIFIERS All identifiers in stored objects
USER - DBA CDB ILMDATAMOVEMENTPOLICIES Data movement related policies in database
USER - DBA CDB ILMEVALUATIONDETAILS Details on policies considered for a particular execution
USER - DBA CDB ILMOBJECTS Policies and the objects they affect in the database
- - DBA CDB ILMPARAMETERS Describes ILM PARAMETERS in the database and their values
USER - DBA CDB ILMPOLICIES ILM policies in the database
USER - DBA CDB ILMRESULTS Information on ILM jobs
USER - DBA CDB ILMTASKS Information on ILM execution
USER - DBA CDB IM_EXPRESSIONS Automatically captured expressions enabled for in-memory storage
USER ALL DBA CDB INDEXES Descriptions of indexes on tables
USER ALL DBA CDB INDEXTYPES Index types
USER ALL DBA CDB INDEXTYPE_ARRAYTYPES All array types specified by the indextype
USER ALL DBA CDB INDEXTYPE_COMMENTS Comments for indextypes
USER ALL DBA CDB INDEXTYPE_OPERATORS Operators
- - DBA CDB INDEX_USAGE
USER ALL DBA CDB IND_COLUMNS Columns that compromise an index.
USER ALL DBA CDB IND_COLUMNS_V$
USER ALL DBA CDB IND_EXPRESSIONS The expressions that provide the values for a function-based index.
USER ALL DBA CDB IND_PARTITIONS
USER ALL DBA CDB IND_PENDING_STATS Pending statistics of indexes, partitions, and subpartitions
USER ALL DBA CDB IND_STATISTICS Optimizer statistics for all indexes on tables
USER ALL DBA CDB IND_SUBPARTITIONS
- - DBA CDB INMEMORY_AIMTASKDETAILS Information on details for an automatic inmemory management task
- - DBA CDB INMEMORY_AIMTASKS Information on tasks for automatic inmemory store management (AIM)
USER ALL DBA CDB INTERNAL_TRIGGERS Description of the internal triggers on the tables.
- ALL - - INT_DEQUEUE_QUEUES Queues
- - DBA CDB INVALID_OBJECTS Lists all invalid objects.
USER - DBA CDB JOBS All jobs in the database
- - DBA CDB JOBS_RUNNING All jobs in the database which are currently running, join v$lock and job$.
USER - DBA CDB JOINGROUPS Join groups in the database
USER ALL DBA CDB JOIN_IND_COLUMNS Join Index columns comprising the join conditions
- - DBA CDB JSON_COLSTORAGE_STATS
USER ALL DBA CDB JSON_COLUMNS Comments on the JSON columns
USER ALL DBA CDB JSON_DUALITY_VIEWS Description of the JSON Relational Duality Views
USER ALL DBA CDB JSON_DUALITY_VIEW_LINKS Description of the links of the tables of a JSON Relational Duality View
USER ALL DBA CDB JSON_DUALITY_VIEW_TABS Description of the tables of a JSON Relational Duality View
USER ALL DBA CDB JSON_DUALITY_VIEW_TAB_COLS Description of the columns of the tables of a JSON Relational Duality View
USER ALL DBA CDB JSON_INDEXES Comments on the JSON indexes accessible to the user
USER ALL DBA CDB JSON_SCHEMA_COLUMNS Description of JSON schema check constraints on columns
- - DBA CDB JSON_TABLE_COLS_COUNT
- - DBA CDB JSON_VIEW_COLS_COUNT
USER ALL DBA CDB JSON_DATAGUIDES
USER ALL DBA CDB JSON_DATAGUIDE_FIELDS
- - DBA CDB KEEPSIZES Created in prvtpool.plb, possibly in relation with dbms_shared_pool.
- - DBA CDB KGLLOCK Lists all locks and pins held on KGL (Kernel Generic Library cache) objects.
USER ALL DBA CDB LIBRARIES Description of libraries
- - DBA CDB LMT_FREE_SPACE Free extents in all locally managed tablespaces. Compare with dmt_free_space
- - DBA CDB LMT_USED_EXTENTS All extents in the locally managed tablespaces
USER ALL DBA CDB LOBS Description of LOBs stored in tables
USER ALL DBA CDB LOB_PARTITIONS
USER ALL DBA CDB LOB_SUBPARTITIONS
USER ALL DBA CDB LOB_TEMPLATES
- - - - LOCAL_ADMINAUTH$
- - - - LOCAL_ADMIN_PRIVS Describes local administrative privileges granted in PDBs of a CDB
- - DBA CDB LOCK
- - DBA CDB LOCKDOWN_PROFILES Describes all the rules of all the lockdown profiles
- - DBA CDB LOCK_INTERNAL
- - DBA CDB LOGMNR_LOG
- - DBA CDB LOGMNR_PURGED_LOG
- - DBA CDB LOGMNR_SESSION
- - DBA CDB LOGSTDBY_EDS_SUPPORTED List of all tables that could have EDS-based replication for Logical Standby
- - DBA CDB LOGSTDBY_EDS_TABLES List of all tables that have EDS-based replication for Logical Standby
- - DBA CDB LOGSTDBY_EVENTS Information on why logical standby events
- - DBA CDB LOGSTDBY_HISTORY Information on processed, active, and pending log streams
- - DBA CDB LOGSTDBY_LOG List the information about received logs from the primary
- - DBA CDB LOGSTDBY_NOT_UNIQUE List of all the tables without primary or unique key not null constraints
- - DBA CDB LOGSTDBY_PARAMETERS Miscellaneous options and settings for Logical Standby
- - DBA CDB LOGSTDBY_PLSQL_MAP PL/SQL mapping from user invokable procedure to supp-log pragma-ed procedure
- - DBA CDB LOGSTDBY_PLSQL_SUPPORT PLSQL packages registered with logical standby
- - DBA CDB LOGSTDBY_PROGRESS List the SCN values describing read and apply progress
- - DBA CDB LOGSTDBY_SKIP List the skip settings choosen
- - DBA CDB LOGSTDBY_SKIP_TRANSACTION List the transactions to be skipped
- - DBA CDB LOGSTDBY_UNSUPPORTED List of all the columns that are not supported by Logical Standby
- - DBA CDB LOGSTDBY_UNSUPPORTED_TABLE List of all the data tables that are not supported by Logical Standby
USER ALL DBA CDB LOG_GROUPS Log group definitions on accessible tables
USER ALL DBA CDB LOG_GROUP_COLUMNS Information about columns in log group definitions
USER ALL DBA CDB MEASURE_FOLDERS OLAP Measure Folders in the database
USER ALL DBA CDB MEASURE_FOLDER_CONTENTS OLAP Measure Folder Contents in the database
USER ALL DBA CDB MEASURE_FOLDER_SUBFOLDERS OLAP Measure Folders contained within the OLAP Measure Folders
USER ALL DBA CDB METADATA_PROPERTIES OLAP Metadata Properties in the database
USER ALL DBA CDB METHOD_PARAMS Description of method parameters of types
USER ALL DBA CDB METHOD_RESULTS Description of method results of types
- ALL - - MINING_ALGORITHMS
USER ALL DBA CDB MINING_MODELS Description of the models
USER ALL DBA CDB MINING_MODEL_ATTRIBUTES Description of all the model attributes
USER ALL DBA CDB MINING_MODEL_PARTITIONS Description of all the partitions
USER ALL DBA CDB MINING_MODEL_SETTINGS Description of all the settings
- - DBA CDB MINING_MODEL_TABLES Description of all the mining model tables in the system
USER ALL DBA CDB MINING_MODEL_VIEWS Description of all the model views
USER ALL DBA CDB MINING_MODEL_XFORMS User-specified transformations embedded in all models
USER ALL DBA CDB MVIEWS All materialized views in the database
USER ALL DBA CDB MVIEW_AGGREGATES Description of the materialized view aggregates
USER ALL DBA CDB MVIEW_ANALYSIS Description of the materialized views
USER ALL DBA CDB MVIEW_COMMENTS Comments on materialized views
USER ALL DBA CDB MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the database
USER ALL DBA CDB MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables
USER ALL DBA CDB MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the database
USER ALL DBA CDB MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view
USER ALL DBA CDB MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view
USER ALL DBA CDB MVIEW_LOGS Materialized view logs
- - DBA CDB MVIEW_LOG_FILTER_COLS All filter columns (excluding PK cols) being logged in the materialized view logs
USER ALL DBA CDB MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table
USER - DBA CDB MVREF_CHANGE_STATS
USER - DBA CDB MVREF_RUN_STATS
USER - DBA CDB MVREF_STATS
USER - DBA CDB MVREF_STATS_PARAMS
USER - DBA CDB MVREF_STATS_SYS_DEFAULTS
USER - DBA CDB MVREF_STMT_STATS
USER ALL DBA CDB NESTED_TABLES Description of nested tables in tables
USER ALL DBA CDB NESTED_TABLE_COLS Columns of nested tables
- - DBA CDB NETWORK_ACLS Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
USER - DBA CDB NETWORK_ACL_PRIVILEGES Privileges defined in network access control lists
USER ALL DBA CDB OBJECTS Lists all objects (such as tables, views etc.)
USER ALL DBA CDB OBJECTS_AE Objects
USER - DBA CDB OBJECT_SIZE Sizes, in bytes, of various PL/SQL objects. Created in prvtpool.plb, possibly in relation with dbms_shared_pool.
USER ALL DBA CDB OBJECT_TABLES Description of object tables
USER - DBA CDB OBJECT_USAGE Record of index usage
USER - DBA CDB OBJ_AUDIT_OPTS Auditing options for all tables and views with atleast one option set
USER ALL DBA CDB OBJ_COLATTRS Description of object columns and attributes contained in the tables
USER - DBA CDB OLDIMAGE_COLUMNS Gives all object tables and columns in old (8.0) image format
USER ALL DBA CDB OPANCILLARY Ancillary operators
USER ALL DBA CDB OPARGUMENTS Arguments of the bindings of an operator.
USER ALL DBA CDB OPBINDINGS All binding functions for operators
USER ALL DBA CDB OPERATORS All operators
USER ALL DBA CDB OPERATOR_COMMENTS Comments for user-defined operators
- - DBA CDB OPTSTAT_OPERATIONS History of statistic related operations performed using the dbms_stats package.
- - DBA CDB OPTSTAT_OPERATION_TASKS Tasks that are performed as part of statistics operations
USER - DBA CDB OUTLINES Stored outlines
USER - DBA CDB OUTLINE_HINTS Hints stored in outlines
- - DBA CDB OUTSTANDING_ALERTS Description of all outstanding alerts
USER - DBA CDB PARALLEL_EXECUTE_CHUNKS
USER - DBA CDB PARALLEL_EXECUTE_TASKS
USER ALL DBA CDB PARTIAL_DROP_TABS All tables with partially dropped columns
USER ALL DBA CDB PART_COL_STATISTICS
USER ALL DBA CDB PART_HISTOGRAMS
USER ALL DBA CDB PART_INDEXES
USER ALL DBA CDB PART_KEY_COLUMNS
USER ALL DBA CDB PART_KEY_COLUMNS_V$
USER ALL DBA CDB PART_LOBS
USER ALL DBA CDB PART_TABLES
USER - - - PASSWORD_LIMITS Display password limits
- - DBA CDB PDBS Describes all pluggable databases in the consolidated database
- - DBA CDB PDB_HISTORY Describes lineage of the pluggable database to which it belongs
- - DBA CDB PDB_SAVED_STATES Shows all saved pluggable database states in the consolidated database
- - DBA CDB PDB_SNAPSHOTS Describes all snapshots for a given pluggable database
USER ALL DBA CDB PENDING_CONV_TABLES All tables which are not upgraded to the latest type version
- - DBA CDB PENDING_TRANSACTIONS information about unresolved global transactions
USER ALL DBA CDB PLSQL_COLL_TYPES Description of named plsql collection types
USER ALL DBA CDB PLSQL_OBJECT_SETTINGS Compiler settings of stored objects
USER ALL DBA CDB PLSQL_TYPES Description of types
USER ALL DBA CDB PLSQL_TYPE_ATTRS Description of attributes of types
USER ALL DBA CDB POLICIES Assgined VPD(?) policies to objects
USER ALL DBA CDB POLICY_ATTRIBUTES All attribute associations of context sensitive and shared context sensitive policies for objects if the user has system privileges or owns the objects
USER ALL DBA CDB POLICY_CONTEXTS All policy driving context defined for all synonym, tables or development/databases/Oracle/objects/views[views].
USER ALL DBA CDB POLICY_GROUPS All policy groups defined for any synonym, table or view
USER - DBA CDB PRIVATE_TEMP_TABLES Lists private temporary tables
USER - - - PRIVILEGE_MAP Description table for user privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names
- - DBA CDB PRIV_AUDIT_OPTS Describes current system privileges being audited across the system and by user
- - DBA CDB PRIV_CAPTURES
- ALL - - PROBE_OBJECTS
USER ALL DBA CDB PROCEDURES Functions/procedures/packages/types/triggers
- - DBA CDB PROFILES Display all profiles and their limits
- ALL DBA CDB PROPAGATION Streams propagation
- - - - PROPERTIES Permanent database properties in all containers
- - - - PROPS$
USER - DBA CDB PROXIES Information about all proxy connections
- - - - PTC_APPLY_PROGRESS
USER ALL DBA CDB QUEUES Queues
USER ALL DBA CDB QUEUE_PUBLISHERS
USER ALL DBA CDB QUEUE_SCHEDULES
USER ALL DBA CDB QUEUE_SUBSCRIBERS All queue subscribers accessible to user
USER ALL DBA CDB QUEUE_TABLES Queue tables
- - DBA CDB RCHILD All the children in any refresh group. This view is not a join.
- - DBA CDB RECOVERABLE_SCRIPT Details about recoverable operations
- - DBA CDB RECOVERABLE_SCRIPT_BLOCKS Details about the recoverable script blocks
- - DBA CDB RECOVERABLE_SCRIPT_ERRORS Details showing errors during script execution
- - DBA CDB RECOVERABLE_SCRIPT_HIST Details about executed or purged recoverable operations
- - DBA CDB RECOVERABLE_SCRIPT_PARAMS Details about the recoverable operation parameters
USER - DBA CDB RECYCLEBIN Description of the Recyclebin view
- - DBA CDB REDEFINITION_ERRORS
- - DBA CDB REDEFINITION_OBJECTS
- - DBA CDB REDEFINITION_STATUS
- - DBA CDB REDO_DB
- - DBA CDB REDO_LOG
USER ALL DBA CDB REFRESH Refresh groups
USER ALL DBA CDB REFRESH_CHILDREN All the objects in refresh groups, where the user can touch the group
- ALL - - REFRESH_DEPENDENCIES Description of the detail tables that materialized views depend on for refresh
USER ALL DBA CDB REFS Description of REF columns contained in tables
- - DBA CDB REGISTERED_ARCHIVED_LOG Details about the registered log files
USER ALL DBA CDB REGISTERED_MVIEWS Remote materialized views of local tables
USER ALL DBA CDB REGISTERED_SNAPSHOTS Remote snapshots of local tables
USER - DBA CDB REGISTRY
- ALL - - REGISTRY_BANNERS
- - DBA CDB REGISTRY_DATABASE
- - DBA CDB REGISTRY_DEPENDENCIES
- - DBA CDB REGISTRY_ERROR
- - DBA CDB REGISTRY_HIERARCHY
- - DBA CDB REGISTRY_HISTORY
- - DBA CDB REGISTRY_LOG
- - DBA CDB REGISTRY_PROGRESS
- - DBA CDB REGISTRY_SCHEMAS
- - DBA CDB REGISTRY_SQLPATCH Information about SQL patches that have been installed in the database
- - DBA CDB REGISTRY_SQLPATCH_RU_INFO
- ALL DBA CDB REPLICATION_PROCESS_EVENTS Dictionary table for the replication processes events
- ALL DBA CDB REPL_DBNAME_MAPPING Details about the database name mapping
- - DBA CDB RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
USER - - - RESOURCE_LIMITS Display resource limits
- - - - RESOURCE_PLAN$
- - - - RESOURCE_PLAN_DIRECTIVE$
USER - DBA CDB RESUMABLE Resumable session information in the system
USER ALL DBA CDB REWRITE_EQUIVALENCES Shows rewrite equivalences.
- - DBA CDB RGROUP All refresh groups. This view is not a join.
- - DBA CDB ROLES All Roles which exist in the database
USER - DBA CDB ROLE_PRIVS Roles granted to users and roles
- - DBA CDB ROLLBACK_SEGS Description of rollback segments
- - DBA CDB ROLLING_DATABASES List of all databases eligible for configuration with rolling upgrade
- - DBA CDB ROLLING_EVENTS List of all events reported from DBMS_ROLLING PL/SQL package
- - DBA CDB ROLLING_PARAMETERS List of parameters to configure rolling upgrade
- - DBA CDB ROLLING_PLAN List of instructions which constitutes the upgrade plan
- - DBA CDB ROLLING_STATISTICS List of rolling upgrade statistics
- - DBA CDB ROLLING_STATUS Overall status of the rolling upgrade
- - DBA CDB ROLLING_UNSUPPORTED List of all the columns that are not supported by DBMS_ROLLING upgrades
- - - - ROPP$X$KCCAL
- - - - ROPP$X$KCCBF
- - - - ROPP$X$KCCBI
- - - - ROPP$X$KCCBL
- - - - ROPP$X$KCCBP
- - - - ROPP$X$KCCBS
- - - - ROPP$X$KCCDC
- - - - ROPP$X$KCCDI
- - - - ROPP$X$KCCDI2
- - - - ROPP$X$KCCFE
- - - - ROPP$X$KCCFN
- - - - ROPP$X$KCCIC
- - - - ROPP$X$KCCLE
- - - - ROPP$X$KCCLH
- - - - ROPP$X$KCCOR
- - - - ROPP$X$KCCPA
- - - - ROPP$X$KCCPD
- - - - ROPP$X$KCCPDB
- - - - ROPP$X$KCCPIC
- - - - ROPP$X$KCCRT
- - - - ROPP$X$KCCSL
- - - - ROPP$X$KCCTF
- - - - ROPP$X$KCCTIR
- - - - ROPP$X$KCCTS
- - - - ROPP$X$KCPDBINC
- - - - ROPP$X$KCVDF
- - - - ROPP$X$KCVFH
- - - - ROPP$X$KCVFHALL
- - - - ROPP$X$KCVFHTMP
- - - - RPP$X$KCCAL
- - - - RPP$X$KCCBF
- - - - RPP$X$KCCBI
- - - - RPP$X$KCCBL
- - - - RPP$X$KCCBP
- - - - RPP$X$KCCBS
- - - - RPP$X$KCCDC
- - - - RPP$X$KCCDI
- - - - RPP$X$KCCDI2
- - - - RPP$X$KCCFE
- - - - RPP$X$KCCFN
- - - - RPP$X$KCCIC
- - - - RPP$X$KCCLE
- - - - RPP$X$KCCLH
- - - - RPP$X$KCCOR
- - - - RPP$X$KCCPA
- - - - RPP$X$KCCPD
- - - - RPP$X$KCCPDB
- - - - RPP$X$KCCPIC
- - - - RPP$X$KCCRT
- - - - RPP$X$KCCSL
- - - - RPP$X$KCCTF
- - - - RPP$X$KCCTIR
- - - - RPP$X$KCCTS
- - - - RPP$X$KCPDBINC
- - - - RPP$X$KCVDF
- - - - RPP$X$KCVFH
- - - - RPP$X$KCVFHALL
- - - - RPP$X$KCVFHTMP
- - DBA CDB RSRC_CAPABILITY settings for database resources that are capable of being managed by the Resource Manager
- - DBA CDB RSRC_CATEGORIES All resource consumer group categories
- - DBA CDB RSRC_CONSUMER_GROUPS all the resource consumer groups
USER - DBA CDB RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups
- - DBA CDB RSRC_GROUP_MAPPINGS all the consumer group mappings
- - DBA CDB RSRC_INSTANCE_CAPABILITY per-instance settings for database resources that are capable of being managed by the Resource Manager
- - DBA CDB RSRC_IO_CALIBRATE Results of the most recent I/O calibration
USER - DBA CDB RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
- - DBA CDB RSRC_MAPPING_PRIORITY the consumer group mapping attribute priorities
- - DBA CDB RSRC_PLANS All the resource plans
- - DBA CDB RSRC_PLAN_DIRECTIVES All the resource plan directives
- - DBA CDB RSRC_STORAGE_POOL_MAPPING resource manager rules for mapping files to storage pools
USER ALL DBA CDB RULES Rules
USER ALL DBA CDB RULESETS Rulesets, maintained for backward compatibility
USER ALL DBA CDB RULE_SETS Rule sets
USER ALL DBA CDB RULE_SET_RULES Rules in all rule sets
USER ALL DBA CDB SCHEDULER_CHAINS All scheduler chains
USER ALL DBA CDB SCHEDULER_CHAIN_RULES All rules from scheduler chains
USER ALL DBA CDB SCHEDULER_CHAIN_STEPS All steps of scheduler chains
USER ALL DBA CDB SCHEDULER_CREDENTIALS All scheduler credentials. Deprecated in favor of dba_credentials
USER ALL DBA CDB SCHEDULER_DB_DESTS Destination objects in the database pointing to remote databases. Compare with dba_scheduler_external_dests.
USER ALL DBA CDB SCHEDULER_DESTS Destination objects for jobs in the database
- ALL DBA CDB SCHEDULER_EXTERNAL_DESTS Destination objects in the database pointing to remote agents. Compare with dba_scheduler_dests.
USER ALL DBA CDB SCHEDULER_FILE_WATCHERS Scheduler file watch requests
- ALL DBA CDB SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
USER ALL DBA CDB SCHEDULER_GROUPS Scheduler object groups
USER ALL DBA CDB SCHEDULER_GROUP_MEMBERS Members of all scheduler object groups
USER ALL DBA CDB SCHEDULER_INCOMPATS All scheduler incompatibility resource objects in the database
USER ALL DBA CDB SCHEDULER_INCOMPAT_MEMBER All incompatibility resource objects members in the database
USER ALL DBA CDB SCHEDULER_JOBS Lists the content of the scheduler job table.
USER ALL DBA CDB SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
- ALL DBA CDB SCHEDULER_JOB_CLASSES All scheduler classes
USER ALL DBA CDB SCHEDULER_JOB_DESTS State of all jobs at each of their destinations
USER ALL DBA CDB SCHEDULER_JOB_LOG Logged information for all scheduler jobs
- - DBA CDB SCHEDULER_JOB_ROLES All scheduler jobs in the database by database role
USER ALL DBA CDB SCHEDULER_JOB_RUN_DETAILS The details of a job run
USER ALL DBA CDB SCHEDULER_NOTIFICATIONS All job e-mail notifications
USER ALL DBA CDB SCHEDULER_PROGRAMS All scheduler programs
USER ALL DBA CDB SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs
- ALL DBA CDB SCHEDULER_REMOTE_DATABASES List of registered remote databases for jobs
USER ALL DBA CDB SCHEDULER_REMOTE_JOBSTATE Remote state of all jobs originating from this database
USER ALL DBA CDB SCHEDULER_RESOURCES All scheduler resource objects in the database
USER ALL DBA CDB SCHEDULER_RSC_CONSTRAINTS All scheduler resource constraint members in the database
USER ALL DBA CDB SCHEDULER_RUNNING_CHAINS All job steps of running job chains
USER ALL DBA CDB SCHEDULER_RUNNING_JOBS
USER ALL DBA CDB SCHEDULER_SCHEDULES All schedules in the database
- ALL DBA CDB SCHEDULER_WINDOWS All scheduler windows in the database
- ALL DBA CDB SCHEDULER_WINDOW_DETAILS The details of a window
- ALL DBA CDB SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
- ALL DBA CDB SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
- ALL DBA CDB SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
USER ALL DBA CDB SECONDARY_OBJECTS All secondary objects for domain indexes
- - DBA CDB SECUREFILE_LOGS
- - DBA CDB SECUREFILE_LOG_INSTANCES
- - DBA CDB SECUREFILE_LOG_PARTITIONS
- - DBA CDB SECUREFILE_LOG_TABLES
USER ALL DBA CDB SEC_RELEVANT_COLS Security Relevant columns of all VPD policies for tables or views
USER - DBA CDB SEGMENTS Storage allocated for all database segments
- - DBA CDB SEGMENTS_OLD Storage allocated for all database segments
- - DBA CDB SENSITIVE_COLUMN_TYPES All Sensitive Column Types in the database
- - DBA CDB SENSITIVE_DATA All sensitive data in the database identified using TSDP
- - DBA CDB SENSITIVE_DATA_TBL
USER ALL DBA CDB SEQUENCES Description of SEQUENCEs
- - DBA CDB SERVER_REGISTRY
- ALL DBA CDB SERVICES
- - - - SERVICE$
- ALL DBA CDB SERVICES
USER ALL DBA CDB SNAPSHOTS Snapshots the user can access
USER ALL DBA CDB SNAPSHOT_LOGS Snapshot logs in the database
USER ALL DBA CDB SOURCE Current source code of PL/SQL procedure, packages etc.
USER ALL DBA CDB SOURCE_AE Current source on stored objects that user is allowed to create
USER ALL DBA CDB SQLJ_TYPES Description of types
USER ALL DBA CDB SQLJ_TYPE_ATTRS Description of attributes of types
USER ALL DBA CDB SQLJ_TYPE_METHODS Description of methods of types
USER ALL DBA CDB SQLSET
USER ALL DBA CDB SQLSET_BINDS Bind values associated with SQL tuning sets
USER ALL DBA CDB SQLSET_PLANS
USER ALL DBA CDB SQLSET_REFERENCES
USER ALL DBA CDB SQLSET_STATEMENTS
USER - DBA CDB SQLTUNE_BINDS
USER - DBA CDB SQLTUNE_PLANS
USER - DBA CDB SQLTUNE_RATIONALE_PLAN
USER - DBA CDB SQLTUNE_STATISTICS
- - DBA CDB SQL_MANAGEMENT_CONFIG
- - DBA CDB SQL_MONITOR_USAGE
- - DBA CDB SQL_PATCHES List of SQL patches
- - DBA CDB SQL_PLAN_BASELINES Set of SQL plan baselines
- - DBA CDB SQL_PLAN_DIRECTIVES Set of SQL plan directives
- - DBA CDB SQL_PLAN_DIR_OBJECTS Set of objects in SQL plan directive
- - DBA CDB SQL_PROFILES Set of SQL profiles
USER ALL DBA CDB SQL_TRANSLATIONS Describes all SQL translations
USER ALL DBA CDB SQL_TRANSLATION_PROFILES Describes all SQL translation profiles
USER - DBA CDB SR_GRP_STATUS
USER - DBA CDB SR_GRP_STATUS_ALL All synchronous refresh groups in the database
USER - DBA CDB SR_OBJ
USER - DBA CDB SR_OBJ_ALL All synchronous refresh objects in the database
USER - DBA CDB SR_OBJ_STATUS
USER - DBA CDB SR_OBJ_STATUS_ALL All synchronous refresh objects in the database
USER - DBA CDB SR_PARTN_OPS
USER - DBA CDB SR_STLOG_EXCEPTIONS
USER - DBA CDB SR_STLOG_STATS
- - DBA CDB SSCR_CAPTURE Session state capture statistics
- - DBA CDB SSCR_RESTORE Session state restore statistics
USER ALL DBA CDB STATEMENTS All SQL statements found in PL/SQL objects
USER ALL DBA CDB STAT_EXTENSIONS Optimizer statistics extensions
- - DBA CDB STMT_AUDIT_OPTS Describes current system auditing options across the system and by user
USER ALL DBA CDB STORED_SETTINGS Parameter settings for objects
- - DBA CDB STREAMS_ADD_COLUMN Add column transformations
- - DBA CDB STREAMS_ADMINISTRATOR Users granted the privileges to be a streams administrator
- ALL DBA CDB STREAMS_COLUMNS Streams unsupported columns
- - DBA CDB STREAMS_DELETE_COLUMN Delete column transformations
- ALL DBA CDB STREAMS_GLOBAL_RULES Global rules created on the streams capture/apply/propagation process that interact with the queue
- ALL DBA CDB STREAMS_KEEP_COLUMNS Keep columns transformations
- ALL DBA CDB STREAMS_MESSAGE_CONSUMERS Streams messaging consumers
- ALL DBA CDB STREAMS_MESSAGE_RULES Rules for Streams messaging
- ALL DBA CDB STREAMS_NEWLY_SUPPORTED List of objects that are newly supported by Streams
- - DBA CDB STREAMS_RENAME_COLUMN Rename column transformations
- - DBA CDB STREAMS_RENAME_SCHEMA Rename schema transformations
- - DBA CDB STREAMS_RENAME_TABLE Rename table transformations
- ALL DBA CDB STREAMS_RULES Rules used by streams processes
- ALL DBA CDB STREAMS_SCHEMA_RULES Rules created by streams administrative APIs on all user schemas
- - DBA CDB STREAMS_SPLIT_MERGE view of details of split/merge jobs/status about streams
- - DBA CDB STREAMS_SPLIT_MERGE_HIST history view of details of split/merge jobs/status about streams
- - DBA CDB STREAMS_STMTS
- - DBA CDB STREAMS_STMT_HANDLERS
- ALL DBA CDB STREAMS_TABLE_RULES Rules created by streams administrative APIs on tables
- - DBA CDB STREAMS_TP_COMPONENT DBA Streams Component
- - DBA CDB STREAMS_TP_COMPONENT_LINK DBA Streams Component Link (Streams Topology Links)
- - DBA CDB STREAMS_TP_COMPONENT_STAT DBA Streams Component Statistics
- - DBA CDB STREAMS_TP_DATABASE DBA Streams Database
- - DBA CDB STREAMS_TP_PATH_BOTTLENECK DBA Streams Path Bottleneck
- - DBA CDB STREAMS_TP_PATH_STAT DBA Streams Path Statistics
- ALL DBA CDB STREAMS_TRANSFORMATIONS Transformations defined on rules
- ALL DBA CDB STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
- ALL DBA CDB STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
USER ALL DBA CDB SUBPARTITION_TEMPLATES
USER ALL DBA CDB SUBPART_COL_STATISTICS
USER ALL DBA CDB SUBPART_HISTOGRAMS
USER ALL DBA CDB SUBPART_KEY_COLUMNS
USER ALL DBA CDB SUBPART_KEY_COLUMNS_V$
USER - DBA CDB SUBSCR_REGISTRATIONS All subscription registrations created in the database
- ALL - - SUMDELTA Direct path load entries
- ALL - - SUMMAP mapping entries of transaction ID and commit SCN
USER ALL DBA CDB SUMMARIES Description of summaries
USER ALL DBA CDB SUMMARY_AGGREGATES
USER ALL DBA CDB SUMMARY_DETAIL_TABLES
USER ALL DBA CDB SUMMARY_JOINS
USER ALL DBA CDB SUMMARY_KEYS
- - DBA CDB SUPPLEMENTAL_LOGGING Describes the current state of supplemental logging for this database
- ALL DBA CDB SYNC_CAPTURE Details about each sync capture process that stores the captured changes in a queue
- ALL DBA CDB SYNC_CAPTURE_PREPARED_TABS All tables prepared for synchronous capture instantiation
- ALL DBA CDB SYNC_CAPTURE_TABLES All tables that are captured by synchronous streams captures.
USER ALL DBA CDB SYNONYMS Synonyms
USER - DBA CDB SYS_PRIVS System privileges granted to users and roles.
USER ALL DBA CDB TABLES Description of relational tables
USER - DBA CDB TABLESPACES Description of all tablespaces.
- - DBA CDB TABLESPACE_GROUPS Description of all tablespace groups
- - DBA CDB TABLESPACE_THRESHOLDS Space Utilization Threshold settings for all tablespaces
- - DBA CDB TABLESPACE_USAGE_METRICS Description of all tablespace space usage metrics
USER ALL DBA CDB TAB_COLS Columns of tables, views and clusters
USER ALL DBA CDB TAB_COLS_V$
USER ALL DBA CDB TAB_COLUMNS Information about columns of tables, views and clusters
USER ALL DBA ? TAB_COL_STAT_MODELS New in 21c: saved real-time statistics models
USER ALL DBA CDB TAB_COL_STATISTICS Statistics and histogram information extracted from xxx_TAB_COLUMNS
USER ALL DBA CDB TAB_COMMENTS Comments on tables and views
USER ALL DBA CDB TAB_HISTGRM_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER ALL DBA CDB TAB_HISTOGRAMS Histograms on columns.
USER ALL DBA CDB TAB_IDENTITY_COLS Describes all table identity columns
USER ALL DBA CDB TAB_MODIFICATIONS Information regarding modifications to tables
USER ALL DBA CDB TAB_PARTITIONS
USER ALL DBA CDB TAB_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER ALL DBA CDB TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
USER ALL - - TAB_PRIVS_MADE User's grants and grants on user's objects
USER ALL - - TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
USER ALL DBA CDB TAB_STATISTICS Table related Optimizer statistics
USER ALL DBA CDB TAB_STATS_HISTORY History of table statistics modifications
USER ALL DBA CDB TAB_STAT_PREFS Statistics preferences for tables
USER ALL DBA CDB TAB_SUBPARTITIONS
- - DBA CDB TEMP_FILES Information about database temp files for all instances
- - DBA CDB TEMP_FREE_SPACE Summary of temporary space usage
- - DBA CDB THRESHOLDS Description of all thresholds
USER ALL DBA CDB TRANSFORMATIONS
USER ALL DBA CDB TRIGGERS Information about triggers
USER ALL DBA CDB TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables
USER ALL DBA CDB TRIGGER_ORDERING Triggers having FOLLOWS or PRECEDES ordering accessible to the current user
USER - - - TS
- - - - TS$
- - DBA CDB TSDP_IMPORT_ERRORS Lists the errors encountered during import of Discovery Result
- - DBA CDB TSDP_POLICY_CONDITION The conditions of TSDP policies
- - DBA CDB TSDP_POLICY_FEATURE All TSDP policies in the database
- - DBA CDB TSDP_POLICY_PARAMETER Parameters of the TSDP policies
- - DBA CDB TSDP_POLICY_PROTECTION Lists the protection enabled through TSDP
- - DBA CDB TSDP_POLICY_PROTECTION_TBL
- - DBA CDB TSDP_POLICY_TYPE All TSDP policy and Sensitive Type associations
- - DBA CDB TSM_DESTINATION Transparent session migration source session statistics
- - DBA CDB TSM_HISTORY Transparent session migration statistics
- - DBA CDB TSM_SOURCE Transparent session migration source session statistics
USER ALL DBA CDB TSTZ_TABLES Description of tables which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
USER ALL DBA CDB TSTZ_TAB_COLS Columns of user's tables, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
USER - DBA CDB TS_QUOTAS Tablespace quotas assigned to users.
USER - DBA CDB TUNE_MVIEW Catalog View to show the result after executing TUNE_MVIEW() API
USER ALL DBA CDB TYPES Description of types
USER ALL DBA CDB TYPE_ATTRS Description of attributes of types
USER ALL DBA CDB TYPE_METHODS Description of methods of types
USER ALL DBA CDB TYPE_VERSIONS Description of each type version
- - DBA CDB UMF_LINK
- - DBA CDB UMF_REGISTRATION
- - DBA CDB UMF_SERVICE
- - DBA CDB UMF_TOPOLOGY
- - DBA CDB UNDO_EXTENTS Extents comprising all segments in the system managed undo tablespaces
- ALL - - UNIFIED_AUDIT_ACTIONS List of all actions audited in Unified Audit Trail
USER ALL DBA CDB UNUSED_COL_TABS All tables with unused columns
- - DBA CDB UNUSED_GRANTS
- - DBA CDB UNUSED_OBJPRIVS
- - DBA CDB UNUSED_OBJPRIVS_PATH
- - DBA CDB UNUSED_PRIVS
- - DBA CDB UNUSED_SYSPRIVS
- - DBA CDB UNUSED_SYSPRIVS_PATH
- - DBA CDB UNUSED_USERPRIVS
- - DBA CDB UNUSED_USERPRIVS_PATH
USER ALL DBA CDB UPDATABLE_COLUMNS Description of updatable columns of updatable views
- - DBA CDB USED_OBJPRIVS
- - DBA CDB USED_OBJPRIVS_PATH
- - DBA CDB USED_PRIVS
- - DBA CDB USED_PUBPRIVS
- - DBA CDB USED_SYSPRIVS
- - DBA CDB USED_SYSPRIVS_PATH
- - DBA CDB USED_USERPRIVS
- - DBA CDB USED_USERPRIVS_PATH
USER ALL DBA CDB USERS Information about all users of the database
- - DBA CDB USERS_WITH_DEFPWD Users that are still using their default passwords
USER ALL DBA CDB USTATS All statistics
USER ALL DBA CDB VARRAYS Description of varrays in tables
USER ALL DBA CDB VIEWS Description of views.
USER ALL DBA CDB VIEWS_AE Description of views
- - DBA CDB WAITERS
USER - DBA CDB WALLET_ACES Access control entries defined in wallet access control lists
- - DBA CDB WALLET_ACLS Access control lists assigned to restrict access to wallets through PL/SQL network utility packages
USER ALL DBA CDB WARNING_SETTINGS Warning settings for objects
- - DBA CDB WI_CAPTURE_FILES
- - DBA CDB WI_JOBS
- - DBA CDB WI_OBJECTS
- - DBA CDB WI_PATTERNS
- - DBA CDB WI_PATTERN_ITEMS
- - DBA CDB WI_STATEMENTS
- - DBA CDB WI_TEMPLATES
- - DBA CDB WI_TEMPLATE_EXECUTIONS
- - DBA CDB WORKLOAD_ACTIVE_USER_MAP Active user mappings to take effect for the current or next replay
- - DBA CDB WORKLOAD_CAPTURES
- - DBA CDB WORKLOAD_CAPTURE_SQLTEXT
- - DBA CDB WORKLOAD_CONNECTION_MAP
- - DBA CDB WORKLOAD_DIV_SUMMARY Replay divergence summary. Compare with dba_workload_replay_divergence
- - DBA CDB WORKLOAD_FILTERS
- - DBA CDB WORKLOAD_GROUP_ASSIGNMENTS
- - DBA CDB WORKLOAD_LONG_SQLTEXT
- - DBA CDB WORKLOAD_REPLAYS
- - DBA CDB WORKLOAD_REPLAY_CLIENTS
- - DBA CDB WORKLOAD_REPLAY_DIVERGENCE Compare with dba_workload_div_summary
- - DBA CDB WORKLOAD_REPLAY_FILTER_SET
- - DBA CDB WORKLOAD_REPLAY_IFSLA Replay-time in-flight session logon actions
- - DBA CDB WORKLOAD_REPLAY_SCHEDULES
- - DBA CDB WORKLOAD_REPLAY_THREAD
- - DBA CDB WORKLOAD_SCHEDULE_CAPTURES
- - DBA CDB WORKLOAD_SCHEDULE_ORDERING
- - DBA CDB WORKLOAD_SQL_MAP SQL remapping
- - DBA CDB WORKLOAD_TRACKED_COMMITS Tracking commits every second during replays.
- - DBA CDB WORKLOAD_USER_MAP
USER ALL DBA CDB XDS_ACL_REFRESH
USER ALL DBA CDB XDS_ACL_REFSTAT
USER ALL DBA CDB XDS_LATEST_ACL_REFSTAT
- - DBA CDB XMLSCHEMA_LEVEL_VIEW
- - DBA CDB XMLSCHEMA_LEVEL_VIEW_DUP
USER ALL DBA CDB XMLTYPE_COLS
USER - - - XML_COLUMN_NAMES
USER ALL DBA CDB XML_INDEXES Description of the XMLType indexes
USER ALL DBA CDB XML_NESTED_TABLES
USER ALL DBA CDB XML_OUT_OF_LINE_TABLES
USER - - - XML_PARTITIONED_TABLE_OK
USER ALL DBA CDB XML_SCHEMAS Description of all XML Schemas that user has privilege to reference
- ALL - - XML_SCHEMAS2 Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
USER ALL DBA CDB XML_SCHEMA_ATTRIBUTES
USER ALL DBA CDB XML_SCHEMA_COMPLEX_TYPES
- - DBA CDB XML_SCHEMA_DEPENDENCY Description of all XML schema first level dependencies on imported and included XML schemas
USER ALL DBA CDB XML_SCHEMA_ELEMENTS
- - DBA CDB XML_SCHEMA_IMPORTS Description of all XML schema first level dependencies on imported XML schemas
- - DBA CDB XML_SCHEMA_INCLUDES Description of all XML schema first level dependencies on included XML schemas
USER ALL DBA CDB XML_SCHEMA_NAMESPACES
USER ALL DBA CDB XML_SCHEMA_SIMPLE_TYPES
USER ALL DBA CDB XML_SCHEMA_SUBSTGRP_HEAD
USER ALL DBA CDB XML_SCHEMA_SUBSTGRP_MBRS
USER ALL DBA CDB XML_TABLES Description of the all XMLType tables
USER ALL DBA CDB XML_TAB_COLS Description of the all XMLType tables
USER ALL DBA CDB XML_VIEWS Description of the all XMLType views
USER ALL DBA CDB XML_VIEW_COLS Description of the all XMLType views
- ALL DBA CDB XSTREAM_ADMINISTRATOR Users granted the privileges to be a XStream administrator
- ALL DBA CDB XSTREAM_INBOUND Details about the XStream inbound server
- ALL DBA CDB XSTREAM_INBOUND_PROGRESS
- ALL DBA CDB XSTREAM_OUTBOUND Details about the XStream outbound server
- ALL DBA CDB XSTREAM_OUTBOUND_PROGRESS
- ALL DBA CDB XSTREAM_OUT_SUPPORT_MODE List of support mode for objects by XStream Out
- ALL DBA CDB XSTREAM_RULES Details about the XStream server rules
- - DBA CDB XSTREAM_SPLIT_MERGE view of details of split/merge jobs/status about XStream
- - DBA CDB XSTREAM_SPLIT_MERGE_HIST history view of details of split/merge jobs/status about XStream
- - DBA CDB XSTREAM_STMTS
- - DBA CDB XSTREAM_STMT_HANDLERS
- ALL DBA CDB XSTREAM_TRANSFORMATIONS Transformations defined on rules
USER ALL DBA CDB XS_ACES All the Real Application Security ACES of the ACLs accessible to the current user
USER ALL DBA CDB XS_ACLS All the Real Application Security ACLs accessible to the current user
USER ALL DBA CDB XS_ACL_PARAMETERS All the Real Application Security ACL parameters defined in the data security policies accessbile to the current user
- - DBA CDB XS_ACTIVE_SESSIONS All the attached application sessions in the database
- ALL - - XS_APPLICABLE_OBJECTS All the tables or views to which the current user can apply data security policies
- ALL DBA CDB XS_APPLIED_POLICIES All the database objects on which Real Application Security data security policies accessible to the current user are enabled
- - DBA CDB XS_AUDIT_POLICY_OPTIONS Describes auditing options defined under all XS security specific audit policies
USER ALL DBA CDB XS_COLUMN_CONSTRAINTS All the Real Application Security column constraints accessible to the current user
- - DBA CDB XS_DYNAMIC_ROLES All the Real Application Security dynamic roles defined in the database
- - DBA CDB XS_ENABLED_AUDIT_POLICIES Describes all XS related audit policy's enablement to users
- - DBA CDB XS_EXTERNAL_PRINCIPALS All the Real Application Security external principals
USER ALL DBA CDB XS_IMPLIED_PRIVILEGES All the Real Application Security implied privileges scoped by the security classes accessible to the current user
USER ALL DBA CDB XS_INHERITED_REALMS All the Real Application Security inherited realms accessible to the current user
- - DBA CDB XS_MODIFIED_POLICIES All Triton policies that were modified after being applied on one or more objects
- - DBA CDB XS_NS_TEMPLATES All the Real Application Security namespace templates
- - DBA CDB XS_NS_TEMPLATE_ATTRIBUTES All the attributes of Real Application Security namespace templates
- - DBA CDB XS_OBJECTS All the Real Application Security objects defined in the database
USER - - - XS_PASSWORD_LIMITS Display password limits for currently logged on application user
USER ALL DBA CDB XS_POLICIES All the Real Application Security data security policies accessible to the current user
- - DBA CDB XS_PRINCIPALS All the Real Application Security principals defined in the database
USER ALL DBA CDB XS_PRIVILEGES All the Real Application Security privileges scoped by the security classes accessible to the current user
- - DBA CDB XS_PRIVILEGE_GRANTS All the Real Application Security system or schema level privilege grants in the database
- - DBA CDB XS_PROXY_ROLES All the Real Application Security proxy role grants
USER ALL DBA CDB XS_REALM_CONSTRAINTS All the Real Application Security realms accessible to the current user
- - DBA CDB XS_ROLES All the Real Application Security roles defined in the database
- - DBA CDB XS_ROLE_GRANTS All the Real Application Security role grants
USER ALL DBA CDB XS_SECURITY_CLASSES All the Real Application Security security classes accessible to the current user
USER ALL DBA CDB XS_SECURITY_CLASS_DEP All the Real Application Security class dependencies of the security classes that are accessible to the current user
- - DBA CDB XS_SESSIONS All the application sessions in the database
- - DBA CDB XS_SESSION_NS_ATTRIBUTES Namespace attributes in application sessions as of the last saved state
- - DBA CDB XS_SESSION_ROLES Roles enabled in application sessions
USER - DBA CDB XS_USERS All the Real Application Security users defined in the database
USER ALL DBA CDB XTERNAL_LOC_PARTITIONS
USER ALL DBA CDB XTERNAL_LOC_SUBPARTITIONS
USER ALL DBA CDB XTERNAL_PART_TABLES
USER ALL DBA CDB XTERNAL_TAB_PARTITIONS
USER ALL DBA CDB XTERNAL_TAB_SUBPARTITIONS
USER ALL DBA CDB ZONEMAPS Zonemaps
USER ALL DBA CDB ZONEMAP_MEASURES Zonemap measures

Related to property graphs

Data dictionary views related to property graphs include:
USER ALL DBA CDB PG_EDGE_RELATIONSHIPS Description of the edge relationships in the property graphs
USER ALL DBA CDB PG_ELEMENTS Description of the element tables in the property graphs
USER ALL DBA CDB PG_ELEMENT_LABELS Description of the labels of the element tables in the property graphs
USER ALL DBA CDB PG_KEYS Description of the key columns
USER ALL DBA CDB PG_LABELS Description of the labels
USER ALL DBA CDB PG_LABEL_PROPERTIES Description of the properties in property graphs
USER ALL DBA CDB PG_PROP_DEFINITIONS Description of the columns and expressions exposed as properties in property graphs
USER ALL DBA CDB PROPERTY_GRAPHS Description of property graphs

Related to domains

Data dictionary views related to domains include:
USER ALL DBA CDB DOMAINS All domains
USER ALL DBA CDB DOMAIN_COLS Columns of the domains
USER ALL DBA CDB DOMAIN_CONSTRAINTS Domains constraints

Related to MLE

USER ALL DBA MLE_ENVS MLE environments
USER ALL DBA CDB MLE_ENV_IMPORTS MLE import name to module mappings.
USER ALL DBA MLE_MODULES metadata pertaining to MLE modules.
USER ALL DBA CDB MLE_PROCEDURES MLE functions and procedures

Creation of data for this table

This table was originally created with help of the following view (and this SQL statement) - and then manually edited. 
create or replace view user_all_dba_cdb_v as
with u as ( select substr(object_name, 6) obj, object_name from dba_objects where owner = 'SYS' and object_name like 'USER\_%' escape '\'),
     a as ( select substr(object_name, 5) obj, object_name from dba_objects where owner = 'SYS' and object_name like  'ALL\_%' escape '\'),
     d as ( select substr(object_name, 5) obj, object_name from dba_objects where owner = 'SYS' and object_name like  'DBA\_%' escape '\'),
     c as ( select substr(object_name, 5) obj, object_name from dba_objects where owner = 'SYS' and object_name like  'CDB\_%' escape '\'),
     o as ( select obj from u union
            select obj from a union
            select obj from d union
            select obj from c)
select
  nvl2(u.obj, 'USER', '-') u,
  nvl2(a.obj, 'ALL' , '-') a,
  nvl2(d.obj, 'DBA' , '-') d,
  nvl2(d.obj, 'CDB' , '-') c,
       o.obj               o,
--  replace(
--  replace(
--  replace(
--  replace(cu.comments, ' owned by the user' , ''),
--                       ' relational tables''s', ' relational tables'),
--                       ' in all containers'   , ''                  ),
--                       ' to the current user' , ''                  ) comment_user,
--  --
--  replace(
--  replace(ca.comments, ' accessible to the user' , ''),
--                       ' to the user'            , '') comment_all,
--  --
--  replace(cd.comments, ' owned by the user' , '') comment_dba,
--  --
--  replace(
--  replace(cc.comments, ' in all containers' , ''),
--                       ' owned by the user' , '') comment_cdb,    --  AW_PS
   cu.comments cu,
   ca.comments ca,
   cd.comments cd,
   case when cc.comments  = ' in all containers' then ''
        else cc.comments
   end                                                       cc
from
                    o                                    left join
                    u on o.obj         = u.obj           left join
                    a on o.obj         = a.obj           left join
                    d on o.obj         = d.obj           left join
                    c on o.obj         = c.obj           left join
  dba_tab_comments cu on u.object_name = cu.table_name   left join
  dba_tab_comments ca on a.object_name = ca.table_name   left join
  dba_tab_comments cd on d.object_name = cd.table_name   left join
  dba_tab_comments cc on c.object_name = cc.table_name
order by
  o.obj;
Github repository oracle-patterns, path: /Installed/data-dictionary/user_all_dba_cdb_view.sql

Gathering stats on the data dictionary views

exec dbms_stats.gather_dictionary_stats;

TODO

HIST views

See also

The select any dictionary and analyze any dictionary system privilege.
Dynamic performance views (v$…)
data dictionary cache
Special synonyms for some data dictionary views.
Create ERDs with the information that is stored in the data dictionary with SQL Developer.
Data dictionary views(?) that are owned by WMSYS.
The ANALYZE ANY DICTIONARY system privilege and the o7_dictionary_accessibility init parameter.
Almost (if not) all ALL_ views depend on x$kzsro.
NLS related views.
The dual table
MOS Note 1500058.1
audit_actions

Links

Jochen Rapp's VISKey is a lookup tool the get the select statements for the most popular data dictionary views.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(68): id_of(Object(PDO), 'referrer', 'https://renenyf...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1741941015, '3.17.74.181', 'Mozilla/5.0 App...', 'https://renenyf...') #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/index(1340): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51