修改Oracle 11g 内存

[Oracle@bi11g bin]$ ./sqlplus /nolog SQL*Plus: Release 11.2.0.1.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> Linux下MySQL备份脚本Oracle 11g 无法启动的处理方式相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）