Re: Db Block Size 8K or 16K for a FS Block Size = 16K

I think your only option is to go with DB_BLOCK_SIZE=16384. If you leave it at 8192, then every single-block read you perform will affect a 16K block in the file-system and further down in the stack; a waste of resources. You don't want to hurt the performance of random, single-block reads in a banking application. There are no problems inherent to the RDBMS with 16K blocks (of which I'm aware -- anybody else?)...

A larger block size may lead to possible data block contention resulting from approximately twice as many rows in a database block, which would probably manifest itself as "buffer busy waits". If it occurs in tables, then the best resolution in 8i would be to increase PCTFREE on that table to simulate a smaller block size (selectively) by wasting some space in each block, to limit the number of rows per block. If it occurs in indexes, then you might try the same thing else consider making the index a REVERSE index, if the application does not perform INDEXED RANGE SCANs on it. I hope you have a good testing environment with good load-generation capabilities (i.e. automated load generators, etc)...

That previous paragraph contains about an hour's worth of discussion, easy, but that's a thumbnail summary...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 23, 2002 7:53 AM

Sun Storage Model 6960 (containing Multiple T3+ Units within) Allows a MINIMUM File System(FS) Block Size of 16K.

DB Block Size 8K OR 16K , For Performance which is Advisable for a Hybrid Banking Application ?

NOTE - Till Date we have been using 8K DB & FS Block size for Our Banking Product
because the Other Storage Boxes did allow 8K FS Block Size . Customers Running Databases of Sizes Upto 500 GB with it .

Solaris 8
Oracle 8.1.7

Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).