Skip to Main Content

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!

Auto Vs Manaul segment space management

user12050217Sep 9 2010 — edited Sep 10 2010
Hi,

I am reading below link :
http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/tspaces002.htm#ADMIN10065

And it has one sentence "Automatic segment space management delivers better space utilization than manual segment space management."

My question is : Then in which cases Manual segment space management is good choice in compare to auto. If Automatic segment space management delivers better space utilization, then why oracle has also introduced Manual segment space management? I mean, what special advantages can be obtained with only manual segment space management, which are not available in automatic segment space management.

Any example will also help me to understand it please.

Thanks,
This post has been answered by Jonathan Lewis on Sep 10 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2010
Added on Sep 9 2010
15 comments
8,311 views