Oracle SQL Tuning Pocket Reference

Errata for Oracle SQL Tuning Pocket Reference

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 40
1st line

The parameter discussed is listed as OPTIMIZER_MODE_ENABLE. In version 8.1.7.2 of Oracle, there is no parameter name OPTIMIZER_MODE_ENABLE. Parameter listed NOW READS: OPTIMIZER_FEATURES_ENABLE

Anonymous    Oct 01, 2003
Printed
Page 40
1st line

The parameter discussed is listed as OPTIMIZER_MODE_ENABLE. In version 8.1.7.2 of Oracle, there is no parameter name OPTIMIZER_MODE_ENABLE. Parameter listed NOW READS: OPTIMIZER_FEATURES_ENABLE

Anonymous    Oct 01, 2003
Printed
Page 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;

Anonymous    Apr 01, 2004
Printed
Page 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;

Anonymous    Apr 01, 2004