V$PROPAGATION_RECEIVER
displays information about buffer queue propagation schedules on the receiving (destination) side. The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts, when propagation migrates to another instance, or when an unscheduled propagation is attempted.
Column | Datatype | Description |
---|---|---|
|
|
Name of the source schema |
|
|
Name of the source queue |
|
|
Name of the source database |
|
|
Name of the destination schema |
|
|
Name of the destination queue |
|
|
Startup time of this schedule. This time changes when the source/destination database gets restarted. |
|
|
High watermark of the messages received |
|
|
Acknowledgement of the messages received by the receiver |
|
|
Last received message |
|
|
Total number of messages |
|
|
Elapsed unpickle time |
|
|
Elapsed rule time |
|
|
Elapsed enqueue time |
|
|
Session ID of the propagation receiver |
|
|
Serial number of the propagation receiver |
|
|
Process identification number of the propagation receiver |
|
|
Name of the Streams propagation on the source database |
|
|
State of the propagation receiver:
When the propagation schedule is not optimized, the state is |
|
|
Last received message position. Corresponds to |
|
|
Acknowledgement position of the messages received by the receiver. Corresponds to |
|
|
The ID of the container to which the data pertains. Possible values include:
|