- Oracle EL 6.9
- Oracle 11.2.0.4
SQL> alter system set pga_aggregage_target=20G sid='*' scope=spfile;
SQL> alter system set sga_target=128G sid='*' scope=spfile;
SQL> alter system set sga_max_size=150G sid='*' scope=spfile;
SQL> alter system set memory_target=0 sid='*' scope=spfile;
SQL> alter system set memory_max_target=0 sid='*' scope=spfile;
However after stop of database node starting process failed with:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 161061273600 cannot be set to more than MEMORY_MAX_TARGET 0.
Instead of setting 0 for params resetting solves this problem:
SQL> alter system reset memory_target sid='*' scope=spfile;
SQL> alter system reset memory_max_target sid='*' scope=spfile;
SQL> startup
ORACLE instance started.
Total System Global Area 1,6034E+11 bytes
Fixed Size 2261848 bytes
Variable Size 5,1003E+10 bytes
Database Buffers 1,0898E+11 bytes
Redo Buffers 352444416 bytes
Database mounted.
Database opened.
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 150G
sga_target big integer 128G
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 20G
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL>
Hiç yorum yok:
Yorum Gönder