首页 > 数据库技术 > 详细

修改数据库内存

时间:2014-04-08 22:35:02      阅读:417      评论:0      收藏:0      [点我收藏+]

SQL> conn / as sysdba

Connected.

SQL> show parameter memory

 

NAME                                 TYPE        VALUE

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

hi_shared_memory_address             integer     0

memory_max_target                    big integer 1584M

memory_target                        big integer 1584M

shared_memory_address                integer     0

SQL> 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     0

memory_max_target                   big integer 1584M

memory_target                        big integer 1584M

shared_memory_address                integer     0

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area 1068937216 bytes

Fixed Size                 2220200 bytes

Variable Size            859836248 bytes

Database Buffers         201326592 bytes

Redo Buffers               5554176 bytes

Database mounted.

Database opened.

SQL> show parameter memory

 

NAME                                 TYPE        VALUE

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

hi_shared_memory_address             integer     0

memory_max_target                    big integer 1G

memory_target                        big integer 512M

shared_memory_address                integer     0

SQL>            

修改数据库内存,布布扣,bubuko.com

修改数据库内存

原文:http://www.cnblogs.com/kevinkim/p/3652785.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!