PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to set the _unnest_subquery= parameter - Will be installing Database 11.2.0.3 - Developers wi

edited Aug 29, 2012 7:34AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓
Hii experts.
How should I set the _unnest_subquery parameter ?


From AdviceForThePeoplesoftOracleDba –

1. performance-related issues associated with semi- and anti-joins. The impact of these issues was
originally performance-based and was particularly problematic in Oracle 9i and some 10g early
patch sets.

Parameters to be Used at Customer Risk
• _unnest_subquery=true - To address issues found during the PeopleTools certification process,
PeopleTools Development requires this setting to be false globally. Many of these problems
have been addressed in later Oracle patchsets; hence, using these features can provide
considerable performance and stability improvements.


From RED_PAPER_-_PeopleSoft_Enterprise_Performance_on_Oracle_11g_Database.pdf  :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center