Re: ORA sizing- HELP

From: Jorge Meirim <Transparente_at_mail.telepac.pt>
Date: Mon, 26 Apr 1999 14:45:28 +0100
Message-ID: <7g1qlr$nnf$1@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 - 08:45:28 CDT