|
3rd March 2016 |
A Generic Approach to nVision Performance Tuning
|
Scripts on
Github: davidkurtz/nVision
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 2014 |
Oracle 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 2012 |
Using 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 2012 |
Managing Optimizer Statistics for PeopleSoft on Oracle 11g
|
Available from
Gibhub: davidkurtz/gfcpsstats Updated 28.10.2017: Enhancement to
preserve statistics preferences when altering table by rename in
Applicaiton Designer. |
|
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 2012 |
Gathering 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 2011 |
Modelling 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 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.
|
|
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
Corresponding
blog entry:
Factors Affecting Performance of Concurrent Truncate during Batch Processes |
|
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. |