| 15th October 2013 | PeopleSoft Instrumentation for the Oracle Database | Presented 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 2013 | Partition, Compress, Archive and Purge - Keep Your System on the Road | Presented 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 2012 | UKOUG2012: Performance Tuning for PeopleSoft Administrators (with bonus slides!) | 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 2011 | Modelling a Complex Batch Schedule in PeopleSoft | Presented 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
|
||
| 20th May 2009 | Managing Cost-Based Optimiser Statistics in PeopleSoft | Presented 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 2009 |
Practical 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 2008 | An introduction to (BEA) Tuxedo | Presented 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 2007 | PeopleTools 8.48/8.49 - New Database Features | Presented 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 2005 | PeopleSoft: 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 2005 | PIA Load Balancing, JVMs and Garbage Collection | Presented 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 2005 | PeopleTools Application Server & BEA/Tuxedo Internals | Presented 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 2005 | SQL*Fingerprints | Presented 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 2005 | PeopleTools 8.45 Upgrade Musings | Presented 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 2004 | PeopleSoft Ping | Presented to PeopleSoft UK Tech PUG |
An
overview of the PeopleSoft Ping utility.
|
||
| 26th June 2003 | Configuring PeopleSoft Internet Architecture on Windows/2000 | Presented 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 2003 | Performance Metrics: What to Measure in the PeopleSoft 8 Environment | Presented 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 2002 | PeopleTools 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 2025