Re: Empty BLocks (Holes) in the Datafile

On 5/2/07, rjamya <rjamya_at_gmail.com> wrote:
>
> try
>
> column sb heading "Start Block"
> column eb heading "End Block"
> column nsb heading "Next Ext Start Block"
> with x as (select file_id, block_id sb, block_id+blocks-1 eb,
> lead(block_id, 1) over(partition by file_id order by block_id) nsb
> from dba_extents where tablespace_name = 'SYSAUX' order by
> 1,2,3)
> select file_id, sb, eb, nsb, case when (nsb-eb) > 1 then 'HOLE - ' ||
> (nsb-eb) || ' blocks' else 'OK' end stat
> from x
> /
>
> This will show you holes, you can add segment names by modifying the query
> if you like.
>
> HTH & YMMV
> rjamya
>
>

Greetings Rjamya

Yes It Helped. Thank you

Regards
BN

-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l