Re: slow import

Hi Yang,

Why do people still insist in creating objects with one extent ?

My recommendation would be to move into the 21st century and use LMT (although the one extent myth with DMT was just that, a myth).

Cheers

Richard
"Yang" <yg.yang_at_wanadoo.fr> wrote in message news:akolt4$q06$1_at_wanadoo.fr...
> - do not import with index (create them separately);
> - create your table with only one extent (resize it to the max size : 52Mo
> is too small);
> - import with option commit=y;
> - when you create index later, do not use initial=1M, give the max size of
> your index in order to have only one extent.
>
> hth
> yang
>
>
> "Murat Balkas" <murat.balkas_at_o2.com.tr> wrote in message
> news:b1148377.0208300546.5598b815_at_posting.google.com...
> > Hi,
> >
> > Oracle 8.1.5 on E-3500 with 2xCPU and 2048 MB RAM.
> >
> > I'm trying to import a table with 22 million rows. The original
> > table, rows being inmported to, has indexes. Exported table, table on
> > dump, doesn't have indexes. My table has 10 columns and 4 indexes.
> > But, importing is very slow.
> >
> > I set sort_area_size to 1000000 and import's buffer to 1000000. I've
> > enough redo log groups and enough rollback segments. indexes are
> > created with initial 1 M and next 100 k.
> >
> > My table's script is as following :
> > PCTFREE 10
> > PCTUSED 40
> > INITRANS 1
> > MAXTRANS 255
> > STORAGE (
> > INITIAL 52428800
> > NEXT 117964800
> > PCTINCREASE 50
> > MINEXTENTS 1
> > MAXEXTENTS 121
> > FREELISTS 1 FREELIST GROUPS 1 )
> >
> > Every 3-4 minutes Oracle stops responding and waits for 40-45
> > seconds. During these time, I see 'write complete waits' or 'free
> > buffer waits'.
> >
> > What can I do to speed it up without restarting the database?
> >
> > Any help would be greatly appreciated.
> >
> > Murat BALKAS
>
>
Received on Sat Aug 31 2002 - 02:41:28 CDT