Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g modify MEMORY_TARGET     - Binary Packages Golang (Linux)

- Analysis of Java exception (Programming)

- Simple comparison of MySQL and Oracle in a sql analytical details (Database)

- What is a logical partition management LVM, how to use in Ubuntu (Linux)

- Detailed installation of CentOS 6.x (Linux)

- Nginx configuration support f4v video format player (Server)

- C # / iOS / Android Universal Encryption and decryption (Programming)

- Use FFmpeg processing high quality GIF (Programming)

- vnStatSVG: traffic monitoring software vnStat (Linux)

- Memcached installation, configuration and monitoring (Server)

- PHP file upload methods exist in the database (Programming)

- ASM Disk Space Check (Database)

- Actual custom yum repository ---- gem commands commonly used parameters (Linux)

- installation of Vim plugin YouCompleteMe under Ubuntu 15.04 (Linux)

- Node.js Getting the basics: Helloworld! (Linux)

- Java interface and inheritance (Programming)

- Android components save state series - Activity (Programming)

- Linux administrator should command: sed and awk (Linux)

- Several Methods of SSH Auto - login (Linux)

- Setting CentOS firewall open port (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:      
 
- MySQL 5.7 perfectly distributed transaction support (Database)
- TeamCity continuous integration in the Linux installation (Linux)
- Subquery Oracle study notes (Database)
- PHP security Programming Advice (Programming)
- Linux shell in back quotes (`) Application (Linux)
- Python closure and function objects (Programming)
- STL spatial Configurator (Programming)
- Kali Linux 2.0 U disk installation errors Your installation cd-rom could not be mounted (Linux)
- Linux directory permissions to read and execute permissions difference (Linux)
- Linux initialization init system - UpStart (Linux)
- Oracle TAF Analysis (Database)
- MySQL remote connection settings (Database)
- Nginx multi-domain certificate HTTPS (Server)
- FastDFS installation and deployment (Server)
- Storm how to ensure that at least once semantics (Programming)
- Using IntelliJ IDEA Import Spark Spark latest source code and compile the source code (Linux)
- Use chattr and lsattr command to manage linux files and directory attributes (Linux)
- How to Install Winusb in Ubuntu 14.04 (Linux)
- Python script file directory traversal examples (Programming)
- Bad name two variables (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.