Specifications for memory particle size under different versions of Oracle

*********************************************** Declaration ********************************************* * 

original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held responsible for copyright law.

Please leave a message or email ([email protected]) to indicate the error.

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

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

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

(a), 9i

Version: Oracle9i
Linux/unix
Sga	Particle size (granule)
Less than or equal to 128M (sga<=128 M)	4M
When greater than 128M (SGA >128 M)	16M
Windows
Sga	Particle size (granule)
Less than or equal to 128M (sga<=128 M)	4M
When greater than 128M (SGA >128 M)	8M

(b), 10g

Version: oracle10g
Linux/unix
Sga	Particle size (granule)
Less than or equal to 1G (SGA<=1G)	4M
Greater than 1G (SGA >1g)	16M
Windows
Sga	Particle size (granule)
Less than or equal to 128M (SGA<=1G)	4M
Greater than 128M (SGA >1g)	8M

(iii), 11g

Version: oracle11g
Linux/unix
Sga	Particle size (granule)
Less than or equal to 1G (SGA<=1G)	4M
Greater than 1G (SGA >1g)	16M
Windows
Sga	Particle size (granule)
Less than or equal to 128M (SGA<=1G)	4M
Greater than 128M (SGA >1g)	8M

In short

"Example" memory particles

Definition: Minimum allocation unit for SGA

Composition: consists of some connected virtual memory

Size: Determined by SGA, 11G environment, SGA is less than 1G when memory grain is 4MB;SGA greater than 1G when memory grain is 16MB

Query Example:

Environment: oracle11g

Sql>select granule_size from V$sga_dynamic_components;

Granule_size

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

4194304

Word Interpretation:

Granule: Granule

Component: Components

Dynamic: Dynamically

Extension

This dynamic view also allows you to view the allocation of memory in the SGA

Sql>select component,current_size/1024/1024 from V$sga_dynamic_components

COMPONENT current_size/1024/1024

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

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

Sharedio Pool 0

Asmbuffer Cache 0

14rows selected.

Special thanks, friends Heffley, Van Bosch give technical help.

*********************************************** Declaration ********************************************* * 

original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held responsible for copyright law.

Please leave a message or email ([email protected]) to indicate the error.

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

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

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

Specifications for memory particle size under different versions of Oracle