On Jul 12, 2007, at 7:34 PM, Peter McLarty wrote:
I never have worked out from a business perspective how a report made ofuncommitted 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.