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>
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, jimReceived on Sat Oct 01 1994 - 22:15:45 CET