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:

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

    © Go-Faster Consultancy Ltd. 2012