Help with Tablespace fragmentation

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 11 Oct 2001 10:24:35 +0100
Message-ID: <F43F5B4264AED511A10F0008C7DBB6062325A2@leuler.leeds.lfs.co.uk>

Check out the Oracle Co-op FAQ here :

http://www.jlcomp.demon.co.uk/faq/ind_faq.html

especially these two :

http://www.jlcomp.demon.co.uk/faq/ts_frag.html http://www.jlcomp.demon.co.uk/faq/RclmFreeSpace.html

Regrads,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: wchy65_at_hotmail.com (Wade Chy) [mailto:wchy65_at_hotmail.com] Posted At: Wednesday, October 10, 2001 11:07 PM Posted To: server
Conversation: Help with Tablespace fragmentation Subject: Help with Tablespace fragmentation

Hi All
How can I find out if a tablespace is fragmented? Is there any data dictionary view I can query to find out howmuch a tablespace has fragmented and what is the best way to coalesc the tablespace. Thank you in advance. Received on Thu Oct 11 2001 - 04:24:35 CDT