开发人员让我把一个Oracle 11g的sga设置的稍微大一点。于是按照之前对oracle 10g的记忆操作。

 [oracle@localhost db_1]$ sqlplus /nolog

 wKiom1OqRCaQm1mnAAEqZs8R4zg231.jpg

SQL*Plus: Release 11.2.0.1.0 Production on 星期六 6月 30 13:42:07 2012

 

Copyright (c) 1982, 2009, Oracle. All rights reserved.

 

SQL> conn /as sysdba

 已连接。

 SQL> show parameter sga;

 

NAME TYPE VALUE

 ------------------------------------ ----------- ------------------------------

 lock_sga boolean FALSE

 pre_page_sga boolean FALSE

 sga_max_size big integer 4800M

 sga_target big integer 0

 

SQL> create pfile='/tmp/pfile.ora' from spfile;

 

文件已创建。

 

SQL> host

 [oracle@localhost db_1]$ cd /tmp

 [oracle@localhost tmp]$ ls

 mapping-root pfile.ora scim-panel-socket:0-root

 [oracle@localhost tmp]$ mor pfile.ora

 bash: mor: command not found

 [oracle@localhost tmp]$ more pfile.ora

 intopay.__db_cache_size=1610612736

 intopay.__java_pool_size=67108864

 intopay.__large_pool_size=67108864

 intopay.__oracle_base='/u01'#ORACLE_BASE set from environment

 intopay.__pga_aggregate_target=2013265920

 intopay.__sga_target=3019898880

 intopay.__shared_io_pool_size=0

 intopay.__shared_pool_size=1207959552

 intopay.__streams_pool_size=0

 *.audit_file_dest='/u01/admin/intopay/adump'

 *.audit_trail='db'

 *.compatible='11.2.0.0.0'

 *.control_files='/u01/oradata/intopay/control01.ctl','/u01/flash_recovery_area/intopay/control02.ctl'

 *.db_block_size=8192

 *.db_domain=''

 *.db_name='intopay'

 *.db_recovery_file_dest='/u01/flash_recovery_area'

 *.db_recovery_file_dest_size=10737418240

 *.diagnostic_dest='/u01'

 *.dispatchers='(PROTOCOL=TCP) (SERVICE=intopayXDB)'

 *.memory_target=5033164800

 *.nls_language='SIMPLIFIED CHINESE'

 *.nls_territory='CHINA'

 *.open_cursors=300

 *.processes=1500

 *.remote_login_passwordfile='EXCLUSIVE'

 *.sessions=1655

 *.undo_tablespace='UNDOTBS1'

 [oracle@localhost tmp]$ exit

 exit

 

SQL> shutdown immediate

 数据库已经关闭。

 已经卸载数据库。

 ORACLE 例程已经关闭。

 SQL> startup mount

 ORACLE 例程已经启动。

 

Total System Global Area 5010685952 bytes

 Fixed Size 2212936 bytes

 Variable Size 3355446200 bytes

 Database Buffers 1610612736 bytes

 Redo Buffers 42414080 bytes

 数据库装载完毕。

 SQL> ALTER SYSTEM SET sga_max_size = 6442450944 COMMENT=’internally adjusted’ SCOPE=SPFILE SID=’INTOPAY′;

 ALTER SYSTEM SET sga_max_size = 6442450944 COMMENT=’internally adjusted’ SCOPE=SPFILE SID=’INTOPAY′

 *

 第 1 行出现错误:

 ORA-01756: 引号内的字符串没有正确结束

 

SQL> ALTER SYSTEM SET sga_max_size = 6442450944 COMMENT='internally adjusted’ SCOPE=SPFILE SID='INTOPAY′;

 ALTER SYSTEM SET sga_max_size = 6442450944 COMMENT='internally adjusted’ SCOPE=SPFILE SID='INTOPAY′

 *

 第 1 行出现错误:

 ORA-02095: 无法修改指定的初始化参数

 

SQL> alter system set sga_max_size=6442450944 scope=spfile ;

 

系统已更改。

 

SQL> show parameter sga;

 

NAME TYPE VALUE

 ------------------------------------ ----------- ------------------------------

 lock_sga boolean FALSE

 pre_page_sga boolean FALSE

 sga_max_size big integer 4800M

 sga_target big integer 0

 SQL> ALTER SYSTEM SET sga_target = 6442450944 SCOPE=SPFILE;

 

系统已更改。