Memory check

Huge pages on SRI()
========================================================

300 GB lock ( lock 300 gb memory for oracle out of 376 GB allocated on server )

--------/etc/security/limits.conf
* soft memlock 314572800
* hard memlock 314572800

huge pages and other shared memory settings

vm.nr_hugepages =45098
shmmax=322122547200
shmall=78643200


disable transparent huge pages
it is enabled as of now and needs to be disabled

SGA size for databases

total sga
mgmtdb= 1024 mb
ASM   = 1088 mb
PDWDB= 79872 mb (78 GB)
PRPDB= 8192 mb (8 GB)
total sga=90176 mb (88.0625 GB)

pga size for databases

pga_aggregate_target
PRPDB=8 GB
PDWDB=148 GB
total pga=156 GB

below parameter of both the databases PDWDB and PXPDB

large_pool_size=500M
use_large_pages=only