Specification of memory size in different Oracle versions, different oracle versions

Specification of memory size in different Oracle versions, different oracle versions

 **************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216791

Deep Blue blog: http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************

(1), 9i

Version: Oracle9I
LINUX/UNIX
SGA	Granule)
When the value is less than or equal to 128 M (SGA <= M)	4 M
When the value is greater than 128 M (SGA> M)	16 M
WINDOWS
SGA	Granule)
When the value is less than or equal to 128 M (SGA <= M)	4 M
When the value is greater than 128 M (SGA> M)	8 M

(2), 10 GB

Version: Oracle10G
LINUX/UNIX
SGA	Granule)
When the value is less than or equal to 1 GB (SGA <= 1G)	4 M
When the value is greater than 1 GB (SGA> 1 GB)	16 M
WINDOWS
SGA	Granule)
When the value is less than or equal to M (SGA <= 1G)	4 M
When the value is greater than MB (SGA> 1 GB)	8 M

(3) 11g

Version: Oracle11G
LINUX/UNIX
SGA	Granule)
When the value is less than or equal to 1 GB (SGA <= 1G)	4 M
When the value is greater than 1 GB (SGA> 1 GB)	16 M
WINDOWS
SGA	Granule)
When the value is less than or equal to M (SGA <= 1G)	4 M
When the value is greater than MB (SGA> 1 GB)	8 M

 

[In short]

[Example] memory Particles

Definition: minimum allocation unit of SGA

Composition: composed of some Connected Virtual Memory

Size: determined by SGA. In 11G environment, when SGA is less than 1 GB, the memory size is 4 MB; When SGA is greater than 1 GB, the memory size is 16 MB.

Query example:

Environment: Oracle11G

SQL> select granule_size from v $ sga_dynamic_components;

 

GRANULE_SIZE

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

4194304

 

Word Meaning:

Granule: particles

Components: Component

Dynamic: dynamic

 

[Expansion]

This dynamic view also shows the memory allocation in SGA.

SQL> select component, current_size/1024/1024 from v $ sga_dynamic_components

COMPONENT CURRENT_SIZE/1024/1024

Bytes --------------------------------------------------------------------------------------

Sharedpool 152

Largepool 8

Javapool 4

Streamspool 0

DEFAULTbuffer cache 416

KEEPbuffer cache 0

RECYCLEbuffer cache 0

DEFAULT2K buffer cache 0

DEFAULT4K buffer cache 0

DEFAULT8K buffer cache 0

DEFAULT16K buffer cache 0

DEFAULT32K buffer cache 0

Audio Dio Pool 0

ASMBuffer Cache 0

14 rows selected.

Special thanks to technical help from friends he Fei and fan boshi.

 **************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216791

Deep Blue blog: http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************

How to calculate the memory size based on memory Particles

At present, there are many manufacturers that use Samsung's memory Granules to produce memory, which has a high market share. Because of its huge product line, the naming rules for Samsung memory granules are very complicated. The model of Samsung memory granules is named by a 16-digit code. The user is more concerned with the recognition of memory capacity and working rate, so we will focus on the meaning of these two parts.
--------------------------------------------------------------------
[Samsung memory granules]
Encoding Rules: K 4 X-X

Main meaning:

The 1st-bit chip function K Represents the memory chip.

2nd-bit: chip type 4, representing DRAM.

3rd-bit-further type description of the chip. S represents SDRAM, H Represents DDR, and G Represents SGRAM.

4th or 5 bits-capacity and refresh rate. Different refresh rates are used for memory with the same capacity, and different numbers are used. 64, 62, 63, 65, 66, 67, 6A represents 64 Mbit capacity; 28, 27, 2A represents Mbit capacity; 56, 55, 57, 5A represents Mbit capacity; 51 represents the capacity of 512Mbit.

6th, 7-bit: the number of data cable pins. 08 represents 8-bit data, 16 represents 16-bit data, 32 represents 32-bit data, and 64 represents 64-bit data.

11th bits -- connect "-".

14th or 15 bits: the chip speed. For example, 60 is 6ns, 70 is 7ns, 7B is 7.5ns (CL = 3), 7C is 7.5ns (CL = 2), and 80 is 8ns; 10 is 10ns (66 MHz ).

Knowing the meaning of the main digits of the memory Particle Code, it is very easy to calculate its capacity after getting a memory stick. For example, a samsung ddr memory is encapsulated with 18 SAMSUNG K4H280838B-TCB0 particles. Particle numbers 4th and 5 "28" indicate that the particles are 128 Mbits, and 6th and 7 "08" indicate that the particles are 8-bit data bandwidth, in this way, we can calculate that the memory size is 128 Mbits (MB) x 16/8 bits = 256 MB (MB ).

