In the Note, there is a reference to enqueue locks with no underscore character) in the first line, and enqueues locks in the second. Both of these should read enqueue_locks
In the Note: two naming errors in one sentence: “as can be seen in the dynamic performance view v$latch_holder, which is underpinned by the structure x$ksuprlatch“. The correct name for the v$ structure is v$latchholder (no underscore), the correct name for the x$ structure is x$ksuprlat
In the Note, fifth line, there is a reference to the parameter enqueues; this should be the hidden parameter _enqueue_locks.
Second paragraph, third line, makes a reference to “… a column x$ksqlres, which is …”; the correct name for the column is ksqlkres.
Bullet point 1 should be: “Session 37: Delete the only child of parent 1”
Bullet point 2 should be: “Session 36: Delete the only child of parent 2”
Figure 4-4, the label on the bottom right-hand rectangle read “Sid 35 0,5” when it should be “Sid 35 0,3“
Three lines from bottom of page: “… session 29 started waiting …”, this should be “… session 39 started waiting …”
Finally, we can see that the backward pointer in line 3 and the forward pointer in line 4 are both (21a4cda0) pointing back to the resource address (21A4CD90), although the offset is 32 rather than 8.
(see comment below) The offset is 16, not 32. The three offsets are 8, 16, and 24 for owners, waiters, and converters respectively.
Table 4-2. Statistic Misses – should be “misses”
Table 4-2. Statistics Sleeps, Immediate_gets, Immediate_misses, Wait_time are all capitalised when they should not be.
Last line of last Note: “Parsing and Optimising” should be (American) “Parsing and Optimizing”
Second paragraph of section Infrastructure, last line: “…the array definition are” needs a colon: “… the array definition are:”
Paragraph after first note: “The command is” needs a colon: “The command is:”
First line of section headed Deadlock: “Looking back as …” should be “Looking back at …”
Last Note, end of second line: “… will say” needs a colon: “… will say:”
Second paragraph (style): “Mutexes are small, and don’t have lists associated with them, we now have information pointing one way, the session knows which mutexes it is holding, but the mutex doesn’t know which sessions are holding it.” This would be better as: “Mutexes are small and don’t have lists associated with them. This means we now have information pointing only one way – the session knows which mutexes it is holding but a mutex doesn’t know which sessions are holding it.”