19th December 2018GL nVision Performance Techniques for Oracle Systems

GL nVision Performance Techniques for Oracle Systems

Presented to UKOUG Apps 2018
This session will look at the techniques and options available to get nVision to perform well as a General Ledger reporting tool. The session will look at indexing of the ledger and summary ledger tables, use of partitioning for both the ledger and tree selector tables, management of statistics, compression, clustering, materialized views and query rewrite. Then we will look at how on an Engineered Oracle system (Exadata/Supercluster) some of that advice is different.

Corresponding blog articles: nVision Performance Tuning

19th June 2018Managing Cost-Based Optimizer Statistics for PeopleSoftPresented to UKOUG PeopleSoft Roadshow 2018
PeopleSoft presents some special challenges when it comes to collecting and maintaining the object statistics use the cost-based optimizer. This session will focus on the Oracle database, and will draw together the various concepts into a single consistent picture and make clear recommendations to help you work with the Oracle optimizer, rather than continually fight against it. We will look at collecting stats for permanent and temporary working storage tables, and consider other factors that can affect optimizer statistics. We will also discuss PSCBO_STATS that is now shipped with PeopleTools.

Corresponding blog articles:

31st March 2015PeopleTools 8.54 for the Oracle DBAPresented to UKOUG PeopleSoft Roadshow 2015
I have been doing some research, and have even read the release notes! As a result, I have picked out some topics that I want to talk about. I will discuss how the feature has been implemented, and what I think are the benefits and drawbacks of the feature:
  • Descending Key Indexes
  • Materialised Views
  • Global Temporary Tables
  • Partitioning
  • %SQLHint Meta-SQL
  • %SelectDummyTable Meta-SQL
  • Multiple Security Records
  • Oracle Resource Manager
  • Performance Monitor enhancements
Corresponding blog articles: PeopleTools 8.54 for the Oracle DBA
15th October 2013PeopleSoft Instrumentation for the Oracle DatabasePresented to UKOUG Apps13 Conference
In successive releases since PeopleTools 8.5, Oracle has augmented already sophisticated performance instrumentation in PeopleTools with additional database instrumentation. This presentation will show how that information feeds through to database management tools such as Enterprise Manager and Active Session History and permits DBAs to pinpoint database performance problems in the PeopleSoft.
24th April 2013Partition, Compress, Archive and Purge - Keep Your System on the RoadPresented to UKOUG EMEA PeopleSoft Roadshow 2013
This is a story about some work done on a number of PeopleSoft systems. It happens to be about PeopleSoft, but this could be applied to any ERP. It happens to be about Payroll and Time and Labor, but it could be about any product. We will look at how database partitioning, and table and index block compression was used in conjunction with archive and purge procedures to improve and stabilise system performance and limit database growth. I will talk about what worked well, what didn't, and what surprised us.

Corresponding paper: Partition, Compress, Archive and Purge - Keep Your System on the Road

1st October 2012UKOUG2012: Performance Tuning for PeopleSoft Administrators (with bonus slides!)

Openword: Performance Tuning for PeopleSoft Administrators

Presented to Oracle OpenWorld 2012 PeopleSoft Conference
System performance is critical to getting the most out of Oracle’s PeopleSoft solutions. In this session, members of Oracle’s PeopleSoft performance team share tips and techniques for maximizing the performance of your PeopleSoft spplication and Web servers. System administrators new to tuning a PeopleSoft environment, as well as seasoned experts, will come away with new techniques that will help them improve the performance of their PeopleSoft system.
23rd June 2011Modelling a Complex Batch Schedule in PeopleSoftPresented to UK Oracle User Group PeopleSoft Conference
In systems with heavy and complex batch processing it is normal for processes to queue. This presentation will demonstrate how to create more priority levels in the Process Scheduler to control which processes execute and which processes queue.

It will also demonstrate a technique to model a batch processes in order to accurately predict the effect of making those changes.

Corresponding paper: Modelling a Complex Batch Scheduler in PeopleSoft
Batch Modeller Code Project: GFC_SLEEP

20th May 2009Managing Cost-Based Optimiser Statistics in PeopleSoftPresented to UK Oracle User Group PeopleSoft Tech SIG
This presentation discusses some of the challenges of providing the right statistics at the right time to PeopleSoft applications.  Although the details are Oracle specific
20th May 2009Practical Guidance on the Use of PeopleSoft Performance Monitor (2009)

Practical Guidance on the Use of PeopleSoft Performance Monitor (2008)

