RE: PCTFREE/PCTUSED

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 18 May 2001 02:16:34 -0700
Message-ID: <F001.003073FC.20010518013043@fatcity.com>

What
is your DB_BLOCK_SIZE?

<FONT face=Tahoma

  size=2>-----Original Message-----From: 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 Fri May 18 2001 - 04:16:34 CDT