SQL> show sga ;
Total System Global Area 6547296256 bytes
Fixed Size 2213856 bytes
Variable Size 4429187104 bytes
Database Buffers 2013265920 bytes
Redo Buffers 102629376 bytes
SQL> show PARAMETERs memory ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 6272M
memory_target big integer 6272M
shared_memory_address integer 0
SQL> alter system set memory_max_target=512G scope=spfile;
System altered.
SQL> alter system set sga_max_size=512G scope=spfile;
System altered.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string $ORACLE_HOME/dbs/spfileorcl.ora
---------------------------------------------------
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 549755813888 cannot be set to more than MEMORY_TARGET 6979321856.
---------------------------------------------------
Check your spfile or pfile files
# ls -al $ORACLE_HOME/dbs
---------------------------------------------------
SQL> create pfile from spfile;
File created.
# vi $ORACLE_HOME/dbs/initorcl.ora
*.memory_max_target=549755813888
*.memory_target=549755813888
---------------------------------------------------
SQL> create spfile from pfile;
File created.
# ls -al $ORACLE_HOME/dbs/spfileorcl.ora
---------------------------------------------------
SQL> startup
ORACLE instance started.
Total System Global Area 5.4730E+11 bytes
Fixed Size 2251016 bytes
Variable Size 2.3569E+11 bytes
Database Buffers 3.1139E+11 bytes
Redo Buffers 227823616 bytes
Database mounted.
Database opened.
---------------------------------------------------
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 2251016
Variable Size 2.3891E+11
Database Buffers 3.0816E+11
Redo Buffers 227823616
---------------------------------------------------
SQL> select * from v$sgainfo;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 2251016 No
Redo Buffers 227823616 No
Buffer Cache Size 3.0816E+11 Yes
Shared Pool Size 1.7180E+10 Yes
Large Pool Size 536870912 Yes
Java Pool Size 536870912 Yes
Streams Pool Size 536870912 Yes
Shared IO Pool Size 0 Yes
Granule Size 536870912 No
Maximum SGA Size 5.4730E+11 No
Startup overhead in Shared Pool 3758096384 No
NAME BYTES RES
-------------------------------- ---------- ---
Free SGA Memory Available 2.2012E+11
12 rows selected.
---------------------------------------------------
SQL> show parameter memory;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 512G
memory_target big integer 512G
shared_memory_address integer 0
---------------------------------------------------
