with isolation set to SERIALIZABLE , you won't see any changes made in the database after the start of your transaction, until you commit.
Currently, there are three transaction isolation levels supported by the Oracle database. There is a fourth transition isolation level,
read uncommitted, that is not supported by Oracle.
These transaction isolation levels are:
Read Committed (the Oracle default)
each query can see only data committed before the query
Serializable
Read Only
No comments:
Post a Comment