ITPub博客

首页 > Linux操作系统 > Linux操作系统 > internal of sga1

internal of sga1

原创 Linux操作系统 作者:tompson1983 时间:2010-02-22 12:56:28 0 删除 编辑
oradebug dumplist
Global Area(在SGA中存放)=Fixed(SGA+GSGA,PGA+GPGA,UGA+GPGA)
IPC=Shared Global Area
SGA+PGA:
在SGA各个pool中的1granule=1extent,1extent=n chunks,在Freelist中单位是buckets
PGA可能类似
       ----------------------------------------------------------------------------------------------------
       |                                                                                                  |
       |                                 Memory Of Oracle Structure                                       |
       |                                                                                                  |
       ---------------------------------------------------------------------------------------------------|                                                                      
       |       GLOBAL_AREA=Fixed_SGA+Fixed_PGA+Fixed_UGA+ Indirct Memory ==>Locate is in :SGA             |                                                             |                                                                      
       ------------------------------------------------------------ --------------------------------------|                                                                      
       |                                                                                                  |                                                                      
       |    =========================================|                              |===================| |                                                                      
       |    |                   SGA                  |                              |      PGA          | |                                                                      
       |    |========================================|->Low Addr                    |===================| |                                                                      
       |    |                Fixed SGA(First Gradule)|                              |    Fixed  PGA     | |                                                                      
       |    |========================================|->High Addr                   |===================| |                                                                      
       |    |                                        |                              |                   | |                                                                      
       |    |                    SGA                 |                              |      PGA          | |                                                                      
       |    |- - - -  -  - - -  - - - - -  - - - - - |                              |                   | |                                                                      
       |    |                Buffer Cache            |                              |-------------------| |                                                                      
       |    |- - - - - - - - - - - - - - - - - - - - |     Oracle Server Process    | Dedicate  Mode    | |                                                                      
       |    |              |               UGA       |  <-------------------------> |-----------------  | |                                                                      
       |    |              |            |-------- |  |     Oracle User Process      |      |||||        | |                                                                      
       |    | Shared Pool  |            |         |  |  <-------------------------> |      |||||        | |                                                                      
       |    |              |            |---------|  |        Listener(Local)       |      |||||        | |                                                                 
       |    |              |            |  UGA    |  |  <-------------------------> |   |---------|     | |                                                                      
       |    |- - - - - - - |Shared(MTS) |         |  |                              |   |  UGA    |     | |                                                                      
       |    |Large Pool    |<---------> |         |  |                              |   | Pieces  |     | |                                                                      
       |    |- - - - - - - |            -----------  |                              |   |----------     | |                                                                   
       |    |. . . .. .  ...    . . .   ..   .   ..  |                              | 1Process<->1UGA   | |                                                                      
       |    |           Other Structure              |                              ===================== |                                                                      
       |    | . . . ... .Fixed PGA,UGA  . .  . . . . |                                      | | |         |                                                                      
       |    |- - - - - - - - -  - - - - - -   -   - -|                                      | | |         |                                                                      
       |    |                Log buffer(Last Gradule)|                                      | | |         |                                                                      
       |    =========================================|                                      | | |         |                                                                      
       |                       ||                                                           | | |         |
       |              Shared OS mem Segment                                         Private Os mem segmet |
       |                                                                                                  |
       ----------------------------------------------------------------------------------------------------
--Fixed Memory structrue   
Global Area
*.Fixed SGA:
The structure of the fixed SGA is externalised in X$KSMFSV;
SELECT
        SUBSTR (ksmfsnam,1,20) AS "Name",
        SUBSTR (ksmfstyp,1,20) AS "Type",
        ksmfsadr AS "Address",
        ksmfssiz AS "Size"
    FROM x$ksmfsv
*.Fixed PGA

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15072844/viewspace-627473/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Internal of Rac ha
下一篇: internal of sga2
请登录后发表评论 登录
全部评论

注册时间:2009-06-15

  • 博文量
    52
  • 访问量
    85441