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