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

Thread: Frag Question for Newbie

  1. #1
    Join Date
    Nov 2000
    Posts
    175
    Hi,

    I am trying to follow the Stop defragmenting and Start living article and would like some feedback.
    I realize LMT in 8i will take care of this, but I would like to get this concept.

    Here is what I got from the article, version 8.0.5
    8k block size - 8192
    500m datafiles (500 * 1024) + 8 (1 block) = 512008k
    Med size tables - 4096k extents

    create tablespace test datafile '/oracle/test_data01.dbf' size 512008k
    minimum extent 4096k
    default storage (initial 4096k
    next 4096k
    minextents 1
    maxextents 505
    pctincrease 0);


    From dba_tablespaces this gives me
    524296192 - bytes, giving user bytes 524288000, takes 8192 out for the header
    64001 - blocks, giving user blocks 64000, takes 1 block out for the header

    I don't see the extents working out equally.
    4096k extents should be 500 (8192 blocks),
    but each of my extents are 515 blocks (4218880 bytes) from dba_extents.

    What am I missing.
    Thanks,


  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Oracle always rounding off to multiples of 5 for the initial and next extents.
    So you need to recalculate your bytes, extents, and blocks to arrive suitable datafile size.

  3. #3
    Join Date
    Nov 1999
    Posts
    226
    It is recommended to follow

    file size of

    32 MB + 1 Block for the header

    128MB +1 Block for the header

    256MB +1 Block for the header

    512MB +1 Block for the header

    1024MB + 1 Block for the header

    regards

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