一、 共享池存储单位
共享池是由堆(Heap)组成,堆是由区(Extent)组成,区是由块(Chunk)组成。块(Chunk)可以包含子堆,子堆又划分区,区又划分块(chunk)。有的甚至有三层。
二、Heap、Extent、Chunk图
三、转储共享池内存结构
环境为32位11.2.0.1.0版本ORACLE
[root@panda ~]# su - oracle
[oracle@panda ~]$ sqlplus / as sysdba
SQL> alter session set events 'immediate trace name heapdump level 2';
Session altered.
SQL> select * from v$diag_info where name = 'Default Trace File';
INST_ID NAME VALUE
---------- -------------------- ------------------------------------------------------------
1 Default Trace File /u01/app/oracle/diag/rdbms/panda/panda/trace/panda_ora_2724.trc
再开一个窗口查看trace文件:
HEAP DUMP heap name="sga heap(1,0)" desc=0x2002b094
extent sz=0xfc4 alt=124 het=32767 rec=9 flg=-126 opc=0
parent=(nil) owner=(nil) nex=(nil) xsz=0x400000 heap=(nil)
fl2=0x20, nex=(nil)
latch set 1 of 1
durations enabled for this heap
reserved granules for root 17 (granule size 4194304)
EXTENT 0 addr=0x4b400000
Chunk 4b400038 sz= 24 R-freeable "reserved stoppe"
Chunk 4b400050 sz= 212888 R-free " "
Chunk 4b433fe8 sz= 24 R-freeable "reserved stoppe"
Chunk 4b434000 sz= 3981312 perm "perm " alo=602240
EXTENT 1 addr=0x4b800000
Chunk 4b800038 sz= 24 R-freeable "reserved stoppe"
Chunk 4b800050 sz= 4184220 R-perm "perm " alo=4184220
Chunk 4bbfd8ec sz= 9980 R-free " "
Chunk 4bbfffe8 sz= 24 R-freeable "reserved stoppe"
EXTENT 2 addr=0x4bc00000
Chunk 4bc00038 sz= 24 R-freeable "reserved stoppe"
Chunk 4bc00050 sz= 212888 R-free " "
Chunk 4bc33fe8 sz= 24 R-freeable "reserved stoppe"
Chunk 4bc34000 sz= 3510272 perm "perm " alo=3510272
Chunk 4bf8d000 sz= 458768 perm "perm " alo=458768
Chunk 4bffd010 sz= 12272 free " "
EXTENT 3 addr=0x4c000000
Chunk 4c000038 sz= 24 R-freeable "reserved stoppe"
Chunk 4c000050 sz= 212888 R-free " "
Chunk 4c033fe8 sz= 24 R-freeable "reserved stoppe"
Chunk 4c034000 sz= 3852224 perm "perm " alo=3852224
Chunk 4c3e07c0 sz= 114704 perm "perm " alo=114704
Chunk 4c3fc7d0 sz= 14384 free " "
EXTENT 4 addr=0x4c400000
Chunk 4c400038 sz= 24 R-freeable "reserved stoppe"
Chunk 4c400050 sz= 212888 R-free " "
Chunk 4c433fe8 sz= 24 R-freeable "reserved stoppe"
Chunk 4c434000 sz= 3980368 perm "perm " alo=3980368
Chunk 4c7ffc50 sz= 944 free " "
EXTENT 5 addr=0x4c800000
Chunk 4c800038 sz= 24 R-freeable "reserved stoppe"
Chunk 4c80005