Multiple extents in system tablespace

From: <davidsonj_at_gtewd.mtv.gtegsc.com>
Date: 1 Oct 94 13:15:45 -0800
Message-ID: <1994Oct1.131545.1321_at_gtewd.mtv.gtegsc.com>


I have noticed that my system tablespace has a lot of segments with multiple extents (some as many as 20 extents). Will this impact performance of stored procedures? Or anything else? Should I compress the system tablespace (I think that is done by exporting and reimporting the tablespace - but don't I have to eliminate the current tables before import will actually compress). Is this worth the effort?

      thanks in advance for any advice you may have,
             jim
Received on Sat Oct 01 1994 - 22:15:45 CET

Original text of this message