Hi Ian,
The purpose of the command set transaction read only is to
implement the repeatable read isolation level.
Did you misspeak? As I understand it, the purpose of the set transaction
command is to set the isolation level of which there are 4 specified in the
ANSI spec and Oracle does
I have not read the ANSI specifications, however the gist of repeatable reads is
that the query will return the same data each time it is issued by a transaction.
Set transaction read only
does provide this. Your attention is invited to ...
The purpose of the command set transaction read only is to implement the
repeatable read isolation level. I just checked the 9i documentation ...
Oracle provides these transaction isolation levels:
Read committed
This is the default transaction isolation level. Each query executed by a