Re: Stopkey not stopping FTS
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 24 Sep 2016 01:45:39 +0300
Message-ID: <CAOVevU6ZhKjF6YD6xK-PQfcxn8duEC30yB+5=hxuBnjKwpDYyg_at_mail.gmail.com>
Date: Sat, 24 Sep 2016 01:45:39 +0300
Message-ID: <CAOVevU6ZhKjF6YD6xK-PQfcxn8duEC30yB+5=hxuBnjKwpDYyg_at_mail.gmail.com>
Henry,
I mean that your plan shows that stopkey works fine but oracle had to scan so huge volume to get just 5 rows. So it seems like almost all rows were deleted.
On Sat, Sep 24, 2016 at 1:33 AM, Henry Poras <henry.poras_at_gmail.com> wrote:
> Sayan,
>
> I'm not at my computer right now, but I thought about other txns and
> delayed block clean out. That isn't it.
>
> No current transactions, the query behavior is reproducible, all object
> I'd access shown in 10046 is from my table, no undo. I can check. $mystats
> later to confirm.
>
> Henry
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 24 2016 - 00:45:39 CEST