| checking fragmentation [message #65805] |
Thu, 30 December 2004 03:40  |
Pankaj Gupta
Messages: 4
Registered: April 2004
|
Junior Member |
|
|
Hello friends
I would like to know the query how can we find out the fragmentation in the Tablespaces. and how can i avoid them.except this query
alter tablespace tablespace_name coalesce;
Thanks and Regards
Pankaj Gupta
|
|
|
|
| Re: checking fragmentation [message #65844 is a reply to message #65805] |
Tue, 11 January 2005 19:08  |
jp
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
Heelo
To quick view the TS fragmentation, we can use DBA_FREE_SPACE view.
"alter tablespace
coalesce;" only effective on honey-comb fragmentation, not for buble one. In case of the second one, General procedure to import and export.
If your version support LMT, then use LMT with uniform extent size. It will helps much to restrict from fragmentation from deletion and rebuild operation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
