Re: Help with Tablespace fragmentation

From: Francesco Dini <dini.f_at_adr.it>
Date: Thu, 11 Oct 2001 07:11:37 +0000 (UTC)
Message-ID: <e55f51968e188a73c01a5ff582efc07f.26931@mygate.mailgate.org>

"Wade Chy" <wchy65_at_hotmail.com> wrote in message news:36df3e33.0110101407.1d5ece22_at_posting.google.com...

> Hi All
> How can I find out if a tablespace is fragmented? Is there any data
> dictionary view I can query to find out howmuch a tablespace has
> fragmented and what is the best way to coalesc the tablespace.
> Thank you in advance.

In my site there are some example (now they are in italian page, but scripts are in PL/SQL)
about fragmentation.
Francesco Dini
http://www.francescodini.f2s.com

-- 
Posted from  [195.94.133.5] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Thu Oct 11 2001 - 02:11:37 CDT