Oracle Performance Tuning, 2nd Edition
by Mark Gurry and Peter Corrigan


Here are the changes from the 5/98 reprint:


{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);


{186} line 7:  changed WHERE EMp_NO > 0 to WHERE emp_no > 0


{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


{194} # inl_outj.sql script:  removed the third AND


{203} example script, line 2:  changed

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


{370} line -8, third list item: changed LOG_ENTRY_PREBUILD_THRESHOLD
to _LOG_ENTRY_PREBUILD_THRESHOLD


{471} line -8, changed DB_BUFFER_BLOCKS to DB_BLOCK_BUFFERS


[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.