You are doing Full-Table-Scans.
1. What's the average row length ? How many columns does the
table have ?
2. How many "consistent gets" does the count(*) cause ?
[ie, how many blocks does it actually have to read ?]
3. Are all these Physical Reads ? Is the DB_CACHE_SIZE large
enough to hold most of the
blocks ? What is the query-run-time if you re-run the query
immediately again ?
Hemant
At 08:19 AM 11-02-03 -0800, you wrote:
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@codetel.net.do
809-565-3121
Hemant K Chitale
My web site page is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
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@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 - 21:23:41 CST
