phyrds in v$filestat and sql trace not match !!

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 12 Nov 2002 02:43:26 -0800
Message-ID: <F001.00500AFC.20021112024326@fatcity.com>

list,
i'm doing benchmarking using two DB's with different block size i run a count(*) on a 17 million row table, and compare the sql_trace file and the v$filestat stats..
the db was bounced before each test, the init.ora params were identical, EXCEPT
in DB1 (4k block size) the muldiblock read was 16, and DB2(block size 8k) it was 8

4 samples were taken...

CPU time :
DB1 = 9023
DB2 = 8027

elapsed time:
DB1 = 19171
DB2 = 18045

phy reads: (from sql_trace)
DB1 = 327022
DB2 = 159347

PHYRDS from v$filestat
DB1 = 16386
DB2 = 16385

PHYBLKRDS from v$filestat
DB1 = 262148
DB2 = 131073

my question is... why the physical reads in the v$filestat are equal ?? but the p reads in the sql_trace
file are different ??

TIA
rahul

--

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

Author: Rahul
  INET: rahul_at_ratelindo.co.id

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 Nov 12 2002 - 04:43:26 CST