Re: Why is bytes not = initial extent when extents = 1 in seg view

Oracle will allocate AT LEAST as much space as you specify in initial.
- It will always allocate at lease 2 Oracle blocks

• It will round up to full blocks. This is usually 2k increments.
• It will allocate more space if appropriate to reduce fragmentation.

David Roth

CMC Systems                                       All opinions expressed
UNIX Client/Server System Integrators      are my own.