Home » RDBMS Server » Performance Tuning » checking fragmentation
checking fragmentation [message #65805] Thu, 30 December 2004 03:40 Go to next message
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 Go to previous message
Messages: 11
Registered: August 2000
Junior Member

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.
Previous Topic: Pl Help: to Tune This query.taking 10 min
Next Topic: Tune SGA urgent
Goto Forum:

Current Time: Tue Feb 27 10:09:34 CST 2024