Trace level 1 provides the following additional
output to Trace level 0:
At startup:
- OCI startup
- OCI connection to source database
- If required, creating the partition or ROWID
data for multiple selects
- Schema details of the copied table (columns, data names,
sizes, buffering)
At shutdown:
- Freeing of buffers
- Freeing of OCI handles
Thread startup - For each read thread:
- OCI startup
- OCI connection to source database
- Buffer acquisition and release
- Data read elapsed time, and number of rows read
Thread startup - For each write thread:
- Buffer acquisition and release
- Data output elapsed time, and number of rows written
See the trace
level1 file example included here to see the typical output
for trace level 1. This limited trace displays the OCI functions
called, and is useful for determining possible problems with
the Oracle processing.
