Re: Defrag Tablespaces and pctincrease 1

Many people avoid setting pctincrease to any large value because the extents then grow exponentially out of control (similar to the old game of taking a penny on the first day of the months, doubling the amount on the second, doubling that on the third, etc etc). By the end of the month you have > one million dollars. However, a value of 0 will keep Oracle from coalescing the available freespace. Hence the 'popular' value of '1'.

Scott T. Johnson <sjohnson_at_ibm.net> wrote in article <01bc13b7$cdf54f00$454948a6_at_7l603>...
> I am creating a new database and would like to create tablespaces
> that are easy to defrag.
  Received on Thu Feb 06 1997 - 00:00:00 CST