3rd March 2016A Generic Approach to nVision Performance Tuning Scripts: nVision_scripts.zip
Utility: PerfOptionSettingAnalysis.Fixed.zip
Documentation: PerfOptionsAnalysisToolDocumentation.zip
This document sets out a number of techniques that can be used to improve and stabilise the performance of PeopleSoft nVision reports. It is based on practical experience on real productions systems at a number of customer sites over a number of years.  However, it is a generic document, and makes general statements. Every customer is different, because their data is different and often their method of analysis differs.  Some of the techniques discussed are specific to the Oracle database, although in some cases, such as partitioning, similar features are available on other databases.

Updated 11.4.2016: Added Leaf Coalece Utility

Related blog entry: nVision Performance Tuning: General Principles, nVision Performance Tuning: Coalescing Tree Leaves

3rd January 2014Oracle Date to Timestamp Conversion during PeopleTools Upgrade Download: gfc_desc_timestamp_index.sql
This document describes a script to convert Oracle date columns to Timestamps as required in PeopleTools 8.51 but only rebilding those indexes that reference those columns, rather than drop and recreate every index in the system, thus producing a significant saving of time during the upgrade.

Related blog entry: Oracle Date to Timestamp Conversion during PeopleTools Upgrade

16th November 2012Using Two Temporary Tablespaces in PeopleSoft
This document proposes a method to made adhoc queries run within a PeopleSoft application use an alternative temporary tablespaces.  Thus allowing better management of temporary tablespace and reducing the risk of errors cause by adhoc consuming available temporary tablespace required by business-as-usual processing.

Related blog entry: Using Two Temporary Tablespaces in PeopleSoft

29th September 2012Managing Optimizer Statistics for PeopleSoft on Oracle 11g Download: gfcpsstats11.zip

Updated 3.4.2014

This documents discusses what I believe is a more effective way to manage optimizer statistics in PeopleSoft on Oracle 11g.

Related blog entry: Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g

11th May 2012Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects in Oracle 11gR2

Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects in Oracle 10g

11g Script: agg_stats11.sql

10g Script: agg_stats.sql

These documents discusses an alternative approach for collecting aggegated statistics on partitioned objects in Oracle 10g and 11g, including measures to correct some of the problems that can occur.  
11th May 2011Modelling a Complex Batch Schedule in PeopleSoft
This paper discusses how to model the batch schedule from a PeopleSoft system so that it is possible to determine the effects of changes. This technique can be used to determine the effects of various changes to Process Scheduler configuration, hardware configuration or batch load.

Updated 16.5.2012
Corresponding presentation: Modelling a Complex Batch Scheduler in PeopleSoft
Batch Modeller Code Project: GFC_SLEEP

19th April 2010Practical 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.
26th January 2009Factors 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
Corresponding blog entry: Factors Affecting Performance of Concurrent Truncate during Batch Processes

7th April 2008PeopleTools 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 2007Running 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

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!

 David Kurtz 2016