Ok..i will try this.
regards
anandkl
Printable View
Ok..i will try this.
regards
anandkl
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
How many extents were there per table?Quote:
Originally posted by krw
[B]We are executing an export/import on our DB as we have tables with many extents etc...
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.:D