Home > Workload Solutions > Oracle > White Papers > Oracle Big Data SQL on Dell EMC PowerFlex > Oracle storage configuration
Many enterprises interested in Oracle’s Big Data SQL data virtualization have experience with Oracle relational databases. The following table shows the simplified database layout that was used to test data virtualization. Dell Technologies’ Oracle customer team works closely with our customers to configure a database for performance.
|
Oracle 19c |
|
|
||
Volume name |
VM disk configuration |
Description |
Size (GB) |
Number of volumes |
Total size (GB) |
TM_VM_ORACLE_OS |
VMFS |
Oracle Linux OS |
800 |
1 |
800 |
TM_VM_ORACLE_DATA |
RDM |
Data files |
600 |
2 |
1,200 |
TM_VM_ORACLE_REDO |
RDM |
Redo logs |
50 |
4 |
200 |
TM_VM_ORACLE_TEMP |
RDM |
Temporary tablespace |
500 |
1 |
500 |
The following explains in more detail what each of the Oracle volumes contains:
Note: The remaining volumes use VMware Raw Device Mapping (RDM). RDM points the virtual machine directly to the PowerFlex LUN, instead of a virtual disk file.
Oracle Automatic Storage Management (ASM) was used to manage the database files. ASM uses disk groups to store datafiles and provides benefits like even distribution of data across disk groups to eliminate hot spots. The following table lists the ASM disk group configuration:
|
Oracle 19c |
|
|
||
ASM disk group |
Purpose |
ASM stripping |
Size (GB) |
Number of volumes |
|
DATA |
Datafiles, control files, and other files |
Coarse grain |
1,200 |
ora-data1, ora-data2, ora-data3, ora-data4 |
|
REDO |
Online redo logs |
Fine grain |
200 |
ora-redo1, ora-redo2, ora-redo3, ora-redo4 |
|
TEMP |
Temp files |
Fine grain |
500 |
Ora-temp |
|