Re: Coalesce Tablespace Question

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Fri, 20 Apr 2001 08:05:24 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D7C4474@apps.leeds.lfs.co.uk>

>> If the default storage of the tablespace is set to 1 or above, oracle
>> will coalesce contiguous space.

I suspect Stephen means 'if the default storage setting PCTINCREASE is 1 or more in his reply.
This will cause SMON to attempt to coalesce free bloocks that are contiguous into one large chunk.
However, it doesn't do them all and it only tries to do it every 2 hours (some docs & books I've seen say every 5 mins, Oracle told me that SMON wakes every 5 mins but doesn't always do the same things when it wakes - you choose !)
Alter tablespace coalesce is the best way as this does complete the job - SMON starts it and after a certain number of blocks have been coalesced, it stops, leaving the rest for another time.

HTH. Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

Received on Fri Apr 20 2001 - 02:05:24 CDT