Re: V7 Create Table Question, Please Help.

On Tue, 4 Apr 1995, Robert DuMoulin wrote (in part):

> I have created an application which cleans up free blocks in tablespaces
> by creating then dropping tables with initial extents equal to the size of
> contiguous blocks of free space.
 ---snip---
> Anyway, this works fine in V6. If I ask for a table with initial size of
> 20480 (10 blocks at 2048/block), I get exactly that. In V7, the same request
> results in an attempt to allocate more. I assume this is for V7 overhead,
> but can't find anywhere that describes how much overhead is needed.
---snip---

	According to notes I have from the 'Oracle7:New Features and Options'
	class I went to, extent sizes are rounded up to multiples of
	five database blocks.  The section was on using NEXT with PCTINCREASE,
	but the 5-block-rule may apply to INITIAL, also (a handwritten note
	also said the smallest a table can be is 5 blocks)...though I see 
	from your example that it was a multiple of 5 blocks.  Still, maybe 
	this might help you find the answer.

	Also, Oracle 7 is supposed to be smarter. The handwritten notes I 
	took say that SMON will 'coalesce' contiguous pieces on a regular
	basis. So just -maybe- you don't have to do this anymore. 

	helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                            Oracle 6.0.36.7.1/Banner Finance 2.0.3 :>
<:                            Oracle 7.1.3/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>