获得Oracle各内存段的内部信息 (二)


Bucket 3 size=140

Bucket 4 size=236

Bucket 5 size=268

Bucket 6 size=524

Bucket 7 size=1036

Bucket 8 size=2060

Bucket 9 size=4108

Bucket 10 size=8204

Bucket 11 size=16396

Bucket 12 size=32780

Bucket 13 size=65548

Bucket 14 size=131084

Bucket 15 size=262156

Bucket 16 size=524300

Bucket 17 size=2097164

Total free space = 260 --- 以 kb 为单位 .

UNPINNED RECREATABLE CHUNKS (lru first):

PERMANENT CHUNKS:

Chunk 7be985c sz= 8500 perm "perm " alo=7524

Chunk 7be532c sz= 3764 perm "perm " alo=3764

Chunk 7b6950c sz= 152 perm "perm " alo=152

Chunk 7bb0c28 sz= 404 perm "perm " alo=404

Chunk 7be31dc sz= 8440 perm "perm " alo=8440

Chunk 7be2c44 sz= 1140 perm "perm " alo=1140

Chunk 7bb003c sz= 3052 perm "perm " alo=3052

Chunk 7be108c sz= 7096 perm "perm " alo=7096

Chunk 7b68d3c sz= 2000 perm "perm " alo=2000

Permanent space = 34548--- 以 kb 为单位 .



HEAP DUMP heap name="top call heap" desc=067D46D8

heap name="top call heap" ---- 这个 PGA 中的 CGA 信息

extent sz=0x213c alt=92 het=32767 rec=0 flg=2 opc=3

parent=00000000 owner=00000000 nex=00000000 xsz=0xfffc

EXTENT 0 addr=07BF0004

Chunk 7bf000c sz= 32828 perm "perm " alo=136

Chunk 7bf8048 sz= 30552 free " "

Chunk 7bff7a0 sz= 1072 recreate "callheap " latch=00000000

ds 67d3d00 sz= 1072 ct= 1

Chunk 7bffbd0 sz= 1072 recreate "callheap " latch=00000000

ds 67d3d68 sz= 1072 ct= 1

Total heap size = 65524

FREE LISTS:

Bucket 0 size=44

Bucket 1 size=76

Bucket 2 size=96

Bucket 3 size=140

Bucket 4 size=236

Bucket 5 size=268

Bucket 6 size=524

Bucket 7 size=1036

Bucket 8 size=2060

Bucket 9 size=4108

Bucket 10 size=8204

Bucket 11 size=16396

Chunk 7bf8048 sz= 30552 free " "

Bucket 12 size=32780

Bucket 13 size=65548

Bucket 14 size=131084

Bucket 15 size=262156

Bucket 16 size=524300

Bucket 17 size=2097164

Total free space = 30552

UNPINNED RECREATABLE CHUNKS (lru first):

PERMANENT CHUNKS:

Chunk 7bf000c sz= 32828 perm "perm " alo=136

Permanent space = 32828



HEAP DUMP heap name="top uga heap" desc=067D47F8

heap name="top uga heap" --- 这个 PGA 中的 UGA 信息

extent sz=0xffdc alt=92 het=32767 rec=0 flg=2 opc=3

parent=00000000 owner=00000000 nex=00000000 xsz=0x1fffc

EXTENT 0 addr=07C00004

Chunk 7c0000c sz= 48 free " "

Chunk 7c0003c sz= 65476 recreate "session heap " latch=00000000

ds 7be7490 sz= 65476 ct= 1

Total heap size = 65524

FREE LISTS:

Bucket 0 size=44

Chunk 7c0000c sz= 48 free " "

Bucket 1 size=76

Bucket 2 size=96

Bucket 3 size=140

Bucket 4 size=236

Bucket 5 size=268

Bucket 6 size=524

Bucket 7 size=1036

Bucket 8 size=2060

Bucket 9 size=4108

Bucket 10 size=8204

Bucket 11 size=16396

Bucket 12 size=32780

Bucket 13 size=65548

Bucket 14 size=131084

Bucket 15 size=262156

Bucket 16 size=524300

Bucket 17 size=2097164

Total free space = 48

UNPINNED RECREATABLE CHUNKS (lru first):

PERMANENT CHUNKS:

Permanent space = 0


这上面有一些还没搞清楚 . 所以在这里就没做解释 .

Published At
Categories with 数据库类
comments powered by Disqus