Export/Import for defragmentation

From: Brad Baker <bbaker_at_mach1.wlu.ca>
Date: 1996/09/23
Message-ID: <Dy74y8.A0F_at_info.uucp>#1/1


I have a 6 Gig Oracle 7.2.2.3.0 database which has approximately doubled in size since its creation. The database has grown through many small transactions (if that will help in diagnosis). I am interested in determing the extent of fragmentation in the database, as well as defragmenting the database.

  1. Is there a means of determining the extent of fragmentation?
  2. Should I use export/import to defrag the database?
  3. Is there a better way?

Thanks for any info.

--

=============================================================
Brad Baker (519)884-1970 x3910 Database Administrator bbaker_at_mach2.wlu.ca Information Systems Wilfrid Laurier University
=============================================================
Received on Mon Sep 23 1996 - 00:00:00 CEST

Original text of this message