Re: Defragmenting table

From: FGuelfucci <guelfucci_at_my-deja.com>
Date: Mon, 18 Sep 2000 10:58:35 GMT
Message-ID: <8q4sgk$1t0$1@nnrp1.deja.com>

Things are getting worse and worse, I have stopped the users from adding anything to the table but it is still getting slower and slower. I really cannot see what could possibly cause oracle,(8.0.6), to slow itself down, (and only on that table).
Any ideas?
I did check v$session_wait but it doesn't seem to help much. I will do sql_trace latter.
Thanks in advance

In article <8psl8q$3eq$1_at_nnrp1.deja.com>, FGuelfucci <fguelfucci_at_goalgroup.co.uk> wrote:
> Hi there,
> I hope that someone could help me with a little problem.
> I often have to do a query on a table, +/-30000 rows, but for some
> reason the system takes between 10 to 40 secs to return from the
select
> count(*), statement, (other tables are 5 times the size and 3 times
> faster).
> There are 2 indexes and 2 primary keys. The size of the table would
> indicate that it should be very quick.
> For the purpose of the application I have to do a select count(*)
often
> as the exact number of rows varies from time to time, does any one
know
> a better way of doing it or a SQL statement that would defrag the
table.
> Any help would be great, (and would make me look great at work).
> Thanks for all the help you can give.
> Florent.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 05:58:35 CDT