Re: defragmentation and Oracle v7...automagic??
From: BARRY ROOMBERG <barry.roomberg_at_compudata.com>
Date: Tue, 18 Oct 94 09:33:00 -0400
Message-ID: <89C023D.0389001789.uuout_at_compudata.com>
Date: Tue, 18 Oct 94 09:33:00 -0400
Message-ID: <89C023D.0389001789.uuout_at_compudata.com>
-> No.
->
-> Oracle7 defragments tablespaces. Actually, all it does is, if it
-> finds two or more adjacent unused fragments it simply combines them
-> into one fragment. It does NOT move database objects (tables,
-> indexes, etc) around to combine all unused space into a single
-> fragment.
That is not defragging. The is simply coalescing adjoining free segments. O6 was supposed to do that whenever a table extent was requested, but some versions had a bug that would only coalesce during initial allocation, and would fail to do it during extends. Received on Tue Oct 18 1994 - 14:33:00 CET