segment fragmentation

  • From: "David" <thump@xxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 8 Sep 2004 12:57:39 -0700 (PDT)

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/

Other related posts: