Oracle Performance Tuning

Errata for Oracle Performance Tuning

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 xvii

Anonymous    Oct 01, 1999
Printed
Page xviii

Anonymous    Oct 01, 1999
Printed
Page xxii

Anonymous    Oct 01, 1999
Printed
Page Part VII, 771

Anonymous    Oct 01, 1999
Printed
Page xviii-xxii
The following text was added to the preface

"We have tested and verified the information in this book to the best of our ability, but you may find that features have changed (or even that we have made mistakes!). Please let us know about any errors you find, as well as your suggestions for future editions, by writing to: O'Reilly & Associates, Inc. 101 Morris Street Sebastopol, CA 95472 1-800-998-9938 (in the U.S. or Canada) 1-707-829-0515 (international/local) 1-707-829-0104 (FAX) You can also send us messages electronically. To be put on our mailing list or request a catalog, send email to: info@oreilly.com To ask technical questions or comment on the book, send email to: bookquestions@oreilly.com We have a web site for the book, where we'll list examples, errata, and any plans for future editions. You can access this page at: http://www.oreilly.com/catalog/9781565922372/ For more information about this book and others, see the O'Reilly web site: http://www.oreilly.com"

Anonymous    Feb 01, 2000
Printed
Page 24

last bullet now reads: * LOB columns (BLOB, CLOB, NCLOB, and BFILE) can be as large as 4 gigabytes. You can specify the BLOB and CLOB columns in a separate tablespace from the rest of the table. BFILE columns are stored in a file external to the database.

Anonymous    Aug 01, 1997
Printed
Page 154

The text in the second example used to read: "Index Range Scan on Dept_Idx Index Range Scan on Cat_Idx" It now reads: "Index Range Scan on Cat_Idx Index Range Scan on Dept_Idx"

Anonymous    Feb 01, 2000
Printed
Page 170
line 5: changed

BY DECODE(:BLK.SEQN_FLD 'E', emp_no, 'D', dept_no); to BY DECODE(:BLK.SEQN_FLD, 'E', emp_no, 'D', dept_no);

Anonymous    May 01, 1998
Printed
Page 174
code 1, line 1: changed "dpt_no" to "dept_no"

Anonymous    Dec 01, 1997
Printed
Page 180
"Note" changed: both "WHEN"s changed to "WHERE"

Anonymous    Dec 01, 1997
Printed
Page 183

code 2, line 4 now reads: UNION ALL The following scripts were replaced: [295]: waiters.sql [431]: tspuse.sql [588]: exp_lrge.sh [609-610]: chk_nxt.sql For the new scripts, return to the book's web page and click on the "Book Examples via ftp" link.

Anonymous    Dec 01, 1997
Printed
Page 186
line 7: changed WHERE EMp_NO > 0 to WHERE emp_no > 0

Anonymous    May 01, 1998
Printed
Page 193
bottom of the example: changed

sum_sick_leave(E.emp_no) sick_days, sum_holiday_leave(E.emp_no) holidays to Sum_Sick_Leave(E.emp_no) sick days, Sum_Holiday_Leave(E.emp_no) holidays

Anonymous    May 01, 1998
Printed
Page 194
# inl_outj.sql script: removed the third AND

Anonymous    May 01, 1998
Printed
Page 203
example script, line 2: changed

sql> SELECT sql_text, executions, to sql> SELECT executions,

Anonymous    May 01, 1998
Printed
Page 211
2nd code block, after 4th line, add

sal_val >= 8001 Then And change the preceding "THEN" to "OR" so the code reads: If sal_val <= 2000 OR sal_val >= 8001 THEN RETURN (0); END IF;

Anonymous    Dec 01, 1998
Printed
Page 370
line -8, third list item: changed LOG_ENTRY_PREBUILD_THRESHOLD

to _LOG_ENTRY_PREBUILD_THRESHOLD

Anonymous    May 01, 1998
Printed
Page 427

Anonymous    Oct 01, 1999
Printed
Page 430
9th line

The FROM statement of objstor.sql used to read: "dbs_tables T," now it reads: "dba_tables T,"

Anonymous    Jun 01, 2001
Printed
Page 451
Bottom of the page

A comma has been added to the end of the seventh line of code: sum(decode(nvl(num_rows,9999), 9999,0,1)) "Tables Analyzed",

Anonymous    Jun 01, 2001
Printed
Page 458

