ALL_CAPTURE
displays information about the capture processes that enqueue the captured changes into queues accessible to the current user.
Related View
DBA_CAPTURE
displays information about all capture processes in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the capture process |
|
|
|
Name of the queue used for staging captured changes |
|
|
|
Owner of the queue used for staging captured changes |
|
|
|
Name of the positive rule set used by the capture process for filtering |
|
|
|
Owner of the positive rule set |
|
|
|
Current user who is enqueuing captured messages |
|
|
|
System change number (SCN) from which the capture process will start to capture changes. |
|
|
|
Status of the capture process:
|
|
|
|
System change number (SCN) of the last redo log record scanned |
|
|
|
System change number (SCN) of the most recent message dequeued by the relevant apply processes. All changes below this SCN have been dequeued by all apply processes that apply changes captured by this capture process. |
|
|
|
Indicates whether the source database name is used as the database link to connect to the source database from the downstream database ( |
|
|
|
System change number (SCN) from which the capture process can be restarted. |
|
|
|
Global name of the source database |
|
|
|
Database ID of the source database |
|
|
|
Resetlogs system change number (SCN) of the source database |
|
|
|
Resetlogs time of the source database |
|
|
|
Session ID of the Oracle LogMiner session associated with the capture process |
|
|
|
Name of the negative rule set used by the capture process for filtering |
|
|
|
Owner of the negative rule set used by the capture process for filtering |
|
|
|
System change number (SCN) at which the last checkpoint was taken by the capture process |
|
|
|
Lowest checkpoint SCN for which the capture process requires redo information. Note: This SCN value does not necessarily correspond with a checkpoint SCN value. |
|
|
|
Logfile assignment type for the capture process:
|
|
|
|
Time that the |
|
|
|
Error number if the capture process was aborted |
|
|
|
Error message if the capture process was aborted |
|
|
|
Version number of the capture process |
|
|
|
Type of the capture process:
|
|
|
|
Last enqueued system change number (SCN) |
|
|
|
Checkpoint retention time Note: When the checkpoint retention time for a capture process is set to |
|
|
|
Time from which the capture process will start to capture changes. You can modify either |
|
|
|
Purpose of the capture process:
|
|
|
|
The global name of the source root database |
|
|
|
Client name of the capture process. This is the outbound name for XStream Out, and the extract name for GoldenGate. |
|
|
|
Status of the client process:
|
|
|
|
Oldest SCN of the transactions currently being processed |
|
|
|
SCN of the low watermark transaction processed |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_XSTREAM_ADM.ENABLE_GG_XSTREAM_FOR_STREAMS
procedure