[oracle@blacklist1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on 星期五 12月 17 17:27:23 2010
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area629145600 bytes
Fixed Size
1262416 bytes
Variable Size
377490608 bytes
Database Buffers
243269632 bytes
Redo Buffers
7122944 bytes
Database mounted.
Database opened.
SQL> alter system set sga_max_size=2500m scope=spfile;
System altered.
SQL> alter system set sga_target=2500m scope=spfile;-----超过物理内存2025M
System altered.
SQL> shutdown immediate;
SQL> startup
ORA-27123: unable to attach to shared memory segment
现在用pfile重新启动后再更改sga
SQL> alter system set sga_max_size=2260m scope=spfile;-----超过物理内存2025MSQL> alter system set sga_target=2260m scope=spfile;
SQL> shutdown immediate;
SQL> startup
ORACLE instance started.
Total System Global Area 2382364672 bytes
Fixed Size
1262224 bytes
Variable Size
738200944 bytes
Database Buffers 1627389952 bytes
Redo Buffers
15511552 bytes
Database mounted.
Database opened.
SQL> show parameter pga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target
big integer 192M
SQL> show parameter sga;
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
lock_sga
boolean FALSE
pre_page_sga
boolean FALSE
sga_max_size
big integer 2272M
sga_target
big integer 2272M
SQL>
