Performance Benefits of ReUse Statement Flag in Application Engine

see related blog entry: Performance Benefits of ReUse Statement Flag in Application Engine

Published in issue 38, Summer 2009 of Oracle Scene, the magazine of the UK Oracle User Group (this issue is availabe as either a PDF file or Digital Edition).
Oracle Fine-Grained Auditing in PeopleSoftPublished in issue 32, Winter 2007 of Oracle Scene, the magazine of the UK Oracle User Group.
PeopleTools 8.48 Changes in Cost-Based Optimizer StatisticsPublished in issue 31, Autumn 2007 of Oracle Scene, the magazine of the UK Oracle User Group.
Suppressing Automatic Lookups for Improved UsabilityPublished in Special Conference 2006 Edition of Oracle Scene, the magazine of the UK Oracle User Group.
The Devil is in the PeopleSoft MetaSQLPublished in issue 26, Summer 2006 of Oracle Scene, the magazine of the UK Oracle User Group.
PeopleSoft DDL & DDL ManagementPublished in issue 25, Spring 2006 of Oracle Scene, the magazine of the UK Oracle User Group.
PeopleTools: Properly Instrumented for Performance Tuning?Published in issue 24, Winter 2005 of Oracle Scene, the magazine of the UK Oracle User Group.
PeopleTools Tables: The Application Repository in the DatabasePublished in issue 23, Autumn 2005 of Oracle Scene, the magazine of the UK Oracle User Group.
This is the first in a series of articles that examines some of the aspects of PeopleTools, the proprietary technology developed by PeopleSoft, and that speculates about Project Fusion
AphorismsPublished in issue 16, Winter 2003 of Oracle Scene, the magazine of the UK Oracle User Group.
Several years ago I realised that I had a collection of catchphrases and quotes that I was using when discussing performance issues. I even put them all into a rather frivolous presentation. However, they do express a valid points. To successfully address performance issues, you have to look at the problem in the correct light.

Companion Presentation: Aphorisms

Experiences of Global Temporary TablesPublished in issue 6, Summer 2001 of Oracle Scene, the magazine of the UK Oracle User Group.
Global Temporary Tables are a new feature in Oracle 8.1. They can bring significant performance improvements when it is too late to change the design.

It is also available as a zip archive with exhibited files. Companion Presentation: Experiences of Global Temporary Tables in Oracle 8.1

Caveat: There is no guarantee that any of the content of this website is error free, rather that there are certainly errors and inconsistencies!


 David Kurtz 2015