Thursday 4 July 2013

Details of Oracle Dictionary – DBA Views

Oracle Dictionaries in the database with descriptions:


TABLE_NAME COMMENTS
DBA_CONS_COLUMNS Information about accessible columns in constraint definitions
DBA_LOG_GROUP_COLUMNS Information about columns in log group definitions
DBA_LOBS Description of LOBs contained in all tables
DBA_CATALOG All database Tables, Views, Synonyms, Sequences
DBA_CLUSTERS Description of all clusters in the database
DBA_CLU_COLUMNS Mapping of table columns to cluster columns
DBA_COL_COMMENTS Comments on columns of all tables and views
DBA_COL_PRIVS All grants on columns in the database
DBA_ENCRYPTED_COLUMNS Encryption information on columns in the database
DBA_INDEXES Description for all indexes in the database
DBA_IND_COLUMNS COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
DBA_IND_EXPRESSIONS FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
DBA_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
DBA_OBJECTS All objects in the database
DBA_OBJECTS_AE All objects in the database
DBA_ROLLBACK_SEGS Description of rollback segments
DBA_ROLE_PRIVS Roles granted to users and roles
DBA_SEQUENCES Description of all SEQUENCEs in the database
DBA_SYNONYMS All synonyms in the database
DBA_TABLES Description of all relational tables in the database
DBA_OBJECT_TABLES Description of all object tables in the database
DBA_ALL_TABLES Description of all object and relational tables in the database
DBA_TAB_COLS Columns of user’s tables, views and clusters
DBA_TAB_COLUMNS Columns of user’s tables, views and clusters
DBA_TAB_COMMENTS Comments on all tables and views in the database
DBA_TAB_PRIVS All grants on objects in the database
DBA_VIEWS Description of all views in the database
DBA_VIEWS_AE Description of all views in the database
DBA_CONSTRAINTS Constraint definitions on all tables
DBA_LOG_GROUPS Log group definitions on all tables
DBA_CLUSTER_HASH_EXPRESSIONS Hash functions for all clusters
DBA_UPDATABLE_COLUMNS Description of dba updatable columns
DBA_UNUSED_COL_TABS All tables with unused columns in the database
DBA_PARTIAL_DROP_TABS All tables with partially dropped columns in the database
DBA_RESUMABLE Resumable session information in the system
DBA_EDITIONING_VIEWS Description of all Editioning Views in the database
DBA_EDITIONING_VIEWS_AE Description of all Editioning Views in the database
DBA_EDITIONING_VIEW_COLS Relationship between columns of all Editioning Views in the database and the table columns to which they map
DBA_EDITIONING_VIEW_COLS_AE Relationship between columns of all Editioning Views in the database and the table columns to which they map
DBA_EDITIONS Describes all editions in the database
DBA_EDITION_COMMENTS Describes comments on all editions in the database
DBA_LIBRARIES Description of all libraries in the database
DBA_PROCEDURES Description of the dba functions/procedures/packages/types/triggers
DBA_STORED_SETTINGS Parameter settings for all objects
DBA_PLSQL_OBJECT_SETTINGS Compiler settings of all objects in the database
DBA_ARGUMENTS All arguments for objects in the database
DBA_ASSEMBLIES Description of all assemblies in the database
DBA_IDENTIFIERS Identifiers in stored objects accessible to sys
DBA_DB_LINKS All database links in the database
DBA_RECYCLEBIN Description of the Recyclebin view accessible to the user
DBA_2PC_PENDING info about distributed transactions awaiting recovery
DBA_2PC_NEIGHBORS information about incoming and outgoing connections for pending transactions
DBA_PROFILES Display all profiles and their limits
DBA_USERS Information about all users of the database
DBA_OBJ_AUDIT_OPTS Auditing options for all tables and views with atleast one option set
DBA_STMT_AUDIT_OPTS Describes current system auditing options across the system and by user
DBA_PRIV_AUDIT_OPTS Describes current system privileges being audited across the system and by user
DBA_AUDIT_TRAIL All audit trail entries
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_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_EXISTS Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
DBA_ROLES All Roles which exist in the database
DBA_SYS_PRIVS System privileges granted to users and roles
DBA_PROXIES Information about all proxy connections
DBA_CONNECT_ROLE_GRANTEES Information regarding which users are granted CONNECT
DBA_TYPES Description of all types in the database
DBA_COLL_TYPES Description of all named collection 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_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_SQLJ_TYPES Description of all types in the database
DBA_TYPE_VERSIONS Description of each type version in the database
DBA_PENDING_CONV_TABLES All tables which are not upgraded to the latest type version 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_OLDIMAGE_COLUMNS Gives all object tables and columns in old (8.0) image format
DBA_NESTED_TABLE_COLS Columns of nested tables
DBA_DIRECTORIES Description of all directories
DBA_REFS Description of REF columns contained in all tables
DBA_NESTED_TABLES Description of nested tables contained in all tables
DBA_VARRAYS Description of varrays in tables accessible to the user
DBA_OBJ_COLATTRS Description of object columns and attributes contained in all tables in the database
DBA_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in all tables in the database
DBA_OPERATORS All operators
DBA_OPBINDINGS All operator binding functiosn or methods
DBA_OPANCILLARY All ancillary operators
DBA_OPARGUMENTS All operator arguments
DBA_OPERATOR_COMMENTS Comments for user-defined operators
DBA_INDEXTYPES All indextypes
DBA_INDEXTYPE_COMMENTS Comments for user-defined indextypes
DBA_INDEXTYPE_ARRAYTYPES All array types specified by the indextype
DBA_INDEXTYPE_OPERATORS All indextype operators
DBA_SECONDARY_OBJECTS All secondary objects for domain indexes
DBA_SOURCE_TABLES Source tables available for Change Data Capture
DBA_PUBLISHED_COLUMNS Source columns available for Change Data Capture
DBA_SUBSCRIPTIONS Change Data Capture subscriptions
DBA_SUBSCRIBED_TABLES Change Data Capture subscribed tables
DBA_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
DBA_EXP_OBJECTS Objects that have been incrementally exported
DBA_EXP_VERSION Version number of the last export session
DBA_EXP_FILES Description of export files
DBA_EXTERNAL_TABLES Description of the external tables accessible to the DBA
DBA_EXTERNAL_LOCATIONS Description of the external tables locations accessible to the DBA
DBA_MINING_MODELS Description of all the models in the database
DBA_MINING_MODEL_ATTRIBUTES Description of all the model attributes in the database
DBA_MINING_MODEL_SETTINGS Description of all the model settings in the database
DBA_MINING_MODEL_TABLES Description of all the mining model tables in the system
DBA_TAB_COL_STATISTICS Columns of user’s tables, views and clusters
DBA_TAB_HISTOGRAMS Histograms on columns of all tables
DBA_ASSOCIATIONS All associations
DBA_USTATS All statistics collected on either tables or indexes
DBA_TAB_MODIFICATIONS Information regarding modifications to tables
DBA_OPTSTAT_OPERATIONS History of statistics operations performed
DBA_TAB_STATS_HISTORY History of table statistics modifications
DBA_TAB_STAT_PREFS Statistics preferences for tables
DBA_TAB_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_IND_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_COL_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_TAB_HISTGRM_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_DIMENSIONS Description of the dimension objects accessible to the DBA
DBA_DIM_LEVELS Description of dimension levels visible to DBA
DBA_DIM_LEVEL_KEY Representations of columns of a dimension level
DBA_DIM_ATTRIBUTES Representation of the relationship between a dimension level and  a functionally dependent column
DBA_DIM_HIERARCHIES Representation of a dimension hierarchy
DBA_DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
DBA_DIM_JOIN_KEY Representation of a join between two dimension tables.
DBA_SUMMARIES Description of the summaries accessible to dba
DBA_MVIEW_ANALYSIS Description of the materialized views accessible to dba
DBA_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to dba
DBA_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables 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_JOINS Description of a join between two columns in the WHERE clause of a materialized view accessible to dba
DBA_MVIEW_COMMENTS Comments on all materialized views in the database
DBA_REWRITE_EQUIVALENCES Description of rewrite equivalence accessible to DBA
DBA_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the database
DBA_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the database
DBA_TSTZ_TAB_COLS Columns of all tables in the database, 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
DBA_TSTZ_TABLES Description of all tables in the database, 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
DBA_ERRORS Current errors on all stored objects in the database
DBA_ERRORS_AE Current errors on all stored objects in the database
DBA_SOURCE_AE Source of all stored objects in the database
DBA_SOURCE Source of all stored objects in the database
DBA_TRIGGERS All triggers in the database
DBA_INTERNAL_TRIGGERS Description of the internal triggers on all tables in the database
DBA_TRIGGER_COLS Column usage in all triggers
DBA_DEPENDENCIES Dependencies to and from objects
DBA_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects
DBA_TRIGGER_ORDERING All triggers having FOLLOWS or PRECEDES ordering in the database
DBA_JOBS_RUNNING All jobs in the database which are currently running, join v$lock and job$
DBA_JOBS All jobs in the database
DBA_SEGMENTS Storage allocated for all database segments
DBA_SEGMENTS_OLD Storage allocated for all database segments
DBA_EXTENTS Extents comprising all segments in the database
DBA_UNDO_EXTENTS Extents comprising all segments in the system managed undo tablespaces
DBA_LMT_USED_EXTENTS All extents in the locally managed tablespaces
DBA_DMT_USED_EXTENTS All extents in the dictionary managed tablespaces
DBA_FREE_SPACE Free extents in all tablespaces
DBA_LMT_FREE_SPACE Free extents in all locally managed tablespaces
DBA_DMT_FREE_SPACE Free extents in all dictionary managed tablespaces
DBA_FREE_SPACE_COALESCED Statistics on Coalesced Space in Tablespaces
DBA_DATA_FILES Information about database data files
DBA_TABLESPACES Description of all tablespaces
DBA_TEMP_FILES Information about database temp files
DBA_TABLESPACE_GROUPS Description of all tablespace groups
DBA_TABLESPACE_USAGE_METRICS Description of all tablespace space usage metrics
DBA_TS_QUOTAS Tablespace quotas for all users
DBA_TEMP_FREE_SPACE Summary of temporary space usage
DBA_CONTEXT Description of all context namespace information
DBA_GLOBAL_CONTEXT Description of all context information accessible globally
DBA_RULE_SETS Rule sets in the database
DBA_RULESETS Rulesets in the database: maintained for backward compatibility
DBA_RULES Rules in the databse
DBA_RULE_SET_RULES Rules in all rule sets 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_SNAPSHOTS All snapshots in the database
DBA_SNAPSHOT_LOGS All snapshot logs in the database
DBA_RCHILD All the children in any refresh group.  This view is not a join.
DBA_RGROUP All refresh groups.  This view is not a join.
DBA_REFRESH All the refresh groups
DBA_REFRESH_CHILDREN All the objects in refresh groups
DBA_REGISTERED_SNAPSHOTS Remote snapshots of local tables
DBA_MVIEWS All materialized views in the database
DBA_MVIEW_REFRESH_TIMES All fast refreshable materialized views and their last refresh times for each master table
DBA_MVIEW_LOGS All materialized view logs in the database
DBA_BASE_TABLE_MVIEWS All materialized views with log(s) in the database
DBA_REGISTERED_MVIEWS Remote materialized views of local tables
DBA_MVIEW_LOG_FILTER_COLS All filter columns (excluding PK cols) being logged in the materialized view logs
DBA_POLICIES All row level security policies in the database
DBA_POLICY_GROUPS All policy groups defined for any synonym, table, view in the database
DBA_POLICY_CONTEXTS All policy driving context defined for any synonym, table, or view in the database
DBA_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies in the database
DBA_AUDIT_POLICIES Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
DBA_FGA_AUDIT_TRAIL All fine grained audit event logs
DBA_COMMON_AUDIT_TRAIL Combined Standard and Fine Grained audit trail entries
DBA_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_AUDIT_MGMT_LAST_ARCH_TS The Last Archive Timestamps set for the Audit Trail Clean up
DBA_AUDIT_MGMT_CLEANUP_JOBS The view displays the currently configured audit trail purge jobs
DBA_AUDIT_MGMT_CLEAN_EVENTS The history of cleanup events
DBA_TSM_SOURCE Transparent session migration source session statistics
DBA_TSM_DESTINATION Transparent session migration source session statistics
DBA_TSM_HISTORY Transparent session migration statistics
DBA_CHANGE_NOTIFICATION_REGS Description of the registrations for change notification
DBA_CQ_NOTIFICATION_QUERIES Description of registered queries for CQ notification
DBA_CPOOL_INFO Connection pool info
DBA_SSCR_CAPTURE Session state capture statistics
DBA_SSCR_RESTORE Session state restore statistics
DBA_SUBSCR_REGISTRATIONS All subscription registrations created in the database
DBA_QUEUE_TABLES All queue tables created in the database
DBA_QUEUES All database queues
DBA_RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
DBA_RSRC_PLANS All the resource plans
DBA_RSRC_CONSUMER_GROUPS all the resource consumer groups
DBA_RSRC_CATEGORIES All resource consumer group categories
DBA_RSRC_PLAN_DIRECTIVES all the resource plan directives
DBA_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups
DBA_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
DBA_RSRC_GROUP_MAPPINGS all the consumer group mappings
DBA_RSRC_MAPPING_PRIORITY the consumer group mapping attribute priorities
DBA_RSRC_STORAGE_POOL_MAPPING resource manager rules for mapping files to storage pools
DBA_RSRC_CAPABILITY settings for database resources that are capable of being managed by the Resource Manager
DBA_RSRC_INSTANCE_CAPABILITY per-instance settings for database resources that are capable of being managed by the Resource Manager
DBA_RSRC_IO_CALIBRATE Results of the most recent I/O calibration
DBA_OUTLINES Stored outlines
DBA_OUTLINE_HINTS Hints stored in outlines
DBA_DATAPUMP_JOBS Datapump jobs
DBA_DATAPUMP_SESSIONS Datapump sessions attached to a job
DBA_FEATURE_USAGE_STATISTICS Database Feature Usage Statistics
DBA_HIGH_WATER_MARK_STATISTICS Database High Water Mark Statistics
DBA_CPU_USAGE_STATISTICS Database CPU Usage Statistics
DBA_ALERT_ARGUMENTS Message Id and arguments of outstanding alerts
DBA_ENABLED_TRACES Information about enabled SQL traces
DBA_ENABLED_AGGREGATIONS Information about enabled on-demand statistic aggregation
DBA_HIST_DATABASE_INSTANCE Database Instance Information
DBA_HIST_SNAPSHOT Snapshot Information
DBA_HIST_SNAP_ERROR Snapshot Error Information
DBA_HIST_COLORED_SQL Marked SQLs for snapshots
DBA_HIST_BASELINE_METADATA Baseline Metadata Information
DBA_HIST_BASELINE_TEMPLATE Baseline Template Information
DBA_HIST_WR_CONTROL Workload Repository Control Information
DBA_HIST_DATAFILE Names of Datafiles
DBA_HIST_FILESTATXS Datafile Historical Statistics Information
DBA_HIST_TEMPFILE Names of Temporary Datafiles
DBA_HIST_TEMPSTATXS Temporary Datafile Historical Statistics Information
DBA_HIST_COMP_IOSTAT I/O stats aggregated on component level
DBA_HIST_SQLSTAT SQL Historical Statistics Information
DBA_HIST_SQLTEXT SQL Text
DBA_HIST_SQL_SUMMARY Summary of SQL Statistics
DBA_HIST_SQL_PLAN SQL Plan Information
DBA_HIST_SQL_BIND_METADATA SQL Bind Metadata Information
DBA_HIST_OPTIMIZER_ENV Optimizer Environment Information
DBA_HIST_EVENT_NAME Event Names
DBA_HIST_SYSTEM_EVENT System Event Historical Statistics Information
DBA_HIST_BG_EVENT_SUMMARY Summary of Background Event Historical Statistics Information
DBA_HIST_WAITSTAT Wait Historical Statistics Information
DBA_HIST_ENQUEUE_STAT Enqueue Historical Statistics Information
DBA_HIST_LATCH_NAME Latch Names
DBA_HIST_LATCH Latch Historical Statistics Information
DBA_HIST_LATCH_CHILDREN Latch Children Historical Statistics Information
DBA_HIST_LATCH_PARENT Latch Parent Historical Historical Statistics Information
DBA_HIST_LATCH_MISSES_SUMMARY Latch Misses Summary Historical Statistics Information
DBA_HIST_EVENT_HISTOGRAM Event Histogram Historical Statistics Information
DBA_HIST_MUTEX_SLEEP Mutex Sleep Summary Historical Statistics Information
DBA_HIST_LIBRARYCACHE Library Cache Historical Statistics Information
DBA_HIST_DB_CACHE_ADVICE DB Cache Advice History Information
DBA_HIST_BUFFER_POOL_STAT Buffer Pool Historical Statistics Information
DBA_HIST_ROWCACHE_SUMMARY Row Cache Historical Statistics Information Summary
DBA_HIST_SGA SGA Historical Statistics Information
DBA_HIST_SGASTAT SGA Pool Historical Statistics Information
DBA_HIST_PGASTAT PGA Historical Statistics Information
DBA_HIST_PROCESS_MEM_SUMMARY Process Memory Historical Summary Information
DBA_HIST_RESOURCE_LIMIT Resource Limit Historical Statistics Information
DBA_HIST_SHARED_POOL_ADVICE Shared Pool Advice History
DBA_HIST_STREAMS_POOL_ADVICE Streams Pool Advice History
DBA_HIST_SQL_WORKAREA_HSTGRM SQL Workarea Histogram History
DBA_HIST_PGA_TARGET_ADVICE PGA Target Advice History
DBA_HIST_SGA_TARGET_ADVICE SGA Target Advice History
DBA_HIST_MEMORY_TARGET_ADVICE Memory Target Advice History
DBA_HIST_MEMORY_RESIZE_OPS Memory Resize Operations History
DBA_HIST_INSTANCE_RECOVERY Instance Recovery Historical Statistics Information
DBA_HIST_JAVA_POOL_ADVICE Java Pool Advice History
DBA_HIST_THREAD Thread Historical Statistics Information
DBA_HIST_STAT_NAME Statistic Names
DBA_HIST_SYSSTAT System Historical Statistics Information
DBA_HIST_SYS_TIME_MODEL System Time Model Historical Statistics Information
DBA_HIST_OSSTAT_NAME Operating System Statistic Names
DBA_HIST_OSSTAT Operating System Historical Statistics Information
DBA_HIST_PARAMETER_NAME Parameter Names
DBA_HIST_PARAMETER Parameter Historical Statistics Information
DBA_HIST_UNDOSTAT Undo Historical Statistics Information
DBA_HIST_SEG_STAT  Historical Statistics Information
DBA_HIST_SEG_STAT_OBJ Segment Names
DBA_HIST_METRIC_NAME Segment Names
DBA_HIST_SYSMETRIC_HISTORY System Metrics History
DBA_HIST_SYSMETRIC_SUMMARY System Metrics History
DBA_HIST_SESSMETRIC_HISTORY System Metrics History
DBA_HIST_FILEMETRIC_HISTORY File Metrics History
DBA_HIST_WAITCLASSMET_HISTORY Wait Class Metric History
DBA_HIST_DLM_MISC Distributed Lock Manager Miscellaneous Historical Statistics Information
DBA_HIST_CR_BLOCK_SERVER Consistent Read Block Server Historical Statistics
DBA_HIST_CURRENT_BLOCK_SERVER Current Block Server Historical Statistics
DBA_HIST_INST_CACHE_TRANSFER Instance Cache Transfer Historical Statistics
DBA_HIST_PLAN_OPERATION_NAME Optimizer Explain Plan Operation Names
DBA_HIST_PLAN_OPTION_NAME Optimizer Explain Plan Option Names
DBA_HIST_SQLCOMMAND_NAME Sql command types
DBA_HIST_TOPLEVELCALL_NAME Oracle top level call type
DBA_HIST_ACTIVE_SESS_HISTORY Active Session Historical Statistics Information
DBA_HIST_TABLESPACE_STAT Tablespace Historical Statistics Information
DBA_HIST_LOG Log Historical Statistics Information
DBA_HIST_MTTR_TARGET_ADVICE Mean-Time-To-Recover Target Advice History
DBA_HIST_TBSPC_SPACE_USAGE Tablespace Usage Historical Statistics Information
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_SESS_TIME_STATS CPU and I/O time for interesting (STREAMS) sessions
DBA_HIST_STREAMS_CAPTURE STREAMS Capture Historical Statistics Information
DBA_HIST_STREAMS_APPLY_SUM STREAMS Apply 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_RULE_SET Rule sets historical statistics information
DBA_HIST_PERSISTENT_QUEUES STREAMS AQ Persistent Queues Historical Statistics Information
DBA_HIST_PERSISTENT_SUBS STREAMS AQ Persistent Queue Subscribers Historical Statistics Information
DBA_HIST_IOSTAT_FUNCTION Historical I/O statistics by function
DBA_HIST_IOSTAT_FUNCTION_NAME Function names for historical I/O statistics
DBA_HIST_IOSTAT_FILETYPE Historical I/O statistics by file type
DBA_HIST_IOSTAT_FILETYPE_NAME File type names for historical I/O statistics
DBA_HIST_IOSTAT_DETAIL Historical I/O statistics by function and filetype
DBA_HIST_RSRC_CONSUMER_GROUP Historical resource consumer group statistics
DBA_HIST_RSRC_PLAN Historical resource plan statistics
DBA_HIST_CLUSTER_INTERCON Cluster Interconnect Historical Stats
DBA_HIST_MEM_DYNAMIC_COMP Historical memory component sizes
DBA_HIST_IC_CLIENT_STATS Historical interconnect client statistics
DBA_HIST_IC_DEVICE_STATS Historical interconnect device statistics
DBA_HIST_INTERCONNECT_PINGS Instance to instance ping stats
DBA_HIST_DISPATCHER Dispatcher statistics
DBA_HIST_SHARED_SERVER_SUMMARY Shared Server summary statistics
DBA_HIST_DYN_REMASTER_STATS Dynamic remastering statistics
DBA_SQL_PROFILES set of sql profiles
DBA_SQL_PLAN_BASELINES set of plan baselines
DBA_SQL_PATCHES set of sql patches
DBA_REGISTERED_SNAPSHOT_GROUPS Snapshot repgroup registration information
DBA_REGISTERED_MVIEW_GROUPS Materialized view repgroup registration information
DBA_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
DBA_REPGROUP Information about all replicated object groups
DBA_REPSITES N-way replication information
DBA_REPSCHEMA N-way replication information
DBA_REPOBJECT Information about replicated objects
DBA_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
DBA_REPPROP Propagation information about replicated objects
DBA_REPKEY_COLUMNS Primary columns for a table using column-level replication
DBA_REPGENOBJECTS Objects generated to support replication
DBA_REPGENERATED Objects generated to support replication
DBA_REPCATLOG Information about asynchronous administration requests
DBA_REPDDL Arguments that do not fit in a single repcat log record
DBA_REPPRIORITY_GROUP Information about all priority groups in the database
DBA_REPPRIORITY Values and their corresponding priorities in all priority groups in the database
DBA_REPCOLUMN_GROUP All column groups of replicated tables in the database
DBA_REPGROUPED_COLUMN Columns in the all column groups of replicated tables in the database
DBA_REPCONFLICT All conflicts for which users have specified resolutions in the database
DBA_REPRESOLUTION_METHOD All conflict resolution methods in the database
DBA_REPRESOLUTION Description of all conflict resolutions 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_REPPARAMETER_COLUMN All columns used for resolving conflicts in the database
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_REPFLAVORS Flavors defined for replicated object groups
DBA_REPFLAVOR_OBJECTS Replicated objects in flavors
DBA_REPFLAVOR_COLUMNS Replicated columns in flavors
DBA_TEMPLATE_REFGROUPS Table for maintaining refresh group information for template.
DBA_TEMPLATE_TARGETS Internal table for tracking potential target databases for templates.
DBA_REPCAT_EXCEPTIONS Repcat processing exceptions table.
DBA_REPEXTENSIONS Information about replication extension requests
DBA_REPSITES_NEW Information about new masters for replication extension
DBA_USERS_WITH_DEFPWD Users that are still using their default passwords
DBA_WARNING_SETTINGS warning settings for all objects
DBA_STAT_EXTENSIONS Optimizer statistics extensions
DBA_TAB_STATISTICS Optimizer statistics for all tables in the database
DBA_IND_STATISTICS Optimizer statistics for all indexes in the database
DBA_PENDING_TRANSACTIONS information about unresolved global transactions
DBA_AWS Analytic Workspaces in the database
DBA_AW_PS Pagespaces in Analytic Workspaces owned by the user
DBA_CUBES OLAP Cubes in the database
DBA_CUBE_DIMENSIONALITY OLAP Cube Dimensionality in the database
DBA_CUBE_MEASURES OLAP Measures in the database
DBA_CUBE_DIMENSIONS OLAP Cube Dimensions in the database
DBA_CUBE_HIERARCHIES OLAP Hierarchies in the database
DBA_CUBE_HIER_LEVELS OLAP Hierarchy Levels in the database
DBA_CUBE_DIM_LEVELS OLAP Dimension Levels in the database
DBA_CUBE_ATTRIBUTES OLAP Attributes in the database
DBA_CUBE_ATTR_VISIBILITY OLAP Attributes visible for Dimensions, Hierarchies, and Levels
DBA_CUBE_DIM_MODELS OLAP Dimension Models in the database
DBA_CUBE_CALCULATED_MEMBERS OLAP Calculated Members in the database
DBA_CUBE_VIEWS OLAP Cube Views in the database
DBA_CUBE_VIEW_COLUMNS OLAP Cube View Columns in the database
DBA_CUBE_DIM_VIEWS OLAP Dimension Views in the database
DBA_CUBE_DIM_VIEW_COLUMNS OLAP Dimesion View Columns in the database
DBA_CUBE_HIER_VIEWS OLAP Hierarchy Views in the database
DBA_CUBE_HIER_VIEW_COLUMNS OLAP Hierarchy View Columns in the database
DBA_MEASURE_FOLDERS OLAP Measure Folders in the database
DBA_MEASURE_FOLDER_CONTENTS OLAP Measure Folder Contents in the database
DBA_CUBE_BUILD_PROCESSES OLAP Build Processes in the database
DBA_QUEUE_SUBSCRIBERS queue subscribers in the database
DBA_SCHEDULER_PROGRAMS All scheduler programs in the database
DBA_SCHEDULER_DESTS All possible destination objects for jobs in the database
DBA_SCHEDULER_EXTERNAL_DESTS All destination objects in the database pointing to remote agents
DBA_SCHEDULER_DB_DESTS All destination objects in the database pointing to remote databases
DBA_SCHEDULER_JOB_DESTS State of all jobs at each of their destinations
DBA_SCHEDULER_JOBS All scheduler jobs in the database
DBA_SCHEDULER_JOB_ROLES All scheduler jobs in the database by database role
DBA_SCHEDULER_JOB_CLASSES All scheduler classes in the database
DBA_SCHEDULER_WINDOWS All scheduler windows in the database
DBA_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
DBA_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs 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_WINDOW_LOG Logged information for all scheduler windows
DBA_SCHEDULER_WINDOW_DETAILS The details of a window
DBA_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
DBA_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
DBA_SCHEDULER_GROUP_MEMBERS Members of all scheduler object groups in the database
DBA_SCHEDULER_GROUPS All scheduler object groups in the database
DBA_SCHEDULER_SCHEDULES All schedules in the database
DBA_SCHEDULER_REMOTE_DATABASES List of registered remote databases for jobs
DBA_SCHEDULER_REMOTE_JOBSTATE Remote state of all jobs originating from this database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
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_RUNNING_CHAINS All steps of all running chains in the database
DBA_SCHEDULER_CREDENTIALS All scheduler credentials in the database
DBA_SCHEDULER_FILE_WATCHERS All scheduler file watch requests in the database
DBA_SCHEDULER_NOTIFICATIONS All job e-mail notifications in the database
DBA_EXPORT_OBJECTS Export INCLUDE and EXCLUDE object type names
DBA_LOGSTDBY_UNSUPPORTED_TABLE List of all the data tables that are not supported by Logical Standby
DBA_LOGSTDBY_UNSUPPORTED List of all the columns that are not supported by Logical Standby
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_LOG List the information about received logs from the primary
DBA_LOGSTDBY_SKIP_TRANSACTION List the transactions to be skipped
DBA_LOGSTDBY_SKIP List the skip settings choosen
DBA_LOGSTDBY_EVENTS Information on why logical standby events
DBA_LOGSTDBY_HISTORY Information on processed, active, and pending log streams
DBA_LOGSTDBY_EDS_TABLES List of all tables that have EDS-based replication for Logical Standby
DBA_LOGSTDBY_EDS_SUPPORTED List of all tables that could have EDS-based replication for Logical Standby
DBA_OUTSTANDING_ALERTS Description of all outstanding alerts
DBA_ALERT_HISTORY Description on alert history
DBA_THRESHOLDS Desription of all thresholds
DBA_TABLESPACE_THRESHOLDS Space Utilization Threshold settings for all tablespaces
DBA_AUTOTASK_OPERATION Automated Maintenance Task Operation Configuration
DBA_AUTOTASK_TASK Information about current and past autmated maintenance tasks
DBA_AUTOTASK_SCHEDULE Schedule of Maintenance Windows for the next 32 days
DBA_AUTOTASK_CLIENT_JOB Current automated maintenance jobs
DBA_AUTOTASK_WINDOW_CLIENTS Description of per-mainteance window activity
DBA_AUTOTASK_WINDOW_HISTORY Automated Maintenance view of window history
DBA_AUTOTASK_CLIENT_HISTORY Automated Maintenance Jobs history
DBA_AUTOTASK_JOB_HISTORY Automated Maintenance Jobs history
DBA_AUTOTASK_CLIENT Autotask Client Summary Information
DBA_HIST_BASELINE Baseline Metadata Information
DBA_HIST_BASELINE_DETAILS Baseline Stats on per Instance Level
DBA_HIST_SQLBIND SQL Bind Information
DBA_TUNE_MVIEW Catalog View to show the result after executing TUNE_MVIEW() API
DBA_FLASHBACK_ARCHIVE Description of the flashback archives available in the system
DBA_FLASHBACK_ARCHIVE_TS Description of tablespaces in the flashback archives available in the system
DBA_FLASHBACK_ARCHIVE_TABLES Information about the tables that are enabled for Flashback Archive
DBA_CAPTURE Details about the capture process
DBA_STREAMS_SPLIT_MERGE view of details of split/merge jobs/status about streams
DBA_STREAMS_SPLIT_MERGE_HIST history view of details of split/merge jobs/status about streams
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_SYNC_CAPTURE_PREPARED_TABS All tables prepared for synchronous capture instantiation
DBA_CAPTURE_EXTRA_ATTRIBUTES Extra attributes for a capture process
DBA_REGISTERED_ARCHIVED_LOG Details about the registered log files
DBA_SYNC_CAPTURE Details about the sync capture process
DBA_APPLY Details about the apply process
DBA_APPLY_PARAMETERS All parameters for apply process
DBA_APPLY_INSTANTIATED_OBJECTS Details about objects instantiated
DBA_APPLY_INSTANTIATED_SCHEMAS Details about schemas instantiated
DBA_APPLY_INSTANTIATED_GLOBAL Details about database instantiated
DBA_APPLY_KEY_COLUMNS alternative key columns for a table for STREAMS
DBA_APPLY_CONFLICT_COLUMNS Details about conflict resolution
DBA_APPLY_TABLE_COLUMNS Details about the destination table columns
DBA_APPLY_DML_HANDLERS Details about the dml handler
DBA_APPLY_PROGRESS Information about the progress made by apply process
DBA_APPLY_ERROR Error transactions
DBA_APPLY_ENQUEUE Details about the apply enqueue action
DBA_APPLY_EXECUTE Details about the apply execute action
DBA_APPLY_SPILL_TXN Streams apply spilled transactions info
DBA_XSTREAM_OUTBOUND Details about the XStream outbound server
DBA_XSTREAM_INBOUND Details about the XStream inbound server
DBA_APPLY_CHANGE_HANDLERS Details about apply change handler
DBA_PROPAGATION Streams propagation in the database
DBA_FILE_GROUPS Details about file groups
DBA_FILE_GROUP_VERSIONS Details about file group versions
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_TABLESPACES Details about the transportable tablespaces in the file group repository
DBA_FILE_GROUP_TABLES Details about the tables in the file group repository
DBA_STREAMS_TP_DATABASE DBA Streams Database
DBA_STREAMS_TP_COMPONENT DBA Streams Component
DBA_STREAMS_TP_COMPONENT_LINK DBA Streams Component Link (Streams Topology Links)
DBA_STREAMS_TP_COMPONENT_STAT DBA Streams Component Statistics
DBA_STREAMS_TP_PATH_STAT DBA Streams Path Statistics
DBA_STREAMS_TP_PATH_BOTTLENECK DBA Streams Path Bottleneck
DBA_STREAMS_MESSAGE_CONSUMERS Streams messaging consumers
DBA_STREAMS_GLOBAL_RULES Global rules created by streams administrative APIs
DBA_STREAMS_SCHEMA_RULES Schema rules created by streams administrative APIs
DBA_STREAMS_TABLE_RULES Table rules created by streams administrative APIs
DBA_STREAMS_MESSAGE_RULES Rules for Streams messaging
DBA_STREAMS_RULES Rules used by Streams processes
DBA_SYNC_CAPTURE_TABLES All tables that are captured by synchronous streams captures.
DBA_XSTREAM_RULES Details about the XStream server rules
DBA_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
DBA_STREAMS_ADMINISTRATOR Users granted the privileges to be a streams administrator
DBA_STREAMS_TRANSFORMATIONS Transformations defined on rules
DBA_STREAMS_RENAME_SCHEMA Rename schema transformations
DBA_STREAMS_RENAME_TABLE Rename table transformations
DBA_STREAMS_DELETE_COLUMN Delete column transformations
DBA_STREAMS_KEEP_COLUMNS Keep columns transformations
DBA_STREAMS_RENAME_COLUMN Rename column transformations
DBA_STREAMS_ADD_COLUMN Add column transformations
DBA_RECOVERABLE_SCRIPT Details about recoverable operations
DBA_RECOVERABLE_SCRIPT_HIST Details about executed or purged recoverable operations
DBA_RECOVERABLE_SCRIPT_PARAMS Details about the recoverable operation parameters
DBA_RECOVERABLE_SCRIPT_BLOCKS Details about the recoverable script blocks
DBA_RECOVERABLE_SCRIPT_ERRORS Details showing errors during script execution
DBA_COMPARISON Details about the comparison object
DBA_COMPARISON_COLUMNS Details about the comparison object’s columns
DBA_COMPARISON_SCAN Details about a comparison scan
DBA_COMPARISON_SCAN_SUMMARY Details about a comparison scan
DBA_COMPARISON_SCAN_VALUES Details about a comparison scan’s values
DBA_COMPARISON_ROW_DIF Details about the differing rows in a comparison scan
DBA_STREAMS_COLUMNS Supportability info about streams columns
DBA_STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
DBA_STREAMS_NEWLY_SUPPORTED List of tables that are newly supported by Streams capture
DBA_JAVA_POLICY java security Permissions for all users
DBA_JAVA_CLASSES class level information of all stored java classes
DBA_JAVA_LAYOUTS class layout information about 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_FIELDS field information of all stored java class
DBA_JAVA_METHODS method information of all stored java class
DBA_JAVA_ARGUMENTS argument information of all stored java class
DBA_JAVA_THROWS list of exceptions thrown from a method of a class owned by user
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_RESOLVERS resolver of java class owned by user
DBA_JAVA_COMPILER_OPTIONS all native-compiler options
DBA_EPG_DAD_AUTHORIZATION DADs authorized to use different user’s privileges
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
DBA_XML_SCHEMAS Description of all the XML Schemas registered
DBA_XML_INDEXES Description of all XML indexes in the database
DBA_NETWORK_ACL_PRIVILEGES Privileges defined in network access control lists
DBA_WALLET_ACLS Access control lists assigned to restrict access to wallets through PL/SQL network utility packages
DBA_XDS_OBJECTS All XDS enabled objects in the database
DBA_NETWORK_ACLS Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
DBA_XDS_INSTANCE_SETS All instance sets in the database
DBA_XDS_ATTRIBUTE_SECS All XDS column security defined in the database
DBA_AW_PROP Object properties in Analytic Workspaces in the database
DBA_AW_OBJ Objects in Analytic Workspaces in the database
DBA_TRANSFORMATIONS
DBA_ADVISOR_PARAMETERS
DBA_PARALLEL_EXECUTE_TASKS
DBA_ADVISOR_RATIONALE
DBA_ADVISOR_ACTIONS
DBA_QUEUE_PUBLISHERS
DBA_SQLSET_BINDS
DBA_ADDM_FINDINGS
DBA_PARALLEL_EXECUTE_CHUNKS
DBA_EXPORT_PATHS
DBA_QUEUE_SCHEDULES
DBA_WORKLOAD_CONNECTION_MAP
DBA_ADVISOR_SQLW_COLVOL
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_SQLA_COLVOL
DBA_PART_TABLES
DBA_ADVISOR_DEF_PARAMETERS
DBA_ADVISOR_FINDINGS
DBA_ADVISOR_DIR_INSTANCES
DBA_SQLTUNE_RATIONALE_PLAN
DBA_TAB_SUBPARTITIONS
DBA_DBFS_HS_FIXED_PROPERTIES
DBA_WAITERS
DBA_LOCK_INTERNAL
DBA_ADVISOR_DIR_DEFINITIONS
DBA_DML_LOCKS
DBA_REGISTRY_DEPENDENCIES
DBA_IAS_OBJECTS
DBA_IND_SUBPARTITIONS
DBA_WORKLOAD_REPLAYS
DBA_PART_COL_STATISTICS
DBA_ADVISOR_SQLA_WK_MAP
DBA_BLOCKERS
DBA_SQLTUNE_PLANS
DBA_REGISTRY
DBA_ADVISOR_LOG
DBA_REGISTRY_HISTORY
DBA_ADVISOR_SQLA_REC_SUM
DBA_ADVISOR_EXECUTION_TYPES
DBA_SQLSET_STATEMENTS
DBA_ADVISOR_DEFINITIONS
DBA_IAS_GEN_STMTS_EXP
DBA_WORKLOAD_REPLAY_FILTER_SET
DBA_ADVISOR_SQLA_TABLES
DBA_ADVISOR_USAGE
DBA_WORKLOAD_CAPTURES
DBA_LOGMNR_PURGED_LOG
DBA_ADVISOR_PARAMETERS_PROJ
DBA_ADVISOR_SQLW_SUM
DBA_KGLLOCK
DBA_IND_PARTITIONS
DBA_SQLSET_REFERENCES
DBA_SUBPART_KEY_COLUMNS
DBA_ADVISOR_SQLA_WK_SUM
DBA_ADVISOR_OBJECT_TYPES
DBA_ADDM_TASK_DIRECTIVES
DBA_ADVISOR_SQLW_STMTS
DBA_IAS_TEMPLATES
DBA_SQLSET_PLANS
DBA_IAS_POSTGEN_STMTS
DBA_ADVISOR_TEMPLATES
DBA_ADVISOR_SQLW_TEMPLATES
DBA_ADVISOR_FDG_BREAKDOWN
DBA_ADDM_SYSTEM_DIRECTIVES
DBA_IAS_PREGEN_STMTS
DBA_LOCK
DBA_SQLSET
DBA_TAB_PARTITIONS
DBA_SUBPART_HISTOGRAMS
DBA_ADDM_FDG_BREAKDOWN
DBA_IAS_CONSTRAINT_EXP
DBA_FLASHBACK_TXN_STATE
DBA_LOB_SUBPARTITIONS
DBA_KEEPSIZES
DBA_AQ_AGENT_PRIVS
DBA_ADVISOR_COMMANDS
DBA_DBFS_HS_PROPERTIES
DBA_SQLTUNE_BINDS
DBA_JAVA_NCOMPS
DBA_REPCAT
DBA_ADVISOR_EXECUTIONS
DBA_REGISTRY_PROGRESS
DBA_PART_LOBS
DBA_IAS_OBJECTS_BASE
DBA_SERVER_REGISTRY
DBA_ATTRIBUTE_TRANSFORMATIONS
DBA_REGISTRY_LOG
DBA_IAS_SITES
DBA_PART_INDEXES
DBA_ADVISOR_SQLA_TABVOL
DBA_WORKLOAD_FILTERS
DBA_IAS_OBJECTS_EXP
DBA_ADDM_INSTANCES
DBA_ADVISOR_JOURNAL
DBA_HIST_ASH_SNAPSHOT
DBA_ADVISOR_EXEC_PARAMETERS
DBA_ADVISOR_FINDING_NAMES
DBA_ADVISOR_SQLW_TABLES
DBA_DBFS_HS_COMMANDS
DBA_ADVISOR_SQLW_TABVOL
DBA_LOGMNR_SESSION
DBA_DDL_LOCKS
DBA_SUBPART_COL_STATISTICS
DBA_WORKLOAD_REPLAY_DIVERGENCE
DBA_ADVISOR_OBJECTS
DBA_SUBPARTITION_TEMPLATES
DBA_LOGMNR_LOG
DBA_REGISTRY_HIERARCHY
DBA_ADVISOR_SQLW_PARAMETERS
DBA_ADVISOR_TASKS
DBA_LOB_TEMPLATES
DBA_REGISTRY_DATABASE
DBA_ANALYZE_OBJECTS
DBA_SQLTUNE_STATISTICS
DBA_SQL_MONITOR_USAGE
DBA_ADVISOR_SQLSTATS
DBA_AQ_AGENTS
DBA_PART_HISTOGRAMS
DBA_PART_KEY_COLUMNS
DBA_ADVISOR_DIR_TASK_INST
DBA_LOB_PARTITIONS
DBA_ADDM_TASKS
DBA_ADVISOR_SQLA_WK_STMTS
DBA_IAS_GEN_STMTS
DBA_FLASHBACK_TXN_REPORT
DBA_INVALID_OBJECTS
DBA_DBFS_HS
DBA_ADVISOR_SQLW_JOURNAL
DBA_ADVISOR_SQLPLANS

0 blogger-disqus:

Post a Comment