| Fragmentations [message #209121] |
Wed, 13 December 2006 07:01  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
Oracle Version : 9.2.0.7
db_block_size = 8192
INITITAL_EXTENT & NEXT_EXTENT = 109051904
Datafile Size : 6442450944
-----------------------------
Ref : Oracle Metalink Note : HOW TO STOP DEFRAGMENTING AND START LIVING: THE DEFINITIVE WORD ON FRAGMENTATION
When allocating files to a tablespace, make sure to set the size of the file to be a multiple of the extent size for the tablespace plus one block.
These extent sizes are chosen to be a multiple of five blocks since Oracle7 will round all extent sizes to a multiple of five
blocks. In Oracle8 extents won’t be rounded to a multiple of five blocks if they are a multiple of the minimum extent size
for the tablespace.
-----------------------------
Will this hold good in version 9 also?
if yes, So what could be the optimal size for extent size and datafle size.
I want the extent size around 100M and datafile around 6GB.
Please suggest
Brian.
|
|
|
|
|
|
| Re: Fragmentations [message #209127 is a reply to message #209121] |
Wed, 13 December 2006 07:18  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Said recomendation is primarily for DMT (initial=next and a zero pctincrease).
With LMT, uniform extent size is the way to go.
It will ***almost*** fix all the fragmentation (still interblock fragmentation is possible which you cannot avoid).
[Updated on: Wed, 13 December 2006 07:18] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
