Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why "Separating Data and Indexes improves performance" is a myth?

RE: Why "Separating Data and Indexes improves performance" is a myth?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 26 Apr 2004 11:11:36 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FC07@irvmbxw02>


> -----Original Message-----
> Paul Drake

>=20

> I would think that non-power of 2 block sizes would
> subject the actor with ORA-600s beyond their wildest
> dreams.
I don't think you can even create a tablespace with a blocksize that's =
not a power of 2 with Oracle 9.0 or higher, but I can tell you that an =
8.1 database with a blocksize of 3K and a locally managed autoallocate =
tablespace makes for some amusing ORA-600s.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Apr 26 2004 - 13:08:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US