Hello,

Need inputs on the initial prerequisites om server parameter settings –

Database Size ranges from 300Gb to 1TB.

Optimal sysctl parameters to be set for the server with below configuration –

[oracle@lnx1386 ~]$ lscpu

Architecture:          x86_64

CPU op-mode(s):        32-bit, 64-bit

Byte Order:            Little Endian

CPU(s):                128

On-line CPU(s) list:   0-127

Thread(s) per core:    2

Core(s) per socket:    16

Socket(s):             4

NUMA node(s):          4

Vendor ID:             GenuineIntel

CPU family:            6

Model:                 79

Model name:            Intel(R) Xeon(R) CPU E7-4850 v4 @ 2.10GHz

Stepping:              1

CPU MHz:               1199.953

BogoMIPS:              4197.77

Virtualization:        VT-x

L1d cache:             32K

L1i cache:             32K

L2 cache:              256K

L3 cache:              40960K

NUMA node0 CPU(s):     0,4,8,12,16,20,24,28,32,36,40,44,48,52,56,60,64,68,72,76,80,84,88,92,96,100,104,108,112,116,120,124

NUMA node1 CPU(s):     1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61,65,69,73,77,81,85,89,93,97,101,105,109,113,117,121,125

NUMA node2 CPU(s):     2,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,66,70,74,78,82,86,90,94,98,102,106,110,114,118,122,126

NUMA node3 CPU(s):     3,7,11,15,19,23,27,31,35,39,43,47,51,55,59,63,67,71,75,79,83,87,91,95,99,103,107,111,115,119,123,127

[oracle@lnx1386 ~]$

[oracle@lnx1386 ~]$ free -g

              total        used        free      shared  buff/cache   available

Mem:           2015          17        1945           0          52        1996

Swap:            63           0          63

[oracle@lnx1386 ~]$

I/O – Storage : 10TB SSD Disks

Thank You,