Tom:
The database block size (DB_BLOCK_SIZE) should be a multiple of the OS block
size. But in some cases the DB blocks should be equal or smaller than the
OS blocks (but still in multples). Oracle corp's documentation says this is
the case if your application has many full-table scans, and the thinking is
that a single OS block read can pick up one or more DB blocks. Other than
that, it's the application itself that should determine block size. The
conventional wisdom is applications with lots of random access favor smaller
blocks, and warehouse apps with lots of sequential access favor larger
blocks.

Martin



-----Original Message-----
From: Tom Schruefer [mailto:[Email Address Removed] Tuesday, April 30, 2002 12:21 PM
To: LazyDBA.com Discussion
Subject: DB Block Size and Tuning????




I've got a database, the DB Block size is 4096k, however the OS (Win2000
Server)block size on the disk is 8192k. This is not something I plan to
leave this way.

I am wondering what impact this disparity would have on Oracle performance
and how it would be manifest?

I'd imagine this would throw off some stats, is that correct?



Tom Schruefer
Howard County Public Schools


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page