Re: ISOLATION LEVEL


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


Other related posts: