Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nx02.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!t31g2000cwb.googlegroups.com!not-for-mail
From: "ORA600" <panandrao@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Pct Free, Pct Used.
Date: 19 Apr 2006 22:49:55 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1145512195.150764.162350@t31g2000cwb.googlegroups.com>
References: <1145456127.423383.153120@v46g2000cwv.googlegroups.com>
   <IxzBEG.A6I@igsrsparc2.er.usgs.gov>
   <1145486254.417478.178670@i39g2000cwa.googlegroups.com>
NNTP-Posting-Host: 125.16.137.50
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1145512200 22645 127.0.0.1 (20 Apr 2006 05:50:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 20 Apr 2006 05:50:00 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: t31g2000cwb.googlegroups.com; posting-host=125.16.137.50;
   posting-account=QswBVQ0AAAB9RMC3nWO4ncVAqOz6vMd5
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:265870

PCTFREE is still a valid parameter, with or without ASSM.

In ASSM, if you do not specify a value for PCTFREE, a default of 10 is
used which was also the case in Manual Segment Space Management.

So, you still need to consider PCTFREE if you want to size the table or
index correctly and  also cater for potential buffer or block related
issues like 'buffer busy waits', row chaining, etc.

cheers
ORA600

