Re: Tablespaces and indexes

On Fri, 21 Sep 2001, nsouto_at_optushome.com.au.nospam wrote:

> As you pointed out, there may be other considerations:
> similarity of space allocation being one that springs to mind
> (for dictionary-allocation tablespaces). Or partitioning.

I asked this question as a standalone post but it is relevant here. Are there performance gains with partitioning when there is striping? I guess with multiple sets of arrays, partitioning to a certain array would give performance gains, but if using one striped array, I don't see partitioning bringing performance gains.

> Fact is: most people nowadays use some form of SAN or other
> RAID-based architecture or a very good LVM. With these, there
> is no point whatsoever is spending large amounts of time
> splitting your database into lots of tablespaces, be they
> indexes or table or mixed.

Hence my question about partitioning.

> Want more speed for reading? Use mirroring.

Why does this work? I thought mirroring was a second layer of safety. Does Oracle use both sides of the mirror based on its intelligence?

--
Galen Boyer
It seems to me, I remember every single thing I know.