Enable the tracing option in Replication Server to gather connector-level and connection-level diagnostic information.
Diagnostic information related to ExpressConnect for Oracle execution is available for operations at both the connector level and the connection level, and for various diagnostic conditions. Not all of the conditions are available for both connector-level and connection-level tracing. Some also require the use of the debug version of the ExpressConnect for Oracle executable.
| Condition | Description | Availability | Requires Debug ECO Executable |
|---|---|---|---|
| cm_ct_connect | Enables all connection-level diagnostic conditions and all possible debugging methods available through the replicate data server connectivity layer. For ECO, the replicate data server connectivity layer is the OCI interface. | Connection only | Yes |
| general_1 | Logs function entry and exit points with input and output parameters and return codes. Enabling this condition for the connector also enables it for all of the connector's connections. | Both connector and connection | Yes |
| general_2 | Logs messages indicating the execution path through internal functions. Enabling this condition for the connector also enables it for all of the connector's connections. | Both connector and connection | Yes |
| consistency_1 | Logs analysis and validation of internal function input parameters. Enabling this condition for the connector also enables it for all of the connector's connections. | Both connector and connection | Yes |
| consistency_2 | Logs analysis and validation of data structures at key points in the execution path. Enabling this condition for the connector also enables it for all of the connector's connections. | Both connector and connection | Yes |
| dsi_buf_dump | Logs the language command buffer sent to the data server. | Connection only | No |
| dsi_trace_writetext | Logs key points in the execution path and data associated with sending large object (LOB) data to the replicate data server. | Connection only | Yes |
| rsfeature_dsql | Logs key points in the execution path of dynamic SQL management. | Connection only | Yes |
| rsfeature_bulk1 | Logs key points in the execution of the bulk (array) insert feature at the operation level. This condition produces less output than rsfeature_bulk2. | Connection only | Yes |
| rsfeature_bulk2 | Logs key points in the execution of the bulk (array) insert feature at the row and column level. This can produce a lot of output when there are many rows. | Connection only | Yes |