Re: Fragmentation

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/07/28
Message-ID: <39818646.CE1EE2C7@edcmail.cr.usgs.gov>#1/1

Thiko,

You can issue this query:

SELECT owner,segment_name FROM dba_segments WHERE segment_type = 'TABLE' AND extents > 10;

This will give you any table that has more than 10 extents, or "fragments".

HTH,
Brian

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.

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Jul 28 2000 - 00:00:00 CDT