| 本月文章推荐 |
获得Oracle各内存段的内部信息（二）发表日期：2008-2-9
|
|
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 ****************************************************** 这上面有一些还没搞清楚.所以在这里就没做解释. |
| 上一篇：获得Oracle各内存段的内部信息（一）
人气:1249 下一篇：优化Oracle库表设计的若干方法(组图) 人气:1081 |
| 浏览全部Oracle教程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
