Statistics for comp.databases.oracle.server - WE 19/1/2003

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 23 Jan 2003 12:11:02 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70335B141@lnewton.leeds.lfs.co.uk>

Hi Niall,

Nope. Never seen that one before - which manual is it in ?

:o)

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Thursday, January 23, 2003 11:57 AM Posted To: server
Conversation: Statistics for comp.databases.oracle.server - WE 19/1/2003 Subject: Re: Statistics for comp.databases.oracle.server - WE 19/1/2003

I can't resist

"One popular approach to manual I/O distribution suggests separating a frequently used table from its index. This is not correct. During the course
of a transaction, the index is read first, and then the table is read. Because these I/Os occur sequentially, the table and index can be stored on
the same disk without contention. It is not sufficient to separate a datafile simply because the datafile contains indexes or table data. The decision to segregate a file should be made only when the I/O rate for that
file affects database performance."

:( Received on Thu Jan 23 2003 - 06:11:02 CST