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

Last updated on NOVEMBER 07, 2023

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.

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

Applies to:

Goal

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!