Extents in SYSTEM tablespace

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 04 Dec 2001 23:45:14 +0100
Message-ID: <t2kq0u00j9jg44omnvkcmu8bu8df1avdjf@4ax.com>

Hello!

I took a look at the number of extents in the tablespaces of an Oracle DB (8.1.7) and found out that there are several thousand of them. Actually, only the TEMP tablespace has more extents.

But this should not be so, since the objects in the SYSTEM tablespace are almost never deleted or added. But this is a development DB, so it happens that tables are created and deleted quite often. Could this be the reason for the high fragmentation in this tablespace?

By the way, which is the best way to get rid of fragmentation?

Thanks

Rick Received on Tue Dec 04 2001 - 16:45:14 CST