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 -> Re: Space and fragmentation in Oracle 7.3.4

Re: Space and fragmentation in Oracle 7.3.4

From: James Belton <jbelton_at_freenetname.co.uk>
Date: Thu, 2 Dec 1999 14:52:31 -0000
Message-ID: <82610u$4h6$1@gxsn.com> 





Eric,



The problem is that you have a high water mark on the table.



Unfortunately, even though there is only one row in the table, when Oracle
does a full table scan, it is reading the space a full 1000000 records would
take. Hence, it is slow.



The only way around this is to either truncate the table or to drop and
recreate it using import / export.



Hope this helps!



James



DBA hints and tips at http://www.jamesbelton.co.uk



>




Received on Thu Dec 02 1999 - 08:52:31 CST












Original text of this message













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