Session ID: 319
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
Objective 2: Oracle Tuning:
Objective 3: The unique PeopleSoft and Oracle issues
- Integration Broker
- PeopleSoft Processing
- SQR - User Query Tool