Oracle 23c New Features for DBA's#############
Memory Calculation for Cassandra (kind of sga setting 🙂 will be done during environment setup with following script excerpt. if you want you can change accordingly this script and restart the cassandra.
##################
geek_cluster/node1/resources/cassandra/conf/cassandra-env.sh
....
half_system_memory_in_mb=`expr $system_memory_in_mb / 2`
quarter_system_memory_in_mb=`expr $half_system_memory_in_mb / 2`
if [ "$half_system_memory_in_mb" -gt "1024" ]
then
half_system_memory_in_mb="1024"
fi
if [ "$quarter_system_memory_in_mb" -gt "8192" ]
then
quarter_system_memory_in_mb="8192"
fi
if [ "$half_system_memory_in_mb" -gt "$quarter_system_memory_in_mb" ]
then
max_heap_size_in_mb="$half_system_memory_in_mb"
else
max_heap_size_in_mb="$quarter_system_memory_in_mb"
fi
MAX_HEAP_SIZE="${max_heap_size_in_mb}M"
# These env variables may be useful to determine proper amount of resources
# assigned to DSE subprocesses, such as Spark components
SYSTEM_CPU_CORES="$system_cpu_cores"
export SYSTEM_CPU_CORES
SYSTEM_MEMORY_IN_MB="$system_memory_in_mb"
export SYSTEM_MEMORY_IN_MB
CASSANDRA_MEMORY_IN_MB="$max_heap_size_in_mb"
export CASSANDRA_MEMORY_IN_MB
Follow Me!!!