Re: How to size db_block

From: Herman Susantio <sherman_at_bcsis.com>
Date: Tue, 19 Jun 2001 01:24:19 -0700
Message-ID: <F001.0032E4D4.20010619011354@fatcity.com>

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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Nirmal Kumar Muthu Kumaran To: <A href="mailto:ORACLE-L_at_fatcity.com" title=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:

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.
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] <FONT 
    face=Arial size=1>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 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 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 href="http://www.hotmail.com" target=_blank>http://www.hotmail.com.

Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com -- Author: Justin Coleman INET: jd_coleman_ora1_at_hotmail.com

Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 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). Received on Tue Jun 19 2001 - 03:24:19 CDT

Re: How to size db_block_size?