Re: Re: DB_BLOCK_SIZE and Solaris block size

Darrell Landrum,

                Hi, for Ufs and VXFS, It should be 8k in most case. Use df -g, fstyp to verify the blocksize. Also from the man newfs:

               -b bsize  The logical block size of the file  sys-
                         tem  in bytes (either 4096 or 8192). The
                         default is 8192. The sun4u  architecture
                         does not support the 4096 block size.

    
               -f fragsize
                         The smallest amount  of  disk  space  in
                         bytes  to allocate to a file. The values
                         must be a power of two selected from the
                         range  512 to the logical block size. If
                         logical block size is 4096, legal values
                         are 512, 1024, 2048 and 4096; if logical
                         block size is 8192, 8192 is also a legal
                         value. The default is 1024.

		

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)

• 2003-03-04 04:23:00 ,you wrote£º=======

>I'll look this up when I get into the office but I'm pretty sure it is 512 bytes.
>
>
>>>> jean.berthold_at_eos-gd.ch 03/04/03 04:28AM >>>
>Hello,
>
>I have a doubt ...
>
>Is it true that Solaris (7, 8, 9) has a OS block size of 64K by default
>?
>
>In this case, is it correct to sizing the DB_BLOCK_SIZE for a new
>database (8.1.7) at 64K ?
>This question because all of our databases was installed with:
>db_block_size = 8192
>
>How to check the value for the OS block size on Solaris (7,8,9) ?
>
>Thanks for your help ?
>
>Jean Berthold
>
>
>--
>________________________________
>
>Jean Berthold
>EOS - energie ouest suisse
>Chemin de Mornex 10 , CP 570
>CH-1001 Lausanne , Switzerland
>Tel. : +41 (0)21 341 24 58
>Fax : +41 (0)21 341 20 49
>E-Mail : jean.berthold_at_eos-gd.ch
>________________________________
>
>
> ...Unix is like a wigwam - no windows, no gates, apache inside...
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jean Berthold
> INET: jean.berthold_at_eos-gd.ch
>
>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: Darrell Landrum
> INET: dlandrum_at_zalecorp.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: chao_ping
  INET: chao_ping_at_vip.163.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).