Check the status of Oracle streams apply

Check the Status of Oracle Streams by following views

Reader Server States: V$STREAMS_APPLY_READER

INITIALIZING – Starting up
IDLE – Performing no work
DEQUEUE MESSAGES – Dequeuing messages from the apply process’s queue
SCHEDULE MESSAGES – Computing dependencies between messages and assembling messages into transactions
SPILLING – Spilling unapplied messages from memory to hard disk
PAUSED – WAITING FOR DDL TO COMPLETE – Paused while waiting for a DDL LCR to be applied

Coordinator Process States: V$STREAMS_APPLY_COORDINATOR

INITIALIZING – Starting up
IDLE – Performing no work
APPLYING – Passing transactions to apply servers
SHUTTING DOWN CLEANLY – Stopping without an error
ABORTING – Stopping because of an apply error

Apply Server States: V$STREAMS_APPLY_SERVER

INITIALIZING – Starting up.
IDLE – Performing no work.
RECORD LOW-WATERMARK – Performing an administrative action that maintains information about the apply progress, which is used in the ALL_APPLY_PROGRESS and DBA_APPLY_PROGRESS data dictionary views.
ADD PARTITION – Performing an administrative action that adds a partition that is used for recording information about in-progress transactions.
DROP PARTITION – Performing an administrative action that drops a partition that was used to record information about in-progress transactions.
EXECUTE TRANSACTION – Applying a transaction.
WAIT COMMIT – Waiting to commit a transaction until all other transactions with a lower commit SCN are applied. This state is possible only if the commit_serialization apply process parameter is set to a value other than DEPENDENT_TRANSACTIONS and the parallelism apply process parameter is set to a value greater than 1.
WAIT DEPENDENCY – Waiting to apply an LCR in a transaction until another transaction, on which it has a dependency, is applied. This state is possible only if the PARALLELISM apply process parameter is set to a value greater than 1.
WAIT FOR CLIENT – Waiting for an XStream In client application to request more logical change records (LCRs).
WAIT FOR NEXT CHUNK – Waiting for the next set of LCRs for a large transaction.
ROLLBACK TRANSACTION – Rolling back a transaction.
TRANSACTION CLEANUP – Cleaning up an applied transaction, which includes removing LCRs from the apply process’s queue.

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s