If your application allows it, and if the Application will not change in the future, then use a 2k block size for OLTP database.
If you are not sure on the application needs, then stick with 4k to be safe. Regards, Satar --- Brian Haas <[EMAIL PROTECTED]> wrote: > Hi, > > According to the Veritas manual, they claim that a > db_block_size of 2K when > using the quick-io files and an oltp system has the > most performance according > to benchmarks. > > I know full well that benchmarks != real world. Has > anyone had any experience > using quickio? If so what are your thoughts on this > and what block size(s) are > you using? > > I'm using solaris 2.8, oracle 8.1.7, latest version > of the veritas suite. > > Thanks, > > -Brian > __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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).
