How To Perform a Session Trace on Mappings In OWB 11g (Doc ID 453777.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1 and later
Information in this document applies to any platform.


Goal

This note describes how to enable tracing for Oracle Warehouse Builder 11g mappings. It can be used to identify the cause of errors when running mappings, but also to investigate performance issues.

To enable a session trace on a mapping, it is required to know in which session the mapping is running. However, when running a mapping with the sqlplus_exec_template.sql script, a new session is spawned in the database. This makes it difficult to enable the session trace, and therefore a different execution method is required.

This note explains how to enable a session trace, without using the sqlplus_exec_template.sql script. It will not spawn a new session for the mapping execution, and therefore this method is more suitable for session tracing.

Note that the tracing method that is described in this Note, does not require the Control Center Service to be "Available".

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms