Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g modify MEMORY_TARGET     - Oracle 11g principle study Dataguard (Database)

- How to update the ISPConfig 3 SSL Certificates (Server)

- MySQL concat function is SQL injection (Linux)

- ORA-12154 TNS could not resolve the specified identifier (Database)

- Rely on IP chain established Linux firewall (Linux)

- Virtual Judge environment to build and configure under Ubuntu (Server)

- OpenResty load balancing MySQL (Database)

- Oracle 10g after the failure to start the upgrade (Oracle instance terminated. Disconnection forced) (Database)

- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)

- Java programmers talk about those advanced knowledge and direction (Programming)

- OpenGL Superb Learning Notes - Fragment Shader (Programming)

- Generators and iterators in Python (Programming)

- Linux Powerful command Awk Introduction (Linux)

- Linux environment variable configuration and save places (Linux)

- Linux operating system Samba server configuration and use (Server)

- Android timer use (Programming)

- Based AutoYaST automated installation of SUSE practice (Linux)

- Precautions against hackers Linux environment (Linux)

- Forwarding module with Apache reverse proxy server (Server)

- Ubuntu Install OpenSSL (Linux)

 
         
  Oracle 11g modify MEMORY_TARGET
     
  Add Date : 2018-11-21      
         
       
         
  By default, Oracle 11g is the use of AMM (Automatic Memory Management, automatic memory management). During the installation process of our database, Oracle uses memory specified percentage of the initial value MEMORY_TARGET MEMORY_MAX_TARGET and use this as an argument on. If these two parameters are set to a nonzero value, then Oracle is using the AMM management strategy.

The following shows how to modify the value of MEMORY_TARGET.

1. Test Environment

We operate in Oracle 11g.

SQL>

SQL> select * from v $ version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL / SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL>

2. Check MEMORY_TARGET and parameter values

We view the initialization parameter values show parameter, other related parameters include MEMORY_MAX_TARGET, sga_max_size, sga_target, pga_aggregate_target like.

SQL>

SQL> show parameter memory

NAME TYPE VALUE

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

hi_shared_memory_address integer 0

memory_max_target big integer 500M

memory_target big integer 400M

shared_memory_address integer 0

SQL>

SQL> show parameter sga

NAME TYPE VALUE

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

lock_sga boolean FALSE

pre_page_sga boolean FALSE

sga_max_size big integer 500M

sga_target big integer 0

SQL>

SQL> show parameter pga

NAME TYPE VALUE

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

pga_aggregate_target big integer 0

SQL>

We see, MEMORY_MAX_TARGET database of 500M, MEMORY_TARGET to 400M.

3. Modify MEMORY_TARGET

We modified by alter system statement MEMORY_TARGET, to note that, MEMORY_TARGET is a dynamic parameters, static parameters MEMORY_MAX_TARGET is.

Thus, when you modify the value of < = MEMORY_MAX_TARGET, we are free to modify MEMORY_TARGET value; however, when you modify a value> MEMORY_MAX_TARGET, we must first modify MEMORY_MAX_TARGET parameter value, restart the database so that static parameter to take effect and then to modify MEMORY_TARGET value, otherwise database error.

3.1 modify the value of < = MEMORY_MAX_TARGET
We try to MEMORY_TARGET parameter values modified by the 400M to 500M.

SQL>

SQL> alter system set memory_target = 500m;

System altered.

SQL>

SQL>

SQL> show parameter memory

NAME TYPE VALUE

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

hi_shared_memory_address integer 0

memory_max_target big integer 500M

memory_target big integer 500M

shared_memory_address integer 0

SQL>

3.2 modify values> MEMORY_MAX_TARGET
    
We try to MEMORY_TARGET parameter values modified by the 500M to 700M. Due to changes in the value of> MEMORY_MAX_TARGET, the database will complain; we must first modify MEMORY_MAX_TARGET parameter value, restart the database so that static parameter to take effect and then to modify MEMORY_TARGET value.

SQL>

SQL> alter system set memory_target = 600m;

alter system set memory_target = 600m

*

ERROR at line 1:

ORA-02097: parameter can not be modified because specified value is invalid

ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

SQL>

SQL> alter system set memory_max_target = 800m scope = spfile;

System altered.

SQL> shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 732352512 bytes

Fixed Size 1347456 bytes

Variable Size 603979904 bytes

Database Buffers 121634816 bytes

Redo Buffers 5390336 bytes

Database mounted.

Database opened.

SQL>

SQL> show parameter memory

NAME TYPE VALUE

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

hi_shared_memory_address integer 0

memory_max_target big integer 700M

memory_target big integer 500M

shared_memory_address integer 0

SQL>

SQL> alter system set memory_target = 600m;

System altered.

SQL> show parameter memory

NAME TYPE VALUE

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

hi_shared_memory_address integer 0

memory_max_target big integer 700M

memory_target big integer 600M

shared_memory_address integer 0

SQL>

SQL>
     
         
       
         
  More:      
 
- Transfer files and permissions from Windows to Linux system by Samba (Linux)
- RedHat 6 xrdp use remote login interface (Linux)
- CentOS install expect (Linux)
- Ubuntu how to install and use Objective-C (Linux)
- C ++ 11 smart pointers (Programming)
- Httpclient4.4 of principle (Http execution context) (Programming)
- View processes and threads under Linux (Linux)
- Linux System Getting Started Learning: Disable Ubuntu Apport internal error reporting procedures (Linux)
- Findbugs installation documentation (Linux)
- Linux Basics Tutorial: Linux Kickstart automated installation (Linux)
- MySQL full-index scan bug (Database)
- Oracle 11g forget approach SYS and SYSTEM password (Database)
- Download Google Android source code under Ubuntu 4.4 (Linux)
- Create a custom pixel format based on an existing image data BufferedImage (Programming)
- Haproxy multi-domain certificate HTTPS (Server)
- Xtrabackup creates a slave node without downtime (Database)
- Ubuntu 12.04 commonly use shortcuts finishing Share (Linux)
- Enterprise Hadoop cluster architecture - NFS installation (Server)
- Installation Mesos + Marathon + Zookeeper under CentOS 7 (Server)
- Repair Chrome for Linux is (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.