Re: Oracle Myths- Tablespace placement answered by Oracle TPC-C

Pablo Sanchez <pablo_at_dev.null> wrote:
>
>I think the burden of proof is on folks who don't believe it's
>important.
>
>As of this writing, the seventh place TPC-C result is an HP 9000
>Superdome Enterprise Server running Oracle 9i. Reviewing the FDR, on
>page 98, we see Appendix E - Disk Storage. Notice that no table
>segments are co-mingled on the same tablespace as any index/cluster
>tablespaces:

Thank you for providing the rope to hang yourself by :-)

If you look at Table 5.2 of that document, you'll see that "Each logical volume is striped 74-way across all the arrays."

_All_ the disks were being used for both tables and indexes.

The fact they were logically separated into different tablespaces is a management issue. I use the same sort of configuration at benchmarks.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/