Performance Issue With SDE_PSFT_GLLINKAGEINFORMATION_PROJECT_EXTRACT (Doc ID 2756686.1)

Last updated on MARCH 03, 2021

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.
PeopleSoft version 9.0 onwards

Goal

Having a performance issue with this OOTB interface - SDE_PSFT_92_ADAPTOR_SDE_PSFT_GLLINKAGEINFORMATION_PROJECT_EXTRACT. In the comments section of the SDE_PSFT_Project_LinkageInformation_Dual.W_GL_LINKAGE_INFOMATION_GS_GL_Linkage temporary interface there is this comment: bug:19581015 Adding #ETL_HINT_NESTED1 for better query performance.
What is this HINT mentioned?

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.

Performance Issue With SDE_PSFT_GLLINKAGEINFORMATION_PROJECT_EXTRACT (Doc ID 2756686.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!