Re: Using PQ in FTS

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Mon, 26 Mar 2007 10:08:08 -0700
Message-ID: <1c1a62990703261008j36f9ee6cybdbd3f6e976c7c1b@mail.gmail.com>

I was going to say unintended block cleanouts.. but then glanced Jonathan Lewis' book page 30 where it mentions 'segment checkpoint', that sounds almost like block cleanouts....

I suppose you did not mean PQ will be used by OLTP queries...

Arul

On 3/23/07, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
> Folks,
> If there are statements where FTS on large tables is unavoidable due to
> the logic in the statements, is there a downside of using PQ to scan
> those tables? Jonathan has mentioned one caution on page 30 of his book
> but are there any other issues that one must be aware of ? The RDBMS
> version are 9.2.0.6 and 10.2.0.2.
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Arul

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 26 2007 - 12:08:08 CDT