event-icon
Description

Session ID: 319

Abstract:

This presentation will provide insight into How a DBA can help Tune the PeopleSoft (PSoft) Applications of PeopleTools, HCM & CRM.   There are rather unique opportunities how PSoft works, and how the Oracle RDBMS may impact performance.     Our PSoft environment was going thru upgrades to the Application, RDBMS and Hardware while the User base was growing at over 20% YOY.  ( Get Current ) With all these changes we had several bumps in the road on performance (especially around payroll processing which is critical as everyone knows!)  The DBA team leveraged their expertise in SQl*Plus, Sql*Developer, OEM & Diagnostic Performance Tuning to provide tuning assistance to the PSoft App. Team.  

 

Objective 1: Learn the Basics of PeopleSoft from a DBA concern
- PeopleTools
- HCM
- CRM

Objective 2: Oracle Tuning:
- OEM
- AWR
- ADDM

Objective 3: The unique PeopleSoft and Oracle issues
- Integration Broker
- PeopleSoft Processing
- SQR - User Query Tool

Audience: Mid-Level

Tags