Oracle 内存结构图

       ---------------------------------------------------------------------------------------------------|
       |                                        GLOBAL   AREA                                             |
       ------------------------------------------------------------ --------------------------------------|
       |                                                                                                  |
       |    =========================================|                              |===================| |
       |    |                   SGA                  |                              |      PGA          | |
       |    |========================================|->Low Addr                    |===================| |
       |    |                Fixed SGA(First Gradule)|                              |    Fixed  PGA     | |
       |    |========================================|->High Addr                   |===================| |
       |    |                                        |                              |                   | |
       |    |                    SGA                 |                              |                   | |
       |    |- - - -  -  - - -  - - - - -  - - - - - |                              |                   | |
       |    |                Buffer Cache            |                              |      PGA          | |
       |    |- - - - - - - - - - - - - - - - - - - - |     Oracle Server Process    |                   | |
       |    |              |               UGA       |         |    |              |            |-------- |  |     Oracle User Process      |                   | |
       |    | Shared Pool  | Dedicate   |Fixed UGA|  |         |    |              |       |    |              |            |  UGA    |  |         |    |- - - - - - - |Shared(MTS) |         |  |                              |                   | |
       |    |Large Pool    |       |    |- - - - - - - |            -----------  |                              |                   | |
       |    |. . . .. .  ...    . . .   ..   .   ..  |                              |                   | |
       |    |           Other Structure              |                              ===================== |
       |    | . . .  . .     . . . .    . .  . . . . |                                                    |
       |    |- - - - - - - - -  - - - - - -   -   - -|                                                    |
       |    |                Log buffer(Last Gradule)|                                                    |
       |    =========================================|                                                    |
       ---------------------------------------------------------------------------------------------------|

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

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