Errata

If you have found something warranting inclusion in the errata, please send details to BookFeedback@Morle.com.

If you don't have the book yet, you can BUY IT HERE!

Page Reason Comments
13 Misprint /Typo Missing close-quote after in UPDATE statement (after INVALID)
82 Incorrect The ptx OSDs for NUMA no longer support quad locality for LGWR (from Oracle8 8.0)
95 Unclear

This section states:

"In addition to the improved seek times near the outer edge of the disk, the increased density also allows far greater data transfer rates, potentially 50 percent greater or more."
This refers to an increase in the amount of data stored in each track (more sectors per track), not an increase in density in each sector (bytes per sector remains constant)
222 Incorrect The fragment
"...we see that all the extents are five blocks in size..."
should read
"...we see that all the extents are multiples of 5 blocks in size..."
236 Unclear The fragment
"....with a maximum of four levels. This directly..."
should read
".. with a typical maximum of four levels in OLTP systems. The actual number of levels directly.."
266 Misprint /Typo

This formula should read:

	Hit Ratio = 1 - (physical reads / (db block gets + consistent gets))
280 Unclear

The fragment

"Once in the session cursor cache ... and the statement does not need to be reparsed up to the number of cursors specified in init.ora"
Should read:
"Once in the session cursor cache ... and the statement does not need to be hard reparsed up to the number of cursors specified in init.ora"
311 Typo

The SQL

SELECT * FROM V$EVENT_NAME
WHERE event='db file sequential read';

Should be

SELECT * FROM V$EVENT_NAME
WHERE name='db file sequential read';