RE: How to size db_block_size?

log
file block size is generally 512, 1024 bytes, dispite the file system block size.
<SPAN
class=683540316-19062001> 
 
"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: hp   [mailto:hp_at_lechateau.ca]Sent: Tuesday, June 19, 2001 12:11   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   How to size db_block_size?
  ok
  I'm confused.
  if i
  run df -g  i get this   

  (/dev/vg00/lvol3 ) :
  8192 file system block size 1024 fragment size
<SPAN

  class=606291415-19062001>and if i
  run
<SPAN

  class=366485908-19062001><FONT face="Lucida Console"   color=#0000ff>select  max(l.lebsz) 
  log_block_sizefrom  sys.x$kccle  lwhere    l.inst_id = userenv('Instance');
<SPAN

  class=366485908-19062001>i
  get 
<SPAN

  class=366485908-19062001>LOG_BLOCK_SIZE______________            1024
<SPAN

  class=366485908-19062001>does this mean my os block size is   1k?
<SPAN

  class=366485908-19062001>if so how do i change it to   8k?    

    <FONT
    size=2> 
    <FONT
    size=2> -----Original
    Message-----From: Christopher Spence     [mailto:cspence_at_FuelSpot.com]Sent: Tuesday, June 19, 2001 9:26     AMTo: Multiple recipients of list ORACLE-LSubject: 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: 
        a) 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. 
        b) 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----- 
          From:   <FONT 
          face=Arial size=1>Justin Coleman 
          [SMTP:jd_coleman_ora1_at_hotmail.com] <FONT face=Arial 
          size=1>Sent:   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:        
          How to size db_block_size? 
          Dear All, 
          Is there a recommended approach on how to 
          decide on the db_block_size for <FONT face=Arial 
          size=2>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 
          jobs.  Therefore I was intent 
          on using 8k or 16k blocks.  Most likely 8k <FONT 
          face=Arial size=2>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. 
          -- <FONT face=Arial 
          size=2>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 <FONT face=Arial 
          size=2>  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 also send the HELP command for 
          other information (like subscribing).