Hi experts,
I've an Oracle 19c RAC 2 Nodes with following current system information:
[root]# lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 16
On-line CPU(s) list: 0-15
Thread(s) per core: 2
Core(s) per socket: 8
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 158
Model name: Intel(R) Xeon(R) E-2278G CPU @ 3.40GHz
Stepping: 13
CPU MHz: 3400.000
BogoMIPS: 6816.00
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 16384K
NUMA node0 CPU(s): 0-15
[root]# cat /etc/os-release
PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"
[root]# free -g
total used free shared buff/cache available
Mem: 31 9 0 18 21 2
Swap: 31 0 31
[root]# cat /proc/meminfo
MemTotal: 32658052 kB
MemFree: 579684 kB
MemAvailable: 2688660 kB
Buffers: 10520 kB
Cached: 21602760 kB
SwapCached: 14664 kB
Active: 24884000 kB
Inactive: 2819184 kB
Active(anon): 23289168 kB
Inactive(anon): 2170548 kB
Active(file): 1594832 kB
Inactive(file): 648636 kB
Unevictable: 483604 kB
Mlocked: 483604 kB
SwapTotal: 33554428 kB
SwapFree: 32763496 kB
query on v$asm_diskgroup:
GROUP_NAME STATE TYPE total_gb free_gb
DG_CRS 'MOUNTED' 'EXTERN' 50 50
DG_DATA 'CONNECTED' 'EXTERN' 500 365
DG_FRA 'CONNECTED' 'EXTERN' 500 498
DG_MGMT 'MOUNTED' 'EXTERN' 100 76
Select all Open in new window
Oracle Memory:
sga_target = 15G
pga_aggregate_target = 5G
Now I'd like to add 5 new instances to my RAC database.
Based on my current configuration of memory, CPU, storage, could you please tell me which better configuration I should use to add 5 new instances to my RAC database?
Thanks in advance!
Raf