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

Could NOT follow the Calculation too . Can any explain ?

> -----Original Message-----
> From: Tim Sawmiller [SMTP:sawmillert_at_state.mi.us]
> Sent: Friday, March 23, 2001 6:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tuning Matter ==> Parameter PCT_USED in a Table
>
> Ok, I'll admit my ignorance. What the heck does "1 row" mean? It can't
> mean the row length, or you'll end up with a negative PCT_USED.
>
> >>> steve.adams_at_ixora.com.au 03/22/01 09:35PM >>>
> Hi Bambang,
>
> Analyze the table and you'll find the average row length in
> USER_TABLES.AVG_ROW_LEN. Subtract 90 bytes from the block size before
> expressing that as a percentage and round it up. Also, the formula
> should be PCT_USED = 100 - (PCT_FREE + 1 row). There are scripts on the
> Ixora web site that do this sort of stuff.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
>
>
> -----Original Message-----
> Sent: Friday, 23 March 2001 11:46
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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: Tim Sawmiller
> INET: sawmillert_at_state.mi.us
>
> 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: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.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).