Re: OCP Question

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 20 Jun 2001 09:53:57 -0700
Message-ID: <3B30D525.7DA10A60@attws.com>

"Thorsten Schütt" wrote:

> Given a table with millions of rows and an index on the table.
>
> What would be the best choice?
>
> a) Have table and index in the same tablespace on the same disk
> b) Have table and index in different tablespaces on the same disk
> c) Have table and index in different tablespaces on different disks
> d) All the same
>
> According to OFA, it must be c), am I right?
>
> Thanks in advance for your answer!

You are correct. Tablespaces for data and indexes should be on separate physical drives and preferably separate controllers.

Which brings up an interesting question. What do you do when the sys admin stripes multiple disks? Are they on different physical drives? And can you tell.

Daniel A. Morgan Received on Wed Jun 20 2001 - 11:53:57 CDT