Re: Query ASH for Undo Blocks
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Mon, 20 Jun 2022 15:13:10 +0100
Message-ID: <CAGtsp8=nFn7tu0i9qTJha+ZaSp4+o9YefyZOQtgPWw1zmGwuwQ_at_mail.gmail.com>
Date: Mon, 20 Jun 2022 15:13:10 +0100
Message-ID: <CAGtsp8=nFn7tu0i9qTJha+ZaSp4+o9YefyZOQtgPWw1zmGwuwQ_at_mail.gmail.com>
On Mon, 20 Jun 2022 at 11:24, Lothar Flatz <l.flatz_at_bluewin.ch> wrote:
>
> As you can see we have 54 buffer/execution.
>
> Still during the batch run there seems to be something not explained.
> Even if just the first column in the index is used we have 112885 Leaf
> blocks devided by 58 distinct keys = 2015 + 4 =2019 buffer on average and
> not 3700 as indicated below.
> Thus, it looks like things were different on production and undo chain
> seems a logical candidate.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 20 2022 - 16:13:10 CEST