Re: DB Buffer Cache Size

> There are many system-level "silver bullets" to Oracle tuning, and
> IMHO you would be foolish not to try them. For example, if you could
> tune 500 DSQL statements by adding an index or building an MV, why
> not? Consulting client demand that you tune the whole system before
> tuning individual SQL statements:
>
> http://www.orafaq.com/articles/archives/000027.htm
>
> However, this will be a moot issue in 24 months when SSD makes those
> stupid magnetic platter obsolete. Once RAM-Disk is as cheap as
> platter disk we will need to find something else to debate!

Oh, I'm all for SSD. I guess we all are. I think it's the way of the future for small to medium size databases. But I still have difficulty in figuring out how they are going to solve the problem of the badly written 500 DSQL statements. Particularly when the current BCHR is already 99.9....

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Sun Aug 22 2004 - 20:40:18 CDT