Re: Newbie question: Should a table/index ideally always be in a single extent ?

In article <01bd7ec6$736eaf60$a504fa80_at_mndnet>, suresh.bhat_at_mitchell- energy.com says...

Thank you for your answer. I'll try to find the discussion in dejanews.

> One suggestion:
>
> As you have planned use pctincrease = 0 for tables. USE PCTINCREASE =1 for
> TABLESPACES. If you do this Oracle SMON process will automatically
> defragment the space after deletions/inserts etc.

I'm afraid I'll ask another FAQ: I used PCTINCREASE = 0 for tablespaces on purpose to disable SMON's coalescing. In the configuration I described, all the (allocated) extents in a given tablespace will have the same size. I don't see the point to merge them just to break the result again later. I hope to save some I/O that way.

Am I missing something ?

• Raoul