ORA sizing

From: nieuws net <gkor_at_rdw.nl>
Date: Mon, 26 Apr 1999 13:41:50 +0200
Message-ID: <7g1jc3$rtd$1@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 - 06:41:50 CDT