You can use dba_extents. Any time you have an extent_id > 0, your table,
index is fragmented. Use block_id and blocks to get the full picture. If
you are locking for skipped blocks within the tablespace, you need to use
something like: current row blockid + current row blocks <> next row blockid
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Jonathan Gennick wrote in message
<373d5f95.10884634_at_netnews.worldnet.att.net>...
>On 29 Apr 1999 20:06:00 GMT, jared_at_pandora.planet.net (Jared
>Hecker) wrote:
>
>>Well, I've been a DBA for a few years, but this request is a new one on
>>me:
>>
>>I'm writing a few report scripts. The manager has asked me to include
>>'skipped blocks' on one of the reports. Interesting request - I've never
>>heard of a skipped block in the Oracle world.
>
>First I would find out if your manager knows.
>
>Jonathan
Received on Mon May 03 1999 - 13:43:48 CDT
