problems with big table

[tamilselvan]

You need to create multiple data files for the tablespace.
Do not use autoextend feature. That will slow down insert process.

If you use 10g or 9i, do not use AUTO SEGMENT SPACE MANAGEMENT. In my test, that gave worst performance for a large load ( 20 million rows insert by 20 threads). There are some bugs reported while using ASSM.

Use LMT with uniform extent size with MANUAL SEGMENT SPACE MANAAGEMENT.

Also, increase freelists for the table. Start with 7 and slowly increase it to 13 depending upon the concurrent inserts on the table.

Tamil

[mike9]

Hi,

If the "old methode" shouldn't work for any reason you may instead to delete 3M rows create a new table via CTS excluding this 3M rows. It may be faster to create a table with 12 x 3M rows (12 in case you keep your data during 1 year) then to delete 3M rows.

good luck
Mike