The bulleted item at the top of the page used to read: Encourage developers to use bind variables whenever possible. For example, use this statement: SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; instead of these: SELECT acct_name, acct_limit FROM account WHERE acct_no = 10301; SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; now it reads: Encourage developers to use bind variables whenever possible. For example, use this statement: SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; instead of this: SELECT acct_name, acct_limit FROM account WHERE acct_no = 10301;

Anonymous    Jun 01, 2001
Printed
Page 466

Bottom of the page used to read: "user_opening" now it reads: "users_opening"

Anonymous    Jun 01, 2001
Printed
Page 469
Bottom of the page

There is now a join required in both SQL statements. They now read as follows: SELECT SUM(VALUE) FROM V$SESSTAT st, V$STATNAME nm WHERE nm.NAME = 'session uga memory' AND st.STATISTIC# = nm.STATISTIC# / and SELECT SUM(VALUE) FROM V$SESSTAT st, V$STATNAME nm WHERE nm.NAME = 'session uga memory max' AND st.STATISTIC# = nm.STATISTIC# /

Anonymous    Jun 01, 2001
Printed
Page 471
line -8, changed DB_BUFFER_BLOCKS to DB_BLOCK_BUFFERS

Anonymous    May 01, 1998
Printed
Page 472

In the code example, it used to read: (TRUNC(indx / 250) +1 interval, now it reads: (TRUNC(indx / 250) +1) interval,

Anonymous    Jun 01, 2001
Printed
Page 475
Tenth line from the top

The line "AND username is not null" has been added.

Anonymous    Jun 01, 2001
Printed
Page 475
Ninth line from the bottom

The line "AND se.username is not null" has been added.

Anonymous    Jun 01, 2001
Printed
Page 476
In the first full code

The line, "and ob_typ = 2", has been removed.

Anonymous    Jun 01, 2001
Printed
Page 476
In the second full code, the last line has been removed and the second

to last line has been changed. It used to read: WHERE username||' ('||sid||')' = "User Session") ORDER BY username, sid, now it reads: WHERE username||'('||v$session.sid||')' = "User Session")

Anonymous    Jun 01, 2001
Printed
Page 513
Middle of the page

"No responses" now reads: "No response"

Anonymous    Jun 01, 2001
Printed
Page 513
Middle of the page

The quotation marks have been changed in the line: WHERE Q.type = 'DISPATCHER'

Anonymous    Jun 01, 2001
Printed
Page 514

Top of the page used to read: FROM v$shared_servers now it reads: FROM v$shared_server

Anonymous    Jun 01, 2001
Printed
Page 514
Top of the page

The quotation marks have been changed in the line: WHERE status !='QUIT'

Anonymous    Jun 01, 2001
Printed
Page 515
In # locksql.sql

In line 1, "sid" has been changed to "ses.sid" In line 2, "prc.osuser" has been changed to "ses.osuser"

Anonymous    Jun 01, 2001
Printed
Page 516

The eleventh line form the top used to read: AND l1.id1 = l2.id1 now it reads: WHERE l1.id1 = l2.id1

Anonymous    Jun 01, 2001
Printed
Page 518
Top of page

All the references to V$SQLAREA have been changed to V$SQLTEXT.

Anonymous    Jun 01, 2001
Printed
Page 518
Top of page

A Order by line has been added to the bottom of the script: order by 'User '||v$session.username||'('||v$session_wait.sid||')', piece

Anonymous    Jun 01, 2001
Printed
Page 588
in the next-to-last line of para. 1, changed "megabytes" to

"gigabytes"

Anonymous    Dec 01, 1997
Printed
Page 588
replaced the exp_lrge.sql script. For the new script, return to

the book's web page and click on the "Book Examples via ftp" link.

Anonymous    May 01, 1998
Printed
Page 653
line 4: "99" changed to "1"

Anonymous    Aug 01, 1997
Printed
Page 923

Any references that may have been missed, and still refer to the disk, should be ignored. Please see the O'Reilly web site instead. Thank you.

Anonymous    Oct 01, 1999
Printed
Page 942
Colophon, para. -2: added the following sentences

"Whenever possible, our books use RepKover, a durable and flexible lay-flat binding. If the page count exceed RepKover's limit, perfect binding is used."

Anonymous    Aug 01, 1997
Printed
Page 942
The following text was removed from the Colophon

"Whenever possible, our books use RepKover, a durable and flexable lay-flat binding. If the page count exceeds Rep- Kover's limit, perfect binding is used."

Anonymous    Feb 01, 2000