ASA SQL User's Guide
Using Transactions and Isolation Levels
The different isolation levels behave in very different ways, and which one you will want to use depends on your database and on the operations you are carrying out. The following set of tutorials will help you determine which isolation levels are suitable for different tasks.
Dirty read tutorial
Non-repeatable read tutorial
Phantom row tutorial
Practical locking implications tutorial