Re: tx isolation

Hi Christoph

There has been a lot posted about this previously. Your best bet would be to search groups.google.com / google.com and look for the following;

"read consistency" or more accurately "multi-version read consistency" "lock escalation" or "escalating locks" etc.

In a nutshell, Oracle was architected many versions ago (ie it is not a new feature) to ensure that those reading from the database do not have to wait for those updating the database. This is not the case in many other databases such as sql server and you have to resort to escalating locks, reading uncommitted transactions etc. to overcome it.

An Oracle biased link is here
http://www.oracle.com/ip/deploy/database/oracle9i/db_sql_ma_askms.html

Further detail is in the Concepts document which can be found at the Oracle documentation site tahiti.oracle.com

HTH KJP Christoph Seidel wrote:
> can one give me some hints about how oracle is better in realizing tx
> isolation compared with other databases (e.g. sql server)
>
>
Received on Sun Dec 01 2002 - 19:37:10 CST