Re: Maximum db_block size
From: Andre Allen <andre_at_interaccess.com>
Date: 1996/06/02
Message-ID: <4os9nn$ppk_at_nntp.interaccess.com>#1/1
Date: 1996/06/02
Message-ID: <4os9nn$ppk_at_nntp.interaccess.com>#1/1
In article <4oqh87$sbk_at_mars.cnct.com>, Ayokunle Giwa <akgiwa_at_cnct.com> wrote:
>Hi,I would appreciate help clarifying this issue for me Ive read
>conflicting text regarding what is the absolute maximum db_block size
>allowed in Oracle and when is it advisable to go beyond the basic 2k or 4k
>
>Also is there a maximum number of blocks for a database?
>
DB_BLOCK_SIZE i believe is O/S dependent - meaning it probably has to be a multiple of your Operating System block size. As far as a limit, I have seen big block sizes (>=32K) on very large systems.
- Andre T. Allen * andre_at_interaccess.com **
- SysAdmin/DBA * 74262.3572_at_compuserve.com **
- Reid Psychological Systems * 312.938.9200 (Voice) **
- Chicago, IL * 312.294.0104 (Fax) **