| 19th April 2010 | Practical Use of Active Session History |
| This document provides a brief overview of Active Session History (ASH) and then looks at the practicalities of how to use the ASH data to diagnose performance problems. It discusses the importance of instrumentation to make the ASH data useful, and how to query the ASH data to determine which SQL statements spent how long doing what, and therefore which need further examination. | |
| 31st March 2010 | Use of Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll |
| Generally, it is not easy to use Oracle Plan Stability in conjunction with PeopleSoft. However, the Global Payroll calculation engine is an exception because it is written in Cobol. This paper describes the use of Stored Outlines to address performance problems experienced in the PeopleSoft Global Payroll calculation. Corresponding blog entry: Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll | |
| 26th January 2009 | Factors Affecting Performance of Concurrent Truncate during Batch Processes |
| This paper describes an investigation into what happens in the Oracle database when concurrent processes frequently truncate working storage tables. This can occur in PeopleSoft when multiple concurrent Application Engine processes truncate working storage tables. 'Time & Labor' processing is a typical example. The paper presents some test results and makes recommendations to minimize the problem. Updated 2.4.2009: Oracle Bug 4260477: ORA-08007: Further changes to this block by this transaction not allowed. See Also Hemant's Oracle DBA Blog | |
| 7th April 2008 | PeopleTools 8.48/8.49 New Database Features (7.4.2008) |
| This paper discusses some of the new features and changes made in PeopleTools 8.48 and 8.49 that may be of interest or concern to the DBA. Corresponding paper: PeopleTools 8.48/8.49 New Database Features | |
| 16th September 2007 | Running Unix Commands and Scripts from the PeopleSoft Process Scheduler |
| This document describes how to run UNIX shell scripts from the Process Scheduler, showing how it is possible to use the Process Scheduler to run operating system commands, and to have those command interact appropriately with the generic Process Scheduler functionality. The wrapper script can be downloaded from the scripts page. |
| Improving the Performance of Security Views in PeopleSoft HCM8.8 |
| This document describes techniques for improving the performance of the tree reading security views that are at the heart of PeopleSoft HCM. It is also available as a zip archive with exhibited files. This document supersedes PeopleSoft HR7.5 Security Views Related presentation: PeopleSoft HR7.5 Security Views |
| Configuring and Operating Streamed Processing in PeopleSoft Global Payroll | |
| This document has been prepared to explain the changes need and the operation of ‘Streamed’ processing in PeopleSoft Global Payroll (GP). It is based on research and experience of GP in a number of sites in the UK, France, Switzerland and Japan. It is Also available as a zip archive including SQL scripts. Related Presentation: Configuring Global Payroll for Optimal Performance, gpbuild.sql script also available separately |
| Advanced Tuxedo for PeopleSoft |
| This document will assist with the understanding, administration, monitoring and tuning of the Tuxedo application server within a PeopleSoft environment. It is intended as an addendum to any other BEA or PeopleSoft documentation regarding the application server, including PeopleSoft's 'Three-Tier Answer Book'. It only available as zip archive with exhibited files. This document is based on PeopleTools 7.5 and Tuxedo 6.5. The material has been heavily revised and included in my book PeopleSoft for the Oracle DBA. Companion Presentation: PeopleTools Application Server & BEA/Tuxedo Internals |
| PeopleSoft for the Oracle DBA |
| This document is for the Oracle DBA with PeopleSoft databases to administer. It does not explain how to administer a database, but discusses certain administrative topics within the context of PeopleSoft. This document has been withdrawn since the publication of my book PeopleSoft for the Oracle DBA. |
Caveat: There is no guarantee that any of the content of this website is error free, rather that there are certainly errors and inconsistencies!
© Go-Faster Consultancy Ltd. 2010