Re: segment fragmentation
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: thump@xxxxxxxxxxxxxxxx
- Date: Wed, 8 Sep 2004 21:56:44 +0100
After the delate are u going to Insert the same amount of Data Back
in.. If no u many need to either tune the PCTFREE or use minimize
records per block to reduce row chaining/migration.
HTH
---
Ganesh
On Wed, 8 Sep 2004 12:57:39 -0700 (PDT), David <thump@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx&subject=unsubscribe
> To search the archives - //www.freelists.org/archives/oracle-l/
>
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
