Zero to one million a day to bulk import data in the new database, which of the following ways to improve import performance?

Customers need to create a new Oracle database server Huawei RH5885 V2 32-core CPU, the host using Redhat 6.4 operating system, file system EXT4; storage devices OceanStor V3, using SAS disks and configure 8D + 1P RAID5.

Zero to one million a day to bulk import data in the new database, which of the following ways to improve import performance? (Multiple choice)
A . Modify the value DB_WRITER_PROCESSES
B . Redhat system default CFQ reading algorithm for database efficiency is not high, it should be adjusted to noop algorithm
C . Oracle database FILESYSTEMIO_OPTIONS parameters can be set as Asynch and log off the system log file
D . Modify the Oracle DB_BLOCK_SIZE parameter

Answer: ACD

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments