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 Defragmentation

970465Oct 24 2012 — edited Oct 25 2012

Hi ,

Recently we had performed table defrgamention on 9i oracle database on linux platform . we did fragmentation for around 20 tables , out of which 10 tables size decrease , 5 tables didnt got affected and to my surprise 5 tables got increased by 8 mb each ? deframention is not there should not increase the size . We even queried dba_tab_modifications and to my surprise there is no inserts ,updates or deltes on those tables ? so just wondering how did the table size increase .

Pleae Oracle Guru's give your thoughts and inputs on this .

Thanks & Regards ,

Edited by: 967462 on 24 Oct, 2012 11:08 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2012

Added on Oct 24 2012

#general-database-discussions

18 comments

1,882 views