Re: Pct Free, Pct Used.

From: ORA600 <panandrao_at_gmail.com>
Date: 19 Apr 2006 22:49:55 -0700
Message-ID: <1145512195.150764.162350@t31g2000cwb.googlegroups.com>

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 Received on Thu Apr 20 2006 - 00:49:55 CDT