Quantcast

Oracle Sql et administration

Vues DBA du Dictionnaire de données Oracle


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


 

Rechercher

Recherche sur le Site

 

Thèmes Oracle

 

Les Vues V$ ...

 

Erreurs Oracle

 

Oracle 10G - DBA -

 

Syndication

  • Flux RSS des articles

 

Contact - C.G.U. - Rémunération en droits d'auteur - Signaler un abus - Articles les plus commentés