Errata

Oracle 8i Internal Services

Errata for Oracle 8i Internal Services

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 1

In the last paragraph, the first sentence used to read:

"... needed for task such as ..."

Now reads:

"... needed for tasks such as ..."

 Anonymous    Dec 01, 1999
Printed
Page 10
At the end of the second paragraph, "Scheduling Latencies"

is now a B-heading.

 Anonymous    Nov 01, 1999
Printed
Page 10
Figure 2-1: the diagram now has the solid lines to represent when

the processes are runnable. There is now a solid line where each of the
numbers are.

 Anonymous    Dec 01, 1999
Printed
Page 10
Changed the Tip to a regular paragraph, and inserted it above the

"Scheduling Latencies" heading. Also, changed "The semaphore parameters..."
to "Note that the semaphore parameters..."

 Anonymous    Jan 01, 2001
Printed
Page 13
Inserted the following Warning above the "Wait Types" heading

"Bug 918002 can inhibit SQL statement sharing and cause latch
contention in release 8.1.5 if TIMED_STATISTICS or SQL_TRACE are used.
Bug 1210242 can cause the same performance problem under release 8.1.6
if both facilities are used concurrently."

 Anonymous    Jan 01, 2001
Printed
Page 17
In the second line of the center column in the table at the bottom of

the page, changed "V$SYSTEM_EVENT" to "V$SESSION_EVENT".

 Anonymous    Jan 01, 2001
Printed
Page 18
In the second line of the center column in the table at the top of

the page, changed "V$SESSION_EVENT" to "V$SYSTEM_EVENT".

 Anonymous    Jan 01, 2001
Printed
Page 27
3rd Paragraph under heading "Latch Wait Posting"

"By default, latch wait posting is enabled for the library cache and shared pool
latches."
should read:
"By default, latch wait posting is enabled for the library cache, library cache load
and shared pool latches."

 Anonymous   
Printed
Page 30

In the 2nd last para, LOG_SIMULTANEOUS_COPIES now reads :

_LOG_SIMULTANEOUS_COPIES

 Anonymous    Nov 01, 1999
Printed
Page 30
Replaced the end of the paragraph at the top of the page, from the

sentence beginning "That statistic represents...", with the following text
(note that terms in single quotes should be in italics):

"That statistic represents the number of times that a process missed
on this latch while holding another latch. For example, the
WAITS_HOLDING_LATCH statistic for the 'redo allocation' latch counts
both 'spin gets' and 'sleep gets' against the 'redo allocation' latch
while holding another latch such as a 'cache buffers chains' latch."

 Anonymous    Jan 01, 2001
Printed
Page 34
The description for LAST_WAIT_POSTING (in the "Parameters" section) did

read:

"latch wait posting is enabled for the library cache and shared pool
latches only."

Now reads:

"latch wait posting is enabled for library cache, library cache load,
and shared pool latches only."

 Anonymous    Jan 01, 2001
Printed
Page 34

The description for _SPIN_YIELD_CPU_FREQ did read:

"...on multi-processor machines."

Now reads:

"...on most multi-processor machines."

 Anonymous    Jan 01, 2001
Printed
Page 35

The description for waits holding latch did read:

"The number of times that a process waited on any event while holding
the latch"

Now reads:

"The number of misses while holding another latch"

 Anonymous    Jan 01, 2001
Printed
Page 42

Used to read:

it is converted from an index into

Now reads

it is converted to an index into

 Anonymous    Nov 01, 1999
Printed
Page 43
In the sentence

The blocked process records an enqueue wait.

the word "enqueue" has been changed to italics.

 Anonymous    Nov 01, 1999
Printed
Page 51
Removed italics from "wait" after "library cache pin".

Anonymous    Nov 01, 1999
Printed
Page 51
In Table 4-5, changed "2 shared" to "3 shared" and "3 exclusive" to

"5 exclusive".

 Anonymous    Jan 01, 2001
Printed
Page 62
Removed italics from "wait" in "DFS lock handle wait"

Anonymous    Nov 01, 1999
Printed
Page 64
Removed italics from "wait" in "row cache lock wait"

Anonymous    Nov 01, 1999
Printed
Page 70
Removed italics from "wait" in "global cache lock waits"

Anonymous    Nov 01, 1999
Printed
Page 74
Removed italics from "wait" in "global cache lock busy waits"

Anonymous    Nov 01, 1999
Printed
Page 77
_LM_DIRECT_SENDS, "all messages are send" now reads "sent"

Anonymous    Nov 01, 1999
Printed
Page 96
The following sentence has been added at the end of the first full

paragraph:

"Note that from release 8.1.6 there are many more free lists in the
shared pool, and thus 'shared pool' latch contention is no longer a
major problem."

 Anonymous    Jan 01, 2001
Printed
Page 98
In the 4th line of the last paragraph, changed "never" to "seldom"

(occurs twice in the line).

 Anonymous    Jan 01, 2001
Printed
Page 99
The last sentence of the first paragraph (starting with "Nevertheless,

large chunks...") has been deleted.

 Anonymous    Jan 01, 2001
Printed
Page 102

The last line on the page did read:

"* Parallel Query Option (PQO)"

Now reads:

"* Parallel Execution (PX)--formerly Parallel Query Option (PQO)"

(colophon) The first sentence of the fifth paragraph did read:

"Ellie Volkenhausen designed the cover of this book..."

Now reads:

"Ellie Volckhausen designed the cover of this book..."

 Anonymous    Jan 01, 2001