SQL> create pfile=’/tmp/init.ora’ from spfile;
File created.

SQL>!echo ‘*.sga_target=2000M’ >> /tmp/init.ora

SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> create spfile from pfile=’/tmp/init.ora’;
File created.http://www.cndba.cn/hbhe0316/article/4846

SQL> startup
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 8622624 bytes
Variable Size 822087136 bytes
Database Buffers 1258291200 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.http://www.cndba.cn/hbhe0316/article/4846

SQL> show parameter sga;

NAME TYPE VALUEhttp://www.cndba.cn/hbhe0316/article/4846

allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 2000M
sga_min_size big integer 0
sga_target big integer 2000M
unified_audit_sga_queue_size integer 1048576http://www.cndba.cn/hbhe0316/article/4846http://www.cndba.cn/hbhe0316/article/4846

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle