Re: PCTFREE/PCTUSED

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Sun, 20 May 2001 23:33:47 -0700
Message-ID: <F001.00308FA4.20010520232030@fatcity.com>

MY DB_BLOCK_SIZE = 8K
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Mark Leith To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Friday, May 18, 2001 12:30 PM Subject: RE: PCTFREE/PCTUSED

  What
  is your DB_BLOCK_SIZE?   

<FONT face=Tahoma

    size=2>-----Original Message-----From: <A 
    href="mailto:root_at_fatcity.com">root_at_fatcity.com [<A 
    href="mailto:root_at_fatcity.com">mailto:root_at_fatcity.com]On Behalf Of 

    Bunyamin K. KaradenizSent: Thursday, May 17, 2001     04:51To: Multiple recipients of list ORACLE-LSubject:     PCTFREE/PCTUSED
    PCT_USED = PCT_FREE + 1 row
    sizePCT_USED + PCT_FREE < 100Are the rules .     But what does 1 row size mean
here?

    For ex . My pctfree=30
<FONT face=Arial

    size=2>            1
    row size (avg.) = 150 bytes .
            Then
    what is PCT_USED ?
    TIA Received on Mon May 21 2001 - 01:33:47 CDT