pdb_commit_generation_status

Description

Returns a status for each Replication Agent thread that generates commit log records for an Oracle instance.

This command is available only for Oracle and is only applicable to Oracle RAC databases.

Syntax

pdb_commit_generation_status

Examples

Example 1

pdb_commit_generation_status

This command returns status for four threads that generate commit log records for the oradb1, oradb2, oradb3, and oradb4 Oracle instances:

Instance Name State

------------- -------

oradb1        RUNNING

oradb2        RUNNING

oradb3        RUNNING

oradb4        RUNNING

Usage

There are seven thread states:

**Table 1-2: Commit-generation thread states**
State	Description
ERRORED	The commit-generation thread encountered an error while generating commit log records in the primary database and is no longer running.
FITERED	The commit-generation thread is filtered and is not generating generating commit log records in the primary database
REQUESTED TO FILTER	The running commit-generation thread received a filter request and is transitioning to the FILTERED state.
RUNNING	The commit-generation thread is generating commit log records in the primary database.
STARTING	The commit-generation thread is in the process of starting to generate commit log records.
STOPPED	The commit-generation thread has stopped generating commit log records after receiving a request to stop.
STOP REQUESTED	The commit-generation thread is generating commit log records but has received a request to stop. The thread is transitioning to the STOPPED state.