Oracle SQL Tuning Pocket Reference
by Mark Gurry

The following errata were *corrected* in the 4/04 reprint:

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem



{68} The second SELECT statement on page 68 NOW READS:

SELECT sql_text n1, 'Executions='||
    executions n1,
    'Expected Response Time in Seconds= '||
    buffer_gets /
      decode (executions, 0,1, executions)
      / 4000 "Reponse"
FROM v$sql
WHERE buffer_gets /
      decode (executions, 0,1, executions)
             / 4000 > 10
AND executions > 0
ORDER BY hash_value, child_number;