Re: Another Oracle "Myth"?

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 26 Nov 2003 07:05:46 -0800
Message-ID: <cf90fb89.0311260705.4b207c86@posting.google.com>

> Cutting down the
> number of IOs is the best and also the hardest strategy one could attempt.

Great point Mladen.

So, which is best for say, a 20 gig Oracle database?

A - 100% caching with db_cache_size = 25g

B - A small db_cache_size with solid-state disk?

Essentially, the question is:

If LIO is also expensive, then would PIO on a super-fast RAM-SAN be a better choice?

It's only going to be a few years until almost all Oracle database run solid-state, so this is an important question! Received on Wed Nov 26 2003 - 09:05:46 CST