PeopleTools 8.54 for the Oracle DBA

The UKOUG PeopleSoft Roadshow 2015 comes to London on 31^st March 2015.  In a moment of enthusiasm, I offered to talk about new and interesting features of PeopleTools 8.54 from the perspective of an Oracle DBA.

I have been doing some research, and have even read the release notes!  As a result, I have picked out some topics that I want to talk about.  I will discuss how the feature has been implemented, and what I think are the benefits and drawbacks of the feature:

• Descending Key Indexes
• Materialised Views
• Global Temporary Tables
• Partitioning
• %SQLHint Meta-SQL
• %SelectDummyTable Meta-SQL
• Multiple Security Records
• Oracle Resource Manager
• Performance Monitor enhancements

This post is not about a new feature in PeopleTools 8.54, but it is something that I discovered while investigating the new version.

• Undocumented Application Engine Parameter: EnableAEMonitoring

Links have been added to the above list as I have also blogged about each.  I hope it might produce some feedback and discussion.  After the Roadshow I will also add a link to the presentation.

PeopleTools 8.54 is still quite new, and we are all still learning.  So please leave comments, disagree with what I have written, correct things that I have got wrong, ask questions.