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!

segment shrinking, any influence on performance?

groxyMar 20 2009 — edited Mar 20 2009

Hi all
I am using 10.2.0.2 64-bit on SLES 10. I am thinking of performing segment shrinking on production database. I did it on the test database and it was time and resource consuming process. Does segment shrinking has any influence on performance apart from gain in disk space? If yes, what?
Thanks for any suggestions.
Groxy

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2009

Added on Mar 20 2009

#general-database-discussions

4 comments

349 views