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 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 <FONT face=Arial 
        size=2>blocks.  But is there an approach to actually chosing the 
        correct 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 
        also send the HELP command for other 
        information (like subscribing).