Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS
29
ASM
Diskgroup
Name
Diskgroup Member Disks
(ASM disks)
ASM
Redundancy
Size
Allocation Unit
(AU) Size
Grid and
Database
Compatibility
FRA_DG
/dev/sde1, /dev/sdh1,
/dev/sdk1, /dev/sdn1
external
2178 GB
1MB (default)
11.2.0
ASM disk group configuration for the Fluid Cache based solution Table 8.
ASM
Diskgroup
Diskgroup Member Disks
(ASM disks)
ASM
Redundancy
Size
Allocation Unit
(AU) Size
DATA_DG
/dev/fldc0,
/dev/fldc1,
/dev/fldc2,
/dev/fldc3,
/dev/fldc4,
/dev/fldc5,
/dev/fldc6,
/dev/fldc7,
external
4356 GB
1MB (default)
FRA_DG
/dev/sde,/dev/sdh,
/dev/sdk,/dev/sdn
external
2178 GB
1MB (default)
Appendix C.4. Parameter settings
The sections below provide the settings and configurations at the operating system level and at the
Oracle Database level.
Appendix C.4.1. Kernel parameter settings
The following kernel parameters were set in the /etc/sysctl.conf file according to Dell and
Oracle’s recommendation and best practices for all the solution testing.
Kernel parameters settings for Oracle database Table 9.
Parameter
Value
fs.file-max
6815744
net.ipv4.ip_local_port_range
9000 65500
net.core.rmem_default
262144
net.core.rmem_max
4194304
net.core.wmem_default
262144
net.core.wmem_max
1048576