Big amount (4.000.000+) of files (1-4Mb each) are loading into Oracle 10g for about several days. Table is allocated in big tablespace, which was created on special volume (labeled BIG_VOL) over hardware RAID (Adaptec 3805 , 8 HDD x 2Tb, raid level 6).
RedoLogs was moved on two another SSD drives. No archivelog. There are only DBF and control files on BIG_VOL.
Transaction closed (by COMMIT) after every loaded file.
Perfomance Monitor shows ~6-9Mb per second on writing for this BIG_VOL ! Simple copy any big file shows about 80+Mb per second!
Can I do something to improve speed?
Aucun commentaire:
Enregistrer un commentaire