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

2/9/2008来源:Oracle教程人气:5869


  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
  
  ******************************************************
  
  这上面有一些还没搞清楚.所以在这里就没做解释.