• From: "Buchanan, Jason" <oracle@xxxxxxxxxxxx>
  • To: Peter McLarty <p.mclarty@xxxxxxxxxx>
  • Date: Fri, 13 Jul 2007 09:34:46 -0400

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.


Other related posts: