Import running slow!

[anandkl]

Ok..i will try this.

regards
anandkl

[rajabalachandra]

hi,

when indexing....

you can pre-allocate the disk space for index
to avoid the dynamic allocation.

if it is to a different physical disk (other
than the one where your tables are) the
disk contention can be reduced.

also you can set the following parameters high enough.

sort_multiblock_read_count

db_file_multiblock_read_count


-Raja

[slimdave]

Originally posted by krw
[B]We are executing an export/import on our DB as we have tables with many extents etc...

How many extents were there per table?

[robertbalmer]

This reply may be a little late but you could check if there isnt any triggers(audit:insert or update) activated on your tables.Disable triggers...import....enable triggers.