Re: Fragmentation

From: <mausumim_at_my-deja.com>
Date: 2000/07/28
Message-ID: <8lsdck$nsd$1@nnrp1.deja.com>#1/1

In article <8lrkbr$52m$1_at_nnrp1.deja.com>, thiko_at_my-deja.com wrote:
> Hi
>
> Does anyone know how to identify fragmentation in tables without using
> the analyze or compute statistics sql? Is there any SQL for this?
>
> Many Thanks
>
> Thiko!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

You can query
> SELECT tablespace_name, count(*) FROM dba_free_space GROUP BY
tablespace_name HAVING count(*) > 0
More the count is tablespace is more fragmented.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 28 2000 - 00:00:00 CDT