Database I/O Configuration

Table 2-2 Recommended Database I/O Configuration for Oracle Argus Insight

Database I/O Configuration Small (< 30,000 cases) Medium (30,000 to 200,000 cases) Large (200,000 to 1,000,000 cases) Extra Large (> 1,000,000 cases)

Number and Size of Redo Log Files

Note: The value depends on the characteristics of the I/O subsystem such as the I/O bandwidth, storage disks type, and RAID level. (Oracle recommends RAID 1+0 or similar.)

Default

3 X 500 MB

5 X 500 MB

5 X 500 MB

TEMP Tablespace Size

32 GB

32 GB

64 GB

128 GB

UNDO Tablespace Size

Note: The recommended UNDO tablespace size is based on the projections with the following two parameter values: RETENTION=NOGUARANTEE and UNDO_RETENTION=900 (seconds)

16 GB

32 GB

64 GB

128 GB