Book errata

Changes are made to books after they have been published. Prior to each printing, the publisher asks me if any changes need to be made and I give them a list. Here are the known issues with the recent editions of the books. Depending on the printing you have, these errors may or may not be fixed in your copy.

 

ORACLE9i DBA Handbook

Base version used for testing scripts: 9.0.1

The following changes have been made to the scripts posted on this site. These corrections will be in the second printing of the book.

Page 24, third line after the listing, change MAX_SGA_SIZE to SGA_MAX_SIZE.

Page 66, first listing, add "alter database" at the beginning of the listing to change this from a code fragment to a full command.

Page 128, change the datafile names in the example (you would anyway if you were executing this code). See pages 176-177 for sample file names.

Page 350, add "execute" as the first word of the first line of the listing
execute STATSPACK.MODIFY_STATSPACK_PARAMETER -

Page 449, change the reference to svrmgrl in the script to sqlplus /nolog instead.

Page 460, last listing, add a comma at the end of the third line:
execute DBMS_LOGMNR.START_LOGMNR(
DictFileName => '/oracle/dictionary.ora',
StartTime => TO_DATE('01-JUNE-2001 12:31:00', DD-MON-YYYY HH:MI:SS'),
EndTime => TO_DATE('01-JULY-2001 00:00:00', DD-MON-YYYY HH:MI:SS'));

Page 461, add a comma at the end of the third line:
execute DBMS_LOGMNR.START_LOGMNR(
DictFileName => '/oracle/dictionary.ora',
StartScn => 125,
EndScr => 300);

 

 

kevinloney.com

Put the pieces together.