Re: Oracle 8.1.17 extent management

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: JDunn@xxxxxxxxx
  • Date: Fri, 20 Jun 2008 14:22:19 -0500

John,

Can you clarify what type of fragmentation you think the database was
experiencing. There are several varieties of fragmentation (block, table,
tablespace, etc.) and until we have established a common understanding, it
is easy for some people to offer suggestions which don't apply to your
situation. When you asked about LMT, that implied that you thought you were
experiencing tablespace fragmentation. When you did exp/imp, did you clear
or rebuild the tablespace?

Dennis Williams

Other related posts: