Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /


Les Vues DBA du dictionnaire de données (vues systèmes statiques)  sont les vues de l'administrateur Oracle.
(Privilèges SELECT ANY TABLE pour les voir)

SQL> SELECT table_name,
            comments
     FROM dictionary
     WHERE table_name like 'DBA%'
     ORDER BY table_name;

NOM

DESCRIPTION

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 data
base
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


Partager cette page

Repost 0
Published by