Re: ISOLATION LEVEL

From: Buchanan, Jason <oracle_at_digistar.com>
Date: Fri, 13 Jul 2007 09:34:46 -0400
Message-Id: <5A8BEFF9-9E52-43FD-9BD3-CBECB1E7EA6E@digistar.com>

On Jul 12, 2007, at 7:34 PM, Peter McLarty wrote:

> I never have worked out from a business perspective how a report
> made of
> uncommitted data is a valid business tool, but then I am "just a dba"

Depends on the report, depends on the company, etc. I've worked in shops where the requirements of some reports didn't need transactionally-consistent data and "WITH UR" was perfectly satisfactory (DM/DW/VLDB). Doing the same type of report in Oracle certainly would have required many gigabytes of undo.

thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 13 2007 - 08:34:46 CDT