Re: defragmenting free space in a tablespace

From: Glenn Andrews <DGWW16A_at_prodigy.com>
Date: 1995/11/11
Message-ID: <480vjf$27v8_at_usenetw1.news.prodigy.com>#1/1

I called Oracle about the same problem a couple of days ago and they said that SMON will not defragment the free space in any tablespace which has the default storage parameter "pctincrease" set to 0. I set the pctincrease to 1 and the fragmentation was gone in a frew hours. Oracle 7.3 will add an alter tablespace command to defragment. Received on Sat Nov 11 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: TSims: "Re: 32 BIT ODBC DRIVERS FOR WIN95 BETA?"
Previous message: Kirk Bradley: "Re: Client-Server Oracle7 / AS400"
Maybe in reply to: Steve Preisach: "Re: defragmenting free space in a tablespace"
Next in thread: TSims: "Re: 32 BIT ODBC DRIVERS FOR WIN95 BETA?"
Reply: Jeffrey Herrick: "Re: defragmenting free space in a tablespace"
Reply: Reinhard Kuhn: "Re: defragmenting free space in a tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message