oracle lock_sga ORA-00847

oracle lock_sga

LOCK_SGA locks the entire SGA into physical memory. It is usually advisable to lock the SGA into real (physical) memory, especially if the use of virtual memory would include storing some of the SGA using disk space. This parameter is ignored on platforms that do not support it.

 

eg:

oracle:~ # su - oracleoracle@oracle:~> sqlplus "/as sysdba"SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 6月 27 21:39:14 2013Copyright (c) 1982, 2007, Oracle.  All rights reserved.连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSYS@orcl#show parameter sga_targetNAME                                 TYPE------------------------------------ ----------------------VALUE------------------------------sga_target                           big integer512MSYS@orcl#set linesizeSP2-0267: linesize 选项 0 超出范围 (自 1 至 32767)SYS@orcl#SYS@orcl#SYS@orcl#SYS@orcl#set linesize 200SYS@orcl#show parameter sga_targetNAME                                 TYPE                   VALUE------------------------------------ ---------------------- ------------------------------sga_target                           big integer            512MSYS@orcl#show parameter sga_max_targetSYS@orcl#show parameter sga_maxNAME                                 TYPE                   VALUE------------------------------------ ---------------------- ------------------------------sga_max_size                         big integer            772MSYS@orcl#show parameter lock_sgaNAME                                 TYPE                   VALUE------------------------------------ ---------------------- ------------------------------lock_sga                             boolean                FALSESYS@orcl#create pfile='./pfile.ora' from spfile;文件已创建。SYS@orcl#!free -m                              total       used       free     shared    buffers     cachedMem:          1004        973         31          0         35        683-/+ buffers/cache:        254        750Swap:         2055        108       1946SYS@orcl#alter system set lock_sga=true scope=spfile;系统已更改。SYS@orcl#start forceSP2-0310: 无法打开文件 "force.sql"SYS@orcl#startup forceORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set togetherSYS@orcl#

解决办法：见  ID 577898.1
参考文章：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1176205889966
        http://www.askmaclean.com/archives/know-more-about-lock_sga-parameter.html
        http://managingoracle.blogspot.com/2010/06/locksga-and-asmm.html