Home -> Usenet -> comp.databases.oracle -> How to measure level of database disorganization/fragmentation?

How to measure level of database disorganization/fragmentation?

From: Dana Smith <dsmith_at_velcro.com>
Date: Mon, 4 Jan 1999 13:27:20 -0500
Message-ID: <pM7k2.212$Rn3.367_at_news13.ispnews.com> 





First question?



We periodically run into severe performance problems due to needing to
rebuild a specific index (a lot of inserts have caused a query/insert do
perform slowly via the index.)



How can we measure level of index disorganization so we can determine when
and what level to launch an index rebuild?



Second question:



When running an export/import on a table, we run into situations where we
can export but not import due to a need for contiguous space which is not
available, even though the overall space IS available.



My question is: How can we determine the level of fragmentation in a
tablespace so we are able to determine when a full tablespace import/export
is needed?



Thanks for the help and direction.




Mr. Dana Smith
Received on Mon Jan 04 1999 - 19:27:20 CET












Original text of this message