Errata for Optimizing Oracle Performance

the URL to Jared Stills site was incorrect, it NOW READS: http://www.cybcon.com/~jkstill/util/util_master.html

Paragraph reads: We've designed the exercises as a way to get you to try things out in your own environment. Generally, there are no single, correct answers. The results from a given exercise will be specific to your systems.

Method R performs reliability in virtually every performance problem situation imaginable; NOW READS: Method R performs reliably in virtually every performance problem situation imaginable;

After the existing "value" field paragraph, added the following paragraph: When no value field is emitted to the trace file, it is an indication that the NULL value has been bound into the placeholder variable. For example, in the fnd_profile.get_specific sample shown earlier, the absence of a value field for bind 4 indicates that the application has provided the NULL value for the :val placeholder. The bind value length specification of zero (avl=00) is corroborative evidence.

After the existing "value" field paragraph, added the following paragraph: When no value field is emitted to the trace file, it is an indication that the NULL value has been bound into the placeholder variable. For example, in the fnd_profile.get_specific sample shown earlier, the absence of a value field for bind 4 indicates that the application has provided the NULL value for the :val placeholder. The bind value length specification of zero (avl=00) is corroborative evidence.

Line break positions HAVE BEEN REVISED, as follows: # WAIT #2: ... # WAIT #2: ... # FETCH #2:...

The second occurrence of "TIMED_STATISTICS" in the last paragraph was spelled incorrectly: TIMED_STATSITICS NOW READS: TIMED_STATISTICS

"In the Hotsos Sparky data collector, we execute a query that is similar to this one immediately prior to executing the commands to activate tracing." NOW READS: "In the Hotsos Sparky data collector, we execute a query that is similar to this one immediately prior to executing the commands to activate and deactivate tracing."

"... before retuning the process to user running state." NOW READS: "... before returning the process to user running state."

NOW READS: Heisenberg uncertainty principle. (2 instances)

"...whatever state the processes is..." NOW READS: "...whatever state the process is..."

The sidebar mentioned an estimate of 10**80 atoms in the universe, and cites a siencenet.org.uk URL as one of the sources for that estimate. That URL no longer functions. The URLs leading to additional information NOW READ: http://www.sunspot.noao.edu/sunspot/pr/answerbook/universe.html#q70 http://www.nature.com/nsu/020527/020527-16.html

On page 173 in the section Un-Instrumented Oracle Kernel Code, the 2nd paragraph reads: u201cChapter 12 lists the number of code segments that are instrumented...u201d Does this refer to Table 11-1 on page 306 and should therefore read: u201cChapter 11...?u201d Reader is correct. The right reference now reads Table 11-1.

On page 173 in the section Un-Instrumented Oracle Kernel Code, the 2nd paragraph reads: u201cChapter 12 lists the number of code segments that are instrumented...u201d Does this refer to Table 11-1 on page 306 and should therefore read: u201cChapter 11...?u201d Reader is correct. The right reference now reads Table 11-1.

A big part of the problem is a principal that I can best.... NOW READS: A big part of the problem is a principle that I can best....

The label "Previous arrival" should say "Next arrival"

"... service time of s time units ..." NOW READS: "... service time of S time units ..."

"... a CPUs service rate ..." NOW READS: "... a CPU's service rate ..."

Similarly, you must ensue that service times are... NOW READS: Similarly, you must ensure that service times are...

"... (the one corresponding to the resource profile in Example 5-2,...)" NOW READS: "... (the one corresponding to the resource profile in Example 10-2,...)"

"... we were actually taught principals ...." NOW READS: "... we were actually taught principles ...."

In "Large c value for a parse call": If you have many small c values distributes across... NOW READS: If you have many small c values distributed across...

"... patch your Oracle kernel so that the your user action's code ..." 'the' HAS BEEN DELETED from the sentence.

"... we starting looking through ..." NOW READS: "... we started looking through ..."

principal NOW READS: principle

"Example 10-3" NOW READS: "Example 11-2 on page 322".

The word "been" was previosuly missing. Furthermore, the the quoted matter IS NOW offset from the surrounding text in a manner similar to that shown in the Oracle connection entry on page 359: the word "methodology" has used as a pretentious... NOW READS: the word "methodology" has been used as a pretentious...

buffer busy wait events, 54, 317 Central limit theorem, 169 Greek alphabet, motive for use, 228 Hotsos Profiler, xv, 61 Kyte, Tom, 55, 183, 194-196 Laplace, Pierre Simon de, 169 _SPIN_COUNT, 320b Still, Jared, xv tim.pl, 134 tkprof, xv, 61, 320 Trace Analyzer, 61 trcsummary, 61

START-SQL_TRACE-IN_SESSION events, 118 NOW READS: SET_SQL_TRACE_IN_SESSION, 118