Free list
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Free list

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    Hi folks,
    Where is the free lists of an object stored..

    REgards
    sonia

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    FREELISTs reside in segment header block.

    Sanjay

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by SANJAY_G
    FREELISTs reside in segment header block.

    Sanjay
    Again dumping the block if you dump the segment header block then you will get to see the freelist in segment header block

    Code:
    *** 2002-09-20 12:28:23.392
    Start dump data blocks tsn: 2 file#: 3 minblk 162 maxblk 162
    buffer tsn: 2 rdba: 0x00c000a2 (3/162)
    scn: 0x0000.0009ae2b seq: 0x01 flg: 0x00 tail: 0xae2b1001
    frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
     
      Extent Control Header
      -----------------------------------------------------------------
      Extent Header:: spare1: 0      space2: 0      #extents: 21     #blocks: 335   
                      last map  0x00000000  #maps: 0      offset: 4128  
          Highwater::  0x00c001ec  ext#: 20     blk#: 10     ext size: 16    
      #blocks in seg. hdr's freelists: 292   
      #blocks below: 329   
      mapblk  0x00000000  offset: 20    
                       Unlocked
         Map Header:: next  0x00000000  #extents: 21   obj#: 24292  flag: 0x40000000
      Extent Map
      -----------------------------------------------------------------
       0x00c000a3  length: 15    
       0x00c000b2  length: 16
    HTH

    Sameer

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    How much space does it occupy???
    -nagarjuna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width