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!

HoneyComb Fragmentation and Fragments

907744Dec 28 2011 — edited Dec 30 2011

Hi All,

I have face the problem of Honeycomb fragmenatation in tablespace.We using 11.2.0.1.0 Oracle database r2 only for production env.

In the monitoring tools show the Temp Tablespace,sysaux &Production tablespace are fragmentated heavily.It all local managed auto extend tablespace.

Can any one please help me how to defragment the Sysaux,Temp tablespace fragment and also Production tablespace is also fragmentated.

Thanks
raj

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2012

Added on Dec 28 2011

#11g, #general-database-discussions

54 comments

2,491 views