Database Utilities (MOSC)

MOSC Banner

Datapump across network link exhibits duplicate successive block reads

edited Dec 10, 2013 10:10PM in Database Utilities (MOSC) 2 commentsAnswered
In the process of migrating a table across a platform boundary (AIX -> Linux) which contained a couple of LOB columns (the columns are XMLTYPEs) we ran into a problem which lead me to trace the sessions involved in reading the data.  It was at this point that I noticed that for the LOB columns, the trace reports that each block is being read twice in succession.  Here is an excerpt of the trace output:
WAIT #2: nam='direct path read' ela= 559 file number=8 first dba=196794 block cnt=1 obj#=10522 tim=31109815875816
WAIT #2: nam='direct path read' ela= 300 file number=8 first dba=196794 block cnt=1 obj#=10522 tim=31109815876338

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center