Re: AWR interpretation
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Nov 2013 11:00:07 -0400
On Fri, Nov 1, 2013 at 10:37 AM, Storey, Robert (DCSO)
<RStorey@xxxxxxxxxxxxxxxxxx> wrote:
> It was made mention that LOB data will ignore the array COMMIT settings and
> will do a line by line commit. Does anyone know if this works the same for
> XMLTYPE columns?
>
That's a good question. Prior to 11.2.0.2, XMLTYPE (by default) were
stored as CLOBs, but now default to faster, better BINARY XML which
under the hood are still LOBs but now stored as SecureFiles.
See MOS note:
Change in default storage model of XMLType to BINARY XML in 11.2.0.2.0
(Doc ID 1207893.1)
So to answer your question, since you are coming from 9i it's safe to
assume that these are clobs and also pretty safe to assume that the
row commits will also happen with BINARY XMLs. COMMIT=Y is useful
when you can restart imports, but if your process for this import is
to truncate/re-import if there are any issues, then COMMIT=Y is doing
you no favors. Switch back to the default, COMMIT=N and the commit
will happen at the end.
Once you are all in 11.2 you can embrace Data Pump :)
Andy K
--
//www.freelists.org/webpage/oracle-l
Other related posts:
