set transaction isolation level serializable is the highest form of locking. It requires reads of data to be repeatable. Any data that is being updated will not be included in your queury. set transaction isolation level read committed is one level below the above. It allows queries to use data as long as it has been commited. This would include data in the redo log.