HELP: Oracle problem in HP workstation

Hi everybody!!

I am new in this group, so if I make any mistakes, please forgive me.

I would like to describe you a problem we have with Oracle version 7.0.16.6.0. We are running Oracle in a HP workstation. Recently, we have installed a new disk, because the old one wasn't enough for the amount of data we manage.

We have put one disk for the data, and the other one for the indexes. But the problem arose when we passed from a 200000 rows-table to a 400000 rows-table.

Now, when we run a sentence like:

        select count (*) from table1;
it takes 5 minutes to do it, while when we have the same table with only 200000 entrys it takes 3-4 seconds.

The problem is that the time should have a linear growing with respect the number of rows, shouldn't it?.

We have changed all the Oracle parametres would allow to improve the perfomance, but nothing happens.

any sugestion?

Thanks.

Patricia Mantecon Received on Tue Oct 11 1994 - 16:09:08 CET