Hello experts,
I am experiencing error ORA-02095: specified initialization parameter cannot be modified
Below is what memory I have
03-MAY-12 @ SYS (GROW) SQL>show parameter target
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 300
memory_max_target big integer 2G
memory_target big integer 2G
parallel_servers_target integer 384
pga_aggregate_target big integer 640M
sga_target big integer 1408M
I did this
03-MAY-12 @ SYS (GROW) SQL>alter system set memory_target=0;
System altered.
Then I bounced my database to see effect
15:51:19 : 03-MAY-12 @ SYS (GROW) SQL>show parameter target
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 300
memory_max_target big integer 2G
memory_target big integer 0
parallel_servers_target integer 384
pga_aggregate_target big integer 640M
sga_target big integer 1408M
It looked perfect, then I did this
03-MAY-12 @ SYS (GROW) SQL>alter system set memory_max_target=0;
alter system set memory_max_target=0
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
Version of the database
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
How can I modify this? I need to remove both memory_target and memory_max_target and increase sga_traget and sga_max_traget.
Edited by: user3636719 on May 3, 2012 1:31 PM