Re: Q:Table Fragmentation. How do I reduce it?

In article <6dn7nh$3tr_at_nnrp1.farm.idt.net>,   Rao Uppuluri <uppuluri_at_IDT.NET> wrote:
>
> Hi all
>
> Setup: Oracle 7.3.2.3 on HP-UX 10.20
>
> I have a table(s) with lot of extents allocated to it. These extents are
> small extents. The extents allocated are not all next to each other.
> Some are but not all. If I drop the table and recreate it, do I get a
> lot of "free space fragmentation"? How do I reduce the fragmentation of
> the table? Do I have to export and import the whole tablespace?? ( I have
> many of these tables with lot of extents allocated to them in the
 tablespace)
>
> Thanx in ADvance
>
> Rao Uppuluri
> (uppuluri_at_XidtX.net -- Please remove X's)
>
>

PLATINUM TSreorg for Oracle improves the efficiency of large databases by restructuring objects that have become disorganized because of heavy use. TSreorg, which is designed for large mission-critical databases, reorganizes data without using the time-consuming, error-prone procedure of rebuilding the entire database structure. After TSreorg corrects the problems of database organization (e.g., fragmentation, poor row ordering, and over-allocation of storage space), system performance increases and user response time significantly decreases.

PLATINUM Fragmentation Analyzer is a tool for determining the degree of fragmentation in your database objects. It allows you to find all objects that need reorganization, measure performance and overall rating of objects, provide summaries of available space per tablespace, and locate chaining and fragmentation. By using the Fragmentation Analyzer, you can determine the efficiency of your database objects and find out which of those objects needs reorganization. This PLATINUM tool provides the first step in solving fragmentation: determining where the problem lies.

For more information, related articles, and a free download of Fragmentation Analyzer, check out the TSreorg product page at: http://www.platinum.com/products/dba/tsreo_ps.htm

Janis Thomas
Platinum Technology, Inc.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 18 1998 - 00:00:00 CST