Re: 600 Gb migration from Sun to Aix in 8 hrs

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Nov 2005 12:54:46 -0800
Message-ID: <1132606486.161629.28870@o13g2000cwo.googlegroups.com>

Kris, I think the db_file_miltiblock_read_count is overkill considering the fact no OS I know of supports an IO of this size.

>From both the version 9.2 and 10g Reference manual entries for the
database parameter:

>> The maximum value is always less than the operating system's maximum I/O size expressed as Oracle blocks ((max I/O size)/DB_BLOCK_SIZE). If you set this parameter to a value greater than the maximum, Oracle uses the maximum. <<

On most systems the maximum is 128K and on AIX I have heard but have never verified that AIX can do a 1M IO. The disk unit might limit the IO size also.

HTH -- Mark D Powell -- Received on Mon Nov 21 2005 - 14:54:46 CST