SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE ‘DBA_%’ ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
—————————— —————————————————————————————————-
DBA_2PC_NEIGHBORS – information about incoming and outgoing connections for pending transactions
DBA_2PC_PENDING – info about distributed transactions awaiting recovery
DBA_ADVISOR_ACTIONS –
DBA_ADVISOR_COMMANDS –
DBA_ADVISOR_DEFINITIONS –
DBA_ADVISOR_DEF_PARAMETERS –
DBA_ADVISOR_DIRECTIVES –
DBA_ADVISOR_FINDINGS –
DBA_ADVISOR_JOURNAL –
DBA_ADVISOR_LOG –
DBA_ADVISOR_OBJECTS –
DBA_ADVISOR_OBJECT_TYPES –
DBA_ADVISOR_PARAMETERS –
DBA_ADVISOR_PARAMETERS_PROJ –
DBA_ADVISOR_RATIONALE –
DBA_ADVISOR_RECOMMENDATIONS –
DBA_ADVISOR_SQLA_REC_SUM –
DBA_ADVISOR_SQLA_WK_MAP –
DBA_ADVISOR_SQLA_WK_STMTS –
DBA_ADVISOR_SQLW_COLVOL –
DBA_ADVISOR_SQLW_JOURNAL –
DBA_ADVISOR_SQLW_PARAMETERS –
DBA_ADVISOR_SQLW_STMTS –
DBA_ADVISOR_SQLW_SUM –
DBA_ADVISOR_SQLW_TABLES –
DBA_ADVISOR_SQLW_TABVOL –
DBA_ADVISOR_SQLW_TEMPLATES –
DBA_ADVISOR_TASKS –
DBA_ADVISOR_TEMPLATES –
DBA_ADVISOR_USAGE –
DBA_ALERT_ARGUMENTS – Message Id and arguments of outstanding alerts
DBA_ALERT_HISTORY – Description on alert history
DBA_ALL_TABLES – Description of all object and relational tables in the database
DBA_ANALYZE_OBJECTS –
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_ENQUEUE – Details about the apply enqueue action
DBA_APPLY_ERROR – Error transactions
DBA_APPLY_EXECUTE – Details about the apply execute action
DBA_APPLY_INSTANTIATED_GLOBAL – Details about database instantiated
DBA_APPLY_INSTANTIATED_OBJECTS – Details about objects instantiated
DBA_APPLY_INSTANTIATED_SCHEMAS – Details about schemas instantiated
DBA_APPLY_KEY_COLUMNS – alternative key columns for a table for STREAMS
DBA_APPLY_OBJECT_DEPENDENCIES – Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS
DBA_APPLY_PARAMETERS – All parameters for apply process
DBA_APPLY_PROGRESS – Information about the progress made by apply process
DBA_APPLY_SPILL_TXN – Streams apply spilled transactions info
DBA_APPLY_TABLE_COLUMNS – Details about the destination table columns
DBA_APPLY_VALUE_DEPENDENCIES – Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS
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 – Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS – All fine grained auditing policy columns 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_OBJ – Objects in Analytic Workspaces in the database
DBA_AW_PROP – Object properties in 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_EXTRA_ATTRIBUTES – Extra attributes for a 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_CHANGE_NOTIFICATION_REGS – Description of the registrations for change notification
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_COMMON_AUDIT_TRAIL – Combined Standard and Fine Grained audit trail entries
DBA_CONNECT_ROLE_GRANTEES – Information regarding which users are granted CONNECT
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_CPU_USAGE_STATISTICS – Database CPU Usage Statistics
DBA_DATAPUMP_JOBS – Datapump jobs
DBA_DATAPUMP_SESSIONS – Datapump sessions attached to a job
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_ENABLED_AGGREGATIONS – Information about enabled on-demand statistic aggregation
DBA_ENABLED_TRACES – Information about enabled SQL traces
DBA_ENCRYPTED_COLUMNS – Encryption information on columns in the database
DBA_EPG_DAD_AUTHORIZATION – DADs authorized to use different user’s privileges
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_EXPORT_OBJECTS – Export INCLUDE and EXCLUDE object type names
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_FEATURE_USAGE_STATISTICS – Database Feature Usage Statistics
DBA_FGA_AUDIT_TRAIL – All fine grained audit event logs
DBA_FILE_GROUPS – Details about file groups
DBA_FILE_GROUP_EXPORT_INFO – Details about export information of file group versions
DBA_FILE_GROUP_FILES – Details about file group files
DBA_FILE_GROUP_TABLES – Details about the tables in the file group repository
DBA_FILE_GROUP_TABLESPACES – Details about the transportable tablespaces in the file group repository
DBA_FILE_GROUP_VERSIONS – Details about file group versions
DBA_FREE_SPACE – Free extents in all tablespaces
DBA_FREE_SPACE_COALESCED – Statistics on Coalesced Space in Tablespaces
DBA_GLOBAL_CONTEXT – Description of all context information accessible globally
DBA_HIGH_WATER_MARK_STATISTICS – Database High Water Mark Statistics
DBA_HISTOGRAMS – Synonym for DBA_TAB_HISTOGRAMS
DBA_HIST_ACTIVE_SESS_HISTORY – Active Session Historical Statistics Information
DBA_HIST_BASELINE – Baseline Metadata Information
DBA_HIST_BG_EVENT_SUMMARY – Summary of Background Event Historical Statistics Information
DBA_HIST_BUFFERED_QUEUES – STREAMS Buffered Queues Historical Statistics Information
DBA_HIST_BUFFERED_SUBSCRIBERS – STREAMS Buffered Queue Subscribers Historical Statistics Information
DBA_HIST_BUFFER_POOL_STAT – Buffer Pool Historical Statistics Information
DBA_HIST_COMP_IOSTAT – I/O stats aggregated on component level
DBA_HIST_CR_BLOCK_SERVER – Consistent Read Block Server Historical Statistics
DBA_HIST_CURRENT_BLOCK_SERVER – Current Block Server Historical Statistics
DBA_HIST_DATABASE_INSTANCE – Database Instance Information
DBA_HIST_DATAFILE – Names of Datafiles
DBA_HIST_DB_CACHE_ADVICE – DB Cache Advice History Information
DBA_HIST_DLM_MISC – Distributed Lock Manager Miscellaneous Historical Statistics Information
DBA_HIST_ENQUEUE_STAT – Enqueue Historical Statistics Information
DBA_HIST_EVENT_NAME – Event Names
DBA_HIST_FILEMETRIC_HISTORY – File Metrics History
DBA_HIST_FILESTATXS – Datafile Historical Statistics Information
DBA_HIST_INSTANCE_RECOVERY – Instance Recovery Historical Statistics Information
DBA_HIST_INST_CACHE_TRANSFER – Instance Cache Transfer Historical Statistics
DBA_HIST_JAVA_POOL_ADVICE – Java Pool Advice History
DBA_HIST_LATCH – Latch Historical Statistics Information
DBA_HIST_LATCH_CHILDREN – Latch Children Historical Statistics Information
DBA_HIST_LATCH_MISSES_SUMMARY – Latch Misses Summary Historical Statistics Information
DBA_HIST_LATCH_NAME – Latch Names
DBA_HIST_LATCH_PARENT – Latch Parent Historical Historical Statistics Information
DBA_HIST_LIBRARYCACHE – Library Cache Historical Statistics Information
DBA_HIST_LOG – Log Historical Statistics Information
DBA_HIST_METRIC_NAME – Segment Names
DBA_HIST_MTTR_TARGET_ADVICE – Mean-Time-To-Recover Target Advice History
DBA_HIST_OPTIMIZER_ENV – Optimizer Environment Information
DBA_HIST_OSSTAT – Operating System Historical Statistics Information
DBA_HIST_OSSTAT_NAME – Operating System Statistic Names
DBA_HIST_PARAMETER – Parameter Historical Statistics Information
DBA_HIST_PARAMETER_NAME – Parameter Names
DBA_HIST_PGASTAT – PGA Historical Statistics Information
DBA_HIST_PGA_TARGET_ADVICE – PGA Target Advice History
DBA_HIST_PROCESS_MEM_SUMMARY – Process Memory Historical Summary Information
DBA_HIST_RESOURCE_LIMIT – Resource Limit Historical Statistics Information
DBA_HIST_ROWCACHE_SUMMARY – Row Cache Historical Statistics Information Summary
DBA_HIST_RULE_SET – Rule sets historical statistics information
DBA_HIST_SEG_STAT – Historical Statistics Information
DBA_HIST_SEG_STAT_OBJ – Segment Names
DBA_HIST_SERVICE_NAME – Service Names
DBA_HIST_SERVICE_STAT – Historical Service Statistics
DBA_HIST_SERVICE_WAIT_CLASS – Historical Service Wait Class Statistics
DBA_HIST_SESSMETRIC_HISTORY – System Metrics History
DBA_HIST_SESS_TIME_STATS – CPU and I/O time for interesting (STREAMS) sessions
DBA_HIST_SGA – SGA Historical Statistics Information
DBA_HIST_SGASTAT – SGA Pool Historical Statistics Information
DBA_HIST_SGA_TARGET_ADVICE – SGA Target Advice History
DBA_HIST_SHARED_POOL_ADVICE – Shared Pool Advice History
DBA_HIST_SNAPSHOT – Snapshot Information
DBA_HIST_SNAP_ERROR – Snapshot Error Information
DBA_HIST_SQLBIND – SQL Bind Information
DBA_HIST_SQLSTAT – SQL Historical Statistics Information
DBA_HIST_SQLTEXT – SQL Text
DBA_HIST_SQL_BIND_METADATA – SQL Bind Metadata Information
DBA_HIST_SQL_PLAN – SQL Plan Information
DBA_HIST_SQL_SUMMARY – Summary of SQL Statistics
DBA_HIST_SQL_WORKAREA_HSTGRM – SQL Workarea Histogram History
DBA_HIST_STAT_NAME – Statistic Names
DBA_HIST_STREAMS_APPLY_SUM – STREAMS Apply Historical Statistics Information
DBA_HIST_STREAMS_CAPTURE – STREAMS Capture Historical Statistics Information
DBA_HIST_STREAMS_POOL_ADVICE – Streams Pool Advice History
DBA_HIST_SYSMETRIC_HISTORY – System Metrics History
DBA_HIST_SYSMETRIC_SUMMARY – System Metrics History
DBA_HIST_SYSSTAT – System Historical Statistics Information
DBA_HIST_SYSTEM_EVENT – System Event Historical Statistics Information
DBA_HIST_SYS_TIME_MODEL – System Time Model Historical Statistics Information
DBA_HIST_TABLESPACE_STAT – Tablespace Historical Statistics Information
DBA_HIST_TBSPC_SPACE_USAGE – Tablespace Usage Historical Statistics Information
DBA_HIST_TEMPFILE – Names of Temporary Datafiles
DBA_HIST_TEMPSTATXS – Temporary Datafile Historical Statistics Information
DBA_HIST_THREAD – Thread Historical Statistics Information
DBA_HIST_UNDOSTAT – Undo Historical Statistics Information
DBA_HIST_WAITCLASSMET_HISTORY – Wait Class Metric History
DBA_HIST_WAITSTAT – Wait Historical Statistics Information
DBA_HIST_WR_CONTROL – Workload Repository Control Information
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_ARRAYTYPES – All array types specified by the indextype
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_STATISTICS – Optimizer statistics for all indexes in the database
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_LOGMNR_LOG –
DBA_LOGMNR_PURGED_LOG –
DBA_LOGMNR_SESSION –
DBA_LOGSTDBY_EVENTS – Information on why logical standby events
DBA_LOGSTDBY_HISTORY – Information on processed, active, and pending log streams
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_COMMENTS – Comments on all materialized views in the database
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_NESTED_TABLE_COLS – Columns of nested 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 with atleast one option set
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_OPTSTAT_OPERATIONS – History of statistics operations performed
DBA_OUTLINES – Stored outlines
DBA_OUTLINE_HINTS – Hints stored in outlines
DBA_OUTSTANDING_ALERTS – Description of all outstanding alerts
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_PLSQL_OBJECT_SETTINGS – Compiler settings of all objects in the database
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 – Source columns available for Change Data Capture
DBA_QUEUES – All database queues
DBA_QUEUE_PUBLISHERS –
DBA_QUEUE_SCHEDULES –
DBA_QUEUE_SUBSCRIBERS – queue subscribers in the database
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_RECOVERABLE_SCRIPT – Details about recoverable operations
DBA_RECOVERABLE_SCRIPT_BLOCKS – Details about the recoverable script blocks
DBA_RECOVERABLE_SCRIPT_ERRORS – Details showing errors during script execution
DBA_RECOVERABLE_SCRIPT_PARAMS – Details about the recoverable operation parameters
DBA_RECYCLEBIN – Description of the Recyclebin view accessible to the user
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_ARCHIVED_LOG – Details about the registered log files
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_REGISTRY_HISTORY –
DBA_REGISTRY_LOG –
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_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_RESOURCE_INCARNATIONS – Resource incarnations that are running or eligible for HA status notification
DBA_RESUMABLE – Resumable session information in the system
DBA_REWRITE_EQUIVALENCES – Description of rewrite equivalence accessible to DBA
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_GROUP_MAPPINGS – all the consumer group mappings
DBA_RSRC_MANAGER_SYSTEM_PRIVS – system privileges for the resource manager
DBA_RSRC_MAPPING_PRIORITY – the consumer group mapping attribute priorities
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_SCHEDULER_CHAINS – All scheduler chains in the database
DBA_SCHEDULER_CHAIN_RULES – All rules from scheduler chains in the database
DBA_SCHEDULER_CHAIN_STEPS – All steps of scheduler chains in the database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE – All scheduler global attributes
DBA_SCHEDULER_JOBS – All scheduler jobs in the database
DBA_SCHEDULER_JOB_ARGS – All arguments with set values of all scheduler jobs in the database
DBA_SCHEDULER_JOB_CLASSES – All scheduler classes in the database
DBA_SCHEDULER_JOB_LOG – Logged information for all scheduler jobs
DBA_SCHEDULER_JOB_RUN_DETAILS – The details of a job run
DBA_SCHEDULER_PROGRAMS – All scheduler programs in the database
DBA_SCHEDULER_PROGRAM_ARGS – All arguments of all scheduler programs in the database
DBA_SCHEDULER_RUNNING_CHAINS – All steps of all running chains in the database
DBA_SCHEDULER_SCHEDULES – All schedules in the database
DBA_SCHEDULER_WINDOWS – All scheduler windows in the database
DBA_SCHEDULER_WINDOW_DETAILS – The details of a window
DBA_SCHEDULER_WINDOW_GROUPS – All scheduler window groups in the database
DBA_SCHEDULER_WINDOW_LOG – Logged information for all scheduler windows
DBA_SCHEDULER_WINGROUP_MEMBERS – Members of all scheduler window groups in the database
DBA_SECONDARY_OBJECTS – All secondary objects for domain indexes
DBA_SEC_RELEVANT_COLS – Security Relevant columns of all VPD policies in the database
DBA_SEGMENTS – Storage allocated for all database segments
DBA_SEGMENTS_OLD – Storage allocated for all database segments
DBA_SEQUENCES – Description of all SEQUENCEs in the database
DBA_SERVER_REGISTRY –
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 – Source tables available for Change Data Capture
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_SQLSET –
DBA_SQLSET_BINDS –
DBA_SQLSET_DEFINITIONS – Synonym for DBA_SQLSET
DBA_SQLSET_PLANS –
DBA_SQLSET_REFERENCES –
DBA_SQLSET_STATEMENTS –
DBA_SQLTUNE_BINDS –
DBA_SQLTUNE_PLANS –
DBA_SQLTUNE_RATIONALE_PLAN –
DBA_SQLTUNE_STATISTICS –
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_ADD_COLUMN – Add column transformations
DBA_STREAMS_ADMINISTRATOR – Users granted the privileges to be a streams administrator
DBA_STREAMS_DELETE_COLUMN – Delete column transformations
DBA_STREAMS_GLOBAL_RULES – Global rules created by streams administrative APIs
DBA_STREAMS_MESSAGE_CONSUMERS – Streams messaging consumers
DBA_STREAMS_MESSAGE_RULES – Rules for Streams messaging
DBA_STREAMS_NEWLY_SUPPORTED – List of tables that are newly supported by Streams
DBA_STREAMS_RENAME_COLUMN – Rename column transformations
DBA_STREAMS_RENAME_SCHEMA – Rename schema transformations
DBA_STREAMS_RENAME_TABLE – Rename table transformations
DBA_STREAMS_RULES – Rules used by Streams processes
DBA_STREAMS_SCHEMA_RULES – Schema rules created by streams administrative APIs
DBA_STREAMS_TABLE_RULES – Table rules created by streams administrative APIs
DBA_STREAMS_TRANSFORMATIONS – Transformations defined on rules
DBA_STREAMS_TRANSFORM_FUNCTION – Rules-based transform functions used by Streams
DBA_STREAMS_UNSUPPORTED – List of all the tables that are not supported by Streams in this release
DBA_SUBPARTITION_TEMPLATES –
DBA_SUBPART_COL_STATISTICS –
DBA_SUBPART_HISTOGRAMS –
DBA_SUBPART_KEY_COLUMNS –
DBA_SUBSCRIBED_COLUMNS – Change Data Capture subscribed columns
DBA_SUBSCRIBED_TABLES – Change Data Capture subscribed tables
DBA_SUBSCRIPTIONS – Change Data Capture subscriptions
DBA_SUMMARIES – Description of the summaries accessible to dba
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_TABLESPACE_GROUPS – Description of all tablespace groups
DBA_TABLESPACE_USAGE_METRICS – Description of all tablespace space usage metrics
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_STATISTICS – Optimizer statistics for all tables in the database
DBA_TAB_STATS_HISTORY – History of table statistics modifications
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_THRESHOLDS – Desription of all thresholds
DBA_TRANSFORMATIONS –
DBA_TRIGGERS – All triggers in the database
DBA_TRIGGER_COLS – Column usage in all triggers
DBA_TSM_DESTINATION – Transparent session migration source session statistics
DBA_TSM_HISTORY – Transparent session migration statistics
DBA_TSM_SOURCE – Transparent session migration source session statistics
DBA_TS_QUOTAS – Tablespace quotas for all users
DBA_TUNE_MVIEW – Catalog View to show the result after executing TUNE_MVIEW() API
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_WARNING_SETTINGS – warning settings for all objects
DBA_WORKSPACES –
DBA_WORKSPACE_SESSIONS –
DBA_XML_INDEXES – Description of all XML indexes in the database
DBA_XML_SCHEMAS – Description of all the XML Schemas registered
DBA_XML_TABLES – Description of all XML tables in the database
DBA_XML_TAB_COLS – Description of all XML tables in the database
DBA_XML_VIEWS – Description of all XML views in the database
DBA_XML_VIEW_COLS – Description of all XML views in the database

515 rows selected.

SQL> SPOOL OFF;

PrintFriendly

Viewers of this post also viewed...