RowSize Equation in Oracle ServerAdmin Guide for 7.3.4 and 8.0.#

From: Jorge Meirim <Transparente_at_mail.telepac.pt>
Date: Fri, 23 Apr 1999 18:13:51 +0100
Message-ID: <7fq9oh$sqc$2@pthp35.telecom.pt>

Does someone understand the equations?
-What is "MIN(argument1+ArgumentN,whateverargument)" ? What is the comma where?
-What is "row header (3 * whateverargument)" ? Is row header a function?(of course not) What is ment then?

Does someone recommend another equations to size "correctly" a table?(sites, whitepapers?)

Any help would be apreciated
J Meirim

---

---

From the manual:
Step 3: Calculate the
Space Used per Row
Calculating the amount of space used per row is a multi–step task. First, you must calculate the column size, including byte lengths: Column size including byte length
=

column size + (1, if column size < 250, else 3) Note: You can also determine column size empirically, by selecting avg(vsize(colname)) for each column in the table. Then, calculate the row size:
Rowsize
=

row header (3 * UB1) + sum of column sizes including length bytes Finally, you can calculate the space used per row: Space used per row (rowspace)
=

MIN(UB1 * 3 + UB4 + SB2, rowsize) + SB2 Where: Received on Fri Apr 23 1999 - 12:13:51 CDT