Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tuning Matter ==> Parameter PCT_USED in a Table

Re: Tuning Matter ==> Parameter PCT_USED in a Table

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 23 Mar 2001 05:29:49 -0800
Message-ID: <F001.002D5DA3.20010323051546@fatcity.com>

max(row size) is the sum of all of the columns sizes in the table plus overhead. The following is the column sizes and the sum formula to calculate the size of a row in a data block.

NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7 TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF COLUMNS > 250)

This is part of the calculations used to determine the storage needed for a table.

OR: you could analyze you table and use the average row size is you need a general calculation of actual usage.

ROR mm

>>> Bambang.Setiawan_at_Sidola.com 03/22/01 08:45PM >>> Dear Listers,

I've download a presentation talking about Calculating PCT_USED . the formula is quite simple :
PCT_USED + PCT_FREE < 100
PCT_USED = PCT_FREE + 1 row size

but I have no idea to calculate the size of 1 row in a table .

is there anyone who knows to calculate it ? or any alternative formula to calculate PCT_USED ?

Thanks a lot in advance : )

=bambang=

<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Bambang Setiawan
  INET: Bambang.Setiawan_at_Sidola.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 23 2001 - 07:29:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US