| Is there any way for defrage the tablespace in linux Os [message #178146] |
Mon, 19 June 2006 10:45  |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Friends/Sirs
I'm suffering from problem with linux os.i think datafiles are too much fragemented.is there any way to defrage the files in linux os with oracle.
Thanks in advance and hoping for the best reply as u give earlier.
Regards
|
|
|
|
| Re: Is there any way for defrage the tablespace in linux Os [message #178147 is a reply to message #178146] |
Mon, 19 June 2006 10:49  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>i think datafiles are too much fragemented.
What makes you thinks so?
Did you measure anything?
Are you talking about OS fragmentation or tablespace fragmentation within oracle tablespace? In case of later, then
What is your oracle version?
If you are using DMT, use init=next and pctincrease=0.
If you are using LMT, using uniform extent size.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
