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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 28 Apr 2004 08:45:30 +0100
Message-ID: <CFECD6EA683C524BB5FD22C0F1F34ACB011F3789@bristol43.audit-commission.gov.uk>

apologies if you all eventually get this twice.    

-----Original Message-----
From: Niall Litchfield
Sent: 27 April 2004 11:46
To: 'oracle-l_at_freelists.org'
Subject: RE: Why "Separating Data and Indexes improves performance" is a myth?

Jonathan wrote
> I believe Stephan Haisley has built a 9i database
> with a 7.5K block size (not for production reasons,
> of course).

SYS 27-APR-04_at_block>show parameter block

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
db_block_buffers                     integer     0
db_block_checking                    boolean     FALSE
db_block_checksum                    boolean     TRUE
db_block_size                        integer     5120
db_file_multiblock_read_count        integer     16

SYS 27-APR-04_at_block>show release
release 1001000200
SYS 27-APR-04_at_block>

5 and 10 are such round numbers I thought I might choose the highest common divisor for my block size...

if anyone has suggestions as to how to achieve interesting errors with this setup the db will be around for a day or so.

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805

---

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

---

---

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 Wed Apr 28 2004 - 02:43:02 CDT