Re: Article about supposed "murky" future for Oracle

From: rkusenet <rkusenet_at_sympatico.ca>
Date: Tue, 30 Mar 2004 21:19:54 -0500
Message-ID: <c4d9n3$2h3mqp$1@ID-75254.news.uni-berlin.de>

"Serge Rielau" <srielau_at_ca.eye-be-em.com> wrote

> There is no such thing as a free lunch. The versioning comes at a cost
> too. Pushing a version and managing the rollback segments is not for free.
> Neither is finding the appropriate version for each row.

Not only that. Oracle's versioning is forced even when there is no need. I proved this to Daniel few months back. A simple query on yesterday's data (which today is only in read mode) can be answered in informix/db2/sqlserver without any locks (READ UNCOMMITTED), giving best possible performance. In Oracle the system has to still read the SCN from the block to determine the version. However efficient it may be, it is still not the same. Received on Tue Mar 30 2004 - 20:19:54 CST