View events.pdf
Title: A Description of Oracle Wait Events
Author: Anjo Kolk
Date: 3 September 1996

The Oracle wait interface is a means of determining current events in the database that are causing waits. The events themselves are detailed and numerous. The events are given in this document along with some sql in order to detrmine their cause
View ofa.pdf
Title: The OFA Standard - Oracle 7 for Open Systems
Author: Cary V Milsap
Date: 24 September 1995

The OFA Standard is a set of configuration guidelines that will give you faster, more reliable Oracle databases that require less work to maintain. Cary Millsap was the original creator of OFA. OFA is a set of rules that define the optimal directory structure for Oracle Software, Database components and administration files. This is now the industry standard for Oracle instalklation and adminstration.

Although originally written under the sub-title of "Oracle 7", the rules are all applicable for later versions of oracle.
View piranhas.doc
Title: PIRANHAS IN THE POOL, SQL PERFORMANCE KILLERS
Author: John Beresniewicz
Date: 1996

This paper investigates the effects of non-sharable SQL on Oracle performance and presents quantitative results of controlled testing of the issue. Oracle shared pool and library cache internals are discussed, as well as DBA strategies for managing performance of high-volume non-sharable SQL. The new 8.1.6 CURSOR_SHARING parameter is also tested for its effectiveness at solving these issues.
View oo.ppt
Title:Oracle Architecture
Author: Unknown


This paper is a chart of the Oracle Architecture and OFA.