Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> FRAGMANTATION on a table

FRAGMANTATION on a table

From: <atta707_at_my-deja.com>
Date: Tue, 08 Feb 2000 04:55:59 GMT
Message-ID: <87o7kv$qj5$1@nnrp1.deja.com> 





hi all the oracle gurus,



i'm a newbie oracle dba.



we've got a table with lotta frequent inserts and deletes. more often
the highwater mark, and number of extents allocated for this table is
way above what it should be.


could you please suggest a way to find out how bad is the fragmentation
and, more importantly, if it is the appropriate time to drop and re-
create this table to prevent the hog.



thanks in anticipation.



ATTA



Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Mon Feb 07 2000 - 22:55:59 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US