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

  • From: Jonathan Lewis <jlewisoracle@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Dec 2021 08:28:06 +0000

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@xxxxxxxxx> 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




Other related posts: