Re: Import with commit=Y very slow

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_at_gmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l