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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: segment fragmentation

Re: segment fragmentation

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 8 Sep 2004 14:34:42 -0700
Message-ID: <bf463804090814343d7acf32@mail.gmail.com>


You may be interested in the dbms_space packages, space_usage in particular.

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_space.htm#996957

Jared

On Wed, 8 Sep 2004 12:57:39 -0700 (PDT), David <thump_at_cosmiccooler.org> wrote:
> I have been asked to determine segment/object fragmentation levels after a
> mass delete has been performed.
>
> Do LMT only negate fragmentation occuring at a tablespace level as an
> issue and segment fragmentation and high water mark issues are still
> relevant after a mass purge?
>
> How does one check for this type of fragmentation?
>
> It has been requested I perform an export/import of said schema after
> verifying segment fragmentation exists.
>
> By the way, I have finally purchased Optimizing Oracle Performance and
> have begun the reading.
>
> Regards,
> --
> ..
> David
>
> --
> To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
> To search the archives - http://www.freelists.org/archives/oracle-l/
>

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Wed Sep 08 2004 - 16:30:29 CDT

Original text of this message

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