Re: ORA sizing- HELP

What I wrote it's wrong. (rowspace was less then rowsize ??). The manual of course is not a great help on this subject. Hope that some guru help us here.

Regards
J. Meirim

Nieuws wrote in message <7g2f8v$jhd$1_at_zonnetje.NL.net>...
>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 - 16:27:14 CDT