Memory structure-SGA

2010-03-21  来源:本站原创  分类:Database  人气:190 

Oracle's memory structure consists of SGA system global area, PGA program global area and the software code area


All the user process, the server process can be shared SGA area, which is the process of different users to communicate with the central server process.

SGA is divided into the following sections:

1) data cache

A) for the preservation of the most recent data file read from the data block, or store frequently used recent data, which data can be shared by all users.

B) The size of the part specified by the initialization parameter DB_CACHE_SIZE, typically 1% of database size

C) that part of it by the three smaller buffer pools, each pool is used to store a cache of data with different access characteristics, in order to improve efficiency. Users can also

For specific objects (such as creating, changing table or index) the use of storage clause specified BUFFER_POOL parameter to set the object to use

Buffer pool.

a) keep to keep buffer pool: one of the data (ie the cache block) to long-term preservation, until the database is shut down. Applicable to long-term preservation and in memory

Frequently accessed objects, such as code tables.

b) recycle buffer pool recovery: Once the data which will be swapped out after use.

c) default default buffer pool: the object using the default buffer pool. oracle using the least recently used LRU algorithm to swap out.

Note: keep, and recycle the size of the initialization parameter to specify BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE

Parameters DB_CACHE_SIZE minus the value of these two parameters after the default is the size of the remaining

D) data cache size equal to the cache by the number of blocks. The same with the OS block size. Can be divided into three categories

a) dirty buffers dirty cache block: When a SQL statement on a cache block in the revised data, this cache block will be marked as dirty cache blocks,

The block of data will be persisted to a data file.

b) free buffers free cache blocks: these blocks there is no data, they are waiting to be written to the data.

c) pinned buffers cache hit blocks: Save the most recent data from being accessed. These data will always be stored in memory.

E) Oracle management through the following two lists of Appeal cache block:

a) dirty list: save has been modified but not yet written the data file cache block dirty

b) LRU list: Save the hit, idle and not be moved to the list of dirty dirty cache blocks. LRU list can be viewed as a queue.

Was frequently visited in the team first, on the tail will be the first to be removed.

Memory structure-SGA

2. Redo log cache

Used to record insert, update, delete statements, and create, alter, drop and other statements of redo records. Log_buffer developed by the parameters.

3. Shared Pool

Save the last executed SQL statements, PL / SQL process and package the data dictionary information, locks, and other control structure information. It is SQL,

PL / SQL for syntax parsing, compilation, execution memory area, mainly by the data dictionary cache and library cache component. Designated by the shared_pool_size.

1) The data dictionary cache (dictionary cache)

A) is used to store frequently used recent data dictionary information, such as table definitions, column definitions, usernames, passwords, permissions, database structure information.

B) Oracle run-time required to access the data dictionary to parse the SQL, to determine whether the object exists, verify permissions. If the data in the cache does not exist

Then take the data file to read the data dictionary.

C) data dictionary cache is stored in one of a record, while the other buffer is the data block stored

2) the library cache

Used to keep the last parsed SQL statement PL / SQL

Oralce will be shared each SQL decomposed and non-shared parts, stored in the shared SQL areas and private SQL area

A) shared SQL area: storage is the recent implementation of the SQL statement syntax tree after parsing and optimized execution plan

B) Private SQL area: storage and private conversations and user-related information, such as: bind variables, the environment, and session parameters.

C) PL / SQL procedures and packages District: Storage PL / SQL parsing code execution. PL / SQL in the SQL or stored in a shared SQL area

D) locks and other control structures District: Oracle instance storage of information required internal operations, such as various locks, latches, registers and other values. Background process needs to

Access to them.

4. Large pool (optional)

Tai Chi for operations that require large memory space to provide relatively independent of memory in order to improve the performance of these operations. Determine the size by large_pool_size

Memory-intensive operations, including:

1) The database backup and recovery, such as the use of RMAN backup in the tape device, dump, restore and other operations.

2) a large number of sort operations with SQL statements.

3) parallel database operations.

Note: If there is no area in the SGA to create a large pool of memory space required for operation of the appeal will take the shared pool of memory

5.Java pool (optional)

After the Oracle 8i, Oracle adds support for Java language, Java provides a pool for the storage of Java code, Java statement syntax analysis table

