internal of sga3

 Area #0 `Fixed Size' containing Subareas 0-0               
  Total size 00000000001299c8 Minimum Subarea size 00000000 
   Area  Subarea    Shmid      Stable Addr      Actual Addr 
      0        0    65536 0x00000020000000 0x00000020000000      Low Address|--Stable addr of Fixed SGA:0x00000020000000  对照开始的图
                              Subarea size     Segment size                 |
                          000000000012a000 0000000011a00000                 |--Segment size 11a00000=282M=(sga_max_size)    SQL> show parameter sga_max                                                   
 Area #1 `Variable Size' containing Subareas 2-2                            |                                                            
  Total size 0000000011000000 Minimum Subarea size 00400000                 |                                               NAME              TYPE        VALUE                        
   Area  Subarea    Shmid      Stable Addr      Actual Addr                 |                                               ----------------- ----------- ---------
      1        2    65536 0x00000020800000 0x00000020800000                 |--Stable addr of Variable:0x00000020800000   sga_max_size      big integer 280M                         
                              Subarea size     Segment size                 |
                          0000000011000000 0000000011a00000                 |
 Area #2 `Redo Buffers' containing Subareas 1-1                             |
  Total size 00000000006d6000 Minimum Subarea size 00000000                 |
   Area  Subarea    Shmid      Stable Addr      Actual Addr                 |
      2        1    65536 0x0000002012a000 0x0000002012a000                 |--Stable addr of Redo Buffer:0x0000002012a000
                              Subarea size     Segment size                 |
                          00000000006d6000 0000000011a00000                 |
 Area #3 `skgm overhead' containing Subareas 3-3                            |
  Total size 0000000000001000 Minimum Subarea size 00000000                 |
   Area  Subarea    Shmid      Stable Addr      Actual Addr                 |
      3        3    65536 0x00000031800000 0x00000031800000     High Address|--Stable addr of OS Specified:0x00000031800000
                              Subarea size     Segment size                 (*地址是从低到高*)
 
                          0000000000001000 0000000011a00000 
验证地址的连续性:variable --redo buffe
SQL> select to_number('20800000','xxxxxxxxx') from dual;
TO_NUMBER('20800000','XXXXXXXX
------------------------------
                     545259520

验证前面的结构图

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

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