Increase SGA: ORA-00845: MEMORY_TARGET not supported on this system
ALTER SYSTEM SET MEMORY_MAX_TARGET = 4096M SCOPE = SPFILE;
SHUTDOWN
STARTUP: ORA-00845: MEMORY_TARGET not supported on this system
df -h /dev/shm:
Filesystem Size Used Avail Use% Mounted on
tmpfs 3.9G 0 3.9G 0% /dev/shm
mount -t tmpfs shmfs -o size=4096m /dev/shm
STARTUP
ORACLE instance started.
Total System Global Area 4294964000 bytes
Fixed Size 9143072 bytes
Variable Size 2315255808 bytes
Database Buffers 1962934272 bytes
Redo Buffers 7630848 bytes
Database mounted.
Database opened.
ALTER SYSTEM SET MEMORY_TARGET = nM;
ALTER SYSTEM SET SGA_TARGET = 0;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0;
SHOW PARAMETER MEMORY_TARGET
sdmrnv, 2019-07-08 [1.143ms, s]