Oracle-L: RE: Count(*) last 30 seconds

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 11 Feb 2003 08:39:49 -0800
Message-ID: <F001.0054966B.20030211083949@fatcity.com>

Ramon - Start by adding an index? :-)

Do you have any indexes on this table? My first guess is that it is doing a full table scan. This does seem to be a bit long for a full table scan. Do you expect to do a lot of full table scans on this table? If so, then you may want to look at how to tune the full table scan. Otherwise add an index.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, February 11, 2003 10:19 AM To: Multiple recipients of list ORACLE-L

Hi list,

I issue a select count(*) from mytable and last 30 seconds.

The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space.

I consider that time exagerated.

The TBS is LMT with a Uniform size of 128 MB.

The block size is 8MB, version 9.2.0.1.0 in Windows 2000.

Where should I start looking ???

TIA Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 11 2003 - 10:39:49 CST