I修改Oracle11g内存.docx

修改Oracle 11g 内存 分类： Oracle Database 2011-12-16 18:49 910人阅读 评论(0) 收藏 举报 oracleintegersystemsqlbic/tswisdom/article/details/7078477[oracle@bi11g bin]$ ./sqlplus /nolog?SQL*Plus: Release .0 Production on Fri Dec 1618:39:36 2011?Copyright (c) 1982, 2009, Oracle.? All rights reserved.?SQL conn / as sysdbaConnected.SQL show parameter memory?NAME???????????????????????????????? TYPE??????? VALUE------------------------------------ -----------------------------------------hi_shared_memory_address integer???? 0memory_max_target big integer 1584Mmemory_target big integer 1584Mshared_memory_address integer???? 0SQL alter system set memory_target = 512M scope=spfile 2? ;?System altered.?SQL alter system set memory_max_target =1024Mscope=spfile 2? ;?System altered.?SQL show parameter memory?NAME???????????????????????????????? TYPE??????? VALUE------------------------------------ -----------------------------------------hi_shared_memory_address integer???? 0memory_max_target?big integer 1584Mmemory_target big integer 1584Mshared_memory_address integer???? 0SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startupORACLE instance started.?Total System Global Area 1068937216 bytesFixed Size?????????????????2220200 bytesVariable Size????????????859836248 bytesDatabase Buffers?????????201326592 bytesRedo Buffers???????????????5554176 bytesDatabase mounted.Database opened.SQL show parameter memory?NAME???????????????????????????????? TYPE??????? VALUE------------------------------------ -----------------------------------------hi_shared_memory_address integer???? 0memory_max_target big integer 1Gmemory_target big integer 512Mshared_memory_address integer???? 0SQL?/uidid-3171158.htmlORACLE 11G自动内存管理 2012-04-11 21:04:48 分类： Oracle/uidid-3171158.htmlORACLE 11g 自动内存管理：在oracle 11g中，使用一个参数memory_target就能够实现SGA和PGA组件依据工作负荷进行自动内存分配。oracle推荐使用自动内存管理简化内存分配。oracle 11g依然支持手工内存分配：1：oracle 11g使用memory_target来支持内存自动分配。2：使用sga_target和pga_targ