The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version |
Location |
Description |
Submitted by |
Date Submitted |
Printed |
Page 51
In the second paragraph, ARCHIVE_LOG_DEST should be LOG_ARCHIVE_DEST. |
|
Anonymous |
|
Printed |
Page 111
The second code example is missing all the appropriate indentation. |
|
Anonymous |
|
Printed |
Page 150
Turkey |
I mention this point about the cost-based optimizer reanalyzing a table for
every execution to a collegue and was rebuffed. It seems that this may be true
for 7.3.4 but clearly is not in 8.1.6 -- the CBO uses some default values in
place of actual statistics when computing an execution cost ("Oracle8i
Designing and Tuning for Performance Release 2 (8.1.6)").
Though your book covers only 7 and 8, the CBO appears to have been going
through a major evolution of features and functionality, even over minor
releases, which brings into question the actual CBO behavior for each release
-- 7.3.4, 8.0, 8.1.5, 8.1.6 -- when statistics are unavailable.
|
Anonymous |
|
Printed |
Page 197
2nd line |
you write:
the command: ALTER DATABASE BACKUP CONTROLFILE TO TRACE will put the tracefile in the directory specified by the INIT.ORA parameter BACKGROUND_DUMP_DEST.
It should be the directory specified by the INIT.ORA parameter USER_DUMP_DEST
THE SAME FOR THE POCKET REFERENCE: ORACLE DBA CHECKLISTS, page 32
(I did not submit an errata form for the pocket reference)
|
Anonymous |
|
Printed |
Page 203
Reader clarification |
"The number of rows per block can then be calculated as:"
(long formula follows...) However, it's not really an equation;
there is no 'rows per block = (formula...)'. In fact, the rows per
block the DBA is trying to calculate is embedded in the formula.
This makes it (very) difficult to calculate rows per block (in MHO).
I'd suggest an improved formula posted to your 'errata' for this book.
|
Anonymous |
|
Printed |
Page 205
Table 11-1 |
sequence of "Size in Blocks" should go 40 40 44 49 not 40 40 40 49
|
Anonymous |
|
Printed |
Page 333
Last example for ALTER TABLE |
The example for adding a primary key is wrong:
ALTER TABLE scott.emp
MODIFY (empno CONSTRAINT pk_emp PRIMARY KEY)
this should be read as:
ALTER TABLE scott.emp
ADD CONSTRAINT pk_emp PRIMARY KEY (empmo)
|
Anonymous |
|
Printed |
Page 368
CREATE ROLLBACK SEGMENT syntax |
[MINEXTENTS integer[K | M] ]
should read
[MINEXTENTS integer]
|
Anonymous |
|
Printed |
Page 386
segment_attrib_clause syntax |
you omit the
[NEXT integer[k|M]]
storage option
|
Anonymous |
|