Multi-Block read count

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 9 Jan 2002 11:57:55 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA77D5FF9@lnewton.leeds.lfs.co.uk>

Morning all,

my first question of 2002 ...

Quote from Guy Harrison in Oracle SQL High-Performance Tuning :

"On Windows NT/Win2k the maximum number of blocks that can be read cannot exceed 128K for 32 bit versions,
On most versions of Unix when the I/O is through a filesystem, no more than 8K can be read in one physical I/O, On Unix when the datafiles are locvated on raw devices, the maximum I/O rate varies from 64K (earlier versions of Solaris) to 1MB (latest version of HP-UX."

So the question I have is, how do I find out what the maximum number of Oracle blocks that I can read in one single OS I/O read is ?

Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

Received on Wed Jan 09 2002 - 05:57:55 CST