Fragmentation in Oracle
From: (wrong string) ín <jsanmart_at_tortuga.its.cl>
Date: 1997/11/06
Message-ID: <3461E97B.CF3F8FB6_at_tortuga.its.cl>#1/1
Date: 1997/11/06
Message-ID: <3461E97B.CF3F8FB6_at_tortuga.its.cl>#1/1
Hi,
I'm using Oracle 7.3.2.3 on an Alpha with OSF/1 v4.0, and I have some
questions.
First, fragmentation problem exist?
Second, I have a process what makes "depuration", it does not delete all
the records from a table, just the ones that meet a condition, I
suppose that this operation makes some fragmentation, how can I fix
this? I'm thinking of making an export of the table, truncate it and
import it, but this is very ineficient, we are calculating 1,000,000
records a day :(
What would you recomend?
That is all, thanks,
Jorge San Martin Received on Thu Nov 06 1997 - 00:00:00 CET