Re: Count(*) is very slow

From: Alexandre Mavel <amavel_at_partner.auchan.com>
Date: Wed, 21 Oct 1998 16:22:54 +0200
Message-ID: <70kqb7$d7n$1@aristote.pratique.fr>

S_at_lut Andreas,

According to the number of reply, your proble seems consistant and need a little mor method to find issue:

few questions witch can the reduce probable causes

-Isn't the user who throw the query limited by a CPU QUOTA ??-
-Does this problem appear on any table, on any type of PK?
-Isn't the tablespace too large?
-have you check Memory Default, I/O default ??

    select SUM(pins),"executions",sum(reloads),"memory default"     from V$librarycache;

    select name,phyrds,phywrts
    from V$datafile df, V$filestat fs
    where df.fil#=fs.fil#;

-have you examinate the problem from the System point of view (Physical
I/O)?

Excuse my poor English, I m a froggy !

            |||||
            °|°


------m--~--m------------------------------

Alexandre MAvel
amavel_at_partner.auchan.com

---

Received on Wed Oct 21 1998 - 09:22:54 CDT