5.22 Summary of intention locking on a public table
NOTE: the shading on this picture may not be accurate. Please click on
the picture to obtain a larger image, which is accurate.
Key points
- The following locks are obtained by default when a read or a write is made to
a single row of a PUBLIC table:
- READ:
- An IS lock is obtained on the table.
- An S lock is obtained on the page.
- READ with an intention to write:
- An IX lock is obtained on the table.
- An SIX lock is obtained on the page.
- WRITE:
- An IX lock is obtained on the table.
- An X lock is obtained on the page.
Page last updated on November 29, 1995
|
Printable version
