PeopleSoft for the Oracle DBA (2nd Edition)NEWS: (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: 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 recently recorded an interview with Dan Iverson and Kyle Benson of psadmin.io.   It has been made available in three parts.  The podcasts are available on psadmin.io, 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.

    (11.4.2016)I have published a new utility to coalesce leaves on PeopleSoft trees into ranged leaves.  This can reduce the number of terms in some of the SQL queries generated by nVision, and in turn reduce parse time.

    (3.3.2016)I have published a document giving some generic advice for improving the performance of nVision Reports

    (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