修改Oracle 11g 内存

最新推荐文章于 2021-04-29 00:23:49 发布

转载最新推荐文章于 2021-04-29 00:23:49 发布 · 537 阅读

Oracle 专栏收录该内容

27 篇文章

订阅专栏

本文记录了如何使用SQL*Plus连接到Oracle数据库并调整其memory_target和memory_max_target参数的过程。通过一系列命令，将memory_target设置为512MB，并将memory_max_target设置为1GB，这些更改被保存在spfile中并在重启数据库后生效。

[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 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