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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow table

Re: Slow table

From: Rafal Czekala <czekala_at_real.pl>
Date: Thu, 02 Sep 1999 14:06:32 GMT
Message-ID: <7qm08v$gpj$1@nnrp1.deja.com>


It's possible that slow table has wrong extents definition - too small and too much. If you have many extents it can be the problem with reading data or adding columns.

Rafal Czekala

In article <DNtz3.281$zo5.1227_at_news1.online.no>,   "Ulf Grindstad" <griulf_at_online.no> wrote:
> I'm working with a database with several tables,
> I tried to do Select Count(*) from table, on two different tables. One
> returned the answer in about two seconds, and the other used about a
minute.
> I also added a new column on the both tables, and on the slow one it
took
> about a minute, and on the other one it took appr. two seconds. Both
tables
> has around 50000 rows, and 10 varchar2 columns.
>
> Any ideas on what the problem is?
>
> ulf
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 02 1999 - 09:06:32 CDT

Original text of this message

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