5.383 DBA_HIST_CAPTURE
DBA_HIST_CAPTURE
displays historical statistics information about each capture process for Oracle GoldenGate, and XStream capture operations.
This view is intended for use with Automatic Workload Repository (AWR).
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Name of the capture process |
|
|
|
Time that the capture process was last started |
|
|
|
Delay (in seconds) between the creation and capture of the most recently captured message |
|
|
|
Total changes captured since the capture process was last started |
|
|
|
Total number of messages enqueued since the capture process was last started |
|
|
|
Elapsed time (in hundredths of a second) evaluating rules since the capture process was last started |
|
|
|
Elapsed time (in hundredths of a second) enqueuing messages since the capture process was last started |
|
|
|
Elapsed time (in hundredths of a second) spent by the capture process in the WAITING FOR REDO state since the capture process was last started. |
|
|
|
Elapsed pause time (in hundredths of a second) spent by the capture process since the capture process was last restarted |
|
|
|
The database ID of the PDB |
|
|
|
Name of the extract process, if applicable |
|
|
|
The total amount of redo data mined (in bytes) since the capture process last started |
|
|
|
Total number of bytes sent by the capture process to the extract process since the last time the extract process attached to the capture process |
|
|
|
Session module. Valid values:
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|