Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Fragmentation

515430Aug 1 2008 — edited Aug 3 2008

Hi All,

I am asked to reorganize tables which experience high degree of fragmentaion. Fragmentation here means lot of voids between the first block and the HWM, may be due to delete operation.

But I am still to get a method or a SQL querry to find out whether the tables are fragmented this way.

I am using Oracle 9i(9.2.0.2.0) and LMT.

It would be good if you guys can help me out.

Regards
Satish

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2008

Added on Aug 1 2008

#general-database-discussions

12 comments

3,376 views