Note: "bit" is "digit", and "B" is the byte. If one byte is 8 bits, the value is divided by 8. There are two examples of memory capacity calculation in this article: one is non-ECC memory, and each eight pieces of 8-bit data can form a memory; in the other ECC memory, an 8-bit ECC verification code is added after every 64-bit data. The verification code can detect two errors in the memory data and correct one error. Therefore, in the actual capacity calculation process, the actual capacity of the memory of 18 particles with ECC function is multiplied by 16 without calculating the check bit. At the time of purchase, we can also determine that the memory of 18 or 9-chip memory patches is ECC memory.

[Micron memory particles]

The capacity identification of Micron (Micron) memory particles is much easier than that of Samsung. The following uses the MT48LC16M8A2TG-75 number to describe the encoding rules of micron memory.

Meaning:

MT -- the name of the Micron vendor.

48 -- memory type. 48 represents SDRAM; 46 represents DDR.

LC-power supply voltage. LC represents 3 V; C Represents 5 V; V represents 2.5 V.

16M8 -- the memory size is 128 Mbits, and the calculation method is: 16 M (Address) x 8-bit data width.

A2 -- Memory kernel version number.

TG-encapsulation method. TG is TSOP encapsulation.

-75 -- Memory working rate.-75 means 133 MHz;-65 means 150 MHz.

Example: A Micron DDR memory, made of 18 pieces of particles numbered as MT46V32M4-75. The memory supports the ECC function. Therefore, each Bank is an odd number of memory particles.

Its capacity is calculated as follows: capacity 32 MB × 4 ...... remaining full text>

Oracle11gR1 System Configuration

Memory Requirements for installing Oracle 11 GB
At least 1 GB physical memory
Run the following command to check the physical memory size:
$ Grep MemTotal/proc/meminfo

The following table shows the relationship between the physical memory size and the swap space size.
Physical memory swap space
257 M-512 M 2 times physical memory size
513 M-2048 M 1.5 times physical memory size
2049 M-8192 M is the same size as physical memory
Physical memory size greater than 8192 MB and 0.75 times

Run the following command to view the swap space size:
$ Grep SwapTotal/proc/meminfo

Configure the swap space as follows (to be queried)

Run the following command to view available physical memory and swap space:
$ Free

The Automatic Memory Management Function of Oracle 11g requires more shared memory (/dev/shm) and file descriptors. the shared memory should be at least greater than the MEMORY_MAX_TARGET and MEMORY_TARGET values of each Oracle instance on a host.

Run the following command to view available shared memory:
$ Df-k/dev/shm

Hard Disk Space Requirements
The/tmp directory must be between 150 and MB.
Run the following command to view the available space of the/tmp directory:
$ Df-k/tmp

If the available space of the tmp directory is less than 400, Perform one of the following steps to meet the hard disk space requirements (why is it MB is unclear here)

* Delete unnecessary files in the/tmp directory to release space
* Set TMP and TMPDIR environment variables when setting oracle user environment variables
* Increase the file system size of the/tmp directory

The Oracle software size ranges from 1.5 to GB depending on the installation type. See the following table.
Size of the Installation Software file (GB)
Enterprise 3.47
Standard 3.22
Custom (max installation) 3.37

Run the following command to view the available disk space:
$ Df-k

The Enterprise and standard editions require GB of data file space, while the custom database requires GB of data file space. in addition, if you select automatic backup, the quick recovery area requires additional hard disk space.
2. check software requirements

* Operating System Requirements

Oracle Datebase 11g release 1 can be installed on the following operating systems:
Asianux 2.0
Asianux 3.0
Oracle Enterprise Linux 4.0
Oracle Enterprise Linux 5.0
Red Hat Enterprise Linux 4.0
Red Hat Enterprise Linux 5.0
SUSE Enterprise Linux 10.0

Run the following command to view the Linux version:
$ Cat/proc/version

* Kernel requirements

Operating system kernel version
Asianux2.0, Oracle Enterprise Linux 4.0, Red Hat Enterprise Linux 4.0 2.6.9
Asianux3.0, Oracle Enterprise Linux 5.0, Red Hat Enterprise Linux 5.0 2.6.18
SUSE 10.0 2.6.16.21

Run the following command to check whether the required kernel is installed:
$ Uname-r

For example, in Red Hat Enterprise Linux 5.0, execute the following command: