Re: SAN revisited

In article <3cfe711b.88492845_at_ausnews.austin.ibm.com>, you said (and I quote):
>
> What I'm thinking here is that perhaps local drive access will be somewhat
> faster than the SAN and so might be a better location for rollbacks and temp
> space.
>

Hmmm, not really. Most SANs have huge caches that can flatten the access speed compared to a normal disk.

In fact, one of the things you can do in some SANs is to allocate specific cache to logical volumes that handle uniquely the redo logs, for example.

This allows you to have write performance (on the redo logs) similar to memory access speed! Fast as it can be.

If you trust your SAN. If not then still do it, but be ready for the occasional recovery. It is an experience worth it to see a 500Mb write finish in a few seconds...

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam