Home > Workload Solutions > Oracle > Guides > Reference Architecture Guide—Dell EMC Ready Solutions for Oracle: Design for Unity All Flash Storage > Database parameter configuration
The following table provides the database configuration and parameter settings used to conduct all Oracle Database 12cR2 tests:
Table 8. Oracle 12cR2 standalone database configuration
Category |
Specification/setting |
Configuration |
Operating system |
VM guest OS |
RHEL 7.4 |
Grid configuration |
Grid version |
12c R2 Grid Infrastructure |
Database configuration |
Database version |
12c R2 Standalone Database |
Database size |
1.2 TB |
|
Database parameter configuration |
db_block_size |
8 KB |
db_file_multiblock_read_count |
4 |
|
sga_max_size |
96 GB |
|
pga_aggregate_target |
25 GB |
The following table provides the database configuration and parameter settings used to conduct all Oracle Database 18cR1 tests:
Table 9. Oracle 18cR1 standalone database configuration
Category |
Specification/setting |
Configuration |
Operating system |
VM guest OS |
RHEL 7.4 |
Grid configuration |
Grid version |
18c R1 Grid Infrastructure |
Database configuration |
Database version |
18c R1 Standalone Database |
Database size |
1.2 TB |
|
Database parameter settings |
db_block_size |
8 KB |
db_file_multiblock_read_count |
4 |
|
sga_max_size |
96 GB |
|
pga_aggregate_target |
25 GB |
Note: 18cR1 Grid and Standalone Database were upgraded from existing 12cR2 Grid and Database, respectively.