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)