Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: changing the isolation level
>> Think of a script, that generates invoices montly. Lets say you have a >> average volume of $1000 dollar. So if a run of the script in the next >> month just returns a volume of $200 you can be pretty sure, that >> something has gone wrong. But if you cannot see this until you >> confirmed all the stuff, then it is too late to revoke it.
This was just an example! The point is: There are scenarious, where you need to read "dirty" uncommitted data. Don't try to think all people have just that one simple business case where everything can be managed within on transaction by one process! Think of heterogenous systems where one specialised system can change data but it cannot commit until another specialiced system reads the data and performs whatever with it.
>> Sybase supports all levels of isolation, so when I read that Oracle >> doesn't allow a certain isolation level it just sounds like a lame >> excuse for a missing feature.
Thanks, I already own several useful Oracle books and my problem is neither a mental problem nor a Sybase one. Sybase doesn't force me to read uncommited data, it _allows_ me to do that (because I need it in my business case). And the model isn't bad because it works with Sybase. Sybase just performs perfectly according the isolation level I'm free to set, even not showing uncommited data if I want, while Oracle doesn't. Received on Sat Feb 03 2007 - 22:41:44 CST