Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why "Separating Data and Indexes improves performance" is a myth?
> -----Original Message-----
> Paul Drake
>=20
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.
-- 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
![]() |
![]() |