RE: How to size db_block_size?

[Rajesh Dayal]

Title: RE: How to size db_block_size?

Just one thought.........   You check the block size of redolog files using following script ( -- Author: Steve Adams) >> select   max(l.lebsz)  log_block_size from   sys.x$kccle  l where   l.inst_id = userenv('Instance') / <<     This would give the OS Block Size. I am sure someone would   correct me if I am wrong...   Rajesh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Herman Susantio Sent: Tuesday, June 19, 2001 1:14 PM To: Multiple recipients of list ORACLE-L Subject: 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   ----- Original Message ----- From: Nirmal Kumar Muthu Kumaran To: 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:   Justin Coleman [SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, June 19, 2001 10:06 AM To:     Multiple recipients of list ORACLE-L 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 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 _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).