Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Viewing a Table's Fragmentation

Re: Viewing a Table's Fragmentation

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 07 Feb 2005 12:12:51 +0100
Message-ID: <96je01pbv2g43ao7hh9v4l1rnhj1t1cpvu@4ax.com>


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
Received on Mon Feb 07 2005 - 05:12:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US