My Oracle Support Banner

How To Perform a Session Trace on Mappings In OWB 10.2 (Doc ID 453699.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Warehouse Builder - Version 10.2 to 10.2 [Release 10.2]
Information in this document applies to any platform.


Goal

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

To be able 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, 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. 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 here, does not require the Runtime Platform Service to be "Available".

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.