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."

:(

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:ppPX9.4693$V6.6776_at_news.indigo.ie...


> Yep. Congrats.

>

>

> Someone else have a go.

> "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message

> news:3e2f084f_3_at_mk-nntp-1.news.uk.worldonline.com...

> > "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message

> > news:U9yX9.4542$V6.6723_at_news.indigo.ie...

> > >

> > > guess the manual  without searching tahiti.. scout's honour accepted.

> > > <easy!>

> > >

> > > "An authalic sphere is a sphere that has the same surface area as a

> > > particular oblate ellipsoid of revolution representing the figure of

the


> > > Earth."

> > >

> > Spatial?

> >

> > Regards,

> > Paul

> >

> >

>

>