Re: Viewing a Table's Fragmentation

On 7 Feb 2005 02:00:42 -0800, "Paul Izzo" <paul.izzo_at_mosca-ag.com> wrote:

>Is there a way with Oracle Enterprise Manager to view a given
>tablespace's level of fragmentation?

Well you can look at the map of a tablespace. However, with the demise of dictionary managed tablespaces and the advent of locally managed tablespaces this would be a futile exercise. A LMT doesn't fragment, and if it does the consequences for the performance are nil.

--
Sybrand Bakker, Senior Oracle DBA