Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex
Introduction Solution architecture Solution components Phase I: Infrastructure design and deployment Network design Phase II: Storage design
Phase II: Storage design
Database application storage design
VM operating system data store and hard disks design
For VM hosting Oracle: Operating system devices and Oracle ASM disk group design
Phase III: Oracle 19c database design and deployment Hadoop cluster design and deployment Configuring Big Data SQL Oracle NoSQL design and deployment Microsoft SQL Server design and deployment Oracle Gateways design and deployment Generate and load data References Appendix A

Database application storage design

Database application storage design

  • The following table shows the volumes that we designed for the solution:

    Table 7.              Oracle database volume design

    Application

    Volume name 

    Purpose 

    Size (GB) 

    Oracle

     

    TM_VM_ORACLE_OS 

    Guest VM operating system  

    1x800 

    TM_VM_ORACLE_STAGE 

    Staging Data 

    1X600 

    TM_VM_ORACLE_DATA 

    DATA files 

    2x600 

    TM_VM_ORACLE _REDO(1-4) 

    REDO LOGs 

    4x50 

    TM_VM_ORACLE_TEMP 

    TEMP 

    1x500 

    TM_VM_ORACLE_FRA

    FRA

    1x200

    Hadoop Namenode

    TM_VM_NN_OS 

    Guest VM operating system  

    1x800 

    TM_VM_NN_STAGE 

    Staging Data 

    1x4000 

    TM_VM_NN_DATA 

    Data files 

    1x500 

    Hadoop Datanode 1

    TM_VM_DN1_OS 

    Guest VM operating system  

    1x800 

    TM_VM_DN1_DATA 

    Data files 

    5x600 

    Hadoop Datanode 2

    TM_VM_DN2_OS 

    Guest VM operating system  

    1x800 

    TM_VM_DN2_DATA 

    Data files 

    5x600 

    Oracle NoSQL

    TM_VM_NOSQL_OS 

    Guest VM operating system  

    1x800 

    TM_VM_NOSQL_STAGE 

    Staging Data 

    1X100 

    TM_VM_NOSQL_SN 

    Storage node data files 

    2x100 

    Microsoft SQL Server

    TM_VM_SQL_OS 

    Guest VM operating system  

    1x800 

    TM_VM_SQL_STG 

    Staging Data 

    2X600 

    TM_VM_SQL_DATA 

    Data files 

    2x500 

    TM_VM_SQL_LOG 

    LOG 

    1x200