Re: TableSpace Storage Parameters?

This is NOT a sensible thing to do.
It would be far better to adopt a sensible storage strategy that made is unnecessary for SMON to do any coalescing of free space.

i.e.

    all objects in a tablespace to use the default storage     default storage to be ' initial = next, pctincrease = 0'.

Although there are some (version dependant) details that have to be addressed with Parallel CTAS and multiple free list groups this policy ensures that any dropped object leaves behind holes which are exactly the right size for the next object you want to create, so space management ceases to be a problem.

See also my document on smon

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Oracleguru, Suresh Bhat wrote in message <01be5068$c1638be0$a504fa80_at_mndnet>...
>Hi!
>
>I would also set the pctincrease to 1 for all tablspaces ( not the tables
>) except Oracle created tablespaces such as SYSTEM, RBS, TOOLS etc.
>
>If the tablespace is already created use:
>
>alter tablespace tablespace_name default storage ( pctincrease 1 );
>
Received on Thu Feb 04 1999 - 11:10:36 CST