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 -> URGENT!!! Extremely slowly table access after delete

URGENT!!! Extremely slowly table access after delete

From: Marc Brevet Lepreux <mbl_at_concept.fr>
Date: 1998/02/12
Message-ID: <34E30CD2.926A3B0E@concept.fr>#1/1

Hello everybody

We have a big problem with Oracle 7.3.2.3.1 , 7.3.3.4 on NT and 7.3.2.3.1 on Aix.
After a big delete (>100000 rows) on a table we have a slowly table access.
I run a select count (*) , 1minutes for 0 rows. Oracle say to me 'it's the block clean out, run a select count (*) and it will be OK'. I've been execute this statement and it's the same problem. My temporary solution is Export / Drop / Import.

If you have any idea, i'm very interesting Received on Thu Feb 12 1998 - 00:00:00 CST

Original text of this message

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