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 :
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 :
0