internal of sga1

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    |       |    |- - - - - - - |            -----------  |                              |   |----------     | |                                                                   
       |    |. . . .. .  ...    . . .   ..   .   ..  |                              | 1Process1UGA   | |                                                                      
       |    |           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博客 ” ，链接：http://blog.itpub.net/15072844/viewspace-627473/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15072844/viewspace-627473/