[oracle@host05 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 15 13:46:01 2021
Copyright © 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> show parameter memory
NAME TYPE VALUE
hi_shared_memory_address integer 0
memory_max_target big integer 980M
memory_target big integer 980M
shared_memory_address integer 0
SQL> show parameter sga
NAME TYPE VALUE
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 980M
sga_target big integer 0
SQL> show parameter pga
NAME TYPE VALUE
pga_aggregate_target big integer 0
SQL> alter system set sga_max_size=900M scope=spfile ;
alter system set sga_target=10M ;
alter system set pga_aggregate_target =1M scope=spfile ;
System altered.
SQL>
System altered.
SQL>
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00823: Specified value of sga_target greater than sga_max_size
SQL>
sga_target设置的值小于sga_max_size设置的值 怎么还会报ORA-00823: Specified value of sga_target greater than sga_max_size这个报错