I continue to put new ideas, and recent research into my blog (www.psftdba.blogspot.com).

Index of postings:

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