Oracle9i

Page 19

The last sentence on page should read ".. temporary connections to the database as a user navigates through the application can contribute..."

Page 39

Note should read "You may occasionally be asked to activate tracing for database events.."

Page 88

Table 3.1, EXPLAIN Option "..using the PLAN_TABLE in the schema specified by this option."

Page 133

18th line should read "USE_STORED_OUTLINES"

Page 155

5th line, "Three" should be changed to "two" in this sentence.

Page 173

The code snippet at the bottom of page 173 is incorrect. It should be,
SQL> CREATE TABLE student_history
2 (student_id NUMBER(10),
3 degree VARCHAR2(3),
4 graduation_date DATE,
5 final_gpa NUMBER)
6 PARTITION BY RANGE (graduation_date)
7 SUBPARTITION BY HASH(student_id)SUBPARTITIONS 6
8 STORE IN (hist_tab01,hist_tab02,hist_tab03,
9 hist_tab04,hist_tab05,hist_tab06)
10 (PARTITION p_1997 VALUES LESS THAN
11 (TO_DATE('01-JUN-1997','DD-MON-YYYY')),
12 PARTITION p_1998 VALUES LESS THAN
13 (TO_DATE('01-JUN-1998','DD-MON-YYYY')),
14 PARTITION p_1999 VALUES LESS THAN
15 (TO_DATE('01-JUN-1999','DD-MON-YYYY')),
16 PARTITION p_2000 VALUES LESS THAN
17 (TO_DATE('01-JUN-2000','DD-MON-YYYY')),
18 PARTITION p_2001 VALUES LESS THAN
19 (TO_DATE('01-JUN-2001','DD-MON-YYYY')),
20 PARTITION p_ERROR VALUES LESS THAN (MAXVALUE));

Page 231

First sentence of "Tune Library Cache-specific init.ora Parameters" Should read "In addition to SHARED_POOL_SIZE, there are four init.ora parameters..."

Page 232

The third sentence in the SESSION_CACHED_CURSORS section should read: "If your application is form-based, setting this parameter to a non-zero value may improve the Library Cache hit ratio."

Page 247

Last sentence before heading "User Server Process" Should read "...use of the Dirty List while carrying out.."

Page 294

First sentence after code snippet at top of page should read "The above output from the ps command shows that six Shared Server processes..."

Page 296

The description for Dispatchers in Table 6.1 should read "Used to specify the number of Dispatchers to spawn at instance startup and the Oracle Net protocol assigned to each Dispatcher. The default value is 1.

Page 309

Second bullet (replace entire sentence)Should read "Recovery Manager backup and restore operations utilizing I/O slaves"

Page 310

Real World Scenario, last paragraph change to read "When the Large Pool is present, and RMAN has been configured to use I/O slaves through the use of the DISK_IO_SLAVES or BACKUP_TAPE_IO_SLAVES init.ora parameters, RMAN will use the Large Pool to buffer?"

Page 319

Question 16 Should read "What is the default size of the Large Pool?" not "What is the minimum size of the Large Pool?"

Page 381

First Run-In, Control Files Should read "The Log Writer and Checkpoint background...." not "The Database Writer and Checkpoint background..."

Page 385

Note at top of page should read ".. in Oracle9i Concepts, Release 1 (9.0.1) (Part Number...)"

Page 397

Understanding Oracle Blocks and Extents section, 6th sentence Should read "? most systems can use 2K, 4K, 8K, 16K, and 32K block sizes."

Page 441

Improving Rollback Segment I/O section, last sentence before bullets Should read "....consider these five tuning categories:" not "....consider these four tuning categories:"

Page 443

Last sentence at bottom of page, onto top of next page Should read "For example, one of user rbron's transactions is generating 280 blocks worth...."

Page 509

Third sentence from end of page - Should read "The techniques used to monitor paging and swapping vary by operating system."

Page 511

The last sentence should read "Table 10.4 describes four common server architectures".

Page 515

First sentence under Figure 10.3 Should read ".....server contains one CPU - as evidenced by the single CPU Usage History graph."

Page l

Explanation 58 should read "The LAST_ANALYZED column in the DBA_TABLES view will...."

Page xlvii

Explanation 30, 4th sentence ".... V$SQLTEXT may be contains in several rows..." should read "... V$SQLTEXT may be in several rows.."

Page xxvii

Assessment test Question 4 "Which default resource group should the BDA put these users in?? should be "Which default resource group should the DBA put these users in??

Page xxxix

Assessment test Question 46 "The DBA has determined that Free List contention in occurring on several busy application tables." Should be "The DBA has determined that Free List contention is occurring on several busy application tables."

Page xxxv

Question 32, 2nd sentence should read ".... of the following items? (choose four)"