Oracle Block size Vs OS block size

[grjohnson]

UNIFORM Initial/Next sizes for both tablespace, and therefore segments, are 4MB.

PCTFREE 0

32K (128 Blocks per extent)
8K (512 Blocks per extent)

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

alter session set db_file_multiblock_read_count=64;

Session altered.

set timi on
Alter session set events '10046 trace name context forever, level 12';

Session altered.

8K Default Tablespace

SQL> select count(*) from test
where snapshot_id_c = 'test';


Elapsed: 00:00:29.86

WAIT #1: nam='db file scattered read' ela= 14379 p1=18 p2=200913 p3=64
WAIT #1: nam='db file scattered read' ela= 14212 p1=18 p2=200977 p3=64
WAIT #1: nam='db file scattered read' ela= 17312 p1=18 p2=201041 p3=64

32K non-Default Tablespace

SQL> select count(*) from test
where snapshot_id_c = 'test';

Elapsed: 00:00:30.01

WAIT #1: nam='db file scattered read' ela= 11546 p1=11 p2=87701 p3=16
WAIT #1: nam='db file scattered read' ela= 11580 p1=11 p2=87717 p3=16
WAIT #1: nam='db file scattered read' ela= 11550 p1=11 p2=87733 p3=16