I continue to put new ideas, and recent research into my PeopleSoft blog (blog.psftdba.com), and my purely Oracle blog (blog.go-faster.co.uk).

Index of postings:

  • Running Unix Shell Scripts from the PeopleSoft Process Scheduler (26.2.2017)
  • Identifying Redundant Indexes in PeopleSoft (12.1.2017)
  • Removing Unnecessary Indexes: 3.Cost of Maintaining Indexes (10.1.2017)
  • Removing Unnecessary Indexes: 2. Identifying Redundant Indexes (6.1.2017)
  • Removing Unnecessary Indexes: 1. The Need for Extended Statistics (2.1.2017)
  • ASH Analysis: Detecting and Profiling Adaptive Plans in 12c (14.11.2016)
  • DBMS_LOCK: How to ensure only one instance of a PL/SQL procedure can execute concurrently (7.11.2016)
  • Refreshing Materialized Views with Referential Integrity Constraints (20.10.2016)
  • One of my Favourite Database Things: DBMS_APPLICATION_INFO (16.9.2016)
  • Complete Refresh of Materialized Views: Atomic, Non-Atomic and Out-of-Place (15.7.2016)
  • Setting Environment Variables in Application Server/Process Scheduler Tuxedo Domains (7.7.2016)
  • Diagnosing Non-Intuitive Errors with Errorstack (16.6.2016)
  • PeopleSoft on Oracle 12c (16.6.2016)
  • PS360: A Utility to Extract and Present PeopleSoft Configuration and Performance Data (16.6.2016)
  • nVision Performance Tuning: Coalescing Tree Leaves (19.4.2016)
  • PeopleSoft Administrator Podcast (26.3.2016)
  • nVision Performance Tuning: General Principles (6.3.2016)
  • Implementing Index Compression (and other Physical Storage Options) via Application Designer (11.2.2016)
  • Disappearing Histograms (14.11.2015)
  • Measuring Tuxedo Queuing in the PeopleSoft Application Server (4.9.2015)
  • When Is An Idle Wait Not An Idle Wait? (10.3.2015)
  • PeopleTools 8.54: Performance Performance Monitor Enhancements (10.3.2015)
  • Undocumented Application Engine Parameter: EnableAEMonitoring (4.3.2015)
  • PeopleTools 8.54: Oracle Resource Manager (21.2.2015)
  • PeopleTools 8.54: Multiple Query Security Records (21.2.2015)
  • PeopleTools 8.54: %SelectDummyTable meta-SQL (21.2.2015)
  • PeopleTools 8.54: %SQLHint meta-SQL (21.2.2015)
  • PeopleTools 8.54: Tables/Index Partitioning (20.2.2015)
  • PeopleTools 8.54: Global Temporary Tables (19.2.2015)
  • PeopleTools 8.54: Materialized Views (18.2.2015)
  • PeopleTools 8.54: Descending Indexes are not supported (16.2.2015)
  • PeopleTools 8.54 for the Oracle DBA (16.2.2015)
  • Filtering PeopleTools SQL from Performance Monitor Traces (3.11.2014)
  • Minimising Parse Time in Application Engine with ReUseStatement (25.10.2014)
  • Who is using this index? (3.9.2014)
  • To Hint or not to hint (Application Engine), that is the question (25.8.2014)
  • Introducing the Analytic Keep Clause for Effective-Dated/Sequence Queries in PeopleSoft (9.7.2014)
  • Implementing Deferred Segment Creation After an Upgrade (30.1.2014)
  • Oracle Date to Timestamp Conversion during PeopleTools Upgrade (3.1.2014)
  • Minimum Number of Recycling Server Processes (2.1.2014)
  • PeopleTools 8.52 Application Engine sets MODULE and ACTION (23.11.2012)
  • Using Two Temporary Tablespaces in PeopleSoft (16.11.2012)
  • Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g (30.9.2012)
  • Enabling Oracle Extended SQL Trace by Module and Action (20.9.2012)
  • Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects (19.7.2012)
  • Applying Hints to Objects inside Database Views (28.6.2011)
  • Deferred Segment Creation in PeopleSoft (26.6.2011)
  • Unlocking Temporary Table Instances from Deleted Process Requests (17.2.2011)
  • Finding Unnecessary Effective Date Processing in PS/Query (19.1.2011)
  • Row Level Locking in the PeopleTools Component Processor (18.1.2011)
  • PeopleTools 8.50 uses DBMS_APPLICATION_INFO to Identify Database Sessions (4.11.2010)
  • Performance Overhead of Multiple SQL calls in SQR (15.9.2010)
  • PeopleSoft Run Control Purge Utility (10.9.2010)
  • Announcing the Co-Operative PeopleTools Table Reference (12.7.2010)
  • Configuring Large PeopleSoft Application Servers (17.6.2010)
  • Life Cycle of a Process Request (11.6.2010)
  • Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll (31.3.2010)
  • Capturing DDL for Database Objects Not Managed by PeopleTools (25.3.2010)
  • Hinting Dynamically Generated SQL in Application Engine (4.3.2010)
  • Performance Metrics and XML Reporting in PeopleSoft (20.1.2010)
  • Automatically Identifying Stored Statements & Using DBMS_STATS in PeopleSoft Cobol (10.1.2010)
  • Hinting Sub-Queries on Oracle (17.12.2009)
  • Controlling How PeopleSoft Cobol Collects Statistics (25.11.2009)
  • Database Links and PeopleSoft (28.10.2009)
  • Partition Maintenance with Globally Partitioned Indexes (21.10.2009)
  • Global Temporary Tables Shared Statistics Across Sessions (13.10.2009)
  • Aggregating & Purging Batch Timings (11.10.2009)
  • Identifying Application Engine Source Code (10.9.2009)
  • Automatic Segment Space -v- Freelist Management for PeopleSoft Temporary Records (28.7.2009)
  • PeopleSoft and the Oracle Recycle Bin (23.7.2009)
  • Oracle Terminated Connection Timeout (14.7.2009)
  • Dynamically Switching PeopleSoft Temporary Records between Global Temporary and Normal Tables during Application Engine Programs (6.7.2009)
  • Oracle 10g Statistics History Retention in PeopleSoft (25.6.2009)
  • Controlling How %UpdateStats Collects Optimizer Statistics (25.6.2009)
  • Manually Booting Tuxedo Application Server Processes in Parallel (19.5.2009)
  • Reducing Unnecessary Instances of Temporary Records (22.4.2009)
  • Statistics Management for Partitioned Objects in PeopleSoft (6.4.2009)
  • Statistics Management for PeopleSoft Temporary Records in Application Engine Programs (6.4.2009)
  • Automatically Granting Privileges on Newly Created Tables (continued) (2.4.2009)
  • Using Oracle Enterprise Manager (Grid Control) with PeopleSoft (13.3.2009)
  • Minimum Number of Application Server Processes (12.3.2009)
  • Automatically Granting Privileges on Newly Created Tables (4.3.2009)
  • Performance Benefits of ReUse Statement Flag in Application Engine (27.2.2009)
  • Do You Need More Temporary Table Instances? (26.2.2009)
  • Managing Changes to the Number of Instances of Temporary Tables used in Application Engine Programs (30.1.2009)
  • Factors Affecting Performance of Concurrent Truncate of Working Storage Tables (26.1.2009)
  • Detecting and Fixing Row Migration (20.1.2009)
  • PeopleSoft's PSADMIN Role (6.1.2009)
  • Poor performance of PSPMSESSIONS_VW view affects Performance Monitor System Monitor Component (22.12.2008)
  • Row Migration can Aggravate Contention on Cache Buffers Chains Latch (15.12.2008)
  • Graphing AWR data in Excel (13.12.2008)
  • How to Clear the Application Server Cache Without Shutting it Down (14.8.2008)
  • Serious fault with PeopleSoft Performance Monitor fixed in PeopleTools 8.49.14 (4.8.2008)
  • Sequence Number Allocation in PeopleSoft (1.7.2008)
  • Discrepancy in Timings between Application Engine and Oracle SQL Trace (27.6.2008)
  • Oracle Optimizer Statistics and Optimizer Dynamic Sample with PeopleSoft Temporary Records (3.6.2008)
  • Performance Tuning the Performance Monitor Archive Process (26.5.2008)
  • Enabling Oracle Database Trace on PeopleSoft processes with a Trigger (improved) (18.5.2008)
  • Bulk Re-Sending Batch Output to Report Repository (30.4.2008)
  • Global Temporary Tables and PeopleSoft Temporary Records (9.1.2008)
  • Oracle/PeopleSoft have mixed up DDL Models used by %UpdateStats from PeopleTools 8.48 (8.1.2008)
  • Changes in Calculation of Predicate Selectivity in Oracle 10g (11.11.2007)
  • Advantages of Row Source Aliases inside Views (3.11.2007)
  • TM locking: Checking for Missing Indexes on Foreign Key Constraints (28.10.2007)
  • Record Locator Dialogue Behaviour (27.10.2007)
  • Dirty Reads in PeopleTools 8.49 (2.10.2007)
  • Descending Indexes are back! (1.10.2007)
  • Using v$session_longops to find long running SQL statements (1.10..2007)
  • Running Unix Commands and Scripts from the PeopleSoft Process Scheduler (7.9.2007)
  • Performance Metrics for Scheduled Queries in Peoplesoft(28.8.2007)
  • Fine-Grained Auditing in PeopleSoft(26.7.2007)
  • Changes to Long Columns and Unicode in PT8.48 (2.7.2007)
  • Data Guard Implications of NOLOGGING operations from PeopleTools 8.48 (27.6.2007)
  • Database login information in your SQL*Plus prompt (27.6.2007)
  • Unix Process Limits for PeopleSoft (15.6.2007)
  • Column default values in PeopleTools 8.48 DDL (8.5.2007)
  • %UpdateStats() -v- Optimizer Dynamic Sampling (3.5.2007)
  • Changes to DDL Models in PeopleTools 8.48 (2.5.2007)
  • Reset Global Unique Identifier when cloning PeopleSoft databases (22.2.2007)
  • Use of Windows Service Dependency in PeopleSoft (7.2.2007)
  • Retrieving Oracle trace files via an external table (4.12.2006)
  • Truncating a Table does not affect the Materialized View Log (1.11.2006)
  • DDL Triggers to prevent loss of database objects not managed by PeopleTools (29.10.2006)
  • Nullable VARCHAR2 columns in PeopleSoft (19.10.2006)
  • What not to Code: The evils of tables as sequence generators and timestamps for uniqueness (11.10.2006)
  • Global nVision performance options (10.10.2006)
  • SQL Tips for Developers: Performance Improvements with the Append Hint (6.10.2006)
  • PeopleTools Platform Flags on Indexes (17.8.2006)
  • Additional Batch Timings from Application Engine (15.6.2006)
  • Identifying Candidate Records for the Lookup Exclusion Table (16.5.2006)
  • Measuring Network Latency with the PeopleSoft Performance Monitor Transaction 116 (27.4.2006)
  • Migrating DDL Overides with Application Designer (26.4.2006)
  • Performance Tuning the Performance Monitor (25.4.2006)
  • Using DDL Triggers to protect database objects not managed by Application Designer (25.4.2006)
  • %CurrentDateIn MetaSQL prevents Oracle CBO from correctly evaluating selectivity of predicate (12.4.2006)

  •  David Kurtz 2017