Oracle 11g sga_target 參數設定

開發人員讓我把一個Oracle 11g的sga設定的稍微大一點。於是按照之前對oracle 10g的記憶操作。
 [oracle@localhost db_1]$ sqlplus /nolog
 
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;
 
系統已更改。

1 2 下一頁