Re: HELP: Oracle problem in HP workstation

P. Mantecon (pmanteco_at_haifa.cern.ch) wrote:

: 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?.

Patricia,

Have you done an update statistics since adding the new rows?

Is it possible that due to memory limitations you are now running out of Oracle / buffer cache buffers? (Where with 20000 rows most of the table was cached.)

You may also want to look into the amount of memory being used by dynamic buffer cache. It may be stealing from Oracle.

--

					STD Disclaimers apply
					Jeff
--
Jeff English  ; Hewlett Packard ; 19091 Pruneridge Ave
jeffe_at_cup.hp.com
--