Re: expdp - cell single block physical read/ read request

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 16 Dec 2021 08:28:06 +0000
Message-ID: <CAGtsp8=KkO6i3_ah3cateRGiQBk8KrxwxS=QbMCWh3Tn1xJJPA_at_mail.gmail.com>



I should have said something about watching the session/system activity stats for: "table fetch continued row".

Regards
Jonathan Lewis

On Thu, 16 Dec 2021 at 08:22, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> Do you have any indication that you're dealing with chained rows? expdp
> would have to follow chained rows across blocks, doing single block reads.
> I'm not sure if your version would do the same with migrated rows, but it
> might if it follows the code path used by parallel tablescans.
>
> Regards
> Jonathan Lewis
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 16 2021 - 09:28:06 CET

Original text of this message