Presented to UK Oracle User Group UKOUG 2008 UKOUG 2009
This presentation gives some practical examples of how to use PeopleSoft Performance Monitor based on real world examples. It looks at both the supplied analytics in the PIA, and how to directly query the underlying data that has been collected, and how to deal with some of the omissions.
3rd December 2008An introduction to (BEA) TuxedoPresented to UK Oracle User Group UKOUG 2008
This presentation was intended for a non-PeopleSoft audience.  It will provide an architectural overview of BEA Tuxedo. Oracle's purchase of BEA has made Tuxedo an Oracle product. Tuxedo is a very mature and robust transaction processing monitor. It can be used to develop a three-tier application, and PeopleSoft have used in their technology since 1997 (long before the Oracle take over). It can also be used to coordinate a distributed XA transaction.
5th December 2007PeopleTools 8.48/8.49 - New Database FeaturesPresented to UKOUG 2007, Collaborate 08
Two years ago you might have been forgiven for thinking that PeopleTools wasn't going to go anywhere new, but the combination of the need to prepare for Fusion and Applications Unlimited initiative have breathed new life into PeopleTools. Version 8.48 have seen a number of subtle but significant changes. This session will discuss some of them.

Corresponding paper: PeopleTools 8.48/8.49 New Database Features

2nd November 2005PeopleSoft: A Properly Instrumented Application!Presented to UKOUG 2005, Hotsos Symposium 2006, Collaborate 08
Most Oracle professionals now realise that timed based metrics are THE reliable way to diagnose performance problems, instead of using various ratios. It is ironic that as this change has come about, the effectiveness of the Oracle timed-event instrumentation has been degraded because more time is spent in the ever-increasing layers of software between the user and the database. Database idle time may actually be application busy time. We know what to do when the problem is in the database, but what about when most of the response time is 'SQL Net message from client'? This presentation will look at how PeopleSoft (before it was acquired by Oracle) sought to address the problems of measuring application performance with their Performance Monitor utility, and whether they were successful.

"...a good follow on to my talk which was just about instrumentation of applications in general. It was interesting to see what [PeopleSoft] had done (and it appears rather comprehensive, it definitely makes figuring out “where the time is being spent” in PeopleSoft much easier."  - Tom Kyte

5th September 2005PIA Load Balancing, JVMs and Garbage CollectionPresented to PeopleSoft UK Tech PUG
A short presentation looking at some recent experiences of PIA load balancing with the Weblogic plug-in to IIS Proxy, and some ideas for improving the stability of the JVM by choosing a new garbage collector.

Further reading: Thinking in Java, 3rd Edition by Bruce Eckel - see http://www.bruceeckel.com/ for a local mirror site.  In particular see Chapter 4: Cleanup: finalization and garbage collection

9th March 2005PeopleTools Application Server & BEA/Tuxedo InternalsPresented to PeopleSoft UK & Ireland RUG
A detailed technical presentation describing BEA/Tuxedo's internal architecture, and how it has been utilised by PeopleSoft. Including how the PeopleSoft Internet Architecture (PIA), introduced from PeopleTools 8, has been implemented. This presentation describes how to monitor, size and tune the application server.

Further reading: PeopleSoft Timeouts by Graham Smith (formerly on the website of the PeopleSoft Technical Product User Group)

10th March 2005SQL*FingerprintsPresented to PeopleSoft UK Tech PUG, PeopleSoft UK & Ireland RUG and UKOUG 2005
Database performance tuning techniques often concentrate on which SQL statements are performing poorly.  It is relatively easy to identify the individual SQL statements that are costing the most time.  Adjusting indexes, or forcing particular execution plans with stored outlines often isn't adequate, and you really do need to change the SQL.  This presentation will discuss how to find SQL statements in the PeopleSoft application.  Once you can find them, you can change them.
10th January 2005PeopleTools 8.45 Upgrade MusingsPresented to PeopleSoft UK Tech PUG
I have recently migrated a Financials system from PeopleTools 8.41/Oracle 8i/Windows 2000 to PeopleTools 8.45/Oracle 9i/Solaris 9.  It was an interesting and sometimes frustrating experience.  This presentation describes some of the problems, and their solutions.
3rd June 2004PeopleSoft PingPresented to PeopleSoft UK Tech PUG
An overview of the PeopleSoft Ping utility.
  • how it works
  • what it does,
  • what it does and does not tell you.
26th June 2003Configuring PeopleSoft Internet Architecture on Windows/2000Presented to PeopleSoft UK RUG
This presentation explains how NERC configured their application server and web servers such that different environments on the same node could run different versions of PeopleTools.
3rd January 2003Performance Metrics: What to Measure in the PeopleSoft 8 EnvironmentPresented to PeopleSoft UK Tech PUG
This presentation is discussed the theory and practice of collecting and interpreting performance metrics. It is based on the Performance Tuning at UBS given at EMEA2002.
23rd January 2002PeopleTools Application Server & BEA/Tuxedo Internals (Note: This is an presentation is based on PeopleTools 7.5x)Presented to PeopleSoft UK RUG Tech SIG, originally presented to PeopleSoft EMEA 2001 Conference.
A detailed technical presentation describing BEA/Tuxedo's internal architecture, and how it has been utilised by PeopleSoft. Including how the PeopleSoft Internet Architecture (PIA), introduced from PeopleTools 8, has been implemented. This presentation describes how to monitor, size and tune the application server.

Companion document: Advanced Tuxedo for PeopleSoft

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 2019