Re: Import with commit=Y very slow
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: aleon68@xxxxxxxxx
- Date: Wed, 22 Mar 2006 12:12:44 -0800
Test it.
Do both imports, tracking performance metrics as you go.
Easily done with statspack - just take a snapshot before
and after each import job, run the reports, see where
the time was spent.
HTH
Jared
On 3/22/06, Alfonso León <aleon68@xxxxxxxxx> wrote:
>
> Hi everybody:
>
> I'm importing a table with 9M records and when I use commit=N it takes
> about 5 hours and with commit=Y it takes about 14hours. (NO INDEXES)
>
> Would anybody can tell me why? it shouldn't take longer the commit=N?
>
> I'm using Oracle Enterprise 10.2 and the export file is from 9.2.0.6.
> with UNDO tablespace of 3 GB.
>
> TIA
>
> --
> Alfonso Leon
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
