RE: How to size db_block_size?

df
-g 
 
"Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Fuelspot

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Herman Susantio   [mailto:sherman_at_bcsis.com]Sent: Tuesday, June 19, 2001 5:14   AMTo: Multiple recipients of list ORACLE-LSubject: Re:   How to size db_block_size?
  Hi all,
 

  just want to ask,
  How do we know the OS Block size from our system   ?
  We use Sun Solaris 2.7
  any command to show OS Block Size ?
 

  Thanks & Regards
 

  Herman
 

  <BLOCKQUOTE
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Nirmal Kumar Muthu Kumaran To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

    Sent: Tuesday, June 19, 2001 4:30
    PM
    Subject: RE: How to size
    db_block_size?     

    Hi Justin,
    A larger data block size provides
    greater efficiency in disk and memory I/O (access and storage of data). Such     cases include:

1. Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater.
2. The operating system that runs Oracle uses a small operating system block size. For example, if the operating system block size is 1K and the data block size matches this, Oracle may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks. Hope that this would helps you. Nirmal.

      -----Original Message----- <FONT 
      face=Arial size=1>From:   <FONT face=Arial 
      size=1>Justin Coleman [SMTP:jd_coleman_ora1_at_hotmail.com] 
      Sent:   <FONT 
      face=Arial size=1>Tuesday, June 19, 2001 10:06 AM <FONT 
      face=Arial size=1>To:     <FONT face=Arial 
      size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
      size=1>Subject:        <FONT 
      face=Arial size=1>How to size db_block_size? 
      Dear All, 
      Is there a recommended approach on how to 
      decide on the db_block_size for your 
      database?  I am looking to create a database that during the day will 
      be used for light OLTP, but during the 
      day and night will have heavish batch <FONT face=Arial 
      size=2>jobs.  Therefore I was intent on using 8k or 16k blocks.  
      Most likely 8k blocks.  But is 
      there an approach to actually chosing the correct <FONT 
      face=Arial size=2>db_block_size? 
      Cheers for any help in advance. 
      Justin 
      <FONT face=Arial 
      size=2>_________________________________________________________________________ 
      Get Your Private, Free E-mail from MSN Hotmail 
      at <A target=_blank 
      href="http://www.hotmail.com">http://www.hotmail.com. 
      -- Please 
      see the official ORACLE-L FAQ: <A target=_blank 
      href="http://www.orafaq.com">http://www.orafaq.com <FONT 
      face=Arial size=2>-- Author: Justin 
      Coleman   INET: 
      jd_coleman_ora1_at_hotmail.com 
      Fat City Network Services    -- 
      (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial 
      size=2>San Diego, California        -- 
      Public Internet access / Mailing Lists <FONT face=Arial 
      size=2>-------------------------------------------------------------------- 
      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 <FONT 
      face=Arial size=2>also send the HELP command for other information (like 
      subscribing).