Thursday, May 21, 2009

All Replication Configuration Views

The types of replication include Streams, Change Data Capture (CDC), Advanced Queuing (AQ) and Advanced Replication.

STREAMS CONFIGURATION VIEWS - ADMINISTRATIVE
DBA_STREAMS_ADMINISTRATOR
DBA_STREAMS_NEWLY_SUPPORTED
DBA_STREAMS_UNSUPPORTED
DBA_STREAMS_MESSAGE_CONSUMERS
DBA_STREAMS_MESSAGE_RULES
DBA_STREAMS_ADD_COLUMN (New from 10.2)
DBA_STREAMS_DELETE_COLUMN (New from 10.2)
DBA_STREAMS_RENAME_COLUMN (New from 10.2)
DBA_STREAMS_RENAME_SCHEMA (New from 10.2)
DBA_STREAMS_RENAME_TABLE (New from 10.2)
DBA_HIST_BUFFERED_QUEUES (New from 10.2)
DBA_HIST_BUFFERED_SUBSCRIBERS (New from 10.2)
DBA_HIST_STREAMS_POOL_ADVICE (New from 10.2)
V$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION


STREAMS CONFIGURATION VIEWS - CAPTURE
DBA_CAPTURE
DBA_CAPTURE_PARAMETERS
DBA_CAPTURE_EXTRA_ATTRIBUTES
DBA_HIST_STREAMS_CAPTURE (New from 10.2)
V$STREAMS_CAPTURE


STREAMS CONFIGURATION VIEWS - APPLY
DBA_APPLY
DBA_APPLY_PARAMETERS
DBA_APPLY_ENQUEUE
DBA_APPLY_ERROR
DBA_APPLY_EXECUTE
DBA_APPLY_PROGRESS
DBA_APPLY_SPILL_TXN
DBA_APPLY_KEY_COLUMNS
DBA_APPLY_TABLE_COLUMNS
DBA_APPLY_OBJECT_DEPENDENCIES (New from 10.2)
DBA_APPLY_VALUE_DEPENDENCIES (New from 10.2)
DBA_HIST_STREAMS_APPLY_SUM (New from 10.2)
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER


STREAMS CONFIGURATION VIEWS - PROPAGATION
DBA_PROPAGATION
DBA_QUEUE_SCHEDULES
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER


STREAMS CONFIGURATION VIEWS - RULES
DBA_RULES
DBA_RULE_SETS
DBA_RULE_SET_RULES
DBA_STREAMS_RULES
DBA_STREAMS_GLOBAL_RULES
DBA_STREAMS_SCHEMA_RULES
DBA_STREAMS_TABLE_RULES
DBA_EVALUATION_CONTEXTS
DBA_EVALUATION_CONTEXT_TABLES
DBA_EVALUATION_CONTEXT_VARS
V$RULE
V$RULE_SET
V$RULE_SET_AGGREGATE_STATS

STREAMS CONFIGURATION VIEWS - INSTANTIATION
DBA_CAPTURE_PREPARED_DATABASE
DBA_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_TABLES
DBA_APPLY_INSTANTIATED_GLOBAL
DBA_APPLY_INSTANTIATED_OBJECTS
DBA_APPLY_INSTANTIATED_SCHEMAS

STREAMS CONFIGURATION VIEWS - SUPPLEMENTAL LOGGING
DBA_LOG_GROUPS
DBA_LOG_GROUP_COLUMNS
DBA_CAPTURE_PREPARED_TABLES
DBA_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_DATABASE
V$DATABASE (columns FORCE_LOGGING SUPPLEMENTAL_LOG_DATA_*)


STREAMS CONFIGURATION VIEWS - HANDLERS
DBA_APPLY_DML_HANDLERS (For DML Handler)
DBA_APPLY (For DDL Handler column DDL_HANDLER)


STREAMS CONFIGURATION VIEWS - CONFLICT HANDLERS
DBA_APPLY_CONFLICT_COLUMNS
DBA_APPLY_TABLE_COLUMNS


STREAMS CONFIGURATION VIEWS - TRANSFORMATION
DBA_TRANSFORMATIONS
DBA_STREAMS_TRANSFORM_FUNCTION
DBA_STREAMS_TRANSFORMATIONS (New from 10.2)


STREAMS CONFIGURATION VIEWS - LOGMINER
DBA_LOGMNR_LOG
DBA_LOGMNR_PURGED_LOG
DBA_LOGMNR_SESSION
V$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY
V$LOGMNR_LOGS
V$LOGMNR_PARAMETERS
V$LOGMNR_DICTIONARY_LOAD (New from 10.2)
V$LOGMNR_LATCH (New from 10.2)
V$LOGMNR_PROCESS (New from 10.2)
V$LOGMNR_SESSION (New from 10.2)
V$LOGMNR_STATS (New from 10.2)


STREAMS CONFIGURATION VIEWS - FLASHBACK QUERY
FLASHBACK_TRANSACTION_QUERY

STREAMS CONFIGURATION VIEWS - DBLINK
DBA_DB_LINKS
V$DBLINK


STREAMS CONFIGURATION VIEWS - JOBS
DBA_JOBS
DBA_JOBS_RUNNING
V$SCHEDULER_RUNNING_JOBS (New from 10.2)


STREAMS CONFIGURATION VIEWS - ARCHIVE LOG/REDO LOG FILES
DBA_REGISTERED_ARCHIVED_LOG
V$ARCHIVED_LOG
V$LOG
V$LOGFILE
V$LOGHIST

STREAMS CONFIGURATION VIEWS - TRANSACTIONS
V$TRANSACTION
V$GLOBAL_TRANSACTION
V$TRANSACTION_ENQUEUE
V$STREAMS_TRANSACTION (New from 10.2)


CHANGE DATA CAPTURE (CDC) CONFIGURATION VIEWS
CHANGE_PROPAGATIONS
CHANGE_PROPAGATION_SETS
CHANGE_SETS
CHANGE_SOURCES
CHANGE_TABLES
DBA_SOURCE_TABLES
DBA_SOURCE_TAB_COLUMNS
DBA_PUBLISHED_COLUMNNS
DBA_SUBSCRIPTIONS
DBA_SUBSCRIBED_TABLES
DBA_SUBSCRIBED_COLUMNS


ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - ENQUEUE AND DEQUEUE
aq$

ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - QUEUE
DBA_QUEUES
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_PUBLISHERS
QUEUE_PRIVILEGES
V$QUEUE
V$AQ



ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - QUEUE TABLE
DBA_QUEUE_TABLES

ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - MESSAGING
DBA_AQ_AGENTS
DBA_AQ_AGENT_PRIVS


ADVANCED REPLICATION CONFIGURATION VIEWS
DBA_REPCATLOG
DBA_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS
DBA_REPCAT_USER_PARM_VALUES
DBA_REPCOLUMN
DBA_REPCOLUMN_GROUP
DBA_REPCONFLICT
DBA_REPDDL
DBA_REPGENOBJECTS
DBA_REPGROUP
DBA_REPGROUPED_COLUMN
DBA_REPGROUP_PRIVILEGES
DBA_REPKEY_COLUMNS
DBA_REPOBJECT
DBA_REPPARAMETER_COLUMN
DBA_REPPRIORITY
DBA_REPPRIORITY_GROUP
DBA_REPPROP
DBA_REPRESOLUTION
DBA_REPRESOLUTION_METHOD
DBA_REPRESOLUTION_STATISTICS
DBA_REPRESOL_STATS_CONTROL
DBA_REPSITES
DBA_REPSITES_NEW
DBA_RGROUP
V$REPLPROP
V$REPLQUEUE

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment