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/