Java statements in program implementation and Java program development. Used to determine the size of java_pool_size

  • Oracle architecture: the memory structure and process structure 2010-06-28

    (A) the structure of memory structures and processes Oracle database, the overall structure of the following diagram: 1: Oracle instance (Instance) In a server , each running an Oracle database, database instance are associated with the instance is a

  • C + + object memory structure and the multi-state implementation 2010-11-11

    Also learn a C + + memory structures, tend to forget, to prevent future everywhere, today to buy the blog. If you are C + + or java object model that do not know, guess you do not know what I'm talking about. At least you have to know the definition

  • Java garbage collection - the memory structure 2010-11-18

    General process: minor collections occurring at intervals long enough to allow many of the objects to die between collections. It is well-tuned in the sense that the young generation is large enough (and thus the period between minor collections long

  • Oracle memory structure and processes 2010-03-17

    1, an Oracle instance from the one known as the System Global Area SGA for shared memory and a number of process composition; is formed by the storage structure and processes. SGA has three essential elements: the shared pool, database cache, and log

  • Oracle System Structure - memory structure 2010-10-29

    First, the system global area (SGA) The data system global area shared by multiple users. When the database instance is started, the system global area memory is automatically allocated. Different according to the role of SGA, is divided into: data b

  • windows in the process of memory structure 2011-01-02

    Before reading this article, even if you do not know more than what the stack, then read the back of the basics of the article. Contact with people who know programming, high-level language variable names can be accessed through the data in memory. T

  • The Oracle architecture - the memory structure 2010-10-29

    First, the system global area (SGA) System global area of ​​data shared by multiple users. When the database instance starts, the system global area memory is automatically allocated. SGA according to the role of different, divided into: data buffer,

  • java memory structure and model 2010-11-04

    A, java memory structures 1. Heap (heap): instances where the distribution, by-Xms and-Xmx to set the 2. MethodArea (approach area): class information and static variables. Corresponds to a Permanet Generation, by-XX: PermSize to set 3. JavaStack (ja

  • oracle memory structure based 2010-12-07

    1. Storage structure Oracle database storage structure is divided into logical storage structure and the physical storage structure. Figure 3 2. Logical structure Logical Oracle database storage structure describes the internal storage structures, fr

  • Oracle memory parameter tuning technology Xiangjie 2010-04-03

    Of Hopes to organize this document, so that we right You oracle memory structure of a comprehensive understanding of the practical work and flexibility in the application, so that oracle's memory Xingneng Dadaozuiyou allocation and improving applicat

  • Oracle recommends manually configure SGA.PGA (rpm) 2011-02-24

    Example structure instance = structure + oracle process memory structure oracle instance starts the process, in fact, the value of oracle memory parameters loaded into memory and start the appropriate background processes related service process. Pro

  • oracle memory tuning parameters explain 2011-06-12

    Transfer: Instance = instance structure oracle memory architecture + oracle instance startup process structure process, in fact, the value of oracle memory parameters loaded into memory and start the approp

  • Finishing the Oracle SQL Plus, and based on technology-related 2010-08-09

    _______put in order MyOracle copyright @ kewen_vip I. ORACLE main features: ************************************ ********************************************** 1. support multi- users, a large amount of transaction processing services 2. Data securit

  • Redis memory storage structure analysis 2011-05-24

    1 Redis memory storage structure This article is based on the analysis Redis-v2.2.4 version. 1.1 Redis the overall structure of memory storage Redis support multiple key-value database (table), and with RedisDb to represent a key-value database (tabl

  • Memory structure-SGA 2010-03-21

    Oracle's memory structure consists of SGA system global area, PGA program global area and the software code area 1.SGA All the user process, the server process can be shared SGA area, which is the process of different users to communicate with the ce

  • Memory structure-PGA 2010-03-22

    Overview: PGA areas are user processes connect to the database and create the corresponding session from the oracle server process for the allocation of the current user session dedicated to the memory Area. The zone of non-shared, not written to acc

  • Oracle-memory structure 2010-03-01

    SGA - Oracle's system global space SGA - data cache pool (DB Buffer) | |--------- Default buffer pool | |--------- Maintain the buffer pool | |--------- Regeneration buffer pool | | --- Shared cache pool | |-------- Library cache | | |------ Shared S

  • oracle rman file structure 2010-05-22

    RMAN based Control of the log file data file file parameter file archive . Dbf suffix names can be modified Archiving mode Non-archive mode RMAN mode to be filed Non-archive mode, RMAN can not start NLS_TERRYTORY NLS_LANGUAGE Character Set: Initializ

  • the basic structure of oracle based 2010-12-07

    1. Oracle architecture consists of the memory structure, process structure, storage structure and composition Figure 1 Memory structures: the SGA (System Global Area, the system global area), PGA (Program Gloal Area, Program Global Area), with use me

  • Oracle memory structure-SGA articles 2011-02-19

    In the " Oracle memory structure "mentioned in the article, PGA is a server process dedicated private memory area, and SGA is the shared memory area. SGA is comprised of several components: 1, the fixed SGA (Fixed SGA) 2, block buffer (Db cache)