Oracle-L: RE: max block size on sun solaris

From: MARREIROS,RUI (HP-Portugal,ex1) <rui.marreiros_at_hp.com>
Date: Thu, 13 Feb 2003 08:19:25 -0800
Message-ID: <F001.0054C04F.20030213081925@fatcity.com>

in oracle 9.0.1 Documentation:

DB_BLOCK_SIZE 2048 to 16384 (Linux, Solaris)

2048 to 32768 (AIX, HP, Tru64)

Of course you can always use the multiple block_size option in non system tablespaces.
See e.g :Marlene Theriault,paper at IOUG live 2002

"...As with earlier databases, the standard block size is set by the DATABASE_BLOCK_SIZE parameter value when the database is created and you cannot change this block size without rebuilding the database. By default, the standard block size is used for the SYSTEM tablespace and for any other tablespaces that are created.
To create a tablespace with a non-standard block size, you use the BLOCKSIZE keyword as follows:
create tablespace DIFBLK_TS
datafile 'G:\Oracle\oradata\mydb\difblk1.dbf' size 10M blocksize 8192;
Remember the note above? You must configure a subcache within the buffer cache to support each of the different block sizes. ...."
regards
rui
-----Original Message-----
Sent: Thursday, February 13, 2003 3:04 PM To: Multiple recipients of list ORACLE-L

Is anyone running ORacle on Sun solaris with db_block_size > 16K? We are getting an error while creating a 32K block size database on Sun and Oracle says 16K is the max on Sun solaris..

Thanks a lot...

Babu

This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: babu.nagarajan_at_Cummins.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: MARREIROS,RUI (HP-Portugal,ex1)
INET: rui.marreiros_at_hp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------