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!

Fragmentation/Defragmentation of space in Database

imran khanJul 31 2012 — edited Oct 10 2012

Hi,

Oracle DB version : 10.2.0.5.0
OS version HP-UX B.11.31 U ia64
DB size : 2TB

We have the above configuration for one of our oracle database. One of our DBA acts like he is only the person on this earth who is managing the process of fragmentation removal from the tablespaces in order to improve the performance and wastage of the space. He performs that task at weekends and takes one-off day extra. I am not sure how the fragmentation removal improves the performance and deallocates the space.

Is it compulsory to perform the rebuild process weekly in order to remove fragmented space from tablespaces?

Do we have any other method to automatically re-organize objects occupying waste space?

Why the reuild of indexes using separate tablespace improves performance? is there any specifi reason for it?

Please help understand the process.

Thanks,
Imran Khan

This post has been answered by anand prakash - oracle on Jul 31 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2012

Added on Jul 31 2012

#general-database-discussions

72 comments

12,959 views