Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS
30
Parameter
Value
kernel.shmall
1073741824
kernel.shmmax
135400749056
kernel.shmmni
4096
kernel.sem
250 32000 100 142
Appendix C.4.2. User security limits settings
The following user security limits were set and appended to the /etc/security/limits.conf file
according to Dell and Oracle’s recommendations and best practices for all the solution testing.
grid hard nofile 131072
grid soft nproc 131072
oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 50000000
oracle hard memlock 50000000
Appendix C.4.3. Oracle database parameter settings
The table below provides the database parameters used for testing all the solutions described in this
paper.
Database parameter settings Table 10.
Parameter
Value
db_writer_processes
8
processes
11000
sessions
16544
open_cursors
11000
transactions
11000
undo_retention
1800
dml_locks
44000
parallel_max_servers
1280
audit_trail
none