Useful Tables and Views, for Troubleshooting Streams Issues
| CAPTURE PROCESS | |
| streams$_capture_process | Lists all defined capture processes |
| dba_capture | Basic status, error info |
| v$streams_capture | Detailed status info |
| dba_capture_parameters | Configuration information |
| PROPAGATE PROCESS | |
| streams$_propagation_process: | Lists all defined propagate processes |
| dba_propagation | Basic status, error info |
| v$propagation_sender | Detailed status info |
| v$propagation_receiver | Detailed status info |
| APPLY PROCESS | |
| streams$_apply_process | Lists all defined apply processes |
| dba_apply | Basic status, error info |
| v$streams_apply_reader | Status of the apply reader |
| v$streams_apply_server | Status of apply server(s) |
| v$streams_apply_coordinator | Overall status, latency info |
| dba_apply_parameters | Configuration information |
| Miscellaneous Tables | |
| v$buffered_queues | View that displays the current and cumulative number of messages enqueued and spilled, for each buffered queue. |
| sys.streams$_apply_spill_msgs_part | Table that the apply process uses, to “spill” messages from large transactions to disk. |
| system.logmnr_restart_ckpt$ | Table that holds capture process “checkpoint” information. |
Leave a Reply
You must be logged in to post a comment.