-
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,
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|