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