Re: ISOLATION LEVEL
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: oracle@xxxxxxxxxxxx
- Date: Thu, 26 Jul 2007 08:10:40 -0700
On 7/13/07, Buchanan, Jason <oracle@xxxxxxxxxxxx> wrote:
>
>
> 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.
>
>
Inaccurate results are acceptable to avoid sacrificing some runtime and
undo?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
- Follow-Ups:
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Oracle-L traffic fall off?
- From: Robert Freeman
- References:
- ISOLATION LEVEL
- From: DBA Deepak
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Re: ISOLATION LEVEL
- From: Hemant K Chitale
- Re: ISOLATION LEVEL
- From: Buchanan, Jason
- RE: ISOLATION LEVEL
- From: Peter McLarty
- Re: ISOLATION LEVEL
- From: Buchanan, Jason
Other related posts:
- » ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » RE: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » RE: ISOLATION LEVEL
- » RE: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » RE: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- » Re: ISOLATION LEVEL
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Oracle-L traffic fall off?
- From: Robert Freeman
- ISOLATION LEVEL
- From: DBA Deepak
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Re: ISOLATION LEVEL
- From: Niall Litchfield
- Re: ISOLATION LEVEL
- From: Hemant K Chitale
- Re: ISOLATION LEVEL
- From: Buchanan, Jason
- RE: ISOLATION LEVEL
- From: Peter McLarty
- Re: ISOLATION LEVEL
- From: Buchanan, Jason