From bunyamink@havelsan.com.tr Sun, 20 May 2001 23:33:47 -0700
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Date: Sun, 20 May 2001 23:33:47 -0700
Subject: Re: PCTFREE/PCTUSED
Message-ID: <F001.00308FA4.20010520232030@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@fatcity.com" 
  title=ORACLE-L@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@fatcity.com">root@fatcity.com [<A 
    href="mailto:root@fatcity.com">mailto:root@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