Search

OakieTags

more tags

Who's online

There are currently 0 users and 22 guests online.

Recent comments

Affiliations

Home

Global Payroll

Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll

Submitted by davidkurtz on Tue, 2010-04-27 15:00

A longer version of this posting, with experimental results, is available on my website.

In PeopleSoft for the Oracle DBA, I wrote a page (p. 291) explaining why stored outlines were not suitable for use in PeopleSoft.  Five years later, my view has not significantly changed.  Essentially, stored outlines work best with shared SQL, and there isn't much shared SQL in PeopleSoft, because a lot of it is dynamically generated.

Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll

Submitted by davidkurtz on Wed, 2010-03-31 20:25

A longer version of this posting, with experimental results, is available on my website.

In PeopleSoft for the Oracle DBA, I wrote a page (p. 291) explaining why stored outlines were not suitable for use in PeopleSoft.  Five years later, my view has not significantly changed.  Essentially, stored outlines work best with shared SQL, and there isn't much shared SQL in PeopleSoft, because a lot of it is dynamically generated.