All Oracle installations include the dynamic performance views, often referred to as V$
views, described in this chapter. These views are used by master sites and materialized view sites to determine such information as which materialized views are being refreshed currently and statistics about the deferred transaction queue.
This chapter contains these topics:
Contains information about the materialized views currently being refreshed.
Column | Datatype | Description |
---|---|---|
SID |
NUMBER |
Session identifier. |
SERIAL# |
NUMBER |
Session serial number, which is used to identify uniquely a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. |
CURRMVOWNER |
VARCHAR2(31) |
Owner of the materialized view currently being refreshed. The materialized view resides in this user's schema. |
CURRMVNAME |
VARCHAR2(31) |
Name of the materialized view currently being refreshed. |
Contains information about the parallel propagation currently in progress at the replication site. Use this view to determine which transactions are currently being propagated, the number of calls propagated in each transaction, and the current activity of the parallel propagation slave processes or parallel propagation coordinator process.
Note:
This view only contains data when deferred transactions are being pushed using parallel propagation at the current site. Theparallelism
parameter must be set to 1
or higher in the DBMS_DEFER_SYS.PUSH
function for a push to use parallel propagation. Otherwise, the push uses serial propagation, and no data appears in this view during the push.Column | Datatype | Description |
---|---|---|
SID |
NUMBER |
Session identifier. |
SERIAL# |
NUMBER |
Session serial number. Used to identify uniquely a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. |
NAME |
VARCHAR2(71) |
Replication Parallel Prop Slave n indicates that the slave process is active, either waiting, pushing deferred transactions, purging metadata, or creating an error transaction.
The |
DBLINK |
VARCHAR2(128) |
Database link on which this replication session is propagating. |
STATE |
VARCHAR2(12) |
WAIT indicates that either the slave or coordinator process is waiting for an event (that is, a message).
|
XID |
VARCHAR2(22) |
If the session is a slave session, then indicates the transaction id of the transaction that the slave is currently propagating. |
SEQUENCE |
NUMBER |
If the process is a slave process, then the sequence number of the calls propagated in the current operation, if relevant. Each transaction must process one or more calls, and the value of SEQUENCE starts at zero and increases as each call is processed. So, the SEQUENCE value shows the call that is currently being processed in each transaction. This value increases until the slave has processed all of the calls in a transaction. |
Contains statistics about the replication deferred transactions queue. All values are stored since the start of the current database instance.
Column | Datatype | Description |
---|---|---|
TXNS_ENQUEUED |
NUMBER |
Number of transactions enqueued in the deferred transactions queue. |
CALLS_ENQUEUED |
NUMBER |
Number of calls enqueued into the deferred transactions queue. |
TXNS_PURGED |
NUMBER |
Number of transactions purged from the deferred transactions queue. |
LAST_ENQUEUE_TIME |
DATE |
Date when the last transaction was enqueued into the deferred transaction queue. NULL if no transactions have been enqueued into the deferred transaction queue since the instance started. |
LAST_PURGE_TIME |
DATE |
Date when the last transaction was purged from the deferred transaction queue. NULL if no transactions have been purged from the deferred transaction queue since the instance started. |