Re: SAFE Rules, defragmentation

norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0302101342.37c54cd6_at_posting.google.com>...
> Hi,
>
> I was reading thru the SAFE Rules whitepaper ("How to Stop
> Defragmenting and Start Living: The definitive Word on
> Fragmentnation").
>
> There is a part that I cant seem to translate to 8i and
> newer...basically in the paper:
>
> Regarding tablesaces (particulalrly section 2.1.1)
>
> 1. NEXT should = INITIAL
> 2. PCTINCREASE should equal zero
> 3. MINIMUM EXTENT should equal INITIAL
>
> Thus, this is their example for such rules in section 2.2.1:
>
> create tablespace tbspc_name
> datafile 'dbf_name' size 102404k autoextend on maxsize 204804k
> minimum extent 4m
> default storage (initial 4m next 4m pctincrease 0
> minextents 1 maxextents 4096);
>
> How does this statement "translate" to 8i using the UNIFORM clause?
> Am I missing the concept here? How do you get the statement to run in
> 8i?
>
> Thanks.

You'd do it with locally managed tablespaces:

   create tablespace tbspc_name
   datafile 'dbf_name' size 10240k
   autoxtend on next 4m maxsize 20480k
   extent management local uniform size 4m;

That would satasify all the requirements. Any table create would have a minimum extent of 4m. Next would also always equal initial since the extens are forced to be 4m. Also, pctincrease can only be 0 in a lmt. Now, initial could be
10m, but what you would get is enough 4m extents to equal 10m.

I don't know if the statement you presented would work, as it would create a dictionary manged tablespace, but for me, uniform lmt's are just an easy to acheive this. Received on Tue Feb 11 2003 - 05:11:47 CET