Sundaramurthy Blog

February 13, 2010

The view introduced in 10.2 onwards

Filed under: Oracle Streams (AQ ) — sundar5 @ 1:40 am

According to oracle metalink the following views are changed on 10.2  version

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

CAPTURE
=========
DBA_CAPTURE
DBA_CAPTURE_PARAMETERS
DBA_CAPTURE_EXTRA_ATTRIBUTES
DBA_HIST_STREAMS_CAPTURE (New from 10.2)
V$STREAMS_CAPTURE

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

PROPAGATION
=============
DBA_PROPAGATION
DBA_QUEUE_SCHEDULES
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER

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

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

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_*)

HANDLERS
==========
DBA_APPLY_DML_HANDLERS (For DML Handler)
DBA_APPLY (For DDL Handler column DDL_HANDLER)

CONFLICT HANDLERS
===================
DBA_APPLY_CONFLICT_COLUMNS
DBA_APPLY_TABLE_COLUMNS

TRANSFORMATION
==============
DBA_TRANSFORMATIONS
DBA_STREAMS_TRANSFORM_FUNCTION
DBA_STREAMS_TRANSFORMATIONS (New from 10.2)

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)

FLASHBACK QUERY
==============
FLASHBACK_TRANSACTION_QUERY

DBLINK
======
DBA_DB_LINKS
V$DBLINK

JOBS
=====
DBA_JOBS
DBA_JOBS_RUNNING
V$SCHEDULER_RUNNING_JOBS (New from 10.2)

ARCHIVE LOG/REDO LOG FILES
======================
DBA_REGISTERED_ARCHIVED_LOG
V$ARCHIVED_LOG
V$LOG
V$LOGFILE
V$LOGHIST

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$<queue table name>

QUEUE
=====
DBA_QUEUES
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_PUBLISHERS
QUEUE_PRIVILEGES
V$QUEUE
V$AQ

QUEUE TABLE
==========
DBA_QUEUE_TABLES

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

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

CAPTURE
=========
DBA_CAPTURE
DBA_CAPTURE_PARAMETERS
DBA_CAPTURE_EXTRA_ATTRIBUTES
DBA_HIST_STREAMS_CAPTURE (New from 10.2)
V$STREAMS_CAPTURE

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

PROPAGATION
=============
DBA_PROPAGATION
DBA_QUEUE_SCHEDULES
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER

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

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

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_*)

HANDLERS
==========
DBA_APPLY_DML_HANDLERS (For DML Handler)
DBA_APPLY (For DDL Handler column DDL_HANDLER)

CONFLICT HANDLERS
===================
DBA_APPLY_CONFLICT_COLUMNS
DBA_APPLY_TABLE_COLUMNS

TRANSFORMATION
==============
DBA_TRANSFORMATIONS
DBA_STREAMS_TRANSFORM_FUNCTION
DBA_STREAMS_TRANSFORMATIONS (New from 10.2)

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)

FLASHBACK QUERY
==============
FLASHBACK_TRANSACTION_QUERY

DBLINK
======
DBA_DB_LINKS
V$DBLINK

JOBS
=====
DBA_JOBS
DBA_JOBS_RUNNING
V$SCHEDULER_RUNNING_JOBS (New from 10.2)

ARCHIVE LOG/REDO LOG FILES
======================
DBA_REGISTERED_ARCHIVED_LOG
V$ARCHIVED_LOG
V$LOG
V$LOGFILE
V$LOGHIST

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$<queue table name>

QUEUE
=====
DBA_QUEUES
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_PUBLISHERS
QUEUE_PRIVILEGES
V$QUEUE
V$AQ

QUEUE TABLE
==========
DBA_QUEUE_TABLES

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

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: