Re: tracking changes on a table through ODBC application

>
>
> We are talking Oracle here. Oracle doesn't have 'dirty reads' like the
> Mickeysoft toys do.
>
>

Both DB2 and SQL Server support all four *standard* isolation levels. Even open source databases like PostgreSQL are also getting there, so its quite suprising that oracle is lagging behind in not supporting these isolation levels. Even going upto the extent of claiming that "dirty reads" are undesireable when they are pretty much standardized and exist in other databases.

Here is what Oracle documentation says about changing isolation level to "uncommitted read":

"READ UNCOMMITTED
Oracle never permits "dirty reads." Although some other database products use this undesirable technique to improve thoughput, it is not required for high throughput with Oracle."

It should actually read:

"READ UNCOMMITTED
Oracle never permits "dirty reads." since one of our developers way back in prehistoric times hardcoded certain attributes that prevents us from supporting uncommitted reads in a straight forward manner and/or without breaking existing functionality."

Sucks just like Oracle's JDBC driver. Its definitely *undesireable* Received on Sat Jul 26 2003 - 16:13:15 CDT