My Oracle Support Banner

How To Capture The SQL Being Executed During a Data Load (Doc ID 751407.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Oracle OLAP - Version 11.1.0.6 and later
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

In this article we will discuss the ways to capture the query generated for selecting the data from the source tables that are mapped to the cube. During data load this query produces the result set for the data to be loaded into the cube.

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
 SQL Trace
 The ___XML_LOAD_TEMPPRG
References

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