Logging for the Data Exchange

Database Logging in the Data Store

Log Table

For data processing within the Data Store for the Data Exchange, the DE_LOG table can be queried to retrieve important logging information.

SELECT * FROM {schema_name}.DE_LOG;

Logging Levels

The database logging levels for the Data Exchange are:

Alter Logging Level for Database Pipelines

You can adjust the logging level to control the amount of diagnostic information captured during data pipeline execution. This is particularly useful for testing, troubleshooting, or performance tuning.

While testing a process, you can increase the logging level to INFO or DEBUG. To do this, execute the following command in the Oracle Autonomous Database for your Data Store:

EXEC {schema_name}.LOGGING.SET_SESSION_LOGGING_LEVEL_OVERRIDE('INFO');

For example, to sync a Collection for Data Exchange, you can execute the following commands to get more detailed logging information and have it provided to you immediately.

SET SERVEROUTPUT ON
EXEC {your_model_schema}.LOGGING.SET_SESSION_LOGGING_LEVEL_OVERRIDE('INFO');
EXEC {your_model_schema}.DE_COLLECTION.SYNC_COLLECTION;