26
Replication Dynamic Performance Views

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.

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.

Replication Parallel Prop Coordinator indicates that the coordinator process is active, either waiting, sleeping, or scheduling slaves to perform operations.

The Replication Parallel Prop Coordinator reads transactions from the deferred transaction queue and assigns them to the Replication Parallel Prop Slaves. Then, the slaves propagate the transactions to the destination site. When the slaves push transactions in a push session, the slaves remain active until the push session completes, even if there are no more transactions to push.

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

SLEEP indicates that the coordinator process is sleeping for the duration of the delay_seconds setting. You set delay_seconds with the SCHEDULE_PUSH procedure in the DBMS_DEFER_SYS package.

PUSH indicates that the slave process is pushing transactions from the deferred transaction queue to the remote site.

PURGE indicates that the slave process is purging metadata related to successfully applied transactions from the remote site.

CREATE ERROR indicates that the slave process is creating an error transaction. In this case, an error or a conflict occurred while the slave was pushing deferred transactions to the remote site.

SCHEDULE TXN indicates that the coordinator process is determining the order that transactions are applied and assigning slave processes to execute the transactions.

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.

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.