PeopleSoft for the Oracle DBA (2nd Edition)NEWS: (28.10.2017) GFCPSSTATS11 package has been enhanced to preserve statsitics preferences when renaming a table by renaming either in a script generated by Applicaiton Designer or the GFC_PSPART package.

(10.10.2017) I am writing a series of blogs on PeopleSoft nVision Performance Tuning

(5.5.2017) In PeopleTools 8.55 [DBNAME] now holds the PeopleSoft Owner ID in lower case.  I have published a new version of the GFCPSSTATS11 package to handle this.

Recent blog postings:

  • PeopleSoft: nVision Performance Tuning series (10.10.2017)
  • PeopleSoft: Running Unix Shell Scripts from the PeopleSoft Process Scheduler (26.2.2017)
  • PeopleSoft: Identifying Redundant Indexes in PeopleSoft (12.1.2017)
  • Oracle: Removing Unnecessary Indexes: 3.Cost of Maintaining Indexes (10.1.2017)
  • Oracle: Removing Unnecessary Indexes: 2. Identifying Redundant Indexes (6.1.2017)
  • Oracle: Removing Unnecessary Indexes: 1. The Need for Extended Statistics (2.1.2017)

  • (19.4.2016)I recorded an interview with Dan Iverson and Kyle Benson of   It has been made available in three parts.  The podcasts are available on, and the three episodes are available on my blog. Since they have been kind enough to keep mentioning my book, I'd like to plug their website and podcasts.  Lots of good material on a wide range of PeopleSoft administration subjects.

    (16.2.2015) I have written a series of blog articles about the support for Oracle database features in PeopleTools 8.54. The presentation PeopleTools 8.54 for the Oracle DBA is now available.

    (18.6.2015) After 15 years of independent consulting I have joined the Accenture Enkitec Group.  I am still available for consultancy, but via Accenture.  Please contact me and I will help facilitate this.  This website and my blogs will continue as a PeopleSoft and Oracle technical resource.  They represent my personal views and not that of Accenture.

    (1.3.2012) The 2nd edition of PeopleSoft for the Oracle DBA was published in February 2012 available in bookshops and on Amazon.

    Join the PeopleSoft DBA Forum as a technical forum for DBAs who work with PeopleSoft.  This forum now has over 1400 members.

    Oak TableOracle ACE Director



     David Kurtz 2017