Re: Dead slow count(*)

So, what is the main wait event you'r waiting on?

On 01/29/2004 06:54:46 PM, Jordi Adame V wrote:
> Hi!
> 
> I have this table with ~4,000,000 entries
> 
> When i do a SELECT COUNT(*) FROM TABLE_NAME
> 
> it takes 4 hours to give me the result, this is way too much
> 
> Im running Oracle 9.2.0.4.0 on RedHat AS 3
> 
> These are my first experiences with Oracle, so I have no clue how to
> fix this
> query time... Any help would be nice
> 
> regards
> 
> Jordi
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: