Re: ORA sizing- HELP

as far as i understand the manuals about this then you must read the formula as your 2nd suggestion.

so the lowest of both

Jorge Meirim heeft geschreven in bericht <7g1qlr$nnf$1_at_pthp35.telecom.pt>...
>Hi,
>What is:
>"MIN(UB1 * 3 + UB4 + SB2, ROWSIZE) + SB2"
>Should it be read like
>The min (....SB2+ROWSIZE) ......
>or
>that I should consider one of 2 values (the lowest one):
>Either the
>(UB1 * 3 + UB4 + SB2)+SB2
>or
>ROWSIZE+SB2
>
>Please help
>
>Jorge Meirim
>
>nieuws net wrote in message <7g1jc3$rtd$1_at_zonnetje.NL.net>...
>>Hi everyone
>>I have the following question about estimating space for tables
>>according the admin manual there are the following formulas
>>
>>HSIZE = DB_BLOCK_SIZE - KCBH - UB4 - KTBBH - (INITRANS - 1) * KTBIT - KDBH
>>
>>AVAILSPACE = CEIL(HSIZE * (1-PCTFREE/100)) - KDBT
>>
>>COLUMNSIZE = COLUMNSIZE+(1, IF COLUMN SIZE <250, ELSE 3)
>>
>>ROWSIZE = (3 * UB1) + COLUMNSIZE
>>
>>ROWSPACE = MIN(UB1 * 3 + UB4 + SB2, ROWSIZE) + SB2
>>why MIN ?? a record is always greater then (ub1*3+ub4+sb2) in most cases
so
>>the rowspace is not sufficient in my opinion
>>
>>ROWSINBLOCK = FLOOR(AVAILSPACE/ROWSPACE)
>>
>>because of the MIN function there can more records in a block than i
>thought
>>
>>who can help me out of the dreams
>>
>>gkor_at_rdw.nl
>>
>>
>
>
Received on Mon Apr 26 1999 - 14:35:58 CDT