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:

  • 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)