Oracle & OS related questions...

From: <david_petit_at_yahoo.com>
Date: Mon, 18 Oct 1999 04:23:05 GMT
Message-ID: <7ue7b2$scn$1@nnrp1.deja.com>

Hello all,

I want to ask some questions about the Oracle and OS questions. Hope someone can help.

I know that during each I/O, OS reads the data block size from hard disk to memory. If I doubling the DB_BLOCK_SIZE, is there any performacce gain if the OS block size still not change? For example, if I change the DB_BLOCK_SIZE from 2K to 4K, OS still needs two I/O to move the data from disk to memory, what are the advantages of setting DB_BLOCK_SIZE from 2K to 4K? And Is is possible to change the data block size on Solaris and Windows NT, and how? (or pointing to which web site discuss these issues)

Thanks,
David

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 17 1999 - 23:23:05 CDT