Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tablespace

  1. #1
    Join Date
    Jul 2001
    Location
    Dubai
    Posts
    3
    hi everyone

    in oracle8i administrators guide it is stated

    " Beginning with Oracle8i, you can now create locally managed tablespaces,
    which use bitmaps (instead of SQL dictionary tables) to track used and free space."

    here, i don't understand the term "bitmaps" .
    can anyone explain me about "bitmaps" pls...

    regards

    Valsaraj


  2. #2
    Join Date
    May 2001
    Posts
    55
    Each bit in the bitmap corresponds to a block or a group of blocks. When an extent is allocated or freed for reuse, Oracle changes the bitmap values to show the new status of the blocks.

    This extract is from the link below

    http://www.dbasupport.com/oracle/ora8/page11.shtml
    A farmer learns more from a bad harvest than a good one

  3. #3
    Join Date
    Jul 2001
    Location
    Dubai
    Posts
    3

    Thanks...

    thanks topstar..

    now i assume, bitmaps is the location ( basically a map itself) keeping the track of extens. each extent is recorded as a bit in bitmap ! so howmany bits, that much extens.. right ???

    thanks anyway...

    regards

    valsaraj

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