|
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 |
|
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.
|
 |
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.
|
 |
Title:Oracle Architecture
Author: Unknown
This paper is a chart of the Oracle Architecture and OFA.
|