Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Visibility of committed changes
Hello. I've been reading up on Oracle lately and I find something quite strange in the "Concepts" manual. This is what they claim:
Actually, even other users' transactions that started before mine will see my changes, as long as the other guys are not running in serializable mode. Read committed mode (default isolation level) is transaction-set consistent at statement level, not transaction level.
I tested this multiple times, and have found that, as expected, committed changes are immediately visible to all transactions running in read committed mode. The disturbing thing is that I find their claim stated over and over again. Here's another bit from the manual:
Another one:
So, what am I missing? Are my senses completely deceiving me? Or can Oracle documentation be so completely misguided? I'm getting quite frustrated.
vlad Received on Sat Jan 11 2003 - 02:00:56 CST