oracle内存结构

最新推荐文章于 2024-11-21 15:02:11 发布

转载最新推荐文章于 2024-11-21 15:02:11 发布 · 994 阅读

oracle 专栏收录该内容

6 篇文章

订阅专栏

For Free List

1.在heap中unused memory 总是保存在一条Free-list上

2. Heap总是最少有一条 Free-List

3. 初始化堆heap的程序调用者(KGH Function Caller)可以指定以下属性：

a. heap中Freelist 空闲列表的数量(The number of free list )

b. chunk内存块的分布范围(The range of chunks to put on them.)

4. memory manger(KGH) 保证 heap中的每一块空闲内存Free Chunk 总是在某一条Free list上

Free List Buck 结构 kghbk-> Kernel Generic shared Heap manager Bucket

ODM Test:

SQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 0
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 200M
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump heapdump 536870914;
Statement processed.
SQL> oradebug tracefile_name;
/s01/admin/G10R21/udump/g10r21_ora_3755.trc
HEAP DUMP heap name="sga heap(1,0)" desc=0x600332a8
extent sz=0xfe0 alt=216 het=32767 rec=9 flg=-126 opc=0
FREE LISTS:
Bucket 0 size=32
Bucket 1 size=40
Chunk 0802e99a8 sz= 40 free " "
Chunk 0805fac20 sz= 40 free " "
......................
Bucket 2 size=48
Chunk 0803ec120 sz= 48 free " "
Chunk 08051d580 sz= 48 free " "
Chunk 0804d9670 sz= 48 free " "
Chunk 0805cc008 sz= 48 free " "
................................
Bucket 251 size=12360
Chunk 08024c3f0 sz= 12496 free " "
Bucket 252 size=16408
Chunk 08026e088 sz= 16592 free " "
Chunk 080256510 sz= 20480 free " "
Chunk 081f8c4f0 sz= 24688 free " "
Bucket 253 size=32792
Bucket 254 size=65560
Chunk 081f30f28 sz= 361928 free " "
Chunk 08019bd80 sz= 714344 free " "
Total free space = 1191752

复制代码

size > 65560bytes=64k chunks always stored in Bucket 254 , 空闲列表最大有0-254 共255个 Buckets(Heap free lists contain 255 buckets)

Each bucket contains double linked list to free chunks

Bucket sizes increase in

increments of 4 bytes - 16, 20, 24, 28, 32 ... 808, 812

increments of 64 bytes - 876, 940, 1004 ... 3948, 4012

then 4108, 8204, 16396, 32780, 65548

Reduces fragmentation

RESERVED FREE LISTS:
Reserved bucket 0 size=32
Reserved bucket 1 size=4400
Reserved bucket 2 size=8216
Reserved bucket 3 size=8696
Reserved bucket 4 size=8704
Reserved bucket 5 size=8712
Reserved bucket 6 size=8720
Reserved bucket 7 size=9368
Reserved bucket 8 size=9376
Reserved bucket 9 size=12352
Reserved bucket 10 size=12360
Reserved bucket 11 size=16408
Reserved bucket 12 size=32792
Reserved bucket 13 size=65560
Chunk 080000088 sz= 212808 R-free " "
Chunk 080400088 sz= 212808 R-free " "
Chunk 080800088 sz= 212808 R-free " "
Chunk 080c00088 sz= 212808 R-free " "
Chunk 081000088 sz= 212808 R-free " "
Chunk 081400088 sz= 212808 R-free " "
Chunk 081800088 sz= 212808 R-free " "
Chunk 081c00088 sz= 212808 R-free " "
Total reserved free space = 4256160

复制代码

RESERVED FREE LISTS一般有14个Bucket

UNPINNED RECREATABLE CHUNKS (lru first):
Chunk 083ffffc8 sz= 56 recreate "fixed allocatio" latch=0x600156a0
Chunk 082bffd10 sz= 64 recreate "fixed allocatio" latch=0x82f4bfd0
Chunk 0823ce0a8 sz= 56 recreate "fixed allocatio" latch=0x82f4bfd0
Chunk 0823cce68 sz= 56 recreate "fixed allocatio" latch=0x82f4bfd0
Chunk 0823caaa8 sz= 56 recreate "fixed allocatio" latch=0x82f4c110
Chunk 0823ca6a0 sz= 56 recreate "fixed allocatio" latch=0x82f4c110
Chunk 0823c98b8 sz= 56 recreate "fixed allocatio" latch=0x82f4c110
Chunk 0823c74f8 sz= 56 recreate "fixed allocatio" latch=0x82f4c070
Chunk 0823c72b0 sz= 56 recreate "fixed allocatio" latch=0x82f4c070
Chunk 0823c6920 sz= 56 recreate "fixed allocatio" latch=0x82f4c110
Chunk 0823c0410 sz= 56 recreate "fixed allocatio" latch=0x82f4c110
Chunk 0823ba420 sz= 1112 recreate "KGLS heap " latch=0x82f4c110
Chunk 0823bfd00 sz= 1112 recreate "Heap0: KGL " latch=0x82f4c110
Unpinned space = 2957616 rcr=974 trn=1465

复制代码

1.recreate memory 是那些已分配的内存，但是仍可以被age out到heap的Free List上
2.KGH heap manager 使用LRU算法来实现aging
3.chunk flag KGHACRECR用来标示那些其内容已经为recreatable的chunk
4. 当chunk不在被使用, chunk的用户可以显示地将它 unpin解锁掉，从而KGM Memory Manager会看到这个chunk成为潜在的Free Chunk
5. KGH 会调用已注册的回调程序(callback)来请求chunk的所有者将该chunk 释放Free掉
6. chunk的拥有者可以自行决定是否释放Free chunk
7. 被 "pinned"住的recreatable chunk无法aged out到Free List上
8. 所有未被锁住的Unpinned Recrateable chunk都被暂存在堆heap的LRU LIST上

Recreatable chunk header - kghrc -> kernel generic heap memory manager recreatable chunk header

Chunk 0823ba420 sz= 1112 recreate "KGLS heap " latch=0x82f4c110

Oracle同样利用latch来限制 client 的callback对recreatable chunk的串行操作。

什么是heaps?

oracle内核中的内存管理器 memory manager (KGH kernel generic heap) 负责管理内存逻辑结构，逻辑结构被称为 heaps 堆。

一个heap 堆包括：
1. 一种被称作堆描述符"heap descriptor"的逻辑结构 (该结构用以记录管理操作信息)
2. 被称作 Extents的连续内存片的集合

一个heap 包含一个或多个Extents ，每一个heap extent占用一个独立的granule ，如4M 16M等size ，也就是说一个parent heap 的最小分配单位是extent- granule 。

每一个 extents 可能包含很多个chunks ，chunk被我们翻译为内存块。

每一个heap 总是有一个Free List 记录了 free chunks 空闲内存块的信息。

什么是Extent?

1.一个Extent 是一段被分配给heap的连续内存段
2. Extent总是从父堆parent heap 或者通过特殊的回调程序分配
3. 绝大多数heap 从他们的父堆parent heap哪里获得内存