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
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.
- Is there a means of determining the extent of fragmentation?
- Should I use export/import to defrag the database?
- Is there a better way?
Thanks for any info.
--Received on Mon Sep 23 1996 - 00:00:00 CEST
=============================================================
Brad Baker (519)884-1970 x3910 Database Administrator bbaker_at_mach2.wlu.ca Information Systems Wilfrid Laurier University
=============================================================