At 07:44 AM 9/25/2003 -0800, you wrote:
Hi!
I think putting your small tables to 2K block size is quite pointless (unless you have tens of thousands of these tables continously in buffer cache).
Tanel.
----- Original Message ----- From: <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] To: <mailto:[EMAIL PROTECTED]>Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 8:54 PM Subject: RE: Multiple block sizes
I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202.
Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]
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